Senior Data Architect/Modeller

Position: Senior Data Architect / Modeller

Duration: 6 Months assignment (contract)
Client Location: Toronto (Onsite/Hybrid: 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday)
Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)

Note on Assignment Type

This position is provisionally Onsite/Hybrid, requiring 7.25 hours per calendar day between 8:00 AM and 5:00 PM, Monday to Friday (excluding breaks). Conditions may change based on organizational requirements and at the discretion of the Hiring Manager.

About the Engagement

Akkodis is seeking an experienced Senior Data Architect / Modeller to support enterprise data architecture, data modeling, and modernization initiatives within a complex, distributed technology environment.

The successful consultant will be responsible for analyzing existing application data structures, evaluating business and technical requirements, designing target-state data models, and ensuring alignment with enterprise data architecture standards. This role requires advanced expertise in logical and physical data modeling, data analysis, source-to-target mapping, and collaboration with business and technology stakeholders.

Scope

• Review, assess, and document source-system data models and databases.

• Design and maintain logical and physical data models for enterprise applications.

• Develop source-to-target data mappings and transformation specifications.

• Collaborate with business stakeholders, architects, analysts, and development teams to support project delivery.

Assignment Deliverables

• Reviewing and analyzing existing application and database architectures.

• Developing logical and physical data models to support target-state solutions.

• Creating source-to-target mapping documentation and data transformation specifications.

• Supporting development teams with data architecture guidance and technical artifacts.

• Performing data analysis and validation activities to ensure solution quality and integrity.

Expertise Required

Must Have:

• Minimum 8 years of experience in data architecture, data modeling, or related disciplines.

• Demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data structures.

• Proven experience designing and developing target-state logical and physical data models.

• Strong experience conducting data analysis, data research, and data architecture assessments.

• Expert knowledge of relational database management systems (RDBMS) and SQL.

• Experience analyzing source systems and creating source-to-target data mappings.

Nice to Have:

• Experience with Azure Data Lakehouse environments.

• Understanding of Star Schema and Snowflake Schema design methodologies.

• Experience supporting enterprise data modernization initiatives.

Security Clearance

Required.

Important

This is a business-to-business engagement. Candidates must represent an incorporated entity, hold a valid business number, maintain appropriate insurance, and invoice for services rendered.

How to Apply

Submit your resume in confidence via the Akkodis Canada website.

We thank all applicants for their interest in this opportunity. Only candidates meeting the above qualifications will be contacted for further discussions.

Accessibility:

At Akkodis, part of The Adecco Group, our purpose is simple: to make the future work for everyone. We live our values, Passion, Collaboration, Inclusion, Courage, and Customers at Heart, by fostering a workplace where diversity is celebrated and every voice matter. We encourage applications from individuals of all backgrounds and identities. Together, we’re making the future work for everyone.