Data Architect/Modeller
Sign in to apply for this position Sign In to ApplyRef: RQ11485 Contract – 6 Months (Extension Possible)
Hybrid: Toronto (40 St. Clair Ave. West)
Posted Date: 2026-10-26
Location: Hybrid – Toronto (40 St. Clair Ave. West)
Public Sector Experience: Required – OPS / Public Sector Contract End Date: 2027-03-31 *Rate: $109/hour
Overview:
The Ministry of Public and Business Service Delivery and Procurement is seeking a Senior Data Architect/Modeller to join the Land & Resources Cluster. In this role, the consultant will be responsible for developing and implementing data architecture in a complex and distributed environment, with a focus on reviewing source data models, designing target logical data models, and collaborating with multidisciplinary teams to ensure alignment with enterprise data modeling standards and business requirements.
Key Responsibilities:
- Develop and implement data architecture for application development in a complex and distributed environment
- Determine the flow and distribution of data, the location of databases, and appropriate data access methods
- Review data models for source applications and databases, then analyze and design logical data model specifications for target systems
- Collaborate with business stakeholders to ensure full coverage of data needs for target systems
- Work with development teams to support the creation of technical artefacts
- Analyze and understand source data models and develop data mappings for source and target systems
- Use SQL and RDBMS knowledge to carry out deep data analysis and validate data integrity
- Align data modeling outputs with enterprise data modeling standards and requirements across related IT initiatives
- Engage and provide information-sharing support to IT architects across Business, Information, Solution, and Technology domains
- Ensure integration with corporate and cluster policies, standards, and industry best practices
- Create, develop, and manage logical and physical data models throughout the project lifecycle
- Research current IT trends and best practices to ensure modeling outputs remain aligned with industry standards
Must-Have:
- Requirements 8+ years of demonstrated experience reviewing and analyzing business needs and requirements for existing IT applications and related data 8+ years of experience designing target data models based on complex business and technical requirements
- Strong experience in research, data analysis, and development of effective IT data model designs
- Expert analytical skills to analyze and understand source data models, including developing data mappings between source and target systems
- Excellent RDBMS knowledge including strong SQL skills for deep data analysis and validation
- Expert skills and hands-on experience with data modeling tools
- Proven ability to work effectively within multi-functional teams including Business Analysts, SMEs, Developers, and Architects
- Ability to understand problem domains and target IT/business requirements, and communicate data modeling outputs clearly
- Demonstrated ability to work independently with minimal supervision and adapt quickly to new environments
- Nice-to-Have Skills
- Experience with MECP applications covering environmental systems (inspections, compliance, enforcement) and hazardous waste management systems
- Experience with Computer Aided Software Engineering (CASE) tools
- Experience using Python to aid in 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
- Public sector or Ontario Public Service (OPS) experience
- Work Environment
This is a hybrid role requiring the consultant to be onsite 3 days per week at 40 St. Clair Ave. West, Toronto, ON, with 2 days worked remotely. Standard working hours are 8:00 AM to 5:00 PM, Monday to Friday (7.25 hours per day). No security clearance is required. The consultant will collaborate with a multidisciplinary team in an OPS environment.
Previous Job Job Listings Final role details, responsibilities, and terms will be confirmed with shortlisted candidates. Compensation may vary based on experience. Errors and omissions excepted.