Data Warehouse Architect

  • 3-5 Year
  • Toronto
  •   Posted On: August 7, 2018
  •   Skills:  Data Warehousing, Interpersonal, Presentation, SAP HANA

Job Overview

Roles & Responsibilities

Assignment Duties

The primary responsibilities of Data Warehouse Architect include, but not limited to:

Enhance a robust, sustainable Data Warehouse architecture that supports business requirements, and also provide ideas for DW expansion given budgetary constraints and availability of data and skilled resources

Review business requests, data sources and data warehouse capacity & usage

Design and direct the information access and delivery effort for the data warehouse

Enhance existing Data Warehouse and Business Intelligence solution, and guide BI /DW team in developing new data warehouse components ensuring consistency and integration with existing warehouse structure

Define, update and implement overall Data Warehouse architecture (e.g., ETL processes using OWB/ODI, SAP Data Services (BODS); semantic layer and interactive dashboards using OBIEE 12c (RPD), SAP Universe, SAP Business Objects Suite (BOBJ); ODS, EDW, Data Marts

Recommend improvements for BI Dashboard and ETL design processes, data quality and testing; Define/help develop the semantic layer, metadata and report definitions

Direct the data warehouse Metadata capture and access effort; Review data models to ascertain that requirements are met

Produce design guidelines/Standards for ETLs (ODI/OWB, SAP BODS), and source to target mappings to ensure a manageable & sustainable ETL infrastructure for TPH BI & DW

Guide / mentor the BI & Data Warehouse analyst in identifying potential sources of data for the data warehouse and data profiling of the sources.

Define and direct the implementation of security requirements for the data warehouse

Define production release requirements and sustainment architecture

Create migration plan for BI Platform migration from Oracle BI / DW platform to SAP BI / (BW/HANA) Platform and lead the execution

Develop test plans and Coordinate integration & user acceptance testing (UAT) of data acquisition processes and their implementation into production

Manage quality control over data analysis and information delivery

Guide / manage Data Governance activities including establishing, publishing and implementing Data Governance standards, procedures and guidelines

Qualifications and Experience:

Extensive and demonstrated experience leading successful large scale/enterprise data warehousing implementations in designing and developing the architecture for all data warehouse components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy).

Hands-on experience in data architecting, data mining, large-scale data modeling, metadata management, and platform migration.

Strong knowledge of applicable data privacy practices, regulatory compliance, governance and data security related issues.

Highly developed consulting, presentation and interpersonal skills including written and oral, with demonstrated ability to effectively interact with senior business managers, subject matter experts and business end-users.

Considerable senior level experience in developing and operationalizing Data Governance and Management frameworks including establishing, publishing and implementing Data Governance standards, procedures and guidelines.

BI / DW platform Migration planning & execution experience with emphasis on Dashboards oriented solutions (OBIEE, SAP BOBJ)

Technical Capabilities:

Demonstrated technical knowledge of Oracle & SAP data warehouse technologies including EDW, SAP BW / HANA, ODS, ETL: OWB/ ODI, SAP BODS , and BI Tools: Oracle Business Intelligence Enterprise Edition 12c including and GIS mapping (MapViewer) applications; SAP BI (BOBJ) WEB Intelligence, SAP Lumira Designer / Lumira Discovery, SAP Universe.

Knowledge of data modelling and data profiling / data quality tools including Embarcadero ER Studio and SAP information Steward. Experience in multi-dimensional data modeling techniques and implementing enterprise wide reporting and analytic platforms.

Proven capabilities/ considerable hands-on experience in using OBIEE 11g/12c architecture & OLAP technology; SAP BI (BOBJ), SAP Lumira Designer, SAP Lumira Discovery tool with GIS functionality; Data Integration ETL tools, testing and quality assurance (e.g. ODI, OWB, SAP Data Services BODS and other similar tools;

Considerable experience with Oracle RPD & SAP Universe for semantic layer modelling. Designing / Creating BI semantic layer, metadata and report definitions using Oracle BI Application, OWB, ODI, SAP BODS and applying customizations to the ETL, RPD and SAP Universe.

Demonstrated competencies and knowledge of relational database structures, theories, principles, and dimensional data modeling skills.

Hands on experience utilizing Data Governance and Management frameworks offered by industry analysts and data management organizations including DAMA.


The Data Warehousing Architect will produce the following Deliverables / artefacts:

Updates to overall data warehouse and business intelligence solution architecture

Capacity planning analysis and multiyear DW implementation roadmap / plan for platform migration from Oracle DW & BI platform to SAP BI

Review / updated Security requirements and implementation guidelines for the data warehouse

ETL design and process guidelines including data quality and testing

Meta data standards and data management plan

Design SAP BI migration and implementation plan for current Oracle BI platform migration

Data Governance and Management framework including standards, procedures and guidelines

Hi! How can we help you?

Click below button to start chat

Chat Icon
chat icon