S

State Street

Holds assets for institutions and runs index funds

Technology Financial Operations Data Analytics & BI Engineer

Data Engineering +1Confirmed live in the last 24 hours
Full-timeQuincy, MA, USA

About the Job

Requirements

  • Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Finance, Business Analytics, Engineering, or a related field preferred; equivalent experience may be considered.
  • Hands-on experience building business intelligence solutions using Microsoft Power BI and Microsoft Fabric, including Power Query, DAX, semantic models, dashboards, dataflows, lakehouse or warehouse patterns, and SQL; strong comparable enterprise business intelligence experience will also be considered.
  • Demonstrated experience building data models, measures, reconciliations, and refresh processes that span multiple source systems and withstand routine changes in those sources.
  • Familiarity with financial, portfolio, procurement, cloud, and headcount data, and with IT cost transparency concepts such as Total Cost of Ownership, showback, and Cloud FinOps, preferred.
  • Experience documenting data lineage, definitions, calculations, and controls in a governed or regulated enterprise environment preferred.
  • Experience working directly with non-technical stakeholders to capture requirements, agree definitions, and validate results before release preferred.
  • Ability to own an ambiguous reporting request from discovery through build, validation, release, and ongoing support.
  • Ability to work with imperfect source data, reconcile differences, document assumptions, and clarify what the data can and cannot support.
  • Ability to distinguish actuals, forecasts, estimates, and advisory analysis consistently.
  • Ability to explain figures, their limitations, and associated tradeoffs to finance partners, technical peers, and senior executives.
  • Ability to build alignment across functions where definitions, source data, and ownership are still maturing.
  • Product mindset that treats reporting as a supported capability with an owner, backlog, and roadmap.
  • Standards for documentation, data quality, governance, and auditability.

Responsibilities

  • Build and maintain data pipelines, transformations, semantic models, dashboards, and refreshable reporting solutions using Microsoft Power BI, Microsoft Fabric, and related analytics tools.
  • Modernize spreadsheet-based reporting by converting recurring, manually maintained reports into governed, reusable business intelligence products with defined owners and a support model.
  • Develop reporting for technology financial management, IT Total Cost of Ownership, Cloud FinOps, portfolio, demand, and headcount processes, including showback views and optimization tracking.
  • Prepare, reconcile, and model data from finance, cloud, procurement, portfolio, headcount, and service management systems, including the transformation logic and refresh processes that keep those sources aligned.
  • Build reusable datasets, semantic models, and measures, with validation checks and exception reporting to surface data quality issues before they reach a report.
  • Design dashboards and reports that Business Office teams, finance partners, and senior technology leaders can read and act on without a walkthrough.
  • Work directly with business stakeholders to capture requirements, agree definitions, and validate results, translating loosely defined questions into questions answerable by available data.
  • Apply controlled release, change, and access practices so reporting stays secure, traceable, and safe to change in production.
  • Document sources, definitions, assumptions, calculation logic, refresh schedules, and known limitations.
  • Support delivered products after launch, including issue intake, triage, resolution, and continuous improvement.
  • Work across finance, FinOps, portfolio, procurement, and technology teams as requirements shift and source data is reconciled.
  • Follow applicable State Street office attendance requirements for the role and location.
  • Work standard business hours, with flexibility as needed to support stakeholders across time zones; limited travel may be required.

About the Company

State Street

Holds assets for institutions and runs index funds

State Street holds and services investments for pension funds, insurers, fund companies, and other large institutions, and it also runs index funds through State Street Investment Management. It launched the first US-listed exchange-traded fund, the SPDR S&P 500 ETF Trust, in 1993, and in 1924 it became custodian of the first US mutual fund. As a custody bank, it safekeeps clients' stocks and bonds, completes their trades, calculates what their funds are worth, and lends their securities to other investors. It earns fees on the assets it services and manages, plus income from currency trading and from interest on client cash. State Street traces its roots to a bank chartered in 1792 and is based in Boston, Massachusetts.

Company size
10,001+
Company stage
IPO
Headquarters
Boston, MA
Founded
1792

Recently Posted Jobs

Explore more opportunities at State Street

See more jobs