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.
