Technology Financial Operations Data Analytics & BI Engineer

State Street•Quincy, MA

2d•Onsite

About The Position

This is a build-and-support role where the successful candidate will directly engage in BI engineering and data modeling. They will collaborate with stakeholders who utilize the output and remain involved with these products post-production. The scope of work covers the entire lifecycle from initial reporting requests through discovery, data preparation, modeling, build, validation, release, and ongoing support. The primary objective is to transition recurring reporting from manual spreadsheets and one-off files to governed analytics products that feature reliable refreshes, consistent definitions, and clear ownership. The corporate platforms for this work are Microsoft Power BI and Microsoft Fabric, though strong comparable enterprise BI experience will also be considered. Immediate priorities include reporting for IT Total Cost of Ownership and showback, Cloud FinOps spend and optimization tracking, productivity and demand reporting, and the retirement of high-effort manual reports.

Requirements

Ownership of a vague reporting request from discovery through build, validation, release, and ongoing support, including the unglamorous parts, without needing to be chased.
Comfort working with imperfect source data, and the discipline to reconcile differences, document assumptions, and state plainly what the data will and will not support.
A clear line between actuals, forecasts, estimates, and advisory analysis, held consistently and without turning every number into a caveat.
The ability to explain a number, its limitations, and the tradeoffs behind it to a finance partner, a technical peer, or a senior executive.
Comfort working across functions where definitions, source data, and ownership are still maturing, and the patience to build alignment rather than wait for it.
A product mindset that treats reporting as a supported capability with an owner, a backlog, and a roadmap rather than a series of one-off builds.
Exacting standards for documentation, data quality, governance, and auditability, because these reports are relied on every month and are expected to hold up to review.
Comfort operating with ambiguity and persistence to resolve it rather than route around it.

Nice To Haves

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 BI solutions using Microsoft Power BI and Microsoft Fabric preferred, including Power Query, DAX, semantic models, dashboards, dataflows, lakehouse or warehouse patterns, and SQL; strong comparable enterprise BI experience will also be considered.
Demonstrated experience building data models, measures, reconciliations, and refresh processes that span multiple source systems and survive routine change 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.

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 BI products with defined owners and a support model.
Develop reporting that supports 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, together with the validation checks and exception reporting that 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 something the available data can answer.
Apply controlled release, change, and access practices so reporting stays secure, traceable, and safe to change once it is 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.

Benefits

our retirement savings plan (401K) with company match
insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages
paid-time off including vacation, sick leave, short term disability, and family care responsibilities
access to our Employee Assistance Program
incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans)
eligibility for certain tax advantaged savings plans
inclusive development opportunities
flexible work-life support
paid volunteer days
vibrant employee networks