Job description

Position Summary We are modernizing our data platform on Azure and seeking an ETL Engineer to help build and maintain a layered data lakehouse. This is a hands-on role with a clear growth path focusing on pipeline implementation and data platform development. Key Responsibilities • Build and maintain ETL/ELT pipelines on Azure, applying modern lakehouse patterns including incremental loads and schema evolution • Implement and manage a layered data architecture from raw ingestion to business-ready analytical datasets • Integrate data from business systems (ERP, project management, field operations) via REST APIs and SQL source connections • Build and manage pipeline workflows using tools such as Azure Data Factory, Databricks Workflows, or Apache Airflow • Collaborate with senior leadership to implement data models and pipeline designs • Monitor pipeline health, troubleshoot data quality issues, and maintain logging and alerting • Maintain technical documentation for pipelines, data models, and platform standards • Contribute to coding, testing, and deployment best practices • Participate in code reviews and grow toward broader engineering ownership over time Required Qualifications • Experience in data engineering, ETL development, or a closely related field • Working knowledge of layered data architecture and modern data warehouse or lakehouse patterns • Strong SQL proficiency – complex queries, data modeling, and transformation logic • Working knowledge of Python for scripting and data transformation; PySpark experience a strong plus • Experience ingesting data from REST APIs – authentication, pagination, rate limiting, and semi-structured JSON/XML handling • Experience pulling from SQL-based sources via JDBC/ODBC with incremental load strategies (watermarking, CDC) • Familiarity with pipeline orchestration concepts and tools (Azure Data Factory, Databricks Workflows, Apache Airflow, or similar) • Familiarity with Azure data services (ADLS Gen2, Key Vault, Azure Monitor, or similar) • Strong communication and collaboration skills Preferred Qualifications • Exposure to a modern cloud data platform (Azure Databricks, Synapse Analytics, Snowflake, or similar) • Additional programming language experience (C#, PowerShell, Scala, Java, or similar) • Experience with pipeline orchestration tools (Azure Data Factory, Databricks Workflows, Apache Airflow, or similar) • Understanding of CDC concepts or patterns • Familiarity with data catalog or governance tooling • Familiarity with BI tools such as Power BI • Experience with ETL tooling such as SSIS, Informatica, Azure Data Factory, Databricks Workflows, or similar • Exposure to construction, trades, or project-based industries Benefits • Competitive salary based on experience. • Comprehensive benefits package including medical, dental, vision, and 401(k). • Career progression path toward Controller leadership. • Professional development and continuing education support. • Collaborative and growth-focused work environment. Join a company that’s building more than just electrical systems—join a team committed to excellence and innovation. If you meet the qualifications outlined above and are ready to contribute your skills to the team at Hays Electrical Services, we encourage you to apply. Join us in providing exceptional service for our clients and supporting our company's operations. Apply now!

Requirements

Must-haves

We are modernizing our data platform on Azure and seeking an ETL Engineer to help build and maintain a layered data lakehouse.
This is a hands-on role with a clear growth path focusing on pipeline implementation and data platform development.
Build and maintain ETL/ELT pipelines on Azure, applying modern lakehouse patterns including incremental loads and schema evolution
Implement and manage a layered data architecture from raw ingestion to business-ready analytical datasets
Integrate data from business systems (ERP, project management, field operations) via REST APIs and SQL source connections
Build and manage pipeline workflows using tools such as Azure Data Factory, Databricks Workflows, or Apache Airflow
Collaborate with senior leadership to implement data models and pipeline designs
Monitor pipeline health, troubleshoot data quality issues, and maintain logging and alerting
Maintain technical documentation for pipelines, data models, and platform standards
Contribute to coding, testing, and deployment best practices
Participate in code reviews and grow toward broader engineering ownership over time
Experience in data engineering, ETL development, or a closely related field

Nice-to-haves

Exposure to a modern cloud data platform (Azure Databricks, Synapse Analytics, Snowflake, or similar)
Additional programming language experience (C#, PowerShell, Scala, Java, or similar)
Experience with pipeline orchestration tools (Azure Data Factory, Databricks Workflows, Apache Airflow, or similar)
Understanding of CDC concepts or patterns
Familiarity with data catalog or governance tooling
Familiarity with BI tools such as Power BI
Experience with ETL tooling such as SSIS, Informatica, Azure Data Factory, Databricks Workflows, or similar
Exposure to construction, trades, or project-based industries
Benefits • Competitive salary based on experience.
Career progression path toward Controller leadership.
Professional development and continuing education support.
Collaborative and growth-focused work environment.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

azurerestsqlpythonjava

Platform: jazzhr
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Professional Development