Data Engineer

Job summary

Design, develop, and maintain scalable data solutions and ETL/ELT pipelines using Azure, Databricks, DBT, Python, PySpark, and SQL. Optimize data pipelines, SQL queries, and Spark jobs while supporting data transformation, integration, and lakehouse workflows.

Job details

One of our clients is looking for an experienced Data Engineer - Canada (Remote) for a contract opportunity. Work Authorization: Canadian Citizens only! Must Have Keywords: Data Engineering, Azure, Databricks, DBT, Python, PySpark, SQL, Unity Catalog, Lakebase 8+ years of hands-on experience in Data Engineering, designing, developing, and maintaining scalable data solutions. Strong hands-on experience with Databricks and Azure Data Services. Strong DBT skills, including building, testing, documenting, and maintaining data transformation models and workflows. Strong Python programming skills for data engineering, automation, and data processing. Decent hands-on experience with PySpark for large-scale data processing, transformation, and ETL/ELT development. Advanced SQL skills, including complex queries, data transformation, optimization, and troubleshooting. Hands-on experience designing, developing, and maintaining ETL/ELT data pipelines. Strong understanding of data warehousing, data modeling, data integration, and distributed data processing. Experience working with Azure-based data platforms and services. Experience with Databricks Notebooks, Jobs/Workflows, Delta Lake, and Unity Catalog. Ability to troubleshoot performance issues and optimize data pipelines, SQL queries, and Spark jobs. Strong written and verbal communication skills, with the ability to effectively collaborate with technical and business stakeholders. Strong analytical, problem-solving, and troubleshooting skills. Knowledge or hands-on exposure to Lakebase is a plus. Experience with modern lakehouse architecture and cloud-based data platforms is preferred. Experience working in Agile development environments is preferred. If you are interested, please send your updated resume to harsh@phtstaffing.com

What you’ll do

Design, develop, and maintain scalable data solutions and ETL/ELT pipelines using Azure, Databricks, DBT, Python, PySpark, and SQL. Optimize data pipelines, SQL queries, and Spark jobs while supporting data transformation, integration, and lakehouse workflows.

Requirements

Requires 8+ years of hands-on data engineering experience, strong skills in Databricks, Azure, DBT, Python, and SQL, and practical PySpark experience. Applicants must be Canadian citizens and have experience with data pipelines, data warehousing, data modeling, and distributed data processing; Lakebase exposure is a plus.

Listed skills

• Microsoft Azure · Preferred
• SQL · Preferred
• Agile · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Engineering
• Azure
• Databricks
• DBT
• Python
• PySpark
• SQL
• Unity Catalog
• Lakebase
• ETL/ELT
• Data Modeling
• Data Warehousing
• Delta Lake
• Data Pipeline Optimization
• Distributed Data Processing
• Agile

Job areas

• Data & Analytics
• Technology
• Software
• Engineering