Data Modeller – Azure

Job Description: Role Title: Data Modeller

Location: Toronto, ON

Skills: Data Concepts & Data Modelling:Azure Data Factory Experience Required: 6-8

Role Description:

Data Modelling & Architecture:

Design and implement conceptual| logical| and physical data models.

Develop scalable and efficient data architectures using Azure Synapse and Databricks.

Integrate data from diverse sources including ERPs| APIs| and cloud databases.

Work closely with data engineers| analysts| and business stakeholders to gather requirements.

Derive Logical| Physical data models.

Ability to do reverse engineering.

Analysis of data across end-to-end applications.

Tools & Technologies:

Azure Synapse Analytics| Azure Data Factory (ADF).

Databricks (including Delta Lake and Unity Catalog)| SQL| PySpark |Python.

Hands-on data modelling tools (E.g., Erwin Data Modeler| ERStudio Data Architect| Power Designer etc.).

Experience with datawarehouse and Azure datalake.

Core Technical Competencies:

Strong understanding of data warehousing concepts and cloud architecture.

Design and implement conceptual| logical| and physical data models.

Develop scalable and efficient data architectures using Azure Synapse and Databricks.

Integrate data from diverse sources including ERPs| APIs| and cloud databases.

Work closely with data engineers| analysts| and business stakeholders to gather requirements.

Azure Synapse Analytics.