Senior Data & BI Engineer - FP&A

Sentrex Health Solutions•Markham, ON

40d•Hybrid

About The Position

We are seeking a Senior Data & BI Engineer to join our FP&A team as a senior individual contributor. Reporting to the Director of FP&A, you will architect and deliver enterprise-grade financial datasets, data pipelines, and Power BI models that drive forecasting, budgeting, profitability, and executive reporting across Sentrex. This role requires a highly experienced technical professional with deep expertise in Azure, Databricks (Unity Catalog, Delta, Medallion Architecture), Power BI DAX, SQL, and financial analytics. You will be the technical owner for finance data and BI solutions, partnering closely with FP&A, BI, Pharmacy, PSP, Distribution, and Operations. This is not a junior or intermediate BI developer role. This position requires someone who has previously owned end-to-end data solutions in a modern analytics stack and can act as the go-to technical expert for Finance.

Requirements

5–8+ years of experience in Business Intelligence, Data Engineering, or Analytics Engineering roles.
Expert-level Databricks experience: PySpark, SQL, Delta, Unity Catalog, Medallion Architecture, data modeling.
Expert-level Power BI + DAX: complex measures, optimization, semantic modeling, RLS, Tabular Editor, calculation groups.
Expert SQL (T-SQL or PLSQL) and strong Python (pandas, PySpark).
Strong experience in Azure (Data Lake, Databricks, ADF/Fabric/Synapse, DevOps).
Proven experience building financial dashboards, profitability reports, variance analysis, and multi-source FP&A datasets.
Excellent communication and ability to explain complex models to non-technical stakeholders.
Strong attention to detail and commitment to accuracy.
Continuous improvement mindset and passion for data-driven decision-making.
Strong ownership mentality; thrives as a senior independent contributor.

Nice To Haves

Experience with AI/ML integration for financial forecasting or anomaly detection

Responsibilities

Build and optimize data pipelines in Azure Databricks (PySpark/SQL) aligned with Medallion Architecture and Unity Catalog governance.
Orchestrate data ingestion, transformation, and validation across finance sources (ERP, pharmacy systems, PSP systems, distribution systems, etc.).
Maintain production-grade code with CI/CD, version control, and DevOps practices.
Design and deliver high-performance semantic models, data marts, and datasets optimized for executive-level financial and operational reporting.
Develop advanced Power BI dashboards using complex DAX, calculation groups, row-level security, and best-practice modeling patterns.
Implement and maintain a finance-wide semantic layer ensuring consistent business definitions, metrics, and KPIs.
Collaborate with FP&A to understand financial processes, drivers, and KPIs to ensure data assets meet forecasting, budgeting, and profitability needs.
Serve as a backup to Finance team members to troub leshoot, modify, and enhance KNIME and Python/Pandas workflows supporting financial consolidation, reporting, budgeting, and forecasting processes during month-end and planning cycles.
Own the documentation of pipelines, data models, definitions, and lineage.
Continuously optimize pipelines, SQL queries, DAX measures, and cloud spend.
Partner with BI & IT teams to enforce governance standards, access controls, and data quality frameworks.
Provide coaching and guidance to Finance team members on Databricks, Power BI, and analytics best practices.
Act as the senior technical expert for all finance-related data questions.

Benefits

Competitive Salary and generous vacation entitlement
Wellness Program (5 paid days off for your well-being!)
Paid Sick Days
Competitive Benefits Package including Dental & Extended Health Benefits, AD&D, LTD & Employee/Dependent Life Insurance
RRSP Matching Program
Employee & Family Assistance Program

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume