Data Architect / Modeller

Cleo Consulting; Ontario; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading consulting firm seeks a Database Administrator with extensive experience in database management systems and cloud environments, particularly Azure. The role involves developing data architecture and optimizing database performance. Ideal candidates will demonstrate strong technical skills and effective communication abilities.

Qualifications

• Experience creating physical database designs and administering DBMS.
• Hands-on experience with Azure SQL Database and T-SQL.
• Experience with cloud development and microservices architecture.

Responsibilities

• Develop and implement data architecture for application development.
• Ensure database optimization, capacity planning, and performance tuning.

Skills

Database Management

Cloud Environments

T-SQL

Data Architecture

NoSQL

Communication

Tools

Azure SQL Database

Azure Data Factories

Databricks

Azure Synapse

Cosmos DB

Oracle DBMS

SSIS

SSRS

Talend

Informatica

Job description

Requisition (SS): RQ09252

Start Date: 2025-06-02

End Date: 2026-03-31

Ministry: Ministry of Public and Business Service Delivery and Procurement

Business Days: 381.00

Hybrid: 3 Days onsite / 2 days remote

Must Have:

• Experience creating physical database designs and operating and administering database management systems (DBMS), including database optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Experience with cloud environments, especially Azure.
• Extensive hands-on experience with Azure SQL Database, proficiency in T-SQL, understanding SQL maintenance and audit, user and permissions management, performance management, and tuning.
• Hands-on experience with technologies such as Azure Data Factories, Databricks, Azure Synapse, Azure SQL, Cosmos DB, Oracle DBMS, along with Big Data/Data Lake/Hadoop experience. Certifications are an asset.

Responsibilities:

• Develop and implement data architecture for application development in complex, distributed environments, including data flow, database location, and data access methods.

Experience and Skill Set Requirements:

Technical Skills (30%):

• Create physical database designs and operate/administer DBMS, including optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Experience with cloud environments, especially Azure.
• Hands-on experience with Azure SQL Database, proficiency in T-SQL, SQL maintenance, audit, user permissions, performance management, and tuning.
• Experience with technologies like Azure Data Factories, Databricks, Azure Synapse, Azure SQL, Cosmos DB, Oracle DBMS, Big Data/Data Lake/Hadoop. Certifications are an asset.
• Experience with SSIS, SSRS, Talend, Informatica, etc.
• Experience working with NoSQL databases and formats like JSON and XML.

Experience (30%):

• Experience in programming languages.
• Experience with cloud development and microservices architecture.
• Experience with data migrations.
• Experience with information retrieval packages and query languages.
• Experience monitoring and enforcing database rules.
• Experience with incident, change, and configuration management procedures.
• Experience with communication protocols, distributed data systems, middleware, gateways, cybersecurity remediation.
• Knowledge of Information Management principles, concepts, policies, and practices.
• Extensive experience in production database administration and maintenance optimization.
• Subject matter expert in data warehouse/data marts design.
• Experience with technology installation, configuration, maintenance, upgrades, and cloning.
• Designing/developing automated data distribution mechanisms.
• Knowledge of object-oriented analysis and design techniques.
• Experience with impact analysis, implementation planning, patches, and technology stack updates.
• Experience with technology or application-specific design, development, and vendor collaboration.

Communication Skills (10%):

• Strong documentation skills for solutions, user manuals, reports, reviews, assessments.
• Effective communication of ideas, technical designs, and development in a user-friendly manner, maintaining high customer service levels.