Senior BI Engineer — Semantic Modeling & Analytics

eRoad

Upper Harbour

On-site

NZD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

EROD is modernising its reporting platform and seeks a BI Engineer to own the modelling layer and deliver trusted, reusable analytics assets. You will design dimensional and semantic models, optimise SQL, and shape last-mile data used for enterprise reporting.

You will work with data engineers, analytics specialists and product managers in an Agile analytics team. The role requires 5+ years in BI/analytics modelling, experience with cloud data warehouses (Snowflake/Redshift/BigQuery/Synapse) and

Qualifications

  • 5+ years in BI engineering, analytics engineering, data warehousing or similar modelling role.
  • Hands-on experience designing dimensional and semantic models for enterprise reporting and analytics.
  • Strong SQL with query optimization across varied data formats.
  • Familiarity with Git-based workflows and CI/CD.
  • Exposure to data engineering concepts.
  • Cloud data warehouse background (Snowflake, Redshift, BigQuery, Synapse).
  • Experience with dbt or similar dimensional/semantic modelling.
  • Comfortable working with BI tools (Power BI) and modelling focus.

Responsibilities

  • Own the modelling layer turning curated data into trusted analytical assets.
  • Design and build dimensional/semantic models (star schemas, fact/dim tables).
  • Shape the Gold-layer data models powering enterprise reporting.
  • Write/optimise SQL across varied data formats.
  • Build/maintain Git-based workflows and CI/CD for BI development.
  • Collaborate with data engineers, analytics specialists and product managers to refine requirements.

Skills

BI engineering
Dimensional modelling
Semantic modelling
SQL
Git CI/CD
Cloud data warehouses
dbt
Power BI

Tools

Snowflake
Redshift
BigQuery
Synapse

Job description

EROD is modernising its reporting platform and seeks a BI Engineer to own the modelling layer and deliver trusted, reusable analytics assets. You will design dimensional and semantic models, optimise SQL, and shape last-mile data used for enterprise reporting.

You will work with data engineers, analytics specialists and product managers in an Agile analytics team. The role requires 5+ years in BI/analytics modelling, experience with cloud data warehouses (Snowflake/Redshift/BigQuery/Synapse) and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Engineer: Semantic Modeling & Analytics
BI Engineer: Semantic Modeling & Analytics

EROAD Ltd • Upper Harbour

On-site
NZD 120,000 - 170,000
BI ENGINEER
BI ENGINEER

eRoad • Upper Harbour

On-site
NZD 120,000 - 180,000
BI Engineer, Semantic Modelling & Analytics Platform
BI Engineer, Semantic Modelling & Analytics Platform

eRoad • Auckland

On-site
NZD 120,000 - 170,000
BI Engineer: Semantic Modeling & Analytics
BI Engineer: Semantic Modeling & Analytics

eRoad • New Zealand

On-site
NZD 105,000 - 160,000
BI ENGINEER
BI ENGINEER

eRoad • Auckland

On-site
NZD 120,000 - 170,000
Analytics Engineer: Build Scalable dbt/Snowflake Data Models
Analytics Engineer: Build Scalable dbt/Snowflake Data Models

Southern Cross Medical Care Society • Auckland

On-site
NZD 120,000 - 160,000
Five days wellbeing leave
Health insurance
Life insurance
+2
BI Analytics Engineer: Drive Scalable Analytics & Data
BI Analytics Engineer: Drive Scalable Analytics & Data

Meridian Energy • Wellington, Christchurch

Hybrid
NZD 120,000 - 150,000
Healthcare
Extended leave
KiwiSaver
+5
BI ENGINEER
BI ENGINEER

EROAD Ltd • Upper Harbour

On-site
NZD 120,000 - 170,000
Senior Bi Analyst
Senior Bi Analyst

Blackbull Markets • Auckland

On-site
NZD 120,000 - 180,000
Predictive Analytics Engineer | Hybrid Role
Predictive Analytics Engineer | Hybrid Role

Metlifecare Limited • Auckland

Hybrid
NZD 110,000 - 150,000
3 paid wellness days each year
A paid day off to celebrate your生日
Complimentary Health Insurance for all
+5
Top locations