Data Architect/Modeller - Senior

Bevertec; Toronto; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

Join a forward-thinking company as a Senior Data Architect, where you'll design and implement an enterprise-grade data lake architecture. This role offers the chance to integrate legacy data with modern platforms, ensuring data consistency and enabling advanced analytics. Collaborate with stakeholders across Finance, HR, and IT to create a governed, future-proof data platform that empowers decision-making. With a hybrid work model and a contract duration of 7 months, this position is ideal for those looking to make a significant impact in a dynamic environment.

Qualifications

• Proven experience in dimensional data modeling and data lake architecture.
• Strong knowledge of financial systems such as Oracle EBS and OneStream.

Responsibilities

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

Skills

Dimensional Data Modeling

Data Lake Architecture

Enterprise Data Integration

OneStream

Hyperion

Azure Data Lake

ETL/ELT Development

Data Security Controls

SQL

Python

Education

Bachelor's Degree in Computer Science

Master's Degree in Information Systems

Tools

Power BI

Oracle EBS

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Bevertec. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$100.00/hr - CA$100.00/hr

Direct message the job poster from Bevertec

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.

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Bevertec by 2x

Sign in to set job alerts for “Data Architect” roles.

Digital Architect - Relocate to Saudi Arabia

Solutions Architect (Cloud / Data Migration)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.