Data Warehouse Developer/ETL Developer

Data Warehouse Developer/ETL Developer

Job Title: Data Warehouse Developer/ETL Developer
Contract Type: Contract
Location: Canberra
Salary: Competitive
Start Date: 2021-09-14
Reference: V-39847
Contact Name: Connie Bellam
Contact Email:
Job Published: September 15, 2021 15:19

Job Description


Our Government client is seeking to fill multiple positions for a large Cloud Services initiative that will transform the way they develop and deliver services to their clients, both internal and external. Separated into two major tranches, you’ll have the opportunity to work across several key Information Technology service delivery areas contributing to enhancing and implementing leading edge technologies as they transition to full Cloud Services offering over the next few years. You’ll be working on uplift and transition of existing ICT capabilities to align with their first Cloud approach and building and deploying of the new Cloud only environment will see you working across complex technical issues and contributing to the realisation of strategic outcomes as part of the program. You will work as part of a multidisciplinary team and have the ability to communicate effectively and manage relationships with a range of internal and external stakeholders, including team members, product owners, project managers, and executives. You will also have experience working in both Agile and Waterfall projects and ideally have experience with to deliver, design and research activities, and strong interpersonal skills with the ability to exercise initiative and sound judgement as part of a large program of work.

Reporting to the Section Manager Business Intelligence or Data Technical Lead, the following tasks are required:

a) As part of the Data Warehouse Team, work with data from multiple sources but primarily on SQL enterprise data warehouse to produce datasets, dashboards and reporting visualisations to meet specific requirements and business needs.

b) Development of ETL processes for Informatica PowerCenter and WhereScape Red to support the addition of priority datasets into the EDW.

c) Provide advice on how to best leverage the data warehouse environment, including best practice on data warehouse design and cloud migration.

d) Work to deadlines, monitor and report progress.

e) Work co-operatively and collaboratively with the (ITB) team, as well as other stakeholders.

Mandatory skills:

a) Demonstrated experience in design and development of ETL solutions using Informatica PowerCenter.

b) Demonstrated experience in building ETL processes with the ability to read, analyse and transform data.

c) Excellent understanding of data warehousing concepts, including data analysis, data profiling, data cleansing and data modelling.

d) Demonstrated experience in monitor, run and troubleshoot the data load processes associated with data warehouse.

e) Demonstrated high-level communication skills, including the ability to identify, manage and effectively liaise with all stakeholders including technical and non-technical audiences.

f) Experience with analysis, design, development, and maintenance of Data Lake using ETL tools.

Desirable skills:

a) Knowledge of Microsoft Azure technologies, WhereScape Red and SQL Server Integration Services.

b) Experience in development of ETL standards and Metadata management.

c) Experience in SQL Server and Oracle databases.

d) SQL Scripting and software development capability: e.g., T-SQL, Python, PowerShell, etc.

Location and Contract Term:
The role is based in Philip, ACT with an estimated start of 18th October 2021 for 9 months, with 1x12  month extension option at the sole discretion of the Department.

Security Requirements:
Applicants must be Australian Citizens and must have BASELINE clearance.

How to Apply:
Please upload your resume to apply. Please note you will be required to complete a selection criterion to complete this application process. We will be in touch with instructions for suitably skilled candidates.

Call Connie Bellam 1300 944 936 for any further information.  Applications close Sunday 26th  September 2021 at 6pm.