ETL Engineer – Cloud Data Lakehouse & Pipeline Development

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.

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!