Closed listing
Data Modeler
- Toronto, ON, Canada
$55 to $60 CAD / hour · Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Pay
- $55 to $60 CAD / hour
- Job type
- Contract
- Closing date
- Experience
- 7+ years of experience in Data Modeling / Data Architecture.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Data Modeler – Azure / Data Architecture
Location: Toronto, Canada
Duration: Long-Term Contract
Role Overview
We are looking for an experienced Data Modeler to support cloud and data modernization initiatives. The ideal candidate will have strong expertise in data modeling, SQL, Azure data platforms, data lineage, and data governance, with experience working on enterprise-scale data environments.
Key Responsibilities
- Design and maintain Conceptual, Logical, and Physical Data Models for enterprise data platforms.
- Develop data mappings, source-to-target mappings, data flows, and data lineage.
- Translate business and technical requirements into scalable and reusable data models.
- Collaborate with business, data engineering, architecture, and technology teams.
- Develop and validate data models using SQL and Azure data platforms.
- Work with Azure Data Lake Storage (ADLS), Azure Databricks, Azure Synapse, and Azure Data Factory (ADF).
- Support data integration, transformation, migration, and cloud modernization initiatives.
- Ensure data models follow data governance, data quality, security, metadata, and architecture standards.
- Perform data analysis and SQL-based validation to ensure model accuracy and completeness.
- Maintain model documentation, metadata, mappings, and lineage information.
Must Have
- 7+ years of experience in Data Modeling / Data Architecture.
- Strong hands-on experience with Conceptual, Logical, and Physical Data Modeling.
- Strong SQL and database concepts.
- Hands-on experience with Azure Cloud data platforms.
- Experience with ADLS, Azure Databricks, Azure Synapse, and ADF.
- Experience with ERwin, PowerDesigner, or similar data modeling tools.
- Strong understanding of data lineage, source-to-target mapping, metadata, and data governance.
- Experience supporting data integration, migration, and transformation projects.
- Strong communication and stakeholder-management skills.
- Banking / Financial Services experience preferred.
More about this job
Responsibilities
Design and maintain enterprise conceptual, logical, and physical data models, mappings, data flows, and lineage using SQL and Azure data platforms. Collaborate with business, engineering, architecture, and technology teams to support integration, transformation, migration, and modernization while ensuring governance, quality, security, metadata, and architecture standards.
Requirements
Requires 7+ years of data modeling or data architecture experience, strong SQL and database knowledge, and hands-on experience with conceptual, logical, and physical modeling and Azure data platforms. Candidates should know ADLS, Databricks, Synapse, ADF, and a modeling tool such as ERwin or PowerDesigner, with experience in lineage, governance, mappings, and data integration or migration; banking experience is preferred.
Skills
- Data Modeling
- Data Architecture
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- SQL
- Azure Data Lake Storage
- Azure Databricks
- Azure Synapse
- Azure Data Factory
- Data Lineage
- Source-To-Target Mapping
- Data Governance
- Data Integration
- Data Migration
- ERwin
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Finance & Accounting
Keywords
- Data Modeling
- Data Architecture
- SQL
- Azure
- Azure Data Lake Storage
- Azure Databricks
- Azure Synapse
- Azure Data Factory
- ERwin
- PowerDesigner
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
- Data Lineage
- Source-To-Target Mapping
- Data Flows
- Data Governance
- Data Quality
- Metadata
- Data Security
- Data Integration
- Data Transformation
- Data Migration
- Cloud Modernization
- Enterprise Data Platforms
- Banking
- Financial Services
- Stakeholder Management