Data Architect / Data Modeller

Our Client is looking for an experienced Senior Data Architect / Data Modeller with 8+ years of experience in enterprise data architecture, data modelling, SQL, and database design to support a large-scale public sector IT initiative.

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.

Required Skills & Experience:

• 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.

Nice to Have:

• 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.