Job Title

Description 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 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 cuttingedge inhouse 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 Stateoftheart facilities to provide highquality products and services The opportunity to be a part of a winning, highperforming team Collaborative, engaging workplace culture we are passionate about our people! Flexible working environment that promotes a healthy worklife balance Diverse and inclusive culture where your talent and commitment to excellence is welcomed and valued Highgrowth environment that provides opportunities for learning and growth supported by our Employee Development Program and industryleading, inhouse 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 enterprisegrade 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 endtoend data solutions in a modern analytics stack and can act as the goto technical expert for Finance. A Day in the Life (What you will do here) 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 productiongrade code with CI/CD, version control, and DevOps practices. Power BI & Semantic Modeling Design and deliver highperformance semantic models , data marts, and datasets optimized for executivelevel financial and operational reporting. Develop advanced Power BI dashboards using complex DAX , calculation groups, rowlevel security, and bestpractice modeling patterns. Implement and maintain a financewide semantic layer ensuring consistent business definitions, metrics, and KPIs. 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 monthend and planning cycles. 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 financerelated data questions. What you need to ensure you are set up for success Technical MustHaves (Nonnegotiable) 58+ years of experience in Business Intelligence, Data Engineering, or Analytics Engineering roles. Expertlevel Databricks experience : PySpark, SQL, Delta, Unity Catalog, Medallion Architecture, data modeling. Expertlevel Power BI + DAX : complex measures, optimization, semantic modeling, RLS, Tabular Editor, calculation groups. Expert SQL (TSQL or PLSQL) and strong Python (pandas, PySpark). Proven experience building financial dashboards , profitability reports, variance analysis, and multisource 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 nontechnical stakeholders. Strong attention to detail and commitment to accuracy. Continuous improvement mindset and passion for datadriven decisionmaking. Strong ownership mentality; thrives as a senior independent contributor. What makes you a great fit for this team Youre passionate about enabling smarter, datadriven decisions through elegant and efficient BI solutions. You thrive in crossfunctional 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. Youre collaborative, communicative, and motivated by helping others grow in their BI and data skills. Benefits Competitive Salary and generous vacation entitlement Wellness Program (5 paid days off for your wellbeing!) 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. Sentrex Health Solutions is proud to be an equalopportunity 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. Accommodations can be made available upon request for those candidates taking part in the selection process. #J-18808-Ljbffr