Data Architect Modeller 0142-0812

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

Job summary

Foilcon is seeking a Senior Data Architect Modeller to design and implement an enterprise-grade data lake architecture. This contract position requires expertise in dimensional modeling and integration of financial systems, ensuring data consistency and governance. The ideal candidate will lead the charge in creating advanced analytics capabilities and support cross-functional decision-making through a robust data platform.

Qualifications

• Proven experience in dimensional data modeling and data integration.
• Hands-on experience with Azure Data Lake and Power BI.
• Experience implementing data security and compliance controls.

Responsibilities

• Architect and develop a robust dimensional data model across various systems.
• Lead ETL/ELT strategies and ensure data quality standards.
• Implement data security controls and monitor compliance.

Skills

Dimensional data modeling

Data lake architecture

ETL / ELT development

Data governance

Communication

Education

Bachelor's or Master's degree in Computer Science

Tools

Azure Data Lake

Power BI

SQL

Python

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.

J-18808-Ljbffr