Senior Data Architect to design and lead the implementation of an enterprise-grade data lake ar[...]

S I Systems; Toronto; Hybrid; CAD 90,000 - 150,000; Full time

Job summary

An innovative public sector client is seeking a Senior Data Architect to spearhead the design and implementation of an enterprise-grade data lake architecture. This role emphasizes integrating legacy systems with modern platforms, ensuring data integrity and compliance while driving high-performance solutions for AI and analytics. The ideal candidate will possess strong expertise in dimensional data modeling, data governance, and security controls. Join a forward-thinking organization that values your contributions and offers a hybrid work environment, allowing you to thrive in your career while making a significant impact in the public sector.

Qualifications

• Proven experience in dimensional data modeling and enterprise data integration.
• Strong knowledge of financial systems like Oracle EBS and cloud-based analytics.

Responsibilities

• Architect and develop a robust dimensional data model across various systems.
• Lead ETL/ELT strategy and implementation for data integration.

Skills

Dimensional Data Modeling

Data Lake Architecture

ETL/ELT Development

Azure Data Lake

SQL

Python

Data Governance

Data Security

Power BI

OneStream

Job description

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.

Our public sector client is seeking 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. REQ 142

Work mode - Hybrid, 2 days per week downtown office

Duration - Until Dec 2025 with a possibility of extension

Key Responsibilities

• Architect and develop a robust dimensional data model across OneStream, Hyperion, Oracle EBS, HCM, and Workbrain systems.
• 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.
• Implementing 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) policies, privacy standards, and adherence to governance standards
• Leading the development of metadata-driven processes and data marts that power self-service analytics and executive reporting.
• Driving high-performance data solutions that are future-ready for AI, machine learning, predictive analytics, and enable PowerBI analytical reports

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
• 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.