A government organisation is looking for an experienced Data Warehouse Lead to plan and implement data warehouse projects. This is a contract that will run up to the end of December with possible extension. It is based in Parramatta with working from home option.
The role is to work with other members of the project and technology team to plan, design, establish, and operationalise data models required for reporting and analytics, using Microsoft Azure services, with a core focus around the integration of Azure Cloud and SQL Databases and Data Warehouses.
Plan and implement projects
Work in a fast-paced environment while solving crises
Design & develop ETL in Azure Data Factory to populate the data warehouse
Involve in the development of related policies, guidelines, standards and other artefacts
Liaise with solutions architects, business analysts and other developers to ensure all deliveries are supported by the correct architectural implementation.
Provide expert advice and guidance on data quality related activities
Enhance the current CI/CD processes to support new and existing development.
Design and develop business reporting capabilities in the data warehouse.
Prior experience in a Technical PM/lead role.
Practical experience with creating pipelines in Azure Data Factory
Experience developing data models in large complex organisations
Experience with building best practice ETL processes
Experience working with JSON data structures
Knowledge of Data Lake concepts
Data modelling experience with knowledge of both relational and star schema designs
Experience with Azure SQL or SQL Server 2014/2016
Strong understanding of how to build a data mart or data warehouses in SQL Server.
Ability to translate the business requirements and architecture into a solution.
Data governance experience will be highly regarded.
Sound knowledge of various data warehousing modelling techniques like Inman and Ralph Kimball's approaches.
Power BI experience will be highly regarded
If you wish to apply for this position, please submit your resume by clicking the 'Apply Now' button. For further information please contact Freda Kwok at Clicks IT Recruitment on 02 9200 4404.
At Clicks we embrace diversity, inclusion and equal opportunity.
We provide reasonable adjustments, including alternate formats to the recruitment process for individuals with disability. If you require an adjustment to be made during the recruitment process, please call 1300 254 257 or email firstname.lastname@example.org