BI Data Engineer: Power BI & Data Warehouse Architect

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 data journeys from raw sources to business-ready reporting in Sydney's CBD. You will design warehouse models, build pipelines, and deliver Power BI reports relied upon across the business.

The role blends BAU and project work, requiring strong SQL, Power BI, and warehousing expertise. 6-month contract with potential extension, on-site in Sydney.

Qualifications

• Hands-on Power BI development experience in Desktop and Service.
• Strong SQL and warehousing fundamentals (Star/Snowflake, SCDs).
• Experience with dbt or similar transformation tool; relational data warehouses like Redshift or SQL Server; AWS exposure is a plus.

Responsibilities

• Design and build dimensional models (facts, dimensions, star schemas, SCDs) for reporting.
• Build and maintain source-to-target pipelines using dbt and SQL.
• Develop Power BI reports from discovery to published semantic models.

Skills

Power BI

SQL

Data warehousing

dbt

Redshift

SQL Server

AWS

Stakeholder communication

Tools

Power BI Desktop

Power BI Service

DAX

Power Query

Job description

Morgan McKinley is seeking a hands-on Data Engineer (BI) to own data journeys from raw sources to business-ready reporting in Sydney's CBD. You will design warehouse models, build pipelines, and deliver Power BI reports relied upon across the business.

The role blends BAU and project work, requiring strong SQL, Power BI, and warehousing expertise. 6-month contract with potential extension, on-site in Sydney.