Why this role is important to us

State Street’s Alpha Services Client 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, ABOR, performance, market data vendors and client supplied data, which runs through a robust workflow to produce end client reports or provides insights via data visualization. We are a self-service report development team who has taken the initiative to meet the most complex reporting requirements for the entire bank.

What you will be responsible for

• Individual in this role will design, develop and support dashboards and reporting for State Street Alpha Services.

• 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

• Employ analytical, conceptual, and creative thinking skills to improve performance

• Support user training, documentation, and rollout

• Maintain effective working relationships with organizational team and clients

• Program in Flash and HTML5 to create and maintain existing dashboards

• Design dashboards and cross connect different components

• Develop and execute database queries and perform analyses

What we value

These skills will help you succeed in this role

• Expertise in analysis, design and implementation of reporting and visualization (Dashboards) using BI suits like Jasper, Webfocus, Actuate, eSpreadsheet, etc

• Experience working with complex data sets and implementing complex business logic to provide intelligence reporting solutions, perform data gap analysis on complex financial data

• Experience in working with large scale data warehouse solutions , data modeling and designing data marts

• Experience in data governance 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

• Knowledge in Big data platforms and cloud technologies

• Experience with Enterprise Servicing Platform (ESP), Enterprise Data Warehouse (EDW), and ETL data extraction and MYSS

• Ability to articulate basic project methodology concepts using either SDLC or Agile

• 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

• Understanding of BI/reporting tool architecture, functions, and features

• Excellent oral and written communication skills for diverse audiences with excellent facilitation

• Demonstrated excellence in business writing, development of business process flow diagrams, making comparisons regarding current and future processes, and effective communication

Education & Preferred Qualifications

• Bachelor's degree in Business, Accounting, Finance, MIS, Information Technology, or related field of study

• 7+ years of experience data analysis, dashboard design and development