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
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.
What you need to ensure you are set up for success: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.
#LI-RB1 
