Data Architect Modeller (Intermediate) 9252-1615

Foilcon; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading company in IT Services and Consulting is seeking a Data Architect Modeller at the mid-senior level. This hybrid contract role involves developing data architecture in complex environments, focusing on Azure technologies and database management. Ideal candidates will have strong communication skills and experience with various database systems. Join a dynamic team to shape data solutions for modern applications.

Qualifications

• Experience creating physical database designs and administering DBMS.
• Hands-on experience in Azure SQL Database and T-SQL.

Responsibilities

• Develops and implements data architecture for application development.
• Determines flow and distribution of data, location of databases.

Skills

Database Administration

Azure

T-SQL

Data Architecture

Communication

Tools

Azure SQL Database

SSIS

SSRS

Talend

Informatica

NoSQL

Hadoop

Job description

Join to apply for the Data Architect Modeller (Intermediate) 9252-1615 role at Foilcon

3 days ago Be among the first 25 applicants

Join to apply for the Data Architect Modeller (Intermediate) 9252-1615 role at Foilcon

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.

Description

Responsibilities

• Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.

Skills

Experience and Skill Set Requirements

Technical Skills 30%:

• Experience creating physical database designs and operating and experience administering database management systems (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Experience cloud environments especially Azure.
• Extensive hands-on experience in Azure SQL Database, proficiency in T-SQL, understanding of SQL maintenance and audit, user and permissions management, performance management and tuning.
• Hands-on experience with 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 with NoSQL databases and formats (JSON, XML).

Experience 30%:

• Experience in programming languages, cloud development, microservices architecture, data migrations, query languages, database rules enforcement, incident/change/configuration management, communication protocols, distributed data systems, middleware, cybersecurity, information management, database administration, data warehouse design, automation, object-oriented analysis, enterprise architecture, impact analysis, patches, and vendor collaboration.

Communication Skills (10%)

• Strong documentation and presentation skills; ability to communicate technical designs clearly; high customer service orientation.

Must Have

• Experience creating physical database designs, administering DBMS, Azure cloud environments, Azure SQL Database, T-SQL, SQL maintenance, and audit; certifications are a plus.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Engineering and Information Technology

Industries

• IT Services and IT Consulting