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.

• 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

• 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

• 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

• 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.