Application closing date: Tuesday, 09 August 2022 • 11:59pm, Canberra time (in Canberra)

Estimated start date: Monday, 29 August 2022

Location of work: ACT

Length of contract: 12 months

Contract extensions: 2 x 12 months

Security clearance: Must be able to obtain Baseline

Rates: $90 - $120 per hour (inc. super)

You will join a team of experienced data platform administrators and developers responsible of the ingestion and maintenance of a data warehouse hosted on a hybrid platform comprising on-premises SQL Server and Azure - with a big focus on Azure. As a SQL Developer, you will play an important role in designing, implementing, maintaining, and supporting the data warehouse platform. You will also work very closely with data scientists, analysts and BI developers to deliver analytical and reporting solutions in an agile framework. You are someone who shows strong initiative and works well both independently and collaboratively as part of a team. 

The role involves: 

  • Developing and implementing ELT solutions to ingest data to our data warehouse using tools including T-SQL, Azure Data Factory, SSIS, PowerShell 
  • Refactoring existing on-premises functionality in Azure 
  • Performing troubleshooting through analysis of code and data to identify issues, and provide resolution 
  • Working as part of a team to problem solve and build/improve processes and automation 
  • Reviewing system performance and optimising code, creating/using indexes to improve database performance

Essential Criteria

  1. Strong SQL Server development skills including ability to optimise for performance 
  2. Experience in building ETL processes including incremental extraction and load 
  3. Experience working with Microsoft ETL tools (Azure Data Factory and SSIS) 
  4. Great communication skills and ability to work as part of a multi-disciplinary team 
  5. Creation of solution design and technical documentation and excellent troubleshooting skills 
  6. Experience with Azure DevOps pipelines/Git

Desirable Criteria

  1. Azure platform experience - SQL Managed Instance, Azure Data Lake Storage • PowerShell
Apply To Position