ETL Engineer
No salary listed
Mid
Houston, TX, USA
In Person
Data & AnalyticsData Engineering
About the job
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, 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 handling semi-structured JSON and XML.
- Experience pulling data from SQL-based sources via JDBC or ODBC with incremental load strategies such as watermarking and change data capture.
- 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.
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, including ERP, project management, and field operations, through 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.
Desired Qualifications
- PySpark experience is a strong plus.
- Exposure to a modern cloud data platform such as Azure Databricks, Synapse Analytics, or Snowflake.
- Experience with additional programming languages such as C#, PowerShell, Scala, or Java.
- Experience with pipeline orchestration tools such as Azure Data Factory, Databricks Workflows, or Apache Airflow.
- Understanding of change data capture concepts or patterns.
- Familiarity with data catalog or governance tooling.
- Familiarity with business intelligence 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.
About the company
Hays Electrical Services installs electrical systems for large construction projects across the United States, from hotels and hospitals to apartment towers and data centers. Many of its jobs are renovations inside buildings that stay open, such as busy hotels, an active hospital and an airport terminal, so crews phase work around guests and patients. Building owners and general contractors hire it for a project's electrical scope, from estimating and 3D design coordination through prefabrication, installation and later service calls. Its crews also install low-voltage systems such as fire alarms, security equipment and data cabling. Hays Electrical Services was founded in 2007 and is headquartered in Houston, Texas.
Company Size
1,001-5,000
Company Stage
N/A
Total Funding
N/A
Headquarters
Houston, TX
Founded
2007
Get referred to Hays Electrical Services
See people who can refer or advise you
Simplify's Take
What believers are saying
- Hays says growth is creating jobs: it cites 146% corporate headcount growth over two years, from LinkedIn workforce data.
- One Dallas data center posting adds incentive pay: Hays lists journeymen at up to $48 an hour plus $10 hourly.
- Injuries have not cost crews workdays: Hays reports a zero lost-time injury rate for 2023 through 2025.
What critics are saying
- Some field leadership jobs mean travel: Hays posts traveling foreman and superintendent roles listed as remote or nationwide.
- Solar contracts put cash at risk: Hays' utility solar managers track contract penalties and retainage, money withheld until completion.
- Apprenticeship means night school: classes meet on set weekdays from 5 to 9 PM, about 40 weeks a year.
What makes Hays Electrical Services unique
- Power-ups have one gatekeeper: on data center jobs, Hays' Energy Marshal controls energizing and lockout of circuits.
- Hays trains its own electricians: a four-year apprenticeship it co-created, registered with the Labor Department, admits only Hays employees.
- Hays is set up for out-of-state work: the contractor reports licenses in 38 states.
Help us improve and share your feedback! Did you find this helpful?