State Streets 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 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
- Experience working with complex data sets and implementing complex business logic 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 PlatformExtensive knowledge in BI Reporting Suits and experience in delivering client reporting projects.Extensive knowledge of Front / Middle / Back office functions of a Trade Life CycleExtensive knowledge of Data Analysis, Data Warehousing platforms and Data Governance conceptsFamiliarity with SQL, Snowflake and Talend will be added advantageStrong written, verbal communication and time management skillsQualifications
Bachelor's degree in Business, Accounting, Finance, MIS, Information Technology, or related field of studyDemonstrated excellence in business writing, development of business process flow diagrams, making comparisons regarding current and future processes, and effective communicationAbility to articulate basic project methodology concepts using either SDLC or Agile10 years in experience data analysis, dashboard design and developmentAbility to analyze entity-relationship diagrams and logical data models to validate design against requirementsAbility to write SQL code for strong data analysis through queries, data profiling, and data validation exercisesFamiliarity with financial reporting, business intelligence, and data warehousing principlesUnderstands BI / reporting tool architecture, functions, and featuresExcellent oral and written communication skills for diverse audiences with excellent facilitationState Street's Speak Up Line
Locations
Bangalore, India