Custody Product Development - Risk Analytics and Reporting, Analyst/Manager - Officer

Who we are looking for

We are seeking an Officer‑level Risk Reporting & SSRS Solutions developer to implement  enterprise‑grade SQL Server Reporting Services (SSRS) solutions supporting regulatory, client, and risk management reporting. This role is hands‑on and delivery‑focused, with accountability for end‑to‑end reporting lifecycle—from requirements interpretation and data modeling through report development, scheduling, distribution, and production support.

You will partner closely with Risk Analytics, Data Engineering, and Product teams to translate complex risk data from the truView risk platform into accurate, controlled, and consumable reports, while continuously improving performance, reliability, governance, and automation across the reporting stack.

Why this role is important to us

This role sits within Risk Analytics Services and supports the firm’s global risk reporting strategy. The focus is on standardized and bespoke SSRS reporting built on SQL Server–based risk data platforms, ensuring consistent delivery of high‑quality reporting outputs aligned to regulatory expectations and internal control standards.

What you will be responsible for

SSRS Report Design & Development

• Design, develop, and maintain SSRS reports (parameterized, drill‑through, subscription‑based) for regulatory, custom, and management reporting use cases.

• Build complex report logic using T‑SQL, stored procedures, and optimized datasets to support large‑volume, time‑sensitive risk reporting.

• Ensure reports are scalable, and aligned to enterprise layout and usability standards.

Reporting Data Enablement

• Partner with data engineering and risk analytics teams to define reporting data models, views, and aggregations optimized for SSRS consumption.

• Validate data completeness, accuracy, and reconciliation between source systems and published reports.

• Support controlled transformations and calculations required specifically for reporting outputs.

Production Operations & Reliability

• Own SSRS job scheduling, subscriptions, and distribution workflows; ensure timely and reliable report delivery.

• Implement monitoring, alerting, and run‑books for reporting failures, delays, or data quality issues.

• Participate in incident triage, root‑cause analysis, and remediation related to reporting processes.

Controls, Governance & Compliance

• Embed auditability, lineage, and validation controls within reporting solutions to meet internal policy and external regulatory requirements.

• Support documentation of report logic, data definitions, and control points for audits and regulatory reviews.

• Ensure adherence to information classification and access‑control standards.

Stakeholder Engagement

• Work directly with risk stakeholders, product partners, and operations teams to clarify requirements, manage expectations, and communicate delivery status.

• Support both standardized reporting and custom client‑specific report requests with appropriate governance.

Continuous Improvement

• Drive simplification and standardization of SSRS report patterns and shared datasets.

• Contribute to migration or modernization initiatives (e.g., SSRS optimization, shared semantic layers, API‑based distribution where applicable).

What we value

Core Requirements

• Deep hands‑on experience with SQL Server Reporting Services (SSRS), including complex layouts, parameters, drill‑downs, and subscriptions.

• Advanced SQL Server / T‑SQL skills, including query optimization for high‑volume reporting workloads.

• Understanding of risk data and financial reporting concepts (market risk, credit risk, liquidity risk, or regulatory reporting preferred).

• Experience supporting production reporting environments with strict SLAs and control expectations.

Preferred / Nice to Have

• Experience with custom risk reporting for clients or regulators.

• Familiarity with SQL Server data marts, SSCD/Snowflake, or enterprise risk data platforms.

• Exposure to .NET for report utilities or SSRS extensions.

• Experience working within regulated financial services environments.

• Other types of reporting platforms, Tableau / Power BI, etc.

• Knowledge of reporting modernization patterns (shared datasets, semantic layers, API‑based delivery).

Education & Preferred Qualifications

• 3+ years of experience in reporting, data analytics, or risk technology roles.

• Proven track record delivering enterprise‑grade SSRS reporting in production environments.

• Experience working in global, matrixed delivery models.

• Bachelor’s degree in computer science, Information Systems, Engineering, or related field.

Role Focus (Approximate Split)

• SSRS report design & development: 60%

• Production support & reliability: 20%

• Data validation, controls & documentation: 15%

• Stakeholder management & planning: 5%

Are you the right candidate? Yes!

We truly believe in the power that comes from the diverse backgrounds and experiences our employees bring with them. Although each vacancy details what we are looking for, we don’t necessarily need you to fulfil all of them when applying. If you like change and innovation, seek to see the bigger picture, make data driven decisions and are a good team player, you could be a great fit.

About State Street

What we do. State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world. From technology to product innovation, we’re making our mark on the financial services industry. For more than two centuries, we’ve been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing, data & analytics, investment research & trading and investment management to institutional clients.

Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary by location, but you may expect generous medical care, insurance and savings plans, among other perks. You’ll have access to flexible Work Programs to help you match your needs. And our wealth of development programs and educational support will help you reach your full potential.

Inclusion, Diversity and Social Responsibility. We truly believe our employees’ diverse backgrounds, experiences and perspectives are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients. We warmly welcome candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality. Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader. You will have tools to help balance your professional and personal life, paid volunteer days, matching gift programs and access to employee networks that help you stay connected to what matters to you.

State Street is an equal opportunity and affirmative action employer.

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement