BI Engineer

Iterate; City of Melbourne; On-site; AUD 120,000 - 170,000; Full time

Job summary

Iterate is seeking a BI Engineer to own reporting that actually gets used. You will manage the dbt-built data layer and Power BI semantic models for commercial reporting, diagnosing issues, shipping fixes, and elevating how the business views its numbers.

You'll collaborate with data engineering and business teams relying on daily metrics. The role involves working across Snowflake, dbt, SQL and Power BI to design modular models, ensure data accuracy, and deliver trustworthy dashboards that

Qualifications

• Strong SQL and dimensional modelling
• Hands-on production experience with dbt
• Advanced Power BI semantic modelling and DAX
• Experience with Snowflake
• Diagnosing issues across the full data/reporting stack
• Git-based development with code review, testing and CI/CD
• Strong stakeholder communication to translate business asks into technical solutions

Responsibilities

• Diagnosing and resolving reporting defects, metric discrepancies, failed dbt jobs, and Power BI refresh or performance issues
• Designing and maintaining modular dbt models with automated tests, documentation and lineage
• Developing and optimising Power BI semantic models, DAX measures and dashboards
• Working with business stakeholders to define metrics, gather requirements, and validate that what's built matches what's needed
• Deciding whether logic belongs in dbt or the Power BI semantic layer to reduce duplicated calculations
• Contributing to standards, code review, and CI/CD practices across the reporting stack

Skills

Advanced SQL

Dimensional modelling

dbt production experience

Power BI modelling and DAX

Snowflake

Git-based development

Stakeholder communication

Tools

dbt

Snowflake

Power BI

Git

Job description

Looking for a BI Engineer who wants ownership over reporting that actually gets used. This role owns the dbt-built data layer and Power BI semantic models behind commercial reporting - diagnosing issues, shipping fixes, and levelling up how the business sees its own numbers.
You'll work across Snowflake, dbt, SQL and Power BI, sitting between data engineering and the business teams who rely on the numbers daily. It's part detective work (root-causing failed dbt jobs, refresh failures, and metric mismatches) and part builder (designing modular dbt models and DAX-driven semantic layers that make reporting faster, cleaner, and more trustworthy).

Responsibilities will include:

• Diagnosing and resolving reporting defects, metric discrepancies, failed dbt jobs, and Power BI refresh or performance issues
• Designing and maintaining modular dbt models, with automated tests, documentation, and lineage built in
• Developing and optimising Power BI semantic models, DAX measures, and dashboards
• Working with business stakeholders to define metrics, gather requirements, and validate that what's built matches what's needed
• Deciding whether logic belongs in dbt or the Power BI semantic layer to cut down on duplicated calculations
• Contributing to standards, code review, and CI/CD practices across the reporting stack

Looking for a BI Engineer who wants ownership over reporting that actually gets used. This role owns the dbt-built data layer and Power BI semantic models behind commercial reporting - diagnosing issues, shipping fixes, and levelling up how the business sees its own numbers.
You'll work across Snowflake, dbt, SQL and Power BI, sitting between data engineering and the business teams who rely on the numbers daily. It's part detective work (root-causing failed dbt jobs, refresh failures, and metric mismatches) and part builder (designing modular dbt models and DAX-driven semantic layers that make reporting faster, cleaner, and more trustworthy).

Responsibilities will include:

• Diagnosing and resolving reporting defects, metric discrepancies, failed dbt jobs, and Power BI refresh or performance issues
• Designing and maintaining modular dbt models, with automated tests, documentation, and lineage built in
• Developing and optimising Power BI semantic models, DAX measures, and dashboards
• Working with business stakeholders to define metrics, gather requirements, and validate that what's built matches what's needed
• Deciding whether logic belongs in dbt or the Power BI semantic layer to cut down on duplicated calculations
• Contributing to standards, code review, and CI/CD practices across the reporting stack

Skills we are looking for:

• Advanced SQL and dimensional modelling
• Hands-on production experience with dbt
• Advanced Power BI semantic modelling and DAX
• Experience with Snowflake
• Comfort diagnosing issues across the full stack — warehouse, transformation, and reporting layers
• Git-based development experience, with code review, testing, and CI/CD
• Strong stakeholder communication - you can translate business asks into technical solutions