Talent.com
Enterprise Data Architect (MDM)

Enterprise Data Architect (MDM)

Saint Elizabeth Health CareOntario, Canada
22 days ago
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
  • 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.

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

  • 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

    • 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 [email protected] at your earliest convenience.

    IND2025