Senior Data Warehouse Developer

  • Great career progression
  • Design and implement highly accurate data models and business information taxonomy
  • Reporting to the Big Data Platform Lead
  • Play a key role in the design, development and implementation of PTVs data warehouse and data analytics platform
  • Full time, ongoing role
  • PTV G 6 $115,137 - $154,076 + 9.5% superannuation
  • Docklands location, close to Southern Cross Railway Station

For further information on Public Transport Victoria, please visit the PTV Website

Job Details
Careers Logo
Department: Public Transport Victoria
Work Type: Ongoing - full time
Job Function: IT and Telecommunications
Classification: PTV 6
Work Location: Melbourne - CBD
Reference: VG/400119080
Closing Date: 01-May-2018
Salary Range: $115,137 - $154,076
Job Duration: N/A
Attachments: Position Des - CIO - Enterprise Info Management - Senior Data Warehouse Developer - PTV6.1 .pdf (PDF, 373KB)

PTV Capability Framework - 1 Page Summary.pdf (PDF, 208KB)

Contact: Nicolas Seak

Position Details

About Public Transport Victoria (PTV)

What is PTV? It is a single point of contact for you to gain information on Public Transport services, fares, tickets and initiatives. We here at PTV manage Victoria's train, tram and bus services. Our team here at PTV develops and nurtures a strong, vibrant culture encouraging innovation to drive a high-performing Government organisation. We build on the hard work, passion and creativity of our people to promote excellence in our industry, and greater mobility for all Victorians.

PTV helps hundreds of thousands of Victorian's make their way to and from lifes events. That may be arriving at work or school, visiting family or friends, attending sporting or entertainment events, whatever it is, WE PLAY A ROLE. 

About the role

The Senior Data Warehouse Developer supports the Big Data Platform Lead, and play a key role in the design, development and implementation of PTV's data warehouse and data analytics platform. This includes working as part of an Agile team and leading the development of new warehouse and reporting capability to meet PTV's data gathering and reporting obligations under the new Metropolitan Rail Franchise contracts as well as ensuring integration with existing reporting systems. 

What we're looking for

Essential (must have to be considered for the position)

  • Strong proven experience in Data Warehousing/BI Development
  • Exceptional knowledge of and extensive practical working experience in information and data modelling.
  • Advanced ability to understand complex and technical information and data use in different business and system contexts.
  • Demonstrated experience in Data quality, data cleansing, Data Governance principles, along with Logical Data Modelling.
  • Expert knowledge of data methodologies and data modelling techniques such as Data Vault/ Kimball/ Inmon etc.
  • Development experience in data warehousing and advanced analytics.
  • Strong ability to initiate and recognize opportunities for continuous improvement by identifying inconsistencies in policy interpretation, processes, service provision and systems with the capacity to influence change in information management.
  • Demonstrated experience in data integration development using Microsoft Azure platform in the cloud.
  • Advanced knowledge in SQL queries, stored procedures, physicalized tables and indexes, execution plans to retrieve data from tables, high availability and resilient architecture for large database such as Azure Data Warehouse, SQL Server, SSIS, Data Lake concepts and Big Data concepts.
  • Strong experience in working with large, complex Data Warehouses using the Microsoft BI Stack within an Azure or cloud based environment.
  • Strong experience in scripting such as Powershell and python.

Desirable (will be well suited to role)

  • Prior experience in waterfall and agile methodology
  • Public Transport Domain Knowledge
  • Exposure/prior experience to Microsoft Azure Technology (e.g. Azure Data Warehouse, Azure Data Factory, Powershell, Blob Storage/Azure Data Lake, etc.)

Qualifications (Mandatory)

  • A Tertiary qualification in Computer Science, Information Technology or related field followed by work experience of data integration design/delivery of solution.

How to apply

Please click the ‘Apply Now' button below.  Your application must include a cover letter and separate resume (MS Word compatible).  For further information about the role, please refer to the attached position description and capability framework documents. If you have any questions specific to the role, please email

Applications close 11:59 P.M. Tuesday, 1 May 2018. 

Emailed applications will not be accepted. 

Unsolicited applications from agencies will not be accepted. 

Public Transport Victoria is committed to fostering a work environment that is inclusive and supports diversity and flexibility. We are proud to be an equal opportunity employer.

From here...