Title |
Senior Data Architect |
Location |
Hybrid - Toronto, ON |
Start Date |
05-23-2025 |
Language |
English |
Salary |
Negotiable |
Security Clearance |
None |
Duration |
6 Months |
Date Posted |
05-07-2025 |
Job ID |
13753 |
Recruiter Email |
|
Maplesoft Group is currently seeking a Senior Data Architect for our client.
Tasks and Responsibilities include, but are not limited to the following:
- 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
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.
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
Maplesoft Group prides itself on its distinct corporate culture and recognizes that success is a direct reflection of our most valuable asset - our people. Therefore, attitude and ambition are key personality traits we seek out, along with skill and aptitude, in potential employees.
Maplesoft Group is committed to having a diverse, representative workforce and continuing to build an inclusive environment. We encourage applications from all qualified individuals. Maplesoft Group is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants irrespective of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans’ status, Aboriginal peoples or any other legally protected factors.
All employment decisions are made based on business needs, job requirements, and individual qualifications.
We are committed to developing inclusive, barrier-free recruitment and selection processes, and a work environment that supports our diverse workforce. Please let us know if you require accommodations at any stage of the recruitment process. We can be reached at Maplesoft Info at info@maplesoftgroup.com.
We thank you for your interest in Maplesoft Group and wish to advise you, that only candidates under consideration will be contacted.