Data Architect/Modeller - Senior

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

Job summary

A leading company is seeking a Senior Data Architect to design and implement a robust data lake architecture. This role involves integrating legacy data with modern platforms, ensuring data consistency, and enabling advanced analytics across the organization. You will collaborate with Finance, HR, and IT stakeholders to deliver a governed data platform that supports decision-making. Ideal candidates will have strong experience in dimensional data modeling and a solid understanding of data governance.

Qualifications

• Proven experience in dimensional data modeling and enterprise data integration.
• Hands-on expertise with Azure Data Lake and cloud-based analytics.

Responsibilities

• Design and lead the implementation of an enterprise-grade data lake architecture.
• Define a unified dimensional model and ensure data consistency.

Skills

Dimensional Data Modeling

Data Lake Architecture

Data Integration

Communication

Education

Bachelor’s or Master’s in Computer Science

Tools

Azure Data Lake

Power BI

SQL

Python

Job description

Job Description

Project: We’re looking for a Senior Data Architect to design and lead the implementation of an enterprise-grade data lake architecture, integrating legacy Hyperion data with modern platforms like OneStream, Azure Data Lake, and other financial and HR systems.

In this role, you will define a unified dimensional model, ensure data consistency, and enable advanced analytics and AI-readiness across the organization. You'll work closely with stakeholders in Finance, HR, and IT to deliver a governed, future-proof data platform that powers cross-functional decision-making.

Title: Data Architect/Modeller - Senior

Contract: 7 Months(Business Days: 135.00)

Hybrid: 2 Days onsite

Location: Toronto, ON

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

Required Skills & Qualifications

• Proven experience in dimensional data modeling, data lake architecture, and enterprise data integration.
• Strong knowledge of OneStream, Hyperion, and financial systems such as Oracle EBS or equivalent.
• Hands-on expertise with Azure Data Lake, Power BI, and cloud-based analytics environments.
• Proficient in ETL/ELT development, data transformation, and scripting (SQL, Python, etc.).
• Solid understanding of metadata management, data governance, and lineage tracking.
• Experience implementing data security, encryption, and compliance controls.
• Familiarity with building and maintaining data marts for self-service analytics.
• Excellent communication and stakeholder engagement skills across business and technical teams.
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or related field.