Enterprise Data Architect (MDM)

Saint Elizabeth Health Care; Ontario; On-site; CAD 100,000 - 150,000; Full time

Job summary

Join a leading social enterprise in Canada as an Enterprise Data Architect. In this pivotal role, you will spearhead data transformation initiatives, bridging legacy systems with modern cloud platforms. Your expertise in data architecture and cloud migration will drive innovation and ensure data integrity, all while contributing to a mission that prioritizes health care excellence.

Benefits

Competitive pay

Benefits

Pension

Work-life balance

Qualifications

• At least 6 years of data architect and enterprise architect experience.
• Strong experience with cloud platforms (Azure / AWS) and SaaS integration (Workday / Salesforce).
• Expert-level knowledge of SQL.

Responsibilities

• Design and maintain hybrid (cloud / on-prem) enterprise data architecture.
• Architect cloud migration strategies for data systems.
• Lead and implement Master Data Management and Meta Data Management pipelines.

Skills

Cloud platforms

SQL

Data architecture

ETL architecture

Data modeling

Education

Bachelor's / master's degree in computer science, Health Informatics, Information Systems

Job description

Join us in re-imagining health care with the largest social enterprise in Canada. SE Health is leading a multi-year enterprise transformation project that leverages human-centered design to be at the forefront of innovation within the healthcare sector. As a leader in home care, we are expanding and enhancing our capabilities to provide personalized experiences using new platforms and cloud-native architectures, ensuring privacy and security by design. Our transformation is grounded in guiding principles drive to ensure that we prioritize team decisions, long-term planning, process standardization, data-driven insights, and balanced user adoption. If you are driven by the desire to have an impact, change the world of health care and shape the future, we invite you to be part of our journey.

Position Summary :

We are seeking a hands-on, experienced Enterprise Data Architect (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.

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
• 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
• 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
• 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
• 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.

Qualifications and Experience :

• 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
• Strong verbal and written communication skills
• Self-motivated with ability to work independently
• Knowledge of SQL Server, Azure SQL Managed Instance, and PostgreSQL

Preferred Qualifications :

• Experience developing or using APIs to manage data
• Experience with healthcare data systems
• Salesforce and Workday
• Previous experience working on Finance, HR or Healthcare projects

About SE Health

At SE, we love what we do. Every day, we bring hope and happiness to clients, homes, and communities across Canada. We treat each person with dignity and love, like our own family; we build empathy; and we do the right thing. We are always inspired to make a difference. As a not-for-profit social enterprise, we share knowledge, provide the best care, and help each client to realize their most meaningful goals for health and wellbeing. We are an inclusive workplace offering competitive pay, benefits, pension, and work life balance. We're a great place to work, and we hope you'll join our team. In the interest of the health and safety of our patients / clients, employees, and greater good of public health,

SE Health requires those that wish to work for this organization to be fully vaccinated against COVID-19. Fully vaccinated means a person has received both doses of the COVID-19 vaccine and it has been 14 days since the last dose.SE Health is committed to the success of all its employees.

If you feel you need accommodations because of illness or disability, please do not hesitate to contact the Talent Acquisition team at [e-mail] at your earliest convenience.