Data Warehouse Modeller & Developer | Y265

Data Warehouse Modeller & Developer | Y265

21 Apr
|
CYOS Solutions
|
Australian Capital Territory

21 Apr

CYOS Solutions

Australian Capital Territory

Application closing date: Thursday 29 April 2021 at 6pm (in Canberra)



Estimated start date: 31-05-2021



Location of work: Australian Capital Territory



Length of contract: Up to 30 June 2022



Contract extensions: Option to extend for 2 periods of up to 12 months



Security clearance: Ability to obtain baseline clearance



Rate: $110 - $125 per hour (inc. super)



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. The Microsoft SQL data warehouse modellers and developers will provide services under direction including:

a)

obtain in-depth knowledge of a business area through data analysis and engagement and consultation with subject matter experts within business

b) develop data models to meet specified business requirements that will allow future integration with other reporting products

c) develop highly optimised SQL scripts in ELT scenarios

d) write clear, business meaningful, code documentation that explains the intent and mechanics of scripts

e) 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 isn't a high priority as this role won't use commercial tools such as ErWIN SSIS DataStage. 34%

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. 33%

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. 33%





Desirable 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

The original job offer can be found in Kit Job:
https://www.kitjobau.com/job/10468646/data-warehouse-modeller-developer-y265-australian-capital-territory/?utm_source=html

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:
Enter Your E-mail address to receive the latest job offers for: data warehouse modeller & developer | y265
Publish a new Free Offer
Need to publish an offer? With more than 1 million unique users per month, you will find the ideal candidate for your company instantly, what are you waiting for!
Publish Now

Subscribe to this job alert