Cyber Insights & Analytics Engineer (Power BI + Azure Data Pipelines)

Transport for NSW; Sydney; On-site; AUD 120,000 - 180,000; Full time

Benefits offered by this job

Flexible work options

Job summary

Transport for NSW’s Cyber Insights & Analytics team is seeking a data engineering and analytics professional to design, build and support enterprise-scale data pipelines and reporting solutions. You will deliver trusted data for executive reporting and cyber operational insights, combining Azure data technologies with Power BI to enable self-service analytics across the function.

You will work with Cyber Governance, Operational and Technical SMEs to translate requirements into scalable

Qualifications

• 5+ years' experience developing and supporting enterprise-scale ETL/ELT pipelines, data marts and data integration solutions using Azure Data Factory (or similar technologies) and T-SQL.
• Demonstrated expertise building executive-ready Power BI reports, dashboards and semantic models using DAX and Power Query (M).
• Strong experience designing and implementing dimensional data models including fact and dimension structures based on Kimball methodologies.
• Experience troubleshooting and optimising data ingestion, transformation and reporting solutions in Azure environments.
• Exposure to Azure DevOps and CI/CD practices for deployment and support of data and reporting solutions.
• Sound understanding of data governance, metadata management and Power BI security controls such as Row Level Security (RLS).
• Strong stakeholder engagement and communication skills, with the ability to present analysis and insights to both technical and executive audiences.

Responsibilities

• Design, develop and support enterprise-scale ETL/ELT pipelines, data integrations, APIs and data ingestion processes using Azure-based technologies.
• Build and maintain reliable data marts, dimensional models and transformation processes to ensure trusted, high-quality reporting data.
• Develop semantic models and executive-ready Power BI dashboards that deliver meaningful cyber and operational insights.
• Partner with Cyber Governance, Operational and Technical SMEs to translate business requirements into fit-for-purpose reporting solutions.
• Troubleshoot and optimise data pipelines, ingestion processes and reporting solutions across Azure SQL, Azure Data Factory, Azure DevOps and Power BI.
• Apply CI/CD practices and contribute to improvements in reporting standards, documentation, metadata management and governance frameworks.
• Support the uplift of self-service analytics capabilities across the Cyber function through the delivery of trusted and governed reporting products.

Skills

Azure Data Factory

T-SQL

DAX

Power Query (M)

Dimensional modeling

Kimball methodology

Azure DevOps

CI/CD for data

Data governance

Power BI security (RLS)

Stakeholder engagement

Tools

Azure Data Factory

Power BI

Job description

Transport for NSW’s Cyber Insights & Analytics team is seeking a data engineering and analytics professional to design, build and support enterprise-scale data pipelines and reporting solutions. You will deliver trusted data for executive reporting and cyber operational insights, combining Azure data technologies with Power BI to enable self-service analytics across the function.

You will work with Cyber Governance, Operational and Technical SMEs to translate requirements into scalable