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.