9d ago

Data Warehouse Developer/ETL Developer

Whizdom Recruitment

Save this job
Save job
APSCO
Unlock your match score
Applying for this job will take you to the advertiser's site
Estimated
$130k ~ $151k
Work type
Full Time
Contract type
Contract
How this job matches you
% match
Get your match score for free
Pay guide
Market insights based on all Data Warehouse Developer jobs in Canberra ACT
Estimated range
$130k - $151k
Market average
$144k
$144k
Market average
$100k
$230k
Actual pay is not disclosed by the employer
Skills
BUSINESS INTELLIGENCE
DATA CLEANSING
DATA PROFILING
DATA WAREHOUSING
DATASETS
EDW
ETL
INFORMATICA
MARKETING ANALYSIS
MICROSOFT SQL SERVER INTEGRATION SERVICES
MS SQL SERVER
SCRIPTING
SQL
STRUCTURED SOFTWARE
T-SQL

Full job description

Overview

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.

Job details
Date posted
15 Sep 2021
Category
Information Technology
Occupation
Database Development & Admin
Estimated
$130k ~ $151k
Contract type
Contract
Work type
Full Time
Job mode
Standard hours
Sector
Private Business
Work Authorisation
Australian Citizen / Permanent Resident

You may also be interested in these jobs