BI ENGINEER

EROAD Ltd; Upper Harbour; On-site; NZD 120,000 - 170,000; Full time

Job summary

EROAD Ltd in Auckland is seeking a BI Engineer (Semantic Modelling & Reporting) to shape the next generation of its analytics capability. You will own the modelling layer and deliver trusted data assets across the business.

Work with data engineers, analytics specialists and product managers in a pragmatic agile analytics team, partnering with stakeholders to refine requirements and deliver valuable business insights.

Qualifications

• 5+ years in BI engineering, analytics engineering, data warehousing or similar modelling role.
• Hands-on experience delivering dimensional and semantic models for enterprise reporting.
• Strong SQL skills and familiarity with Git-based workflows and CI/CD.

Responsibilities

• Own the dimensional and semantic modelling layer across analytics assets.
• Design star schemas, fact and dimension tables, and conformed dimensions.
• Shape the Gold-layer data models powering enterprise reporting and analytics.
• Write and optimise SQL across varied data formats for modelling needs.
• Build and maintain Git-based workflows and CI/CD pipelines for BI development.
• Collaborate with technical and non-technical stakeholders to refine requirements.
• Work with data engineers, analytics specialists, cloud developers and product managers in an agile analytics team.
• Report to the Chapter Lead - Analytics and contribute to BI tooling modernisation.

Skills

BI engineering

Analytics engineering

Data warehousing

Dimensional modelling

Semantic modelling

Tools

dbt

Power BI

SQL

Git CI/CD

Snowflake/Redshift/BigQuery/Synapse

Job description

ABOUT THE COMPANY

ERoad is a global fleet management technology company, listed on both the NZX and ASX, helping fleet operators run safer and more compliant operations through its integrated hardware and software platform.

As EROAD modernises its reporting platform, it's hiring a BI Engineer (Semantic Modelling & Reporting) to help shape the next generation of its analytics capability.

WHAT YOU'LL DO

• You'll own the modelling layer that turns curated data into trusted, reusable analytical assets across the business.
• Design and build dimensional and semantic models, including star schemas, fact and dimension tables, and conformed and slowly changing dimensions.
• Shape the Gold-layer, last-mile data models that power enterprise reporting and analytics.
• Write and optimise SQL across varied data formats to support modelling and reporting needs.
• Build and maintain Git-based workflows and CI/CD pipelines for BI development.
• Partner with technical and non-technical stakeholders to refine requirements and translate them into reliable data models.
• Work alongside data engineers, analytics specialists, cloud developers and product managers as part of a pragmatic, agile analytics team.
• Report to the Chapter Lead - Analytics and contribute to the broader modernisation of EROAD's BI tooling and platform.

WHAT YOU NEED

• A solid Business Intelligence background with 5+ years in BI engineering, analytics engineering, data warehousing or a similar analytical modelling role.
• Hands-on experience designing and delivering dimensional and semantic models for enterprise reporting and analytics.
• Strong SQL skills, including query optimisation and working with varied data formats.
• Familiarity with Git-based workflows and CI/CD.
• Exposure to data engineering concepts.
• Confidence partnering with both technical and non-technical stakeholders to refine requirements and deliver business value.
• Any cloud data warehouse background works well here, Snowflake, Redshift, BigQuery or Synapse are all welcome.
• A transformation tool such as dbt is a plus, or equivalent depth in dimensional and semantic modelling.
• Comfortable working in a reporting or BI tool such as Power BI, since modelling skill matters more than the specific platform.

WHY JOIN

This is a chance to shape the semantic modelling foundation of a platform modernisation effort at a listed, high-growth tech company.

Influence how EROAD's BI platform and tooling evolve as the team modernises its reporting stack.

Work alongside a talented, collaborative team of data engineers, analytics specialists, cloud developers and product managers.

Be part of a true Kiwi success story, publicly listed on the NZX and ASX and growing across New Zealand, Australia, the Philippines and the USA.

Join a multicultural organisation that invests in continuous learning, EAP support and AI tooling to help its people grow.

ERoad provide in-vehicle technology solutions to fleets in New Zealand, Australia and North America to help them operate more safely and efficiently – making our roads safer and more sustainable for everyone.