Analytics Engineer

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.

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

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

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