Job Title

Repost-RQ00570 - Data Architect/Modeller - SeniorRepost due to candidate back out Shortlist Date: 2026-05-08, 5:00 p.m. Must Haves: Minimum 5 years of experience as a Data Architect, Data Specialist, or equivalent role in complex, multisystem environments Demonstrated experience with legacy data discovery, data profiling, and data quality assessment Proven experience developing sourcetotarget data mappings for migration to modern platforms Ability to translate business concepts into precise data definitions and mappings Location: Up to 5 days onsite (subject to HMs discretion) Public Sector Experience: Nice to Have Start Date2026-04-01End Date2027-03-31DepartmentDigital Excellence in HealthBusiness Days250.00Office Location525 University AvenueRQ-2026-009289-Data Architect/Modeller - SeniorThe Agency is responsible for ensuring Ontarians receive highquality, timely health care. Since its creation in 2019, the Agency has unified multiple health organizations to strengthen system performance and deliver better care for patients, families, and providers. As part of the Agency Digital Excellence in Health (DxH) transformation mandate, the ONE ID 2.0 initiative was launched to modernize the provincial provider identity and access management platform and its supporting business and operating models.Must Haves: Experience with Identity and Access Management products or initiatives strongly preferred. Minimum 5 years of experience as a Data Architect, Data Specialist, or equivalent role in complex, multisystem environments Demonstrated experience with legacy data discovery, data profiling, and data quality assessment Proven experience developing sourcetotarget data mappings for migration to modern platforms Strong understanding of conceptual, logical, and physical data models Handson experience with SQL and at least one data profiling/quality tool (e.g., Informatica, Talend, Collibra, Great Expectations) Experience working with health data, identity data, or related standards (HL7 v2/FHIR, provider registries, identity assurance concepts) Ability to translate business concepts into precise data definitions and mappings Strong analytical, documentation, and communication skills Experience collaborating with crossfunctional teams (architecture, integration, governance, security)Desired Skills: Experience with Identity and Access Management (IAM) or Identity Governance & Administration (IGA) Familiarity with SAML, OAuth, OIDC, or federation concepts Experience with device identity, certificates, or credential data Experience working in government or large publicsector digital programs Knowledge of master data management (MDM) concepts Experience with modern integration platforms (Mulesoft, Boomi, Informatica Cloud) Exposure to cloudbased data platforms (Azure, AWS, GCP)Rated Criteria:5+ years as Data Architect/Data Specialist in multisystem environments; experience with health or identity programs 20 PointsDemonstrated ability to analyze legacy systems, perform profiling, assess data quality, and document findings 15Experience developing sourcetotarget mappings, defining transformations, and supporting migration activities 20 PointsUnderstanding of HL7, FHIR, provider registries, identity assurance, IAM/IGA concepts 10 PointsAbility to work with conceptual/logical/physical models; strong ER modelling skills 10 PointsSQL, profiling tools, analytics tools, integration/mapping tools 10 PointsAbility to produce clear documentation, present findings, and collaborate with stakeholders 10 PointsUnderstanding of data governance, privacy, and security requirements in healthcare 5 PointsTotal: 100 PointsLegacy data assessment - Deliver a legacy data assessment, with an inventory of legacy data sources, structures, and dependencies relevant to migration. Data quality assessment Evaluate completeness, accuracy, duplication, and integrity issues in source data. Data mapping specifications define detailed source-to-target mappings between legacy systems and the logical future -state data model. Data transformation rules document cleansing, normalization, and transformation logic required during migration. Migration data sets preparation support verification of migrated data against source records to confirm accuracy and completeness. Migration support for testing provide data expertise and data sets to support integration, system, and UAT testing. Detailed data requirements support contribute to detailed functional requirements and acceptance criteria where data structures, attributes, or data flows must be defined. Support development of logical data model for target solution and mapping of it to SaaS data model, identifying gaps to be addressed. Support data migration planning and transition activities.