Job Search

Data Warehouse Architect/Developer

Job Title: Data Warehouse Architect/Developer
Location: Sydney
Reference: 3184399
Job Published: November 05, 2020 13:16

Job Description

The Role:
  • Our client is looking for a hands-on Datawarehouse Solution Designer/ developer to join their Data team on a long term contract.  
  • You will analyse the existing landscape, design and build the future data warehouse.
  • Develop and support Data warehouse platform using AWS
  • Support current and extend data models and sources into the data warehouse;
  • Design, develop, monitor and tune data loads and queries
  • Design and develop ETL jobs in Talend, SSIS or similar ETL tools
  • Perform complex Data analysis using T-SQL and DAX;
  • Document detailed designs based on business requirements;
About You:
  • Experience in enterprise information management architecture and understanding of various Data segments i.e. Architecture, Integration, Governance, Quality, Meta Data and Master Data Management.
  • Design, built and deployed data models for Enterprise Data Warehouse. Solid research and complex problem-solving skills in BI system design.
  • Extensive experience of BI Architecture and Solution Design with complex source systems and good working experience with state-of-the-art BI technologies and platforms
  • Demonstrated experience working on Data Warehouse and Analytics platforms
  • Understanding of Data Warehousing concepts, architecture, software, data modelling techniques and implementation
  • Strong conceptual and analytical data skills and proven ability to resolve complex data problems using innovative technology solutions
  • Good verbal and written communication skills with technical and non-technical audiences
  • At least 5 years’ experience in developing and tuning SQL Server (stored procedures, functions and views, SSIS package creation and maintenance, ETL concepts, data modelling)
  • Experience with AWS & On Prem architectures