Principal Finance Data Engineer - BI & Finance Reporting

Terumo BCT; Lakewood (CO); On-site; USD 139,000 - 173,000; Full time

Benefits offered by this job

401(k) with matching

Medical, dental & vision plans

Wellness program

Life insurance

Disability insurance

Job summary

Terumo Blood and Cell Technologies in Colorado is seeking a Principal Finance Data Engineer to lead finance BI, reporting, and data modeling initiatives. You will partner with Finance leadership to standardize data definitions, improve data quality, and deliver reliable analytics across the organization.

You will design dashboards and data models, support FP&A processes, and collaborate with IT and data teams to ensure governance and scalability of enterprise reporting in a fast-paced healthcare

Qualifications

• 8–10 years of experience in finance BI, financial reporting, FP&A analytics, data management.
• Experience building dashboards and reporting solutions using modern BI tools.
• Experience with ERP, finance data, hierarchies, master data, and data governance.
• Experience in corporate finance, manufacturing finance or regulated industries preferred.

Responsibilities

• Design, develop, and maintain finance dashboards, scorecards, and reporting solutions for FP&A and accounting.
• Partner with Finance leaders to understand requirements and deliver actionable insights for planning and forecasting.
• Create standardized KPI definitions, reporting methodologies, and governance for consistency.
• Support month-end close, budgeting cycles, variance analysis, and management reporting.
• Improve reporting efficiency and auditability of financial information.

Skills

Power BI

Tableau

SQL

Data modeling

Data governance

Financial reporting

KPIs & metrics

Stakeholder management

Azure Data Factory

Databricks

Education

Bachelor's degree

Master's degree

Tools

Azure Data Factory

Synapse

Databricks

Microsoft Fabric

Job description

Requisition ID: 35391

At Terumo Blood and Cell Technologies, our 8,000+ global associates proud to come to work each day, knowing that what we do impacts the lives of patients around the world. For Terumo, for Everyone, Everywhere.

We make medical devices and related products that are used to collect, separate, manufacture and process various components of blood and cells. With our innovative technologies and service offerings, we touch a patient's life every second of every day and are committed to continuing to increase the number of patients we serve. Advancing healthcare with heart.

With some of the best and brightest minds in the industry, an unmatched global footprint, comprehensive benefits and a distinct culture, Terumo Blood and Cell Technologies is a great place to work, grow and be part of a team that is focused on making a difference. Join us and help shape wherever we go next. You create your future and ours.

Principal Finance Data Engineer - Business Intelligence & Finance Reporting

JOB SUMMARY

Partners closely with Finance leadership and stakeholders to develop, maintain, and enhance business intelligence solutions that support financial planning, forecasting, budgeting, management reporting, profitability analysis, and executive decision-making. Leads efforts to standardize financial data definitions, improve data quality, strengthen reporting controls, and deliver consistent, reliable financial analytics across the organization. Responsible for designing and maintaining critical finance dashboards, reports, and data models while ensuring alignment with enterprise data governance standards and finance reporting requirements. Serves as a key resource in transforming complex financial and business requirements into actionable insights through modern business intelligence tools and reporting platforms.

Business Intelligence & Reporting

• Design, develop, and maintain finance dashboards, scorecards, and reporting solutions supporting FP&A, accounting, cost controlling, revenue, margin, and profitability analysis.
• Partner with Finance leaders and business stakeholders to understand financial reporting requirements and deliver actionable insights that support planning, forecasting, and performance management.
• Create and maintain standardized financial KPI definitions, reporting methodologies, and business rules to ensure consistency across Finance reporting processes.
• Support month-end close, forecast cycles, annual budgeting, variance analysis, and management reporting through automated and controlled reporting solutions.
• Identify opportunities to improve Finance reporting efficiency, reduce manual data preparation, and strengthen accuracy, transparency, and auditability of financial information.

Data Standardization & Governance

• Support Finance data governance initiatives by establishing and maintaining financial data standards, business rules, account hierarchies, cost center structures, and metric definitions.
• Collaborate with Finance, Accounting, IT, and data teams to ensure consistency, accuracy, and reconciliation of financial data across reporting platforms.
• Assist in the development and maintenance of a centralized finance reporting and analytics environment that supports standardized corporate reporting.
• Monitor and improve financial data quality through validation, reconciliation, exception reporting, and governance processes.

Data Management & Analytics

• Develop and maintain data models, datasets, and reporting structures that support enterprise reporting requirements.
• Work with IT and data engineering teams to support data integration, transformation, and automation efforts.
• Analyze financial performance trends, variances, cost drivers, profitability, and business results to provide recommendations that improve financial outcomes.
• Support the development and maintenance of finance data marts, reporting environments, and cloud-based analytics platforms that enable scalable financial reporting.

Collaboration & Leadership

• Act as a subject matter expert for business intelligence, reporting, and data management best practices.
• Collaborate with Finance, Accounting, FP&A, IT, and cross-functional teams to prioritize reporting initiatives and enhancements.
• Communicate financial insights, reporting outcomes, and recommendations to Finance leadership, management, and business stakeholders.

MINIMUM QUALIFICATION REQUIREMENTS

Education

• Bachelor's Degree in Finance, Accounting, Business Analytics, Information Systems, Computer Science, Statistics and/or related field; equivalent education and experience sufficient to successfully perform the essential functions of the job may be considered.
• Master's degree in Finance, Accounting, Business Analytics, Information Systems and/or related field preferred.

Experience

• 8-10 years of experience in finance business intelligence, financial reporting, FP&A analytics, data management, or related fields.
• Experience developing dashboards and reporting solutions using modern BI tools.
• Experience working with ERP, enterprise finance data, financial hierarchies, master data, and data governance processes.
• Experience in corporate finance, manufacturing finance, cost accounting, or regulated industries preferred.

Skills

Business Intelligence & Reporting

• Advanced experience with Power BI, Tableau, or similar BI and visualization platforms.
• Strong understanding of financial reporting concepts, FP&A processes, accounting structures, KPIs, variance analysis, and performance metrics.
• Ability to gather Finance requirements and translate them into reporting, analytics, and decision-support solutions.
• Experience creating executive-level finance dashboards, management reporting packages, and performance reporting.

Data Management

• Working knowledge of data modeling, data warehousing, and data integration concepts.
• Experience with Azure Data Factory, Synapse, Microsoft Fabric, SQL, Databricks or similar technologies.
• Understanding of ETL/ELT processes and enterprise data structures.
• Knowledge of data governance and data quality best practices.

Professional Skills

• Strong analytical and problem-solving capabilities.
• Excellent communication and stakeholder management skills.
• Ability to work effectively with Finance, Accounting, FP&A, IT, and business teams.
• Self-motivated with strong organizational and project management skills.
• Experience working in a global organization preferred.

PHYSICAL REQUIREMENTS

• Typical Office Environment requirements include: reading, speaking, hearing, close vision, walking, bending, sitting, and occasional lifting up to 20 pounds.

Target Pay Range: $138,500.00 to $173,100.00 - Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data

Target Bonus on Base: 10.0%

We provide competitive total reward offerings that consist of compensation, benefits, recognition, along with a wealth of other well-being, work-life and recognition programs which support in unlocking the potential for you and your family. Included in our expansive list of benefits offerings are multiple group medical, dental and vision plans, a robust wellness program, life insurance and disability coverages, also a variety of voluntary programs such as group accident, hospital indemnity, critical illness, pet insurance and much more. To help you save for retirement, we offer a 401(k) plan with a matching contribution and for work-life balance we have vacation and sick time programs for associates. For us, it's about protecting the personal welfare of our associates and their families, helping to achieve personal goals and offering those extra touches for convenience, security and overall peace of mind.

• Terumo Blood and Cell Technologies is part of Terumo Group, founded in 1921 and headquartered in Tokyo, Japan.
• In 2024, Terumo Blood and Cell Technologies reached $1.5 billion in revenue.
• We employ nearly 8,000 associates globally, with global headquarters in Lakewood, CO, U.S., and regional headquarters in Brussels, Buenos Aires, Singapore and Tokyo.
• We manufacture devices, disposable sets and solutions at our facilities in Belgium, India, Japan, Northern Ireland, the U.S. and Vietnam. Our global presence enables us to serve customers in more than 130 countries.
• Our core values help set our direction, guide our actions and keep us true to our corporate mission of contributing to society through healthcare.
• Respect -- Appreciative of others
• Integrity -- Guided by our mission
• Care -- Empathetic to patients
• Quality -- Committed to excellence
• Creativity -- Striving for innovation
• We contribute to the Leukemia and Lymphoma Society (LLS), raising $2.4 million USD since 2025.

We are proud to be an Equal Opportunity Aff… All applicants will be afforded equal opportunity without discrimination because of race, color, religion, sex, gender identity or expression, sexual orientation, marital status, order of protection status, national origin or ancestry, citizenship status, age, physical or mental disability unrelated to ability, military status or an unfavorable discharge from military service.

Terumo Blood and Cell Technologies is committed to providing a safe, healthy and secure working environment. Our Colorado campus locations are tobacco-free workplaces, and we maintain a drug-free workplace and perform pre-employment substance abuse testing and detailed background verification.