BI Data Engineer: Power BI & Data Warehouse Pro

Morgan McKinley; Sydney; On-site; AUD 111,000 - 144,000; Full time

Job summary

Morgan McKinley is seeking a hands-on Data Engineer (BI) to own the journey from raw source data to trusted, business-ready reporting in Sydney. You will design the warehouse model, build pipelines, and deliver Power BI reports used across the business.

The role combines BAU and project delivery with shifting priorities in a 6‑month contract likely to extend. You'll bring deep Power BI experience, strong SQL/warehousing fundamentals, and experience with dbt or similar tools.

Qualifications

• Hands-on Power BI development across Desktop and Service.
• Strong SQL and data warehouse fundamentals (Kimball, star/snowflake, SCDs).
• Experience with dbt or similar ETL/ELT tooling.
• Experience with relational warehouses (Redshift, SQL Server) and exposure to AWS.
• Ability to gather requirements from business users and translate into specs.
• 6+ years in data engineering/BI/analytics engineering.

Responsibilities

• Design and build dimensional models (facts, dimensions, star schemas, SCDs).
• Build and maintain source-to-target pipelines using dbt and SQL.
• Develop Power BI reports from scratch: Power Query, DAX, navigation and semantic models.
• Capture stakeholder needs and craft clear technical specifications.
• Implement data validation and quality controls for trusted reporting.
• Tune SQL and models for performance.

Skills

Power BI development

SQL & data warehousing

dbt / ETL tooling

Relational warehouses (Redshift/SQL-SS

Business-facing requirements

4+ years data engineering/BI

Tools

dbt

Power BI

Redshift

SQL Server

AWS

Job description

Morgan McKinley is seeking a hands-on Data Engineer (BI) to own the journey from raw source data to trusted, business-ready reporting in Sydney. You will design the warehouse model, build pipelines, and deliver Power BI reports used across the business.

The role combines BAU and project delivery with shifting priorities in a 6‑month contract likely to extend. You'll bring deep Power BI experience, strong SQL/warehousing fundamentals, and experience with dbt or similar tools.