Senior Data

Senior Data & BI Engineer - FP&A at Sentrex Health Solutions Position Type: Full-time Department: Financial Planning & Analysis (FP&A) Work Location: 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 the support they need to maximize their treatment outcomes. Our core capabilities include Specialty Pharmacy Services, Patient Support Programs, Customized Solutions for Warehouse & Distribution, Clinic Services, and a cutting‑edge in‑house creative agency and software development team. Why We Love Working Here 100% Canadian with locations across the country State‑of‑the‑art facilities that provide high‑quality products and services The opportunity to be 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 troubleshoot, 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? 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 Growth opportunities, training, and a collaborative culture Inclusive and diverse workplace environment 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. 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. #J-18808-Ljbffr