• Provides a standard common business vocabulary, expresses strategic data requirements, outlines high level integrated designs to meet these requirements, and aligns with the enterprise strategy and related business architecture

• Define conceptual, logical model and physical model mapping from data source to curated model and data mart.

• Design dimensional data mart models, create source-to-target-mapping documentation, design and document data transformation from curated model to data mart

• The Architect / Modeler must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
· Development of documentation and materials as part of a review and knowledge transfer to other members

· Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed



Qualifications
Must Have:

- Proficiency in SQL and python, with hands-on experience using Databricks and Spark SQL for data modeling and transformation tasks.

- Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols.

- Experience in design, development and implementation of data models for analytics and business Intelligence

- Knowledgeable in BI modelling methodologies (Inmon, Kimball, data vault), data mapping, data warehouse, data lake and data lakehouse for enterprise.

- Strong understanding of data quality principles, with the ability to design and implement automated data quality checks using tools such as Python and SQL, ensuring data integrity across pipelines and models.

- Experience with middleware and gateways

- Experience in designing/developing an automated data distribution mechanism

Desirable Skills:
Experience with middleware and gateways
Experience in designing/developing an automated data distribution mechanism
Knowledge and understanding of object-oriented analysis and design techniques.
Experience in developing enterprise architecture deliverables (e.g. models) based on Ontario Enterprise Architecture processes and practice
Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience creating detailed data standards to enable integration with other systems
Experience reviewing conceptual, logical and physical data models for quality and adherence to standards
Knowledge and understanding of dimensional and relational data models
Knowledge and experience in information resource management tools and techniques



Summary
If you are interested in the Senior Data Architect/Modeller role in Toronto, please apply online at www.randstad.ca. Qualified candidates will be contacted.


Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.