Data Warehouse Development Consultant

Job Title: Data Warehouse Development Consultant
Contract Type: Contract
Location: Canberra, Australian Capital Territory
Salary: Negotiable
Reference: CR/010425_1647498251
Contact Name: David South
Contact Email:
Job Published: March 17, 2022 17:24

Job Description

We have a current opportunity for a Data Warehouse Development Consultant on a contract basis. The position will be based in Canberra. For further information about this position please apply.
The Development Consultant engages in the design and the development of high quality solutions in support of business and technical requirements. The role solves highly complex problems.
* The Development Expert exercises a considerable degree of independence and undertakes a technical leadership role, with work being performed under the general guidance of senior staff.

Specifically the job description is:
* Develop and support the load of multiple disparate data sources into the Enterprise Data Warehouse for reporting and analytical purposes.
* Engage with technical experts from a number of source systems to identify and document their data holdings.

Key Tasks/Duties may include some or all of the following:
* perform and manage analysis, design, development, prototyping, unit testing and maintenance activities
* solve highly complex problems and deliver high quality solutions
* perform high-level analysis of technical requirements to support project evaluation with proposed solutions
* undertake technical design and development of highly complex custom solutions, and/or standard conversion and migration solutions
* manage the release and ensure go-live production support and maintenance for the team's developments
* proactively share knowledge and expertise as the subject matter expert, and provide assistance and mentor-ship to less experienced colleagues

* ensure compliance with endorsed software development methodologies
* provide support to development teams to ensure high quality custom solution realisation
* maintain and support existing system/technology to support day-to-day operation
* report on the achievement of business outcomes, key performance indicators and quality assurance in the area of responsibility
* develop staff capability through coaching, mentoring and succession planning
* resolve escalated issues and suggest alternative approaches
* prepare and review a range of written material which may include technical and corporate documentation
* provide detailed, specialist technical advice to the senior executive where appropriate
* engage and partner with other agencies and service providers to build service delivery capability
* influence and contribute to ICT strategy
* perform and manage cost analysis activities as required
* support innovation and manage and lead change
* encourage and support continuous improvement

Mandatory Criteria

1. Demonstrated experience in multi layer data warehousing.

Weighted Criteria

1. Demonstrated ability in one or more programming and scripting languages including Java, Python, shell script or similar.

2. Demonstrated experience in data modelling, design and querying languages including SQL or similar.

3. Demonstrated experience in relational databases including Teradata, DB2, SQL Server or similar.

4. Experience in scheduling tools including Control-M or similar.

5. Experience in ETL Control Frameworks including Teradata GCFR or similar.

6. Experience in DevOps and version control tools such as GitLab or similar.

7. Demonstrated ability to use best practice techniques for development, support and documentation

8. Have demonstrated strong communication skills, both oral and written