Transport for NSW is the lead agency of the NSW Transport cluster. Our role is to lead the development of a safe, efficient, integrated transport system that keeps people and goods moving, connects communities and shapes the future of our cities, centres and regions. We work with several government agencies to coordinate road, rail, bus and maritime services, always keeping the safety and comfort of our customers at the heart of what we do.

About Customer Strategy and Technology at TfNSW

We are a trusted partner to our clients, within Customer Strategy and Technology, developing and delivering smart, integrated and sustainable data and analytics solutions which enable evidence-driven decisions to benefit our customers and communities, and leading an uplift in data literacy of use of data insights across the clusters..

The opportunity

We have three opportunities for Data & BI Operations Analyst roles to be an integral part of the Advanced Analytics & Insights team within Customer Strategy and Technology. This role will contribute in ensuring optimal performance through managing and processes and operations relating to data and reporting, including the investigation and resolutions of incidents to ensure continued availability and reliability of data products throughout the delivery lifecycle. It is responsible for the continuous improvement and maintenance of business intelligence tools.

Your role will include;

• Actively contribute to innovation in Data and BI Ops practices and delivery approaches and technologies that assist with the development and delivery of data products.
• Work within the practices and processes necessary for effective problem management to minimise the impact of service outages, including updating the database of known issues, causes and resolutions to guide the development and support teams in minimising the impact of incidents.
• Manage and play an active role in monitoring, investigating and resolving incidents relating to data processes and reports whilst documenting learnings and working towards any future mitigation strategy.
• Contribute to existing data pipelines proactively to deliver continuous improvement in terms of automation, enrichment, timeliness, reliability, cost to serve with adherence to quality standards, including pipelines from external data sources such as DSpark
• Provide support for the maintenance of data and reporting processes to ensure availability of data and business intelligence assets including working with vendors to ensure consistency and access to source data
• Assist with implementation of data and business intelligence assets and support warranty period post release
• Model collegiate and collaborative behaviours to achieve the greater good for the community, celebrate a diverse workforce, create an environment where people can create and thrive, or support people’s wellbeing 

About you

To be successful in the role you will be:

• You will have tertiary qualifications or relevant professional experience.
• Technical expertise in troubleshooting and improvement of Data Lake, Data Warehouse and data integration implementations on AWS cloud.
• Basic understanding of ELT design and architecture and ability to create ELT processes using a range of AWS cloud native technologies, custom code development and enterprise tools such as Talend.
• Knowledge and understanding of Logical Data Models, Physical Data Models and Dimension Models and ability to deliver Logical Models and Physical Designs.
• Understanding of source systems to the customer delivery of data products including releasing, deployment and monitoring
• Experience in development using visualisation tools such as Tableau, PowerBI or AWS QuickSight
• Ability to coordinate with other teams for planning, design, governance, engineering and release management of processes and products to ensure timely and accurate delivery of data and analytics services
• Knowledge and experience building algorithms and applications using advanced scripting and object oriented programming in Python, C# or JAVA would be an advantage.

Salary and Benefits

The salary for this position is TfNSW Grade 7 ($106,086.00 - $118,816.00) per annum plus superannuation and leave loading.