Senior Data Engineer

111000 Extendicare (Canada) Inc.; Markham; Hybrid; CAD 110,000 - 160,000; Full time

Job summary

Extendicare, based in Markham, Ontario, is seeking a Senior Data Engineer to design, build and modernize enterprise data integrations supporting business transformation. The role focuses on scalable cloud-based frameworks, ETL development, and data migration, with mentoring to promote best practices across the organization.

The ideal candidate has 7+ years in data engineering, strong SQL/ETL experience, and hands-on Azure data services knowledge, including Azure Data Factory and Synapse.

Qualifications

• 7+ years of hands-on experience in Data Engineering, ETL Development, or Data Warehouse Development.
• Advanced experience with Microsoft SQL Server, SSIS, Python, and ETL development methodologies.
• Experience with Azure cloud technologies, including Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, or similar platforms.
• Strong troubleshooting, analytical, and problem-solving skills with a focus on data quality and accuracy.
• Experience integrating data from APIs, relational databases, flat files, Excel, XML, and JSON data sources.

Responsibilities

• Design, build, test, and deploy data integration solutions between enterprise applications and business systems.
• Develop and maintain ETL processes using Microsoft SQL Server, SSIS, Python, PowerShell, and Azure technologies.
• Support cloud transformation initiatives, including modernization of legacy integrations and migration of on-premise data solutions.
• Build scalable integration frameworks that support acquisition, migration, and business transformation projects.
• Troubleshoot and resolve data quality issues, integration failures, and performance bottlenecks.
• Develop and optimize complex SQL queries, stored procedures, and data transformation processes.
• Implement monitoring, error handling, logging, auditing, and alerting capabilities to ensure reliable and secure data pipelines.
• Collaborate with technical and business stakeholders to understand integration requirements and deliver effective solutions.
• Participate in code reviews and promote best practices related to data security, governance, and privacy.
• Mentor team members and share knowledge to help grow internal cloud and data integration capabilities.
• Complete other duties as assigned.

Skills

ETL Development

SQL Proficiency

Data integration

Python

Azure Cloud

Education

Bachelor's degree in Computer Science/Engineering

Tools

Microsoft SQL Server

SSIS

Azure Data Factory

Azure Synapse Analytics

PowerShell

Microsoft Fabric

Job description

Job Description

Reporting to the Sr. Manager, Data Architecture, the Senior Data Engineer will play a key role in designing, building, and modernizing enterprise data integrations that support business transformation initiatives across Extendicare. This individual will develop scalable cloud-based integration frameworks, support acquisition-related data migration efforts, and help advance our cloud data capabilities while mentoring team members and promoting best practices across the organization. This position will be based at our Head Office in Markham, Ontario. Extendicare offers a hybrid working environment.

Key responsibilities

• Design, build, test, and deploy data integration solutions between enterprise applications and business systems.
• Develop and maintain ETL processes using Microsoft SQL Server, SSIS, Python, PowerShell, and Azure technologies.
• Support cloud transformation initiatives, including modernization of legacy integrations and migration of on-premise data solutions.
• Build scalable integration frameworks that support acquisition, migration, and business transformation projects.
• Troubleshoot and resolve data quality issues, integration failures, and performance bottlenecks.
• Develop and optimize complex SQL queries, stored procedures, and data transformation processes.
• Implement monitoring, error handling, logging, auditing, and alerting capabilities to ensure reliable and secure data pipelines.
• Collaborate with technical and business stakeholders to understand integration requirements and deliver effective solutions.
• Participate in code reviews and promote best practices related to data security, governance, and privacy.
• Mentor team members and share knowledge to help grow internal cloud and data integration capabilities.
• Complete other duties as assigned.

What we’re looking for

• Bachelor's degree in Computer Science, Engineering, or a related field.
• 7+ years of hands-on experience in Data Engineering, ETL Development, or Data Warehouse Development.
• Advanced experience with Microsoft SQLrver, SSIS, Python, and ETL development methodologies.
• Experience with Azure cloud technologies, including Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, or similar platforms.
• Strong troubleshooting, analytical, and problem-solving skills with a focus on data quality and accuracy.
• Experience integrating data from APIs, relational databases, flat files, Excel, XML, and JSON data sources.
• Ability to work independently, manage technical initiatives, and effectively collaborate with technical and business stakeholders.
• Experience supporting cloud migration initiatives, handling sensitive data (PII/PHI), Workday integrations, Snowflake, and/or AWS environments is considered an asset.

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.

About Extendicare

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 broad network of long-term care homes (both owned and under management contracts), deliver over 24 million hours of home health care services annually, and provide group purchasing services to third parties representing approximately 157,000 beds across Canada. Extendicare proudly employs more than 30,000 qualified, highly trained and dedicated team members who are passionate about providing high-quality care and services to help people live better.

Compensation

Compensation will be discussed during the recruiting process. 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.

Equal Opportunity

Extendicare is an equal opportunity employer committed to respectful and inclusive hiring practices. We welcome all applicants, including those from equity-deserving groups, including Indigenous peoples, women, people with disabilities, and visible minorities. Extendicare is committed to fostering an accessible, inclusive, and equitable hiring process. We will gladly accommodate the needs of applicants throughout all stages of the recruitment process upon request and in accordance with applicable legislation. If you require support during any stage of the process, email us at [e-mail].

Indigenous Acknowledgement

We acknowledge that the care we provide across Canada occurs on lands that have been cared for by many Indigenous peoples for generations. We recognize First Nations, Inuit, and Métis Peoples and their enduring connection to this land, and the importance of respect and cultural safety in the work we do.

Company Overview

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 the growing seniors’ population, inspired by our mission to provide people with the care they need, wherever they call home. We operate a network of 99 long-term care homes (59 owned, 40 under management contracts), deliver approximately 14.0 million hours of home health care services annually, and provide group purchasing services to third parties representing approximately 153,600 beds across Canada. Extendicare proudly employs approximately 23,000 individuals and manages an additional 5,000 joint venture employees, all of whom are highly qualified, trained and dedicated team members and passionate about providing high-quality care and services to help people live better.

Mission, Vision, Values

Our Mission To provide people with the care they need, wherever they call home.

Our Vision Everyone in Canada has access to the care and support they need to live their best lives.

Our Values We embrace every person for the individual they are. We care for each person as we would our own family. We collaborate with others because we achieve more together. We are relentless in our efforts to improve. We respect the resources entrusted to us.