Data Architect

ZipRecruiter; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Data Architect/Modeler for a 6-month contract in downtown Toronto. The role involves designing data models, optimizing data architecture, and ensuring data governance and security while supporting reporting needs in a cloud-based analytics environment.

Qualifications

• At least 7 years experience in relevant fields.
• Knowledge of OneStream, Hyperion, Oracle EBS.
• Experience with Azure Data Lake and Power BI.

Responsibilities

• Design and optimize fact and dimension tables and data marts.
• Support analytical and operational reporting.
• Implement data security and compliance controls.

Skills

Dimensional data modeling

Data lake architecture

Enterprise data integration

ETL/ELT development

Data transformation

Scripting (SQL, Python)

Metadata management

Data governance

Data security

Tools

OneStream

Hyperion

Oracle EBS

Azure Data Lake

Power BI

Job description

Job Description

PrecisionERP is seeking a Data Architect/Modeler for a 6 month contract at our client located in downtown Toronto. Work onsite at least 2 days per week.

Requirements:

• Must have at least 7 years experience in dimensional data modeling, data lake architecture, and enterprise data integration.
• Must have knowledge of OneStream, Hyperion, and financial systems such as Oracle EBS or equivalent.
• Design experience to optimize fact and dimension tables, data marts, and calculated metrics within Azure Data Lake,
• Must be able to support analytical and operational reporting with Power BI, and cloud-based analytics environments.
• Proficient in ETL/ELT development, data transformation, and scripting (SQL, Python, etc.).
• Good 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.