Job Description
tate 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, 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.
- Individual in this role will participate in the design, development and support dashboards and reporting for State Street’s MyStateStreet platform
- Participate in projects in design, implementation and testing of dashboards/reports. Work with operations, client, and technology to deliver various projects
- Develop data and functional requirements and assist in the creation of related estimates and dashboards/reports using different source applications
- Participate in information delivery and business intelligence strategy sessions
- Complete data analysis, profiling, and data mappings
- Interface with data experts, data sourcing resources and assist in the data validation process and write queries
- Assist in the development the conceptual/logical data models with appropriate business contexts
- Perform data gap analysis on complex financial data
- Serve as a 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
- Ensure project activity is customer focused, results oriented, performance driven, and in compliance with all applicable internal and external requirements
- 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
- Knowledge of State Street Proprietary Dashboard Designer Platform, preferred
- Develop and execute database queries and perform analyses
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
- Experience in data analysis with big data platforms like snowflake.
- Expertise in designing and developing reports and dashboards using BI suits
- Ability to articulate basic project methodology concepts using either SDLC or Agile
- 5 years of 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
- Understanding of 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
