ETL Engineer – Cloud Data Lakehouse & Pipeline Development

Hays Electrical Services • Houston, TX

1d

About The Position

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.

Requirements

• 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

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

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

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed