Enterprise Data Architect Consultant (MDM) to design and implement enterprise data architecture that bridges our healthcare client's legacy systems with mo
S.i. Systèmes Toronto
Contract: 2-year contract with a high possibility of extension Hybrid (occasional site visits in Markham) Our Healthcare client is seeking a hands-on, experienced Enterprise Data Architect Consultant (MDM) to spearhead our organization's data transformation initiatives.
The successful candidate will design and implement enterprise data architecture that bridges our legacy systems with modern cloud-based platforms including Azure, AWS, Workday, and Salesforce. This role is critical in our transition from on-premises infrastructure to cloud solutions, with primary focus on MDM strategy implementation (Master Data Management and Meta Data Management), data integration, data management, ETL architecture, and data modeling.
You will be the technical authority ensuring data quality and integrity during system migrations while establishing architectural patterns that support future business growth and regulatory compliance, and to lead the transition from an integration perspective.
Must Haves: Bachelor's/master's degree in computer science, Health Informatics, Information Systems, or related field At least 6 years of data architect and enterprise architect experience as well as several years of development experience in app design or database management or data development Strong experience with cloud platforms ( Azure/AWS ) and SaaS integration ( Workday/Salesforce ) Expert-level knowledge of SQL: complex query concepts, OLAP queries, etc.
Experience designing and implementing cloud migration strategies Knowledge of data architecture, ETL architecture, data modelling concepts Experience working closely with business stakeholders to identify needs and opportunities Knowledge of SQL Server, Azure SQL Managed Instance, and PostgreSQL Nice to Haves: Custom visualization development expertise DELL BOOMI, Azure Data Factory, Azure Synapse, AWS Glue, Azure Purview Experience developing or using APIs to manage data Agile delivery methodology experience Experience with healthcare data systems Cloud certification (Azure/AWS) Salesforce and Workday Previous experience working on Finance, HR or Healthcare projects Role and Responsibilities: Enterprise Data Architecture and Modeling Design and maintain hybrid (cloud/on-prem) enterprise data architecture Create cloud-native data models optimized for platforms like Azure, AWS, Workday and Salesforce Develop logical and physical data models that enhance reporting and ETL structures Design data structures supporting real-time and batch processing needs Establish data modeling standards for both traditional and cloud-native architectures Create and maintain data dictionaries and metadata repositories Cloud Migration and Integration Architecture Architect cloud migration strategies for data systems Design hybrid cloud integration patterns Develop API-first data architecture approaches Implementation of complex API integration and data integration mechanisms Create specifications for complex API-to-database integrations Design event-driven architectures for real-time data processing Develop integration patterns between cloud services Ensure data consistency across hybrid environments Design fault-tolerant and scalable integration patterns Data Discovery and Migration Planning Conduct system analysis to reverse engineer existing data structures Create detailed data mapping specifications for migration projects Design data transformation and cleansing strategies Develop migration patterns for complex data including Finance, HR, Clinical and Operations Plan staged migration approaches minimizing business disruption Create validation frameworks for migrated data Document data lineage and dependencies Design rollback and recovery strategies for migrations Technical Design and Implementation Leadership Lead and implement Master Data Management and Meta Data Management pipelines, mechanisms and models Design ETL/ELT processes for hybrid environments Establish architecture patterns for microservices and APIs Establish Data Integration Patterns Review and approve integration designs Provide technical guidance on cloud-native development Create and maintain technical standards documentation Guide teams on best practices for cloud data modeling Performance Optimization and Monitoring Design scalable data architectures for cloud environments Develop performance monitoring frameworks Create data quality metrics and validation approaches Optimize data models for cloud performance Implement data validation rules across hybrid environments Design disaster recovery and business continuity approaches Additional Responsibilities: Requirements gathering and analysis; user stories, technical/data specification documents Actively participate in product selection and evaluation (such as AWS or Azure products) Facilitate requirements gathering sessions including interviews and meetings Develop complex SQL queries, scripts, and database objects Partner with other technical counterparts to achieve implementation goals Be the SME for many different subjects including Finance, HR, Operations, etc.
The successful candidate will design and implement enterprise data architecture that bridges our legacy systems with modern cloud-based platforms including Azure, AWS, Workday, and Salesforce. This role is critical in our transition from on-premises infrastructure to cloud solutions, with primary focus on MDM strategy implementation (Master Data Management and Meta Data Management), data integration, data management, ETL architecture, and data modeling.
You will be the technical authority ensuring data quality and integrity during system migrations while establishing architectural patterns that support future business growth and regulatory compliance, and to lead the transition from an integration perspective.
Must Haves: Bachelor's/master's degree in computer science, Health Informatics, Information Systems, or related field At least 6 years of data architect and enterprise architect experience as well as several years of development experience in app design or database management or data development Strong experience with cloud platforms ( Azure/AWS ) and SaaS integration ( Workday/Salesforce ) Expert-level knowledge of SQL: complex query concepts, OLAP queries, etc.
Experience designing and implementing cloud migration strategies Knowledge of data architecture, ETL architecture, data modelling concepts Experience working closely with business stakeholders to identify needs and opportunities Knowledge of SQL Server, Azure SQL Managed Instance, and PostgreSQL Nice to Haves: Custom visualization development expertise DELL BOOMI, Azure Data Factory, Azure Synapse, AWS Glue, Azure Purview Experience developing or using APIs to manage data Agile delivery methodology experience Experience with healthcare data systems Cloud certification (Azure/AWS) Salesforce and Workday Previous experience working on Finance, HR or Healthcare projects Role and Responsibilities: Enterprise Data Architecture and Modeling Design and maintain hybrid (cloud/on-prem) enterprise data architecture Create cloud-native data models optimized for platforms like Azure, AWS, Workday and Salesforce Develop logical and physical data models that enhance reporting and ETL structures Design data structures supporting real-time and batch processing needs Establish data modeling standards for both traditional and cloud-native architectures Create and maintain data dictionaries and metadata repositories Cloud Migration and Integration Architecture Architect cloud migration strategies for data systems Design hybrid cloud integration patterns Develop API-first data architecture approaches Implementation of complex API integration and data integration mechanisms Create specifications for complex API-to-database integrations Design event-driven architectures for real-time data processing Develop integration patterns between cloud services Ensure data consistency across hybrid environments Design fault-tolerant and scalable integration patterns Data Discovery and Migration Planning Conduct system analysis to reverse engineer existing data structures Create detailed data mapping specifications for migration projects Design data transformation and cleansing strategies Develop migration patterns for complex data including Finance, HR, Clinical and Operations Plan staged migration approaches minimizing business disruption Create validation frameworks for migrated data Document data lineage and dependencies Design rollback and recovery strategies for migrations Technical Design and Implementation Leadership Lead and implement Master Data Management and Meta Data Management pipelines, mechanisms and models Design ETL/ELT processes for hybrid environments Establish architecture patterns for microservices and APIs Establish Data Integration Patterns Review and approve integration designs Provide technical guidance on cloud-native development Create and maintain technical standards documentation Guide teams on best practices for cloud data modeling Performance Optimization and Monitoring Design scalable data architectures for cloud environments Develop performance monitoring frameworks Create data quality metrics and validation approaches Optimize data models for cloud performance Implement data validation rules across hybrid environments Design disaster recovery and business continuity approaches Additional Responsibilities: Requirements gathering and analysis; user stories, technical/data specification documents Actively participate in product selection and evaluation (such as AWS or Azure products) Facilitate requirements gathering sessions including interviews and meetings Develop complex SQL queries, scripts, and database objects Partner with other technical counterparts to achieve implementation goals Be the SME for many different subjects including Finance, HR, Operations, etc.
Apply
S.i. SystèmesToronto
What You’ll Be Doing The Senior Data Architect - provides data architecture expertise on key business and IS (Information Services) initiatives and participates in the development of application systems...
Zortech Solutions Inc.Mississauga, 26 km from Toronto
information through creation of data visualization
• Use ensemble modelling to combine multiple algorithms to obtain better predictive performance
• Research and document data requirements, data collection and administration policy, and data access...
BDO CanadaOakville, 38 km from Toronto
We welcome new energy into any one of our multiple offices across Canada as we seek Data Architect (Manager role) to join the Data & AI team and own the following responsibilities: Go-to-Market: Engage in pre-sales...