RQ09345 - Data Architect/Modeller – Senior

S M Software Solutions Inc; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

An opportunity for a Senior Data Architect at a leading consulting firm in Ontario. This role involves creating data models, ensuring compliance, and implementing data governance practices. Ideal candidates will possess extensive experience in public sector projects and be adept in various data modeling tools. The position offers a hybrid work environment with a blend of in-office and remote work.

Qualifications

• 10+ years experience with solutions development.
• 5+ years working with public-sector healthcare providers.
• Experience in complex data integration challenges.

Responsibilities

• Construct a high-level overview of the entire data landscape.
• Develop high-level designs outlining main entities and their relationships.
• Document processes for extracting, transforming, and loading data.

Skills

Data Modeling

Data Governance

Public Sector Experience

Cloud Technologies

Analytical Skills

Tools

ERWIN

Power Designer

Azure Data Factory

Azure Data Lake Storage

Azure Databricks

Job description

1 day ago Be among the first 25 applicants

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid

Estimated Start Date: 2025-07-02

Estimated End Date: 2026-04-02

#Business Days: 248.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC

Description

Responsibilities:

• Construct a high-level overview of the entire data landscape of the organization.
• Illustrate how data moves through the organization and between systems.
• Develop high-level designs outlining the main entities and their relationships.
• Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects.
• Implement designs showing how data will be stored, including tables, columns, indexes, and relationships.
• Design diagrams showing how different data systems and databases interact and are integrated.
• Document standards and policies for data management, including naming conventions, data quality standards, and data security policies.
• Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity.
• Compile detailed descriptions of data elements, their meanings, and their relationships.
• Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization.
• Document and design processes for extracting, transforming, and loading data from various sources.
• Strategize and schedule the movement of data from legacy systems to new systems or platforms.
• Detail the design of the data warehouse, including the schema, dimensions, and fact tables.
• Set up and configure BI tools and dashboards.
• Regularly report on the quality of data, identifying issues and areas for improvement.
• Develop strategies and methods for cleaning and improving the quality of data.
• Plan and diagram how data security will be implemented and maintained.
• Document compliance with relevant regulations and standards.
• Develop strategies for improving the efficiency and performance of data systems.
• Detail plans for data architecture projects, including timelines, milestones, and resources required.
• Document technical specifications for all data architecture components and processes.
  
  

Experience And Skill Set Requirements

Public Sector Experience – 5 Points

• 5+ years of experience working with federal/provincial/broader public-sector healthcare providers.
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.
• In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
• Knowledge and experience with Public Sector Health related projects.
• Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
• Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies.
• Experience with large complex IT Health-related projects.
  
  

Technical Skills And Experience – 50 Points

7+ years experiences in the following:

• developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas.
• Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer).
• developing and implementing common data models and master data management strategies
• design schemas that balance agility, schema flexibility, data governance, and quality.
• Expertise in creating schemas that allow flexible querying and analysis across various data formats.
• defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.
• implementing schemas and metadata structures that support efficient data management.
• Understanding of data governance principles and practices, especially in designing schemas and metadata structures.
• Experience in creating Architecture Artefacts based on enterprise standards.
• 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.
• 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment.
• Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.
  
  

Core Skill And Experience – 30 Points

• 10+ years experience with Solutions development.
• Experience in addressing complex data integration challenges and design efficient, scalable data models.
• Experience in monitoring and enforcing data modelling/normalization standards.
• Experience with the privacy and security requirements or software development in a health context, or equivalent.
• Demonstrated knowledge of leading technical design, security and recovery procedures for application development.
• Experience with relational and hierarchical database technologies.
• Demonstrated understanding and experience with the use of information retrieval packages using query languages.
• Experience in production environment troubleshooting and tuning to improve performance.
• Knowledge and experience of Information Management tools, principles, concepts, policies and practices.
  
  

General Skills – 15 Points

• Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols.
• Knowledge of performance considerations for different database designs in different environments.
• Experience in structured methodologies for the design, development and implementation of applications.
• Experience in systems analysis and design in large or medium systems environments.
• Awareness of emerging I&IT trends and directions
• Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders.
• Experience working with cross-functional teams, including IT, business, and data engineering teams.
• Strong analytical skills to understand and model complex data relationships and structures.
• Meticulous attention to detail in designing and implementing data models and schemas.
  
  

Note

This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager.

Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.

Eligibility and Application Steps

If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: [e-mail]

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)
  
  

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role!

If you have any questions or need further clarification, feel free to call or text at [phone].

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at S M Software Solutions Inc by 2x

Sign in to set job alerts for “Senior Data Architect” roles.

Mississauga, Ontario, Canada 18 hours ago

Senior Data Architect – Dimensional Modeling & Data Lake Integration

Enterprise Data Architect - Modeling & Analysis - Hybrid

Greater Toronto Area, Canada 22 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.