Product Development Data Analyst and Client Reporting, Officer

State Street’s MyStateStreet Reporting Team provides a full suite of advanced reporting services to sophisticated investment managers. We aggregate data from multiple internal and external sources (IBOR, ABOR, CBOR, performance, market data vendors, client data, etc.) through robust workflows to produce client-ready reports. As a self-service reporting team, we tackle some of the bank’s most complex global reporting requirements.

In this Officer, Report Development role, you will be an individual contributor (no direct reports) responsible for designing and delivering dynamic client-facing reports via MyStateStreet (State Street’s client web portal). You will serve as a subject matter expert in State Street’s Interactive Report Designer (IRD) platform, developing reporting solutions that support global requirements across the CDFS (Custody, Digital, and Fund Services) domain. Success in this role will be measured by timely, high-quality delivery of reporting products that meet diverse client needs.

Role Overview

The Officer will lead the creation of reports for State Street’s Investment Services clients. This includes working closely with data experts and product teams to translate complex data into clear, actionable visualizations and reports. The ideal candidate is technically skilled in BI/reporting tools and data warehousing, with a strong capacity to manage stakeholder expectations and deliver solutions on time in a fast-paced, global environment.

Key Responsibilities

• Design and develop reports using IRD and visualizations using Manage Card Designer (MCD)

• Analyze large-scale datasets and contribute to data modelling and data mart design.

• Implement reporting and visualization solutions using BI suites such as Jasper, WebFocus, Actuate, and eSpreadsheet.

• Apply strong SQL skills for data analysis, query optimization, and validation.

• Collaborate with data sourcing teams and product stakeholders to ensure data integrity and alignment with business logic.

• Act as a subject matter expert for IRD, supporting ad-hoc report creation and issue resolution.

• Stay current with Big Data platforms, cloud technologies, and tools like Data Bricks, Snowflake, and EDW.

Required Skills and Experience

• Expertise in State Street’s IRD platform in preferred but not required.

• Proficiency in BI tools such as JasperReports, WebFocus, Actuate, and eSpreadsheet.

• Strong SQL skills and experience with large-scale data warehouse environments.

• Knowledge of data governance and data quality techniques.

• Familiarity with Big Data platforms, cloud technologies, Snowflake, and Databricks.

• Understanding of front, middle, and back-office investment operations and trade lifecycle.

• Strong analytical, problem-solving, and communication skills.

• Ability to manage multiple priorities and deliver high-quality outputs on time.

Qualifications

• Bachelor’s degree in business, Finance, Accounting, MIS, Computer Science, or related field.

• 6+ years of experience in data analysis, dashboard design, and business intelligence.

• Experience with financial reporting, data warehousing, and BI tool architecture.

• Familiarity with SDLC or Agile methodologies.

• Excellent written and verbal communication skills.