Data Engineer

Job summary

Design, build, and maintain automated enterprise data pipelines and ETL processes using Python, SQL, and AWS. Analyze and validate data, troubleshoot pipeline issues, optimize performance, and collaborate with analytics and business teams to provide reliable reporting datasets.

Job details

Summary We are looking for a Data Engineer to design, build, and automate scalable data pipelines. In this role, you will leverage strong Python and SQL expertise to extract, transform, and load data from varied sources, ensuring high data quality and supporting analytics across the organization. This is a long-term consulting job and the client is one of the major banks. Working Model: Hybrid – 2 days onsite in Toronto Location: M1W, Scarborough In-person Interview is required Key Responsibilities Design, build, and maintain automated data pipelines for enterprise applications. Develop efficient ETL processes to extract, transform, and load data across systems. Write complex SQL queries and Python scripts for data processing and validation. Perform data analysis to troubleshoot pipeline issues, verify data integrity, and optimize performance. Collaborate with analytics and business teams to deliver reliable datasets for business reporting. Requirements & Qualifications 7+ years of experience as a Data Engineer or in a closely related data role. Strong proficiency in Python for data manipulation and automation scripts. Advanced SQL skills for data transformation, querying, and relational database management. Hands-on experience building and maintaining data pipelines within the AWS cloud ecosystem. Solid track record building automated ETL pipelines and managing batch workflows. Strong analytical and problem-solving skills to ensure high data quality and accuracy.

What you’ll do

Design, build, and maintain automated enterprise data pipelines and ETL processes using Python, SQL, and AWS. Analyze and validate data, troubleshoot pipeline issues, optimize performance, and collaborate with analytics and business teams to provide reliable reporting datasets.

Requirements

Requires 7+ years of experience in data engineering or a closely related role, strong Python and advanced SQL skills, and hands-on experience with AWS data pipelines. Candidates should have a track record building automated ETL pipelines and managing batch workflows, along with strong analytical and problem-solving skills.

Listed skills

• SQL · Preferred
• Problem solving · Preferred
• Data Validation · Preferred
• Data analysis · Preferred
• Amazon Web Services · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Python
• SQL
• Data Engineering
• Data Pipelines
• ETL
• AWS
• Data Processing
• Data Validation
• Data Analysis
• Data Integrity
• Batch Workflows
• Relational Database Management
• Performance Optimization
• Problem-Solving

Job areas

• Data & Analytics
• Technology
• Software
• Consulting
• Finance & Accounting

More jobs from UniSysTech Consulting