Snr Specialist Cyber Insights &Analytics

Transport for NSW; Sydney; On-site; AUD 138,000 - 154,000; Full time

Job summary

Transport For NSW is seeking a data and analytics professional to join the Cyber Insights & Analytics team in Macquarie Park. You will design and support enterprise ETL/ELT pipelines, data marts and semantic models, and develop executive-ready Power BI dashboards to deliver meaningful cyber and operational insights.

The role requires 5+ years in Azure data environments, expertise with Azure Data Factory, T-SQL and dimensional modeling, and strong stakeholder engagement to translate requirements

Qualifications

• 5+ years' experience building ETL/ELT pipelines, data marts, and data integration solutions with Azure Data Factory and T-SQL.
• Experience creating executive-ready Power BI reports and semantic models using DAX.
• Strong dimensional modeling knowledge (Kimball) with fact and dimension tables.
• Experience troubleshooting and optimizing data ingestion, transformation and reporting in Azure environments.
• Exposure to Azure DevOps and CI/CD practices for deployment of data and reporting solutions.
• Understanding of data governance, metadata management and Power BI security controls (RLS).
• Excellent stakeholder engagement and communication skills for technical and executive audiences.

Responsibilities

• Design, develop and support enterprise-scale ETL/ELT pipelines, data integrations, APIs and ingestion using Azure-based tech.
• Build and maintain data marts, dimensional models and transformation processes for trusted reporting data.
• Develop semantic models and executive-ready Power BI dashboards delivering cyber and operational insights.
• Collaborate with SMEs to translate business requirements into fit-for-purpose reporting solutions.
• Troubleshoot and optimize data pipelines and reporting solutions across Azure SQL, Data Factory, DevOps and Power BI.
• Apply CI/CD practices and contribute to governance, metadata management and reporting standards.
• Support uplift of self-service analytics across the Cyber function through delivering trusted reporting products.

Skills

Azure Data Factory

T-SQL

Power BI

DAX

Kimball dimensional modeling

Azure SQL

Azure DevOps

Data governance

Stakeholder engagement

Tools

Azure Data Factory

Power BI

SQL

Job description

Job Details

Organisation/Entity: Transport For NSW

Job category: Projects

Job location: Macquarie Park, NSW, AU, 2113

Job reference number: 107937

Employment type: Permanent Full-Time

Salary range: $137551.0-$154055.0

You’re excited by opportunities to explore your potential and try something new.

If finding complex technological solutions is your game, we've got the team for you. You're going to help us create seamless operations that result in efficiency for millions of customers.

In this role, you'll:

At Transport for NSW, our Cyber Insights & Analytics (CI&A) team turns complex cyber, governance and operational information into trusted insights that support decision-making across the business. This is an opportunity to work at the intersection of cyber security, data engineering and analytics, building reporting products and data solutions that help protect critical infrastructure and support a secure, data-driven organisation.

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 understand business requirements and translate them 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.

Please view the role description and Information Pack for more information.

About You

You are a data and analytics professional with a strong foundation in data engineering, reporting and business intelligence.

You enjoy solving complex data challenges and take pride in delivering reliable, scalable and well-governed reporting solutions. You are equally comfortable working with technical teams to build data pipelines as you are engaging with senior stakeholders to present meaningful insights. You stay current with emerging Data & AI technologies and are keen to apply modern approaches to analytical and reporting challenges.

Essential

Skills & Experience

• 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.

Desirable

• Experience with Microsoft Fabric.
• Exposure to cyber security governance platforms and data sources including ServiceNow, Jira, Qualys or Prisma.
• Microsoft Data & Analytics certifications.

Who We Are

Transport for NSW provides a safe, integrated, and efficient transport system. We connect people, communities and industry every day.

Join us

Our workforce is as diverse as the community we serve. If you’d like further information on our inclusion and diversity initiatives, visit Transport careers.

Flexible work options may be available. Learn more via Flexible work options and policy

Aboriginal people and people living with disability are supported throughout the recruitment process and at work, and we encourage you to apply. Visit Supporting Aboriginal People or Supporting People with Disability for more information or speak to your talent team member to arrange any adjustments to how you interact with us.

Job Segment

Cyber Security, Analytics, Business Intelligence, Data Analyst, Database, Security, Management, Technology, Data