Senior Data & BI Engineer - FP&A

Position Type: Full-time

Department: Financial Planning & Analysis (FP&A)

Work Location: Markham, Ontario

Work Hours: Monday to Friday - standard business hours

Work Arrangement: Hybrid

Travel Required: Minimal

A proudly Canadian company,

Sentrex Health Solutions is a fully integrated specialty distributor and patient support provider for pharmaceutical manufacturers, physicians, and their patients. We provide innovative solutions focused on ensuring patients have access and the support they need to maximize their treatment outcomes. Our core capabilities include Specialty Pharmacy Services, Patient Support Programs, Customized Solutions for Warehouse, Warehouse & Distribution, Clinic Services, and a cutting-edge in-house creative agency and software development team.

Come and join our team! But first, let us tell you why we love working here:

• We are 100% Canadian with locations across the country
• State-of-the-art facilities to provide high-quality products and services
• The opportunity to be a part of a winning, high-performing team
• Collaborative, engaging workplace culture – we are passionate about our people!
• Flexible working environment that promotes a healthy work-life balance
• Diverse and inclusive culture where your talent and commitment to excellence is welcomed and valued
• High-growth environment that provides opportunities for learning and growth supported by our Employee Development Program and industry-leading, in-house corporate training offered throughout the year

The Opportunity

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.

A Day in the Life (What you will do here):

Databricks, Azure & Data Engineering

• 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.

Power BI & Semantic Modeling

• 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.

Financial Analytics Support

• 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.

Governance, Optimization & Architecture

• 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.

Mentorship & Technical Leadership

• 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.

Technical Must-Haves (Non-negotiable)

• 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.

Nice to Have

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

Soft Skills

• 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.

What makes you a great fit for this team:

• You’re passionate about enabling smarter, data-driven decisions through elegant and efficient BI solutions.
• You thrive in cross-functional environments and are energized by business challenges.
• You are meticulous in your work, ensuring accuracy and reliability in every dataset and dashboard.
• You have a continuous improvement mindset, always looking for ways to optimize and innovate.
• You’re collaborative, communicative, and motivated by helping others grow in their BI and data skills

Why join Sentrex?

We value our employees! Our permanent full-time employees are provided with a:

• 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
• The anticipated base salary hiring range for this role is 110K to 130K annually. The final base salary will be determined based on relevant experience, skills, and internal equity.

Sentrex Health Solutions is proud to be an equal opportunity employer demonstrated by our commitment to diversity, inclusion, belonging, equity, and accessibility. We provide a safe space for all team members to express their individuality within our corporate culture.

We encourage you to apply and accept all applications. We realize that not every candidate will meet every single desired qualification. If your experience looks a little different from what we have identified and you think you can bring value to the role, we would love to learn more about you!

Accommodations can be made available upon request for those candidates taking part in the selection process.

Sentrex hiring managers may use artificial intelligence tools to assist them in the recruitment process.