Data Architect / Data Modeller
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 8+ years of experience in data architecture, data modelling, and relational database environments.
- Posting language
- English
- Posted
Original job description
Key Responsibilities
- Design and develop logical and physical data models for enterprise applications and target systems.
- Analyze existing applications, databases, and source data models to define target-state data architecture.
- Develop source-to-target data mappings and validate data integrity using SQL.
- Collaborate with Business Analysts, SMEs, Developers, and Architects to translate business requirements into effective data models.
- Define data flows, database structures, data distribution, and access methods across complex IT environments.
- Ensure alignment with enterprise data architecture standards, governance policies, and industry best practices.
- Prepare technical documentation and data modelling deliverables to support application development.
- 8+ years of experience in data architecture, data modelling, and relational database environments.
- Strong expertise in logical and physical data modelling, database design, and data analysis.
- Advanced SQL and RDBMS skills for data profiling, analysis, and validation.
- Hands-on experience with enterprise data modelling tools and source-to-target data mapping.
- Experience translating business and technical requirements into scalable data models.
- Strong understanding of enterprise data architecture standards and integration principles.
- Excellent analytical, documentation, and stakeholder collaboration skills.
- Experience with CASE tools and Python for data processing.
- Knowledge of Azure Data Lakehouse, Delta Lake, Parquet, Star Schema, and Snowflake.
- Familiarity with Information Management principles and data governance.
- Experience with environmental compliance, inspections, enforcement, or hazardous waste management systems.
- Previous Ontario public sector or government IT project experience.
More about this job
Responsibilities
Design logical and physical data models, analyze existing systems to define target-state architecture, and create source-to-target mappings validated with SQL. Collaborate with business and technical stakeholders, define data flows and database structures, and produce documentation aligned with enterprise standards and governance policies.
Requirements
Requires 8+ years of experience in data architecture, data modelling, and relational database environments, with strong database design, advanced SQL, and data analysis skills. Candidates should have experience with enterprise modelling tools, source-to-target mapping, scalable data models, architecture standards, and stakeholder collaboration; Python and specified data platforms are advantageous.
Skills
- Data Architecture
- Data Modelling
- Logical Data Modelling
- Physical Data Modelling
- Database Design
- SQL
- Relational Databases
- Data Analysis
- Data Profiling
- Source-to-Target Data Mapping
- Data Integrity Validation
- Enterprise Data Architecture
- Data Governance
- Stakeholder Collaboration
- Technical Documentation
- Python
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Government & Public Sector
Keywords
- Enterprise Data Architecture
- Data Modelling
- Logical Data Models
- Physical Data Models
- Database Design
- SQL
- Data Profiling
- Data Analysis
- Data Integrity
- Source-to-Target Mapping
- Data Flows
- Data Governance
- Enterprise Architecture Standards
- Integration Principles
- CASE Tools
- Python
- Azure Data Lakehouse
- Delta Lake
- Parquet
- Star Schema
- Snowflake
- Information Management
- Environmental Compliance
- Inspections
- Enforcement
- Hazardous Waste Management
- Public Sector IT