Data Modeler – Cloud/Azure
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 7+ years of experience in Data Modeling or Data Architecture.
- Posting language
- English
- Posted
Original job description
Job Title:- Data Modeler – Cloud/Azure
Location: Toronto Canada
Contract: Long-Term Contract
Job Overview
We are looking for an experienced Data Modeler to support cloud and data modernization initiatives. The ideal candidate will have strong hands-on experience in data modeling, SQL, Azure data platforms, data mapping, and data governance. Banking or financial services experience is preferred.
Key Responsibilities
- Design and maintain Conceptual, Logical, and Physical Data Models.
- Develop source-to-target mappings, data flows, data lineage, and metadata.
- Translate business and technical requirements into scalable enterprise data models.
- Work closely with Data Architects, Data Engineers, Business Analysts, and Technology teams.
- Develop and optimize SQL queries and support complex database structures.
- Work with Azure data services including ADLS, Azure Databricks, Azure Synapse, and Azure Data Factory (ADF).
- Support data integration, transformation, migration, and modernization initiatives.
- Ensure data models comply with data governance, quality, security, and architecture standards.
- Identify data dependencies, relationships, and business rules across enterprise data platforms.
- Maintain data dictionaries, metadata, lineage, and modeling documentation.
Must-Have Skills
- 7+ years of experience in Data Modeling or Data Architecture.
- Strong expertise in SQL and database concepts.
- Hands-on experience with Microsoft Azure data platforms.
- Experience with ERwin, PowerDesigner, or similar data modeling tools.
- Strong understanding of Conceptual, Logical, and Physical Data Modeling.
- Experience with data mapping, lineage, metadata, and data governance.
- Experience with ADLS, Databricks, Synapse, and ADF.
- Strong communication and collaboration skills.
- Banking / Financial Services experience preferred.
More about this job
Responsibilities
Design and maintain conceptual, logical, and physical data models, and develop source-to-target mappings, data flows, lineage, metadata, and documentation. Support Azure-based data integration, transformation, migration, and modernization while ensuring data governance, quality, security, and architecture standards.
Requirements
Requires 7+ years of experience in data modeling or data architecture, strong SQL and database knowledge, and hands-on experience with Azure data platforms and modeling tools such as ERwin or PowerDesigner. Candidates should understand data mapping, lineage, metadata, and governance; banking or financial services experience is preferred.
Skills
- Data Modeling
- SQL
- Microsoft Azure
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- Data Mapping
- Data Lineage
- Metadata Management
- Data Governance
- ERwin
- PowerDesigner
- Azure Data Lake Storage
- Azure Databricks
- Azure Synapse
- Azure Data Factory
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Finance & Accounting
Keywords
- Data Modeling
- Data Architecture
- SQL
- Microsoft Azure
- Azure Data Lake Storage
- Azure Databricks
- Azure Synapse
- Azure Data Factory
- ERwin
- PowerDesigner
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
- Source-to-Target Mapping
- Data Flows
- Data Lineage
- Metadata
- Data Governance
- Data Quality
- Data Security
- Database Concepts
- Data Integration
- Data Transformation
- Data Migration
- Data Modernization
- Enterprise Data Models
- Data Dictionaries
- Business Rules
- Banking
- Financial Services