Data Engineer 2

HDR is an employee-owned company focused on creating positive impacts in communities and around the world. The Data Engineer II will build and maintain data ingestion pipelines, develop reliable and well-documented transformation models, and support data quality, CI/CD, monitoring, and operational processes.

Responsibilities

Build and maintain batch and streaming ingestion pipelines from source systems into the enterprise data platform

Implement robust error handling, retries, and recovery patterns to improve reliability

Collaborate with platform teams on connectivity, access, and operational readiness

Develop transformation models using a layered structure (raw, conformed, curated) to separate concerns and improve maintainability

Use dependency management patterns to ensure correct build order and reproducible transformations

Leverage shared code and reusable components to standardize patterns, reduce duplication, and enforce consistent logic

Implement incremental processing where appropriate to reduce runtime and warehouse cost

Implement data quality tests (e.g., unique, not_null, accepted_values) on critical models and key business entities

Configure and monitor source freshness expectations for important upstream datasets

Maintain model and column-level documentation; publish documentation and lineage to enable impact analysis and change management

Integrate transformations into CI/CD workflows (build, test, docs generation) before promotion to higher environments

Participate in code reviews, follow branching standards, and adhere to quality gates and approval processes

Support release and rollback practices to maintain stability and reduce risk

Tune transformations for performance and efficiency; partner with stakeholders to manage cost impacts

Support monitoring and alerting for pipelines and transformations; respond to incidents and perform root cause analysis

Document operational procedures and contribute to runbooks/playbooks

Company

Employee-owned design firm for engineering, architecture, environmental and construction services.

Omaha, Nebraska, USA

http://www.hdrinc.com/

Founded in 1917

10001+ employees

Qualifications

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or equivalent practical experience

A minimum of 3 years of experience in data engineering, data integration, or related roles

Proven SQL proficiency and experience building transformations and pipelines

Familiarity with cloud data platforms and modern ELT patterns

Glassdoor

4.0

HDR is an employee-owned design firm specializing in engineering, architecture, environmental and construction services. We’re ranked No.

Omaha, Nebraska, USA

http://www.hdrinc.com

H1B Sponsorship

Data Powered by

Distribution of Different Job Fields Receiving Sponsorship

94

Represents job field similar to this job

Engineering and Development

Customer Service and Support

Trends of Total Sponsorships

*2026

(6)

2025

(3)

2024

(4)

2023

2022

2021

(5)

2020

(8)

Late Stage

Leadership Team

Bill Manhart

Chief Human Resources Officer

Galen Meysenburg

CFO

Recent News

Google Patent

System and method for groundwater remediation

2026-10-11

Njbiz

Required skills

SQL, Data Engineering, Data Integration, Data Pipelines, Cloud Data Platforms, ELT Patterns

Experience

3+ years