Hybrid Senior Business Intelligence Developer – FP&A

at Sentrex Health Solutions

• Job title: Senior Business Intelligence Developer – FP&A
• Job type: Full Time
• Experience level: Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, Cloud, Pandas, PySpark, Python, SQL, Unity
• Location requirements: Hybrid, Markham, Canada

About the role

• Senior BI Developer responsible for developing Power BI reports and data models at Sentrex Health Solutions. Collaborating across teams to drive business insights and analytics for financial planning.

Responsibilities

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

Requirements

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

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