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.
What Extendicare has to offer:
At Extendicare, we believe that working as a team creates an environment that allows us to reach our potential. We value each employee, encourage equal opportunity for growth and recognize achievement. As a valued member of our team, you can expect:
Continuous mentorship, support for life-long learning and growth opportunities.
Opportunities for advancement and career growth within the organization.
A rewarding and meaningful work experience where you can enrich your life and the lives of others through your work.
Employee Family Assistance Program.
Robust benefits package.
Extendicare is a leading provider of care and services for seniors across Canada, operating under the Extendicare, ParaMed, Extendicare Assist, and SGP Purchasing Network brands. We are committed to delivering quality care to meet the needs of a growing seniors’ population, inspired by our mission to provide people with the care they need, wherever they call home. We operate a network of long-term care homes (both owned and under management contracts), deliver over 11 million hours of home health care services annually, and provide group purchasing services to third parties representing approximately 150,000 beds across Canada. Extendicare proudly employs nearly 30,000 qualified, highly trained and dedicated team members who are passionate about providing high-quality care and services to help people live better.
#ExtendicareIT
Full time
Compensation Details
Compensation will be discussed during the recruiting process.
At Extendicare, we’ve spent more than 50 years dedicated to enhancing quality of life for the people we serve across Canada. When you join Extendicare, you become part of a compassionate, mission-driven team committed to supporting care delivery in homes and communities nationwide. Our corporate roles play a vital part in enabling front-line teams to provide exceptional experiences for clients and families. Together, we foster a culture of collaboration, innovation, and accountability—creating solutions that strengthen our services and improve lives every day.
We are committed to providing competitive compensation that reflects the value of this role and the unique qualifications each candidate brings. This opportunity is a replacement for an existing role and to support transparency, a hiring range may be included with this posting. However, 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.
