Client Reporting Specialist - AVP

State Street’s MyStateStreet Reporting Team offers a full suite of reporting services required by the most sophisticated Investment Managers. We gather data from multiple sources internally and externally from  - IBOR, ABORE, performance, market data vendors and client supplied data and runs through a robust workflow to produce end client reports. We are a self-service report building team who has taken the initiative to build a team to meet the most complex reporting requirements for the entire bank.

• Individual in this role will design, develop and support dashboards and reporting for State Street Investment Management Services.
• Expertise in analysis, design and implementation of reporting and visualization ( Dashboards) using BI suits like Jasper, Webfocus, Actuate, eSpreadsheet, etc
• Experience in working with large scale data warehouse solutions , data modeling and designing data marts
• Experience in data governess models and data quality implementation techniques
• Strong knowledge of SQL and experience in query performance optimization
• Interface with data experts, data sourcing resources and assist in the data validation process and Write queries
• Experience working with complex data sets and implementing complex business logics to provide intelligence reporting solutions, perform data gap analysis on complex financial data
• Requires intimate knowledge of Interactive Report Designer (IRD) and IBI WebFocus
• Serve as primary subject matter expert across the organization and assist users with adhoc dashboard/report construction queries and researching issues on existing data, query tools, and reports
• Knowledge in Big data platforms and cloud technologies
• Experience with Enterprise Servicing Platform (ESP), Enterprise Data Warehouse (EDW), and ETL data extraction and MYSS
• Employ analytical, conceptual, and creative thinking skills to improve performance
• Maintain effective working relationships with organizational team and clients
• Able to program in Flash and HTML5 to create and maintain existing dashboards
• Ability to design dashboards and cross connect different components
• Develop and execute database queries and perform analyses

What we value

• Experience with State Street IRD reporting Platform
• Extensive knowledge in BI Reporting Suits and experience in delivering client reporting projects.
• Extensive knowledge of Front/Middle/Back office functions of a Trade Life Cycle
• Extensive knowledge of Data Analysis, Data Warehousing platforms and Data Governance concepts
• Familiarity with SQL, Snowflake and Talend will be added advantage
• Strong written, verbal communication and time management skills

Qualifications 

• Bachelor's degree in Business, Accounting, Finance, MIS, Information Technology, or related field of study
• Demonstrated excellence in business writing, development of business process flow diagrams, making comparisons regarding current and future processes, and effective communication
• Ability to articulate basic project methodology concepts using either SDLC or Agile
• 10+ years’ in experience data analysis, dashboard design and development
• Ability to analyze entity-relationship diagrams and logical data models to validate design against requirements
• Ability to write SQL code for strong data analysis through queries, data profiling,  and data validation exercises
• Familiarity with financial reporting, business intelligence, and data warehousing principles
• Understands BI/reporting tool architecture, functions, and features
• Excellent oral and written communication skills for diverse audiences with excellent facilitation

State Street's Speak Up Line