Hybrid Senior Business Intelligence Developer – FP&A

Posted last week

Apply now

About the role

  • 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

Job title

Senior Business Intelligence Developer – FP&A

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job