Client: Ministry of Public and Business Service Delivery and Procurement – RQ11485
We are seeking a
Senior Data Architect/Modeller with extensive experience in data architecture, data modelling, business requirements analysis, relational database management systems (RDBMS), SQL, and the design and development of logical and physical data models. The successful candidate will review source data models and databases, analyse business and IT requirements, design target data models, develop source-to-target data mappings, and collaborate with business stakeholders, developers, architects, and subject matter experts to ensure high-quality IT deliverables and alignment with enterprise data modelling standards.
Role Snapshot
- Job Title: RQ11485 – Data Architect/Modeller – Senior
- Client: Ministry of Public and Business Service Delivery and Procurement
- Work Location: 40 St. Clair Avenue West, Toronto, Ontario, Canada
- Work Arrangement: Hybrid – 3 Days Onsite and 2 Days Remote per Week
- Estimated Start Date: October 5, 2026
- Estimated End Date: March 31, 2027
- Business Days: 123.00
- Extension: 60.00
- Hours: 7.25 hours per day
- Working Schedule: Monday to Friday, between 8:00 AM and 5:00 PM, excluding lunch breaks
- Security Level: No Clearance Required
Must Have
- Demonstrated experience reviewing and analysing business needs and requirements for existing IT applications and related data, and designing target data models.
- Strong experience in research, data analysis, and the development of effective IT data model designs.
Description
Responsibilities
Develops and implements the data architecture for application development in a complex and distributed environment, including determining the flow and distribution of data, the location of databases, and data access methods.
The successful candidate will review data models for source MECP applications and databases, analyse and design/develop logical data model specifications for target systems, collaborate with business stakeholders to ensure coverage of data needs for target systems, and work with development teams to support the development of technical artefacts.
Core Skills and Experience (8+ Years)
- Demonstrated experience reviewing and analysing business needs and requirements for existing IT applications and related data, and designing target data models.
- Strong experience in research, data analysis, and the development of effective IT data model designs.
- Work with related IT initiatives as required to align with enterprise data modelling standards and requirements.
- Expert analytical skills and experience analysing and understanding source data models and data, including developing data mappings for source and target systems.
- Excellent RDBMS knowledge, including SQL skills for carrying out in-depth analysis and/or confirming and validating data.
- Ability to work with and effectively engage a multifunctional team, including Business Analysts, Subject Matter Experts (SMEs), Developers, Architects, and other stakeholders, to ensure IT deliverables are of high quality.
- Ability to understand the problem domain and target IT/business requirements and communicate data modelling outputs as required.
- Ability to learn quickly, adapt, and work independently with little or no supervision.
- Ability to conduct research from a variety of sources to ensure alignment with current IT trends and best practices.
- Expert skills and experience using data modelling tools.
- Ability to engage with IT architects and provide information-sharing support to Business, Information, Solution, and Technology Architects as required.
- Ensure integration with related corporate and client cluster policies and standards, incorporating industry best practices.
- Knowledge and experience in creating, developing, and managing logical and physical data models.
Desirable Skills And Experience
- Experience with similar MECP applications covering environmental systems, including inspections, compliance, and enforcement, as well as hazardous waste management systems.
- Experience with Computer-Aided Software Engineering (CASE) tools.
- Experience using Python to support data processing activities.
- Knowledge and understanding of Information Management principles, concepts, policies, and practices.
- Knowledge of Parquet and Delta Lake data formats.
- Knowledge of Azure Data Lakehouses, star schema, and Snowflake.
Experience And Skill Set Requirements
- Core Skills and Experience - 70%
- Demonstrated experience reviewing and analysing business needs and requirements for existing IT applications and related data, and designing target data models.
- Strong experience in research, data analysis, and the development of effective IT data model designs.
- Experience aligning related IT initiatives with enterprise data modelling standards and requirements.
- Expert analytical skills in understanding source data models and source data, including developing source-to-target data mappings.
- Excellent knowledge of RDBMS and SQL for in-depth data analysis, confirmation, and validation.
- Ability to collaborate effectively with multifunctional teams, including Business Analysts, SMEs, Developers, and Architects, to deliver high-quality IT solutions.
- Ability to understand business and IT requirements and communicate data modelling outputs effectively.
- Ability to learn quickly, adapt to changing requirements, and work independently with minimal supervision.
- Ability to conduct research and apply current IT trends and industry best practices.
- Expert experience with data modelling tools.
- Ability to engage with and support Business, Information, Solution, and Technology Architects through information sharing.
- Knowledge of corporate and client cluster policies, standards, and industry best practices.
- Experience creating, developing, and managing logical and physical data models.
- Desirable Skills and Experience - 25%
- Experience with MECP applications involving environmental inspections, compliance, enforcement, and hazardous waste management.
- Experience with Computer-Aided Software Engineering (CASE) tools.
- Experience using Python for data processing activities.
- Knowledge of Information Management principles, concepts, policies, and practices.
- Knowledge of Parquet and Delta Lake data formats.
- Knowledge of Azure Data Lakehouses, star schema, and Snowflake.
- Education - 2%
- Education requirements are identified as a separate evaluation category in the original job description. Specific educational qualifications have not been provided.
- Public Sector Experience - 3%
- Public sector experience is identified as a separate evaluation category in the original job description. Specific public sector experience requirements have not been provided.
How to Apply
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to
hrsmss@smsoftconsulting.com by
Thursday, October 29, 2026, at 12:00 PM EST.
Mandatory Documents
- Updated Resume in Word format (Mandatory)
- References (Mandatory)
- Expected Hourly Rate (Mandatory)
- Visa Status (Mandatory)
- LinkedIn ID (Mandatory)
Without the mandatory documents, we cannot submit a candidate.
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join our WhatsApp Group
Note
This position is listed as
Hybrid, unless otherwise instructed by the client. The resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00 AM and 5:00 PM, excluding lunch breaks, every Monday to Friday inclusive.
As part of the hybrid arrangement, the resource is required to work onsite at the designated Ontario Public Service (OPS) office location for
3 days per week and remotely for
2 days per week.
- Onsite Requirement: 3 days per week.
- Remote Work: 2 days per week.
Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
