RQ11485 – Data Architect/Modeller – Senior in Toronto

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.

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.

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.

#J-18808-Ljbffr