ETL Engineer – Cloud Data Lakehouse & Pipeline Development

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!