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
Time Type:
Full timeAt 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.
Skills Required
- 5+ years of experience in Business Intelligence or Data Engineering
- Bachelor's degree in Computer Science or related field
- Advanced SQL Server expertise
- Advanced Power BI experience
- Experience developing automation with Python
- Familiarity with Databricks or large-scale data platforms
- Experience with GitHub or Azure DevOps
What We Do
For more than 50 years, Extendicare’s qualified and experienced teams have been helping people live better through a commitment to quality care and service that includes skilled nursing care, home health care and management and consulting services. We are proud to be at the forefront of senior care across Canada and work closely with government, community agencies, researchers, and our care partners, including families, to address needs, close gaps, solve problems and advance best practices. We employ thousands of people across the country who have made it their career and goal in life to care, and we have made it our priority to make sure they are trained and supported to provide the best care possible. Our Mission: Helping people live better
.jpg)
