Jobs/SQL Server Integration Services (SSIS)/Database Technical Lead/Developer

 

SQL Server Integration Services (SSIS)/Database Technical Lead/Developer

EXPIRED

facebook.png
twitter.png
linkedin.png

Agency / Department

Department of Education, Skills and Employment

Experience Level

Senior

Employment Type

Contract

Expected Rate (inc. Super)

$115 per hour***

Location

Australian Capital Territory

Overview

The Data Development and Analysis team is responsible for developing database solutions to support reporting and analysis on employment services such as jobactive, Transition to Work and ParentsNext. This includes data profiling and analysis, proposing, designing, and implementing database architecture as well as creating de-normalised table structures within the INTERNAL database.

 

The roles required are SQL Server Integration Services (SSIS)/Database Technical Lead/Developer resources to assist with database structure, security, automation, programming and administration. The role includes proposing, designing, and implementing database architectures, as well automating table production to support various government programs for which the Department is responsible.

Responsibilities

The services of qualified SSIS/database technical leads/developers are required to meet the growing demand for user driven data analytics, business intelligence and Qlik visualisations. As the INTERNAL database continues to expand to support the department’s reporting and analysis needs, integration services need to be implemented and supported to solve complex business problems by cleansing and mining data, managing SQL server objects, programming and loading the INTERNAL database.

Bringing these skill sets into the team enables best practice and documentation to be developed and taught in house. Increasing the skills and confidence of current staff to continue to develop valuable solutions. Implementing database security and administration best practice also allows us to reduce the manual burden of INTERNAL database maintenance, which allows us to provide a more stable and streamlined user experience for our stakeholders.

Essential Criteria

  • Demonstrated ability to manage users, roles and privileges within different tiers of a SQL Server reporting environment. Demonstrated ability to maintain database integrity and data governance. Demonstrated ability to develop Extract-Transform-Load processes for ingesting new data sources.
  • Demonstrated ability to take design specifications from client and write scripts in SSIS. Demonstrated ability to automate various processes utilising SSIS. Ability to deploy new agent jobs and improve existing ones. Demonstrated ability to document relevant processes.
  • Ability to provide input to a variety of technical problems of moderate scope and complexity. Demonstrated ability to train and educate staff in SSIS and database management.
  • Well Developed organisational skills and strong ability to manage competing priorities. oral and written skills, including a demonstrated ability to communicate with stakeholders in technical and business areas.
  • Demonstrated knowledge of Employment Services and the Employment Business Intelligence Warehouse. Demonstrated ability to conduct business analysis and develop data models to meet specified business requirements. Demonstrated ability to follow good SQL programming practices and team programming conventions.

Desired Criteria

Nil

Security Clearance

Must have current baseline clearance

Extension

Two x 12 month extension options

**Please refer to our Terms and Conditions for more information regarding the expected rate

SUBSCRIBE TO NEW JOB ALERTS

FOLLOW US

  • Facebook

Merlin's Group Australia

Merlin’s Group focus on recruitment  and placement of highly-skilled ICT Professionals as well as delivery of high-quality ICT products in Government.

We have highly coveted skills and certifications from Standford University, ITIL, PRINCE2, PRINCE2 AGILE, SCRUM, CAPM, and PMP.  We use these skills and certifications to continuously deliver tailored, high-quality solutions to each of our Clients.

We utilise our channel partnerships with tech giants CISCO, SAMSUNG, LENOVO, DELL/EMC, and MICROSOFT to drive innovation, build digital strategies, and deliver technology transformations to our Clients.

Get In Touch

ACT Office Phone (02) 6243 5116

Toll Free Number 1800 161 422

ACT Office: Level 9, Nishi Building, 2 Phillip Law St, Canberra, 2601

ABN 11 635 131 798

ACN 635 131 798

Follow us

  • Facebook

©2020 by Merlin's Group Pty Ltd.