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.