Data Architect Modeller 0142-0812

Foilcon; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

An innovative IT services firm is seeking a Senior Data Architect to lead the design and implementation of a cutting-edge data lake architecture. This role will involve integrating legacy systems with modern platforms, ensuring data consistency, and enabling advanced analytics across the organization. The ideal candidate will work closely with finance, HR, and IT stakeholders to deliver a robust data platform that supports strategic decision-making. If you are passionate about data architecture and enjoy working in a collaborative environment, this opportunity is perfect for you.

Qualifications

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

Responsibilities

• Architect and develop a dimensional data model across various systems.
• Implement data quality rules and ensure compliance with data governance.

Skills

Dimensional Data Modeling

Data Lake Architecture

ETL/ELT Development

Data Governance

SQL

Python

Stakeholder Engagement

Education

Bachelor's in Computer Science

Master's in Information Systems

Tools

OneStream

Hyperion

Azure Data Lake

Power BI

Oracle EBS

Job description

Join to apply for the Data Architect Modeller 0142-0812 role at Foilcon

2 days ago Be among the first 25 applicants

Join to apply for the Data Architect Modeller 0142-0812 role at Foilcon

HM Note: This hybrid contract role requires three (3) days in office. Candidates' resumes must include their first and last names.

Description

Senior Data Architect – Dimensional Modeling & Data Lake Integration

• 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.
• This role involves defining a unified dimensional model, ensuring data consistency, and enabling advanced analytics and AI-readiness across the organization. The candidate will work closely with stakeholders in Finance, HR, and IT to deliver a governed, future-proof data platform that supports cross-functional decision-making.

Key Responsibilities

• Architect and develop a robust dimensional data model across systems such as OneStream, Hyperion, Oracle EBS, HCM, and Workbrain.
• Design and optimize fact and dimension tables, data marts, and calculated metrics within the Azure Data Lake to support analytics and operational reporting.
• Lead ETL/ELT strategy and implementation to integrate historical and current data sources with focus on scalability and performance.
• Implement data quality rules, data lineage tracking, and proactive monitoring to ensure auditability, integrity, and compliance.
• Develop and enforce data quality frameworks, including automated monitoring, validation rules, and reconciliation processes.
• Implement and maintain data security controls, such as encryption, role-based access controls (RBAC), privacy standards, and governance standards adherence.
• Lead the development of metadata-driven processes and data marts that support self-service analytics and executive reporting.
• Drive high-performance data solutions that are future-ready for AI, machine learning, predictive analytics, and PowerBI reports.

Required Skills & Qualifications

• Proven experience in dimensional data modeling, data lake architecture, and enterprise data integration.
• Strong knowledge of OneStream, Hyperion, and financial systems like Oracle EBS or equivalent.
• Hands-on experience with Azure Data Lake, Power BI, and cloud-based analytics environments.
• Proficiency 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.

Must Haves

• Architect and develop a robust dimensional data model across OneStream, Hyperion, Oracle EBS, HCM, and Workbrain systems, especially within finance.
• Design and optimize fact and dimension tables, data marts, and calculated metrics within the Azure Data Lake to support analytics and operational reporting.
• Lead ETL/ELT strategy and implementation to integrate historical and current data sources with focus on scalability and performance.
• Implement and maintain data security controls, including encryption, RBAC policies, privacy standards, and governance adherence.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Engineering and Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at Foilcon by 2x

Set job alerts for “Data Architect” roles.