About the role
Title: Senior Data Engineer
Job Type: Contract (6 Months, High Potential for Extension)
Location: Markham, ON (Onsite – 4 days per week)
Our client is seeking a Senior Data Engineer to join their expanding data team. The ideal candidate will be results-oriented with strong analytical acumen, hands-on technical expertise, and a proven ability to build scalable data pipelines, execute advanced analysis, and manage multiple initiatives proactively. This role involves designing, developing, and maintaining cloud-based data solutions while collaborating closely with cross-functional stakeholders.
Key Responsibilities:
- Design, develop, and maintain resilient data pipelines utilizing Azure Data Factory (ADF), Blob Storage, on-premises systems, and Azure Functions.
- Manage end-to-end data engineering tasks independently, from requirements gathering through deployment, liaising directly with business stakeholders.
- Collaborate with Data Science, Integration, and Operations teams to assess data needs and deliver high-quality solutions.
- Lead and coordinate multiple projects, ensuring timely execution, effective communication, and alignment with organizational objectives.
- Develop and optimize data models for OLTP systems and relational databases.
- Write optimized SQL queries and scripts for SQL Server (experience with Oracle considered an asset).
- Implement mechanisms for data quality assurance, monitoring, alerting, master data management, and data cleansing strategies.
- Utilize Python for data transformation, automation, and integration activities.
- Ensure compliance with data security, governance, and best practices.
Key Requirements:
- 10+ years of professional experience in data engineering or a related discipline.
- Extensive experience with Azure Cloud Services (ADF and Azure Functions required).
- Proficiency in SQL and relational databases (SQL Server essential; Oracle a plus).
- In-depth knowledge of OLTP systems, data modeling methodologies, and system architecture design.
- Advanced programming skills in Python.
- Experience with CDC processes, master data management, and data cleansing.
- Strong analytical and problem-solving abilities, with the capacity to manage multiple projects simultaneously.
- Excellent communication skills with proven experience engaging stakeholders directly and contributing to architectural discussions.
Preferred Qualifications
- Experience with CI/CD pipelines and Azure DevOps practices.
- Familiarity with data warehousing concepts and associated tools.
- Knowledge of data governance and security standards.
About Patch Tech Staffing
Patch is dedicated to providing customized tech (IT/AV) staffing solutions that meet the unique needs and company culture of our clients across North America.
We offer staffing services for a wide range of technical positions, including software developers, network engineers, project managers, cybersecurity professionals, audio visual professionals and many more. Our extensive network of industry contacts and talent pools allows us to quickly identify and attract the best candidates for our clients' needs.
We offer flexible staffing options including temporary, contract-to-hire, and direct placement services. Whether you need to quickly fill a short-term project or hire a permanent employee, we have the expertise and resources to meet your staffing needs.
About the role
Title: Senior Data Engineer
Job Type: Contract (6 Months, High Potential for Extension)
Location: Markham, ON (Onsite – 4 days per week)
Our client is seeking a Senior Data Engineer to join their expanding data team. The ideal candidate will be results-oriented with strong analytical acumen, hands-on technical expertise, and a proven ability to build scalable data pipelines, execute advanced analysis, and manage multiple initiatives proactively. This role involves designing, developing, and maintaining cloud-based data solutions while collaborating closely with cross-functional stakeholders.
Key Responsibilities:
- Design, develop, and maintain resilient data pipelines utilizing Azure Data Factory (ADF), Blob Storage, on-premises systems, and Azure Functions.
- Manage end-to-end data engineering tasks independently, from requirements gathering through deployment, liaising directly with business stakeholders.
- Collaborate with Data Science, Integration, and Operations teams to assess data needs and deliver high-quality solutions.
- Lead and coordinate multiple projects, ensuring timely execution, effective communication, and alignment with organizational objectives.
- Develop and optimize data models for OLTP systems and relational databases.
- Write optimized SQL queries and scripts for SQL Server (experience with Oracle considered an asset).
- Implement mechanisms for data quality assurance, monitoring, alerting, master data management, and data cleansing strategies.
- Utilize Python for data transformation, automation, and integration activities.
- Ensure compliance with data security, governance, and best practices.
Key Requirements:
- 10+ years of professional experience in data engineering or a related discipline.
- Extensive experience with Azure Cloud Services (ADF and Azure Functions required).
- Proficiency in SQL and relational databases (SQL Server essential; Oracle a plus).
- In-depth knowledge of OLTP systems, data modeling methodologies, and system architecture design.
- Advanced programming skills in Python.
- Experience with CDC processes, master data management, and data cleansing.
- Strong analytical and problem-solving abilities, with the capacity to manage multiple projects simultaneously.
- Excellent communication skills with proven experience engaging stakeholders directly and contributing to architectural discussions.
Preferred Qualifications
- Experience with CI/CD pipelines and Azure DevOps practices.
- Familiarity with data warehousing concepts and associated tools.
- Knowledge of data governance and security standards.
About Patch Tech Staffing
Patch is dedicated to providing customized tech (IT/AV) staffing solutions that meet the unique needs and company culture of our clients across North America.
We offer staffing services for a wide range of technical positions, including software developers, network engineers, project managers, cybersecurity professionals, audio visual professionals and many more. Our extensive network of industry contacts and talent pools allows us to quickly identify and attract the best candidates for our clients' needs.
We offer flexible staffing options including temporary, contract-to-hire, and direct placement services. Whether you need to quickly fill a short-term project or hire a permanent employee, we have the expertise and resources to meet your staffing needs.