Data Engineer 2
About this role
At HDR, our employee-owners are fully engaged in creating a welcoming environment where each of us is valued and respected, a place where everyone is empowered to bring their authentic selves and novel ideas to work every day. As we foster a culture of inclusion throughout our company and within our communities, we constantly ask ourselves: What is our impact on the world?
Watch Our Story:' https://www.hdrinc.com/our-story'
Each and every role throughout our organization makes a difference in our ability to change the world for the better. Read further to learn how you could help make great things possible not only in your community, but around the world.
- 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, notnull, acceptedvalues) 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.
- 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.
What We Believe
HDR is our company. Together, we build on each other's life experiences and perspectives to make great things possible every day. This shapes our collaborative culture, encourages organizational trust and connects us closer to the clients and communities we serve.
Our Commitment
As employee owners, we all have a role in creating an inclusive environment where each of us is welcomed, valued, respected and empowered to bring our authentic selves to work every day.
Our eight Employee Network Groups (Asian Pacific, Black, Hispanic/Latino(a), LGBTQ+, People with Disabilities, Veterans, Women, Young Professionals) help create a sense of belonging and foster a supportive environment where everyone is empowered to engage and contribute. Each group has an executive sponsor and is open to all employees.
Company at a glance
HDR is an employee-owned design firm specializing in engineering, architecture, environmental and construction services. We’re ranked No. 6 among the world’s design firms and we’re the largest healthcare design firm. Led by the strength of our values and a culture shaped by employee ownership, we network with each other, build on each other’s contributions, and collaborate together to make great things possible.
When you join HDR, we give you license to do the same. We help you take charge of your career, giving you multiple growth opportunities along the way.
So, what are you waiting for? Come grow with us.
Top Benefits
- Employee ownership
- Inclusive environment
- Employee network groups
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?