Senior Data Architect - Dimensional Modeling & Data Lake Integration

ZipRecruiter; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

A leading company is seeking a Data Architect to develop and optimize a robust dimensional data model across multiple systems. The role involves designing data marts, leading ETL strategies, and ensuring data security compliance. This hybrid position requires 2 days onsite per week and offers the opportunity to work with advanced data technologies.

Qualifications

• Experience with dimensional data modeling and ETL processes.
• Strong knowledge of data security controls and governance standards.

Responsibilities

• Architect and develop a robust dimensional data model.
• Design and optimize data marts and calculated metrics.
• Lead ETL/ELT strategy for data integration.

Skills

Data Modeling

ETL/ELT

Data Security

Tools

Azure Data Lake

OneStream

Oracle EBS

Hyperion

HCM

Workbrain

Job description

Job Description

Start Date: 2025-05-29

End Date: 2025-12-03

HYBRID Role : 2 days per week onsite

Must Haves:

• Architect and develop a robust dimensional data model across OneStream, Hyperion, Oracle EBS, HCM, and Workbrain systems. – Finance within a company

• Design and optimize fact and dimension tables, data marts, and calculated metrics within the Azure Data Lake to support analytical and operational reporting.

• Lead ETL/ELT strategy and implementation to integrate historical and current data sources with a focus on scalability and performance.

• Implement and maintain data security controls, such as encryption, role-based access controls (RBAC) policies, privacy standards, and adherence to governance standards