Data Engineer - ETL/ELT, Oracle, SQL Server, Snowflake, Azure SQL, Medallion Architecture, Spark, Python
Toronto, ON - Hybrid (4 Days WFO)
12Months Contract
Key Responsibilities
- Design and Develop ETL ELT Pipelines Build scalable data ingestion and transformation processes using industry best practices, supporting both batch and real-time data flows Architect Data Solutions Implement and optimize Medallion Architecture (Bronze, Silver, Gold layers) across cloud and on-premises data platforms
- Manage Hybrid Infrastructure Work seamlessly with both on-premises databases and cloud data platforms, ensuring data consistency and performance across environments
- Lead Pipeline Development Own the design and execution of batch data pipelines, ensuring reliability, scalability, and maintainability
- Troubleshoot and Optimize Diagnose and resolve complex data pipeline issues, performance bottlenecks, and integration challenges with a detailed, methodical approach
- Collaborate Cross-Functionally Partner with analytics teams, data scientists, and stakeholders to understand requirements and deliver solutions that drive business value
Required Qualifications
- Proven hands-on experience with ETLELT tools and frameworks Demonstrated expertise with both on-premises (Oracle, SQL Server, PostgreSQL) and cloud databases (Snowflake, BigQuery, Redshift, Azure SQL)Strong experience building and implementing Medallion Architecture patterns
- Proficiency with cloud data lakehouses and warehouses as well as on-premises data lake solutions
- Solid experience designing, building, and optimizing batch data pipelines
- Advanced troubleshooting and problem-solving skills with attention to detail
- Strong communication and documentation practices
Preferred Qualifications
- Experience with pipeline orchestration tools (Apache Airflow, Databricks Workflows, Azure Data Factory)
- Knowledge of data quality frameworks and governance
- Experience with version control and CICD practices
- Familiarity with Spark, Python, SQL, or similar data technologies
- Leadership or mentoring experience
Pay: $50.00-$53.00 per hour
Work Location: Hybrid remote in Toronto, ON (Toronto District)
