Intermediate Data Architect/Modeller

Akkodis group; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading company is looking for an Intermediate Data Architect/Modeller to design and implement robust data architectures in a hybrid environment. The role involves optimizing performance, ensuring data security, and supporting cloud-based solutions across Azure and other platforms.

Qualifications

• Experience in physical database design and DBMS administration.
• Hands-on experience in cloud environments, especially Microsoft Azure.

Responsibilities

• Design and implement enterprise-level data architectures.
• Support the development of cloud-first, scalable data solutions.

Skills

Physical Database Design

DBMS Administration

Performance Tuning

Backup/Recovery

Capacity Planning

Cloud Environments

T-SQL

Data Security

Data Governance

Tools

Azure Data Factory

Databricks

Azure Synapse

Cosmos DB

Oracle DBMS

Big Data/Data Lake/Hadoop

Job description

The Client is seeking an Intermediate Data Architect/Modeller to design and implement robust data architectures in a complex, distributed environment. The successful candidate will support data solutions across Azure and other cloud-based platforms.

Job Title:Intermediate Data Architect/Modeller

Job Location:Toronto, ON/Hybrid

Job Description:

Must Haves:

· Proven experience in physical database design, DBMS administration, performance tuning, backup/recovery, and capacity planning

· Hands-on experience in cloud environments, particularly Microsoft Azure

· Expertise in Azure SQL Database, including T-SQL, audit, user/permissions management, and performance optimization

· Practical experience with technologies such as Azure Data Factory, Databricks, Azure Synapse, Cosmos DB, Oracle DBMS, and Big Data/Data Lake/Hadoop environments

Key Responsibilities:

· Design and implement enterprise-level data architectures

· Define data flow, distribution strategies, and access methods

· Support the development and maintenance of cloud-first, scalable data solutions

Optimize performance and ensure data security and governance across platforms