Facebook Pixel


There are currently 9 jobs listed by Infrastructure & Place

Report Integration Specialist x 2

Organisation/Entity: Infrastructure & Place
Job Category:
  • Information and Communications Technology | Management and Supervision
Job Location:
  • Sydney Region / Sydney - North/North West
Job Reference Number: 0000762V
Work Type: Full-Time
Number of Positions: 2
Total Remuneration Package: Transport Service Grade 9 ($129,349 - $144,870), plus employer's contribution to superannuation and annual leave loading.
Contact: 02 9422 1379 - Sunetra Mukherjee
Closing Date: 28/07/2019 - 11:59 PM


  • An exciting time to join the Infrastructure and Place Division of Transport for NSW where you can be part of the significant government investment into NSW infrastructure
  • Transport Service Grade 9 ($129,349 - $144,870), plus employer’s contribution to superannuation and annual leave loading
  • Fixed Term 12 months, full-time position, located in Chatswood (a short walk from Chatswood station with a large shopping centre, parks and cafes, restaurants)
  • Be a key leader in a large complex projects within Transport for NSW

The opportunity 

We have an exciting opportunity for two (2) Report Integration Specialists to be a part of Business Solutions Team in Program Management Office within Infrastructure & Place Division of Transport for NSW. The primary purpose of the role is to develop reporting and integration solutions and to provide a framework for the business to develop its own views, utilising approved data sources, which facilitate the achievement of business outcomes, thereby improving business efficiencies, processes and decision making.

The role will provide ongoing development and maintenance of existing reports and integration components.

This newly created position will utilise and translate input from the Business Analyst, Business Solutions team and Business stakeholders to design, develop and deliver technical and operational reporting and integration solutions.

SSIS / SSRS Developer
Responsibilities and Tasks
  • Drives end user adoption to ensure its success (simply providing BI to an increasing number of information consumers doesn’t guarantee more people will use it).
  • This individual will apply proven communication, analytical, and problem-solving skills to help maximise the benefit of IT system investments
  • Assist with the definition of the overall data warehouse architecture (e.g., ETL process, Enterprise Data Warehouse, Data Marts) with guidance from the key functional requirements
  • Define technical requirements, technical and data architectures for the data warehouse
  • Defining the data model (logical and physical)
  • Defining common data definitions
  • Defining the information workflow
  • Design and direct the ETL process, including data quality and testing
  • Design and direct the information access and delivery effort for the data warehouse
  • Define and direct the implementation of security requirements for the data warehouse
  • Define meta data standards for the data warehouse
  • Direct the data warehouse meta data capture and access effort
  • Define production release requirements and sustainment architecture
  • Design, develop & test scalable ETL application for data warehouse application
  • Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
  • Analyse & translate functional specifications & change requests into technical specifications.
  • Develop, test & implement program logic
  • Scheduling and synchronising automated jobs

Key Accountabilities
  • ETL Tools including SSIS and Alteryx
  • Report and dashboard tools including SSRS and Tableau
  • Deep understanding of RDBMS and related technologies
  • Modelling and Architecture principles (Kimball)
  • Data Modelling (relational and multi-dimensional modelling)
  • Database Design
  • Complex SQL, SQL optimisation, stored procedures and triggers
  • Data Quality (Profiling, Root Cause Analysis, Remediation)
  • Business Intelligence (Strategy, Analysis, Implementation)
  • Experience using Subversion
  • Experience using JIRA and Confluence
  • Comfortable working in an agile environment

Services Provided

  • Tableau (Desktop and Server)
  • Alteryx
  • Microsoft SQL Server Development
  • Microsoft SQL Server Management
  • Microsoft SQL Integration Services
  • Microsoft SQL Server Reporting Services 
  • Microsoft Analysis Services 
  • Visual Studio for Data/BI Development
  • PMWeb and Primavera P6 experience

For more information on this position, view the role description here

If you are looking for an environment in which you can contribute to creating a legacy of achievement that will last for generations, and enjoy a flexible and diverse working environment which values collaboration and personal development, then we’d like to meet you. 

About us 

At Transport, our vision is for a truly integrated transport system that will meet the needs of our customers now and into the future. The Transport portfolio includes Transport for NSW as principal agency with Sydney Trains, NSW Trains, State Transit Authority and Roads and Maritime Services as our key operating agencies.


We are a values based organisation and  employ the most talented people to work together to deliver services for our customers and make NSW a better place to live, do business and visit.


At Transport our people have access to a range of benefits that help balance life at work and at home. These include flexible working arrangements, professional development opportunities, health and wellbeing programs, and a program that helps you stay connected with work before, during and after parental leave.

Check out our Employee Benefits Guide to find out more about the benefits available to you when you join Transport. 


Our commitment to Diversity 

Great people come from all walks of life and at Transport for NSW we are committed to creating a diverse, inclusive and flexible workforce which reflects the community and the customers we serve. 

Essential requirements 

  • Tertiary qualifications in relevant discipline, or equivalent experience supporting and planning projects or systems maintenance
  • Experience with Data Warehouse, Business Intelligence and Decision Support tools and concepts

Please note: The successful candidate may need to undertake background checks and criminal record checks. 

How to apply 

To apply for this position, please submit a resume and brief covering letter (Covering letter no longer than two pages) which addresses: 

a) The reason for your interest in this role, and 
b) How your skills and experience suit the role

For more information on how to apply for a role in the NSW Public Sector please click here or for more information on Transport for NSW please click on link provided. 

Should you have enquiries about the role, please contact Sunetra Mukherjee on 02 94221379 and quote 0000762V

If you encounter technical issues please contact I Work for NSW Support Team on 1800 562 679 (Mon-Fri) or support@jobs.nsw.gov.au 

Applications close: 11:59pm, Sunday 28 July 2019.

Key Application Responses

To apply for this position, please submit a resume and brief covering letter (Covering letter no longer than two pages) which addresses: 

a) The reason for your interest in this role, and 
b) How your skills and experience suit the role