Job Description

Looking for an Analytics 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.

n

You'll work across Snowflake, dbt, 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).

n

Responsibilities will include:

n

n
- Diagnosing and resolving reporting defects, metric discrepancies, failed dbt jobs, and Power BI refresh or performance issues
n
- Designing and maintaining modular dbt models, with automated tests, documentation, and lineage built in
n
- Developing and optimising Power BI semantic models, DAX measures, and dashboards
n




- Working with business stakeholders to define metrics, gather requirements, and validate that what's built matches what's needed
n
- Deciding whether logic belongs in dbt or the Power BI semantic layer to cut down on duplicated calculations
n
- Contributing to standards, code review, and CI/CD practices across the reporting stack
n

n

Skills we are looking for:

n

n
- Advanced SQL and dimensional modelling
n
- Hands-on production experience with dbt
n
- Advanced Power BI semantic modelling and DAX
n
- Experience with Snowflake
n
- Comfort diagnosing issues across the full stack — warehouse, transformation, and reporting layers
n
- Git-based development experience, with code review, testing, and CI/CD
n
- Solid stakeholder communication - you can translate business asks into technical solutions
n
- Experience in retail media, adtech, marketing analytics, ecommerce, or marketplace analytics is a plus
n

#J-18808-Ljbffr

📌 Analytics Engineer, BI & Reporting (Victoria)
🏢 iterate
📍 Victoria