Data Modeler
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Data Modeler
Longterm Contract
Location: Toronto, Ontario (Hybrid) 2 days
Job Description / Role Summary
The Data Modeler is responsible for designing, governing, and optimizing the data models required to migrate analytical and operational workflows from Alteryx into Azure Synapse. This role focuses on conceptual, logical, and physical modelling across Synapse SQL, Data Lake storage structures, and transformation pipelines. The Data Modeller ensures the models support performant analytics and align with enterprise architectural standards.
Key Responsibilities
- Develop conceptual, logical, and physical data models for Synapse.
- Translate Alteryx workflows and datasets into optimized Synapse-ready schema structures.
- Produce metadata, data dictionaries, and source‑to‑target mappings.
- Support model validation with SMEs and engineering stakeholders.
- Ensure data models adhere to governance, RLS, and performance requirements.
- Guide implementation of models across Synapse SQL pools and ADLS.
- Profile data, define quality rules, and support reconciliation validation.
- Maintain modelling documentation and reusable enterprise assets.
Required Experience
- 7+ years in enterprise data modelling.
- Strong experience with Synapse SQL, SQL Server, and ADLS.
- Experience translating Alteryx workflows into structured data models.
- Expertise in dimensional, normalized, semantic, or data vault modelling.
- Proficiency with modelling tools (ER/Studio, ERwin, SQL DBM, etc.).
Preferred Skills
- Comfort with Lakehouse concepts and metadata governance tools.
- Strong facilitation skills for on‑site collaboration.
More about this job
Responsibilities
The Data Modeler is responsible for designing and optimizing data models to migrate workflows from Alteryx into Azure Synapse. This includes creating conceptual, logical, and physical models while ensuring alignment with enterprise architectural standards.
Requirements
Candidates need over 7 years of enterprise data modelling experience with proficiency in Synapse SQL, SQL Server, and ADLS. Expertise in various modelling methodologies and experience translating Alteryx workflows are required.
Skills
- Data Modelling
- Azure Synapse
- Alteryx
- SQL Server
- ADLS
- Dimensional Modelling
- Normalized Modelling
- Semantic Modelling
- Data Vault Modelling
- ER/Studio
- ERwin
- SQL DBM
- Lakehouse Concepts
- Metadata Governance
- Data Profiling
- Source-to-Target Mapping
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Consulting
- Software
- Engineering
Keywords
- Data Modeler
- Azure Synapse
- Alteryx
- ADLS
- SQL Server
- Conceptual Modelling
- Logical Modelling
- Physical Modelling
- Dimensional Modelling
- Data Vault
- ER/Studio
- ERwin
- SQL DBM
- Lakehouse
- Metadata Governance
- Data Dictionary
- Source-to-Target Mapping
- RLS
- Data Profiling
- Enterprise Architecture
- IT Consulting