Analytics Engineer 2

HDR; Omaha (NE); On-site; USD 70,000 - 90,000; Full time

Job summary

HDR is seeking a data professional in Omaha, Nebraska to design and develop analytics models that align with business needs. The ideal candidate will have a Bachelor’s degree in Computer Science or related fields, along with experience in analytics and proficiency in SQL.

Responsibilities include creating data models, implementing standardized patterns, and maintaining documentation. Preferred skills include familiarity with dbt and BI tools such as Power BI or Tableau. Join HDR to drive data-driven decisions in a supportive environment.

Qualifications

• Bachelor’s degree in a relevant field.
• Experience in analytics, BI, or data roles with SQL proficiency.
• Ability to translate business requirements into stable data models.

Responsibilities

• Design and develop analytics models for business reporting.
• Implement models using modular SQL design and layered patterns.
• Define and document KPIs/metrics across reporting surfaces.

Skills

SQL proficiency

Data modeling

Business Intelligence (BI)

Analytical skills

Education

Bachelor’s degree in Computer Science, Information Systems, or Data Engineering

Tools

dbt Cloud or dbt Core

Power BI

Tableau

Job description

At HDR, we are committed to the principles of employment equity. We are an affirmative action and equal opportunity employer. We consider all qualified applicants, regardless of criminal histories, arrests, and conviction records.

Responsibilities

• Design and develop analytics models aligned to business processes and reporting needs.
• Create curated marts and semantic structures that promote reuse and consistent interpretation.
• Partner with analysts to translate business questions into durable data models.
• Implement models using layered patterns (raw/conformed/curated) and modular SQL design.
• Use managed dependencies and reusable components (e.g., shared functions/templates) for standardized patterns and reuse.
• Apply incremental strategies where appropriate to improve refresh performance and manage costs.
• Define, document, and maintain KPIs/metrics; ensure consistent definitions across reporting surfaces.
• Maintain transformation-layer documentation (model/column descriptions) and publish lineage artifacts for impact analysis.
• Contribute to governance practices including naming conventions, tagging/metadata, and change management.
• Implement automated tests and freshness checks to ensure the reliability of published analytics datasets.
• Participate in peer review and CI checks to improve quality and reduce regressions.
• Enable stakeholders through documentation, demos, and shared patterns to support adoption.

Preferred Qualifications

• In depth experience with dbt Cloud or dbt Core with Git integration.
• Experience with BI tools (e.g., Power BI, Tableau) and semantic modeling patterns.
• Familiarity with CI/CD for analytics models (PR-based testing, documentation builds, promotion).

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or other applicable degree.
• Experience in analytics, BI, or data roles with demonstrated modeling and SQL proficiency.
• Ability to translate business requirements into stable, reusable data models.
• Familiarity with BI/reporting consumption patterns.