BI Engineer: Own Data Layer & Insightful BI Dashboards

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

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