Jobs/Data Warehouse Modeller & Developer

 

Data Warehouse Modeller & Developer

EXPIRED

facebook.png
twitter.png
linkedin.png

Agency / Department

Department of Agriculture, Water and the Environment

Experience Level

Senior

Employment Type

Contract

Expected Rate (inc. Super)

$115 per hour***

Location

Australian Capital Territory

Overview

The Department requires skilled contractors with data warehouse modeller and developer skills to work in a high performing data warehousing team delivering analytics and workload measurement.

Responsibilities

The Microsoft SQL data warehouse modellers and developers will provide services under direction including:

  • Obtain in-depth knowledge of a business area through data analysis and engagement and consultation with subject matter experts within business
  • Develop data models to meet specified business requirements that will allow future integration with other reporting products
  • Develop highly optimised SQL scripts in ELT scenarios
  • Write clear, business meaningful, code documentation that explains the intent and mechanics of scripts
  • Follow good programming practices and team programming conventions f) other related activities as required.

Essential Criteria

  1. Skills and proven experience in solving complex SQL problems is paramount. Role requires a code-first approach with proven ability to have an SQL-first, ELT, method to resolve complex business problems. Experience in commercial tools not a high priority as this role will not use tools including ErWIN, SSIS, DataStage etc.
  2. Demonstrated ability to deliver combined business analyst, data modeller and ETL developer services. This role will propose, negotiate, and create all the data transformation logic for business. The role will not separate between data modelling and ELT development.
  3. Ability to work independently in a rigorous, yet extremely rapid, environment. Ability to deliver incremental production changes on a weekly to fortnightly basis. Ability to adapt quickly with flexibility to changing demand and priorities.

Desired Criteria

  1. SQL Server query tuning, including the ability to diagnose problems using the query planner
  2. SQL Server Analysis Services: Tabular modelling, DAX
  3. Advance computer science/software programming skills

Security Clearance

Ability to obtain baseline clearance

Extension

Option to extend for 2 periods of up to 12 months

**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.