Senior Data Architect/Modeller

We are seeking an experienced Senior Data Architect/Modeller to lead the review, analysis, and design of robust data architectures within complex, distributed application environments. In this role, you will analyze business requirements and existing source applications to design and implement target logical and physical data models. Working collaboratively with cross-functional teams of business analysts, developers, subject matter experts, and architects, you will define data flows, determine database placement and access methods, establish source-to-target data mappings, and support the creation of high-quality technical artifacts aligned with enterprise standards.

Location: Toronto, ON (Hybrid – 3 days onsite, 2 days remote)

Duration: 6-month contract.



Advantages
Modern Architecture Scope: Hands-on design of target logical and physical data models for large-scale enterprise modernization.

Flexible Hybrid Model: Collaborative 3-day onsite schedule paired with 2 days of remote work flexibility.

Cross-Functional Influence: Work directly with enterprise architects, solution designers, and engineering leads to shape data strategy.

Advanced Data Ecosystem: Exposure to contemporary data formats, lakehouse architectures, and cloud data platforms.



Responsibilities
Review and analyze business requirements and existing source IT applications and databases to design target data models.

Develop and implement end-to-end data architectures in distributed environments, determining data flow, distribution, database locations, and data access methods.

Design and develop detailed logical and physical data model specifications for target systems.

Create and maintain comprehensive source-to-target data mapping documentation.

Execute deep data analysis and validation utilizing advanced SQL queries and relational database management systems (RDBMS).

Collaborate with development teams to support the creation and alignment of technical design artifacts.

Partner with enterprise IT architects (Business, Information, Solution, and Technology) to ensure alignment with enterprise modeling standards and governance policies.

Conduct technical research to integrate industry best practices and emerging data architecture trends into system designs.



Qualifications
Target Data Modeling: Demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data, and designing target data models (Strictly Required).

Research & Data Architecture: Strong experience in technical research, in-depth data analysis, and the development of effective IT data model designs (Strictly Required).

Senior Modeling Seniority: 8+ years of core experience creating, developing, and managing logical and physical data models using professional data modeling tools (Strictly Required).

Source-to-Target Mapping & Analysis: Expert analytical skills to evaluate source data structures and develop detailed source-to-target data mappings (Strictly Required).

Advanced SQL & RDBMS: Extensive relational database knowledge with deep SQL querying capabilities for rigorous data verification and profiling (Strictly Required).

Multi-Disciplinary Collaboration: Proven ability to work independently and effectively engage across multidisciplinary project teams (Business Analysts, SMEs, Developers, and Architects) (Strictly Required).

Nice-to-Have Assets:
Prior data modeling or architecture experience within a public sector or enterprise regulatory environment.

Experience with Computer-Aided Software Engineering (CASE) tools.

Practical experience using Python to support data processing and analysis.

Knowledge of modern data storage formats and architectures, including Parquet, Delta Lake, Azure Data Lakehouse, Snowflake, or Star Schema design.

Understanding of enterprise Information Management principles, concepts, and data governance policies.



Summary
If you're interested in the "Senior Data Architect/Modeller" role based in Toronto, we encourage you to apply online at www.randstad.ca.

Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

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.

This posting is for existing and upcoming vacancies.