BI Engineer, Semantic Modelling & Analytics Platform

EROAD; Auckland; On-site; NZD 120,000 - 170,000; Full time

Job summary

EROAD is seeking a BI Engineer (Semantic Modelling & Reporting) to shape the next generation of its analytics capability in Auckland, NZ. You will design dimensional and semantic models and work across data, analytics, and product teams.

You'll partner with data engineers and stakeholders, optimise SQL, build Git-based pipelines, and contribute to modernising the BI platform, helping establish scalable reporting for enterprise needs.

Qualifications

• 5+ years in BI engineering, analytics engineering, data warehousing or similar.
• Experience designing dimensional and semantic models for enterprise reporting.
• Strong SQL skills and data format variety; knowledge of cloud warehouses.

Responsibilities

• Design and build dimensional and semantic models including star schemas and conformed dimensions.
• Shape gold-layer data models powering enterprise reporting and analytics.
• Write and optimise SQL across varied data formats for modelling and reporting.
• Build and maintain Git-based workflows and CI/CD pipelines for BI development.
• Partner with stakeholders to refine requirements and translate into reliable data models.
• Collaborate with data engineers, analytics specialists, cloud developers and product managers in an agile team.
• Report to Analytics Chapter Lead and contribute to BI tooling platform modernisation.

Skills

Dimensional modelling

Semantic modelling

SQL

Data warehousing

Git CI/CD

Cloud data warehouses

dbt

Power BI

Stakeholder collaboration

Agile analytics

Tools

dbt

Power BI

Snowflake

Redshift

BigQuery

Synapse

Git

Job description

EROAD is seeking a BI Engineer (Semantic Modelling & Reporting) to shape the next generation of its analytics capability in Auckland, NZ. You will design dimensional and semantic models and work across data, analytics, and product teams.

You'll partner with data engineers and stakeholders, optimise SQL, build Git-based pipelines, and contribute to modernising the BI platform, helping establish scalable reporting for enterprise needs.