nWe are seeking a highly skilled ETL Consultant to join our client team. The ideal candidate will be responsible for designing, developing, and maintaining robust ETL processes to support data integration and analytics initiatives. This role requires a strong understanding of data warehousing, big data technologies, and cloud platforms such as Azure and AWS.n
The ETL Consultant will collaborate with cross-functional teams in an Agile environment to deliver scalable data solutions that enable insightful analysis and business decision-making.
n
Key Responsibilities
n
n
- Develop advanced SQL queries and expert-level stored procedures.
n
- Build and maintain pipelines using Azure (ADF, Synapse, ADLS) and Databricks.
n
- Perform data validation across database tables and flat files.
n
- Use Python scripting (as needed) for automation and data processing.
n
- Support risk, regulatory, and compliance data needs.
n
- Implement data quality checks and resolve data issues.
n
- Develop database schemas, optimize queries using SQL and Python scripts, and ensure data integrity across systems.
n
- Conduct analysis of data flows for performance tuning,
troubleshooting issues, and implementing improvements in ETL processes.
n
- Participate in Agile development cycles, including sprint planning, stand-ups, and retrospectives to ensure timely delivery of projects.
n
nRequired Skillsn
n
- Proven experience as an ETL Consultant or Data Engineer with a strong background in designing scalable data pipelines.
n
- Expert in SQL and stored procedure development.
n
- Experience with Azure data platform and Databricks.
n
- Solid background in data validation and reconciliation (tables & files).
n
- Python scripting experience (as needed).
n
- Experience in banking/financial services preferred.
n
nPay: $55.00-$70.00 per hourn
Ability to commute/relocate
nn
- Greater Toronto Area, ON: reliably commute or plan to relocate before starting work (required)
n
nExperience:nn
- ETL: 5 years (required)
n
- Azure: 2 years (required)
n
- SQL: 5 years (required)
n
nLocation:nn
- Greater Toronto Area, ON (required)
n
nWork Location: Hybrid remote in Greater Toronto Area, ON
Apply on Kit Job: kitjob.ca/job/2hvdj6
📌 ETL Consultant / Data Engineer (SQL, Azure, Databricks) – Banking (Greater Toronto Area)
🏢 vss
📍 Greater Toronto Area
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.