- Quick Apply
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.