Senior Data Architect

Maplesoft Group; Toronto; On-site; CAD 100,000 - 140,000; Full time

Job summary

A technology consulting firm in Toronto is seeking a Senior Data Architect to architect and develop data models, optimize data structures, and lead data integration strategies. The ideal candidate has strong knowledge in dimensional data modeling and familiarity with financial systems and cloud environments. Competitive salary and professional development opportunities are offered.

Qualifications

• Proven experience in dimensional data modeling.
• Experience with data lake architecture.
• Knowledge of financial systems like Oracle EBS.

Responsibilities

• Architect and develop a robust dimensional data model.
• Design and optimize fact and dimension tables.
• Lead ETL / ELT strategies and implementation.

Skills

Dimensional data modeling

Data lake architecture

Enterprise data integration

Oracle EBS

Azure Data Lake

Power BI

SQL

Python

Data governance

Communication skills

Education

Bachelor’s or Master’s degree in relevant fields

Job description

Maplesoft implements TimeLive for electronic time tracking.

Please view the demo below on how to enter and approve time.

Do you want to work in a dynamic environment where your contributions count?

At Maplesoft, we value the contributions of all our employees and contractors. We listen and act upon suggestions, advice, and innovative ideas to further our strategic vision. In turn, Maplesoft contributes to the communities where we live and operate. We think globally, but act locally.

Build your future with Maplesoft’s exciting technologies, deep partnerships, personal approach to consulting services, professional development opportunities, and vibrant company culture.

If you are interested in any of the following job openings, please apply directly to [e-mail] , citing the position title and job id in the email subject line.

Maplesoft Group is currently seeking a Senior Data Architect for our client. The key responsibilities include :

• Architecting and developing a robust dimensional data model across systems such as OneStream, Hyperion, Oracle EBS, HCM, and Workbrain.
• Designing and optimizing fact and dimension tables, data marts, and calculated metrics within the Azure Data Lake to support analytical and operational reporting.
• Leading ETL / ELT strategies 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.
• Developing and enforcing data quality frameworks, including automated monitoring, validation rules, and reconciliation processes.
• Implementing and maintaining data security controls, such as encryption, role-based access controls (RBAC), privacy standards, and governance standards.
• Leading the development of metadata-driven processes and data marts to support self-service analytics and executive reporting.
• Driving high-performance data solutions that are future-ready for AI, machine learning, predictive analytics, and enabling PowerBI reports.

The required skills and qualifications include proven experience in dimensional data modeling, data lake architecture, enterprise data integration, knowledge of financial systems like Oracle EBS, expertise with Azure Data Lake, Power BI, scripting skills (SQL, Python), understanding of data governance and security, and excellent communication skills. A Bachelor’s or Master’s degree in relevant fields is also required.

We value attitude and ambition, alongside skill and aptitude, and are committed to diversity and inclusion. We encourage applications from all qualified individuals and support inclusive recruitment processes. For accommodations during the recruitment process, contact Maplesoft Info at [e-mail].

Thank you for your interest in Maplesoft Group. Only candidates under consideration will be contacted.

Ready to Excel?

Think you're a great fit for our team? Explore our Job Opportunities page.

J-18808-Ljbffr