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!
Skills Required
- 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, including complex queries, data modeling, and transformation logic
- Working knowledge of Python for scripting and data transformation
- Experience ingesting data from REST APIs, including authentication, pagination, rate limiting, and semi-structured JSON/XML handling
- Experience pulling data from SQL-based sources via JDBC/ODBC with incremental load strategies such as watermarking or CDC
- Familiarity with pipeline orchestration concepts and tools such as Azure Data Factory, Databricks Workflows, or Apache Airflow
- Familiarity with Azure data services such as ADLS Gen2, Key Vault, and Azure Monitor
- Strong communication and collaboration skills
- PySpark experience
- Exposure to a modern cloud data platform such as Azure Databricks, Synapse Analytics, or Snowflake
- Additional programming language experience such as C#, PowerShell, Scala, or Java
- Experience with pipeline orchestration tools such as Azure Data Factory, Databricks Workflows, or Apache Airflow
- 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, or Databricks Workflows
- Exposure to construction, trades, or project-based industries
What We Do
Founded in 2007, Hays Electrical Services, Inc. is a leading national electrical contractor specializing in large-scale construction across commercial, healthcare, hospitality, and mission-critical infrastructure markets. Licensed in 38 states with over 1,500 employees, the company delivers sophisticated electrical solutions for high-rise and complex projects. Their mission is to be indispensable to customers through reliability, quality execution, and long-term partnerships.
