Data Engineer 2

About the role

In the role of Data Engineer 2, we'll count on you to:

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

Responsibilities

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.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or equivalent practical experience.
• Minimum 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.

Preferred Qualifications

• Hands-on experience with dbt Cloud or dbt Core in Git-integrated workflows.
• Experience with orchestration tools (e.g., Airflow, Dagster, Prefect) and scheduling patterns.
• Experience implementing CI/CD quality gates for data (tests, linting, docs artifacts).

Qualifications

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

Skills

• Hands-on experience with dbt Cloud or dbt Core in Git-integrated workflows.
• Experience with orchestration tools (e.g., Airflow, Dagster, Prefect) and scheduling patterns.
• Experience implementing CI/CD quality gates for data (tests, linting, docs artifacts).

Benefits

At HDR, we believe in fostering a culture of inclusion and belonging. Our Employee Network Groups provide support and resources for diverse backgrounds and identities. We also offer competitive compensation packages, comprehensive benefits, and opportunities for professional growth and development.

Pay

The salary range for this position is $85,000 - $120,000 annually, depending on experience and qualifications.

Schedule

This is a full-time position with a standard workweek.

Business Class

Marketing and Admin

Job Posting

May 27, 2026

At HDR

We are committed to the principles of employment equity. We are an Affirmative Action and Equal Opportunity Employer.