Self Service Reporting, Business Analyst, Officer
Core
Design, develop, and support self-service reporting and dashboards for sophisticated investment managers using BI tools and data visualization.
Role type
Senior Business Analyst (Reporting & BI)
Builds
End-client reports, interactive dashboards, and data visualization solutions for State Street Investment Management Services.
Domain
Financial Services / Business Intelligence / Data Warehousing
Required skills
SQL query optimization, data modeling, data gap analysis, BI tool implementation, data profiling, complex business logic implementation, data validation, project estimation, data mapping.
Preferred skills
Snowflake cloud platform expertise, Big data platforms, cloud technologies, entity-relationship diagram analysis, SDLC/Agile methodology.
Technologies
Jasper, Webfocus, Actuate, eSpreadsheet, Interactive Report Designer (IRD), IBI WebFocus, Snowflake.
Responsibilities
Perform end-to-end requirement analysis for reporting and dashboards; design and implement data models and data marts; optimize SQL query performance; conduct data gap analysis on complex financial data; support user training and documentation; participate in BI strategy sessions.
Seniority
Senior, hands-on IC