Job Description

Reporting to the Hiring Manager the Senior Business Intelligence Developer will support an established, high-performing Data & Analytics team. This role is ideal for a highly analytical, detail-oriented professional who enjoys solving complex business problems through data. You will contribute to a mature BI environment, enhancing existing data models, reports, and analytics solutions while delivering meaningful insights that influence decision-making across the organization.

This position will be based at our Head Office in Markham, Ontario. Extendicare offers a hybrid working environment.

What You'll Do

• Lead the development and optimization of complex SQL queries, stored procedures, and scalable data models.

• Design, develop, and enhance enterprise Power BI dashboards, reports, and semantic models with a strong focus on usability, performance, and maintainability.

• Perform in-depth data analysis to identify trends, anomalies, opportunities, and actionable business insights.

• Partner with business stakeholders to understand requirements and translate them into effective analytical solutions.

• Build reusable reporting templates, standards, and scalable BI frameworks.

• Develop and maintain automated solutions using Python, Power Automate, and related technologies.

• Contribute to modern data platform initiatives leveraging Microsoft Fabric, Databricks, and cloud-based analytics solutions.

• Support data quality, validation, governance, and continuous improvement initiatives.

• Collaborate with team members on solution design, peer reviews, and best practices while independently owning assigned deliverables.

What You Bring

• 5+ years of hands-on experience in Business Intelligence, Analytics, or Data Engineering roles within complex enterprise environments.

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field.

• Advanced SQL Server expertise, including query optimization, data modeling, ETL development, and performance tuning.

• Advanced Power BI experience, including DAX, semantic modeling, visualization design, and performance optimization.

• Strong analytical and problem-solving skills with the ability to transform complex data into actionable insights.

• Experience developing automation solutions using Python.

• Experience with Microsoft Fabric and modern cloud analytics platforms.

• Experience with Power Platform technologies, including Power Apps and Power Automate.

• Familiarity with Databricks, Spark, or large-scale data processing platforms.

• Experience with source control and deployment processes using GitHub, Azure DevOps, or similar tools.

#ExtendicareIT

Time Type:

At Extendicare, we’ve spent more than 50 years dedicated to enhancing the quality of life for residents in our long-term care homes across Canada. When you join Extendicare, you become part of a compassionate, mission-driven team committed to creating a safe, supportive, and enriching environment for every resident we serve.

We provide competitive compensation that reflects the value of this role and the unique qualifications each candidate brings. Final salary offers are based on a variety of factors such as your skills, experience, education, and alignment with the responsibilities of this position.

Base salary is one component of our broader total rewards package. We offer a comprehensive suite of benefits designed to support your health, financial well-being, and long-term career growth. Your recruiter can provide more details about our total rewards offerings during the hiring process.

We may use artificial intelligence (AI) tools to support certain stages of the recruitment process, such as reviewing applications, analyzing resumes, or assessing candidate responses. These tools assist our recruitment team but do not replace human judgment — every application is reviewed by a member of our team to ensure thoughtful and equitable consideration. If you would like more information about how your data is processed, please contact us.

Extendicare is committed to fostering an accessible, inclusive, and equitable hiring process. We gladly accommodate the needs of applicants throughout all stages of recruitment and selection upon request.