Data Warehouse Solution Architect


New South Wales

Work type:



Information & Communication Technology



Job reference:


Start date:


Contact email:


Anna Au

Data Warehouse Solution Architect
6 Months Contract

The Solution Architect is responsible for the design and development of Analytics and Reporting solutions consistent with patterns defined in the data warehouse and business intelligence architectures.
 Key Accountabilities:
  • Within the agreed architecture, define and design analytics and reporting solutions to assist the business in meeting their business objectives
  • Review, interpret and respond to detailed business requirements specifications (BRS) to ensure alignment between customer expectations and current or future ICT capability
  • Reverse engineer logic and rules of legacy reporting constructs and design solutions consistent with architectural standards as replacement functionality.
  • Define and design data acquisition and delta strategies for extracts from various source systems.
  • Mapping of data elements from source systems to the Enterprise Data Model and Data Marts including any required transformations.
  • Incorporate audit, logging and lineage standards in solution designs.
  • Work closely with the Data Architect to define conceptual and logical schemas for Staging, EDW, Data Mart and ODS schemas.
  • Oversee development, testing and implementation of solutions and report on delivery commitments to ensure solutions are implemented as expected and to agreed standards.
Key Criteria:
  • Minimum 5 years Data Warehouse / Data Mart / BI Solution Design
  • Demonstrated expertise and experience in end to end data warehouse and business intelligence solution design including data marts, OLAP cubes, reporting, and delivery methods.
  • Extensive experience in relational database analysis, design and engineering including the ability to use using common modelling tools such as ERWIN, Enterprise Architect, etc.
  • Strong dimensional modelling skills with attention to determining and applying level of detail, aggregation, summarization, etc.
  • Extensive expertise and experience in the Microsoft Business Intelligence platform including SQL Server data mart implementations, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Power BI, SharePoint and related products.
  • Relevant tertiary qualifications, preferably in an IT discipline, or equivalent successful experience
If you would be interested in this role please submit your cover letter and CV in Word format only by clicking the "APPLY NOW" button below or


Share this job:

help your friends find their dream job: