Manager, Finance Business Intelligence & Data Products

Location: Northfield

Job Summary The Manager, Finance Business Intelligence & Data Products is responsible for delivering business intelligence, visualization, reporting, and analytics solutions for the Finance organization. This role partners cross-functionally to design, develop, and implement governed, reusable data products and dashboards that monitor key performance indicators and drive business decisions. The role combines hands-on technical leadership with people leadership, advancing modern BI practices such as semantic-layer design, KPI governance, and self-service analytics on a cloud data platform, while maintaining strong standards for data quality, lineage, and documentation.

Job Description

Job Responsibilities:

Business Partnership & Solution Delivery Collaborate with Finance leadership and business partners to understand reporting and analytical needs, and translate them into scalable, reusable data products. Lead requirements discovery, KPI definition discussions, and design reviews; convert business intent into clear specifications for facts, dimensions, KPIs, and dashboards. Manage the design and delivery of dashboards and analytics solutions that monitor key performance indicators and drive business decisions.

Serve as a trusted advisor on automation, self-service, and rationalization opportunities across the reporting landscape. BI Platform Development (Microsoft Fabric & Power BI) Design, develop, and maintain analytics content on Microsoft Fabric, including Lakehouse / Warehouse objects, semantic models, and Power BI work spaces. Build and review high-quality Power BI dashboards and paginated reports with strong UX, performant DAX, and clear narrative.

Define and apply platform standards such as workspace structure, deployment pipelines, refresh strategy, row-level security, and naming conventions. Support modernization of legacy BI assets onto Microsoft Fabric and Power BI, including portfolio rationalization, consolidation, and decommissioning of duplicate reports. Semantic Layer, Data Modeling & KPI Governance Design and evolve a semantic layer for Finance: conformed dimensions, transaction-grain and snapshot facts, and business-facing views aligned to how Finance operates.

Develop reusable business logic and calculation patterns (DAX, SQL, and Python) that promote consistency and prevent metric drift across reports. Lead KPI definition, governance, and documentation — including name, formula, grain, source of record, owner, validation rule, and control sensitivity — maintained in a trusted catalogue. Partner with controllership, audit, and risk stakeholders to ensure KPIs supporting close, compliance, and external reporting are accurate and traceable.

Data Engineering, Python & Automation Use Python (pandas, notebooks, and Spark / PySpark where applicable) for data analysis, transformation, reconciliation, and automation of recurring Finance tasks. Drive process improvements by automating manual reporting, controls evidence, and reconciliations through a combination of data pipelines, notebooks, and Power BI. Partner with Data Engineering on layered architecture patterns (e.g., Bronze / Silver / Gold) that ingest data from ERP, operational, and custom source systems.

Promote modern engineering practices within the team: version control, code review, testing, reusable libraries, and CI / CD for data and reporting assets. Data Quality, Lineage & Documentation Establish and uphold data quality, lineage, and documentation standards across Finance data products, with clear source-to-KPI traceability. Implement data quality checks, control rules, and reconciliations between source systems, the semantic layer, and downstream Power BI deliverables.

Maintain documentation that is usable by both technical and business audiences, including data product descriptions, KPI dictionaries, and change history. Foster transparency around known limitations, assumptions, and pending source-system clarifications. Leadership & Team Development Lead and develop a team of BI developers and / or analysts: hiring, coaching, performance management, capacity planning, and career growth. Set the technical bar…