Sr. Business Intelligence Developer - FP&A (Hybrid)

Position Type:                  Fulltime

• Department:                    Financial Planning & Analysis (FP&A)
• Work Location:                The Greater Toronto Area
• Work Hours:                     Monday - Friday, 9-5 EST

Work Arrangement:       Remote/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 BI Developer to join our FP&A (Financial Planning & Analysis) team. Reporting to the Director of FP&A, you'll develop scalable Power BI reports and semantic models that enable faster, smarter decision-making across Sentrex.

You’ll work closely with teams across Finance, Business Intelligence, Pharmacy, PSP, Distribution, and the Enterprise PMO to deliver impactful, reusable reporting solutions that drive business insight.

The ideal candidate will bring deep technical knowledge in Azure Databricks, SQL, Python, Power BI, and modern data architecture (including Medallion Architecture, Unity Catalog, and semantic layer modeling).

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

• Build, optimize, and maintain robust Power BI dashboards and datasets, and semantic models supporting financial and operational reporting.
• Leverage Azure Databricks, SQL/PLSQL, Python/PySpark, and Azure DevOps to design and develop efficient data pipelines and transformation logic.
• Serve as a backup to Finance team members to troubleshoot, modify, and enhance KNIME and Python/Pandas workflows supporting financial consolidation, reporting, budgeting, and forecasting processes during month-end and planning cycles.
• Own and manage the end-to-end technical documentation process, ensuring all data models, pipelines, and reporting assets are well-documented, version-controlled, and easily understood by cross-functional teams.
• Collaborate with Finance team members to develop a strong understanding of financial processes, KPIs, and terminology, ensuring BI solutions align with business objectives
• Provide mentorship and technical guidance to Finance team members on Databricks, Power BI, and best practices in data engineering.
• Collaborate closely with the BI team to align on data modeling, pipeline performance, and governance frameworks. Continuously optimize data solutions for daily performance, propose cost-efficient cloud-based options, and coordinate with IT to implement them.
• Participate in establishing a semantic layer and standardized business definitions to ensure consistency across reporting assets.
• Explore opportunities to incorporate AI/ML techniques for predictive and prescriptive analytics within the Finance function.

 What you need to ensure you are set up for success:

• Bachelor’s degree in Computer science, Engineering, or related field.
• 3–5 years of experience in a Business Intelligence or Data Engineering role (minimum).
• 2+ years of hands-on experience with Azure Databricks and a strong grasp of the Medallion Architecture.
• Solid proficiency in SQL, PLSQL, Python (pandas library), PySpark and Power BI DAX.
• Experience working in cloud environments, with a focus on Azure-based services and Azure DevOps.
• Deep expertise in building Power BI reports using complex DAX expressions, developing datasets and semantic models, with a strong focus on visual design and usability.
• Proven experience in building complex FP&A dashboards combing multiple data sources.
• Familiarity with financial reporting and healthcare operations, including pharmaceutical distribution or patient support programs, is a plus.
• Experience or interest in AI/ML applications within BI, Unity Catalog, data governance, and secure data sharing practices is considered a strong asset.
• Excellent communication skills, with a collaborative approach to working with technical and non-technical teams.

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
• We value our employees! Our permanent full-time employees are provided with a:
• 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
• We value our employees! Our permanent full-time employees are provided with a:

Why Join Sentrex?

• 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
• Employee & Family Assistance Program
• RRSP Matching Program

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.