Apply now »

MDM Architect

Location:  Toronto
Other locations:  Primary Location Only
Salary: Competitive
Date:  Aug 28, 2023

Job description

Requisition ID:  1394048
At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

The opportunity


We are looking for a Manager, MDM Architect within EY’s Data & Analytics consulting team.

As a senior person in the team you will be assessing requirements, designing and implementing successful Master Data Management solution that comprise of Data cleansing, Data ingestion pipelines, Business process workflow, de-duplication and Standardization. You will work with a team to create a robust, sustainable and flexible design and contribute towards technical delivery using agile delivery framework. The Solution Architect understands both technical and functional design and brings perspective from all architecture domains (process, application, integration, data, technology and security) into the solution design of Master Data Management capabilities that support broader portfolio capabilities (e.g. HR, Supply Chain, Procurement, Finance, etc. )

This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.


Your key responsibilities

  • Need to work as a Senior team member to contribute in various technical streams of MDM implementation and support projects.
  • Develop, enhance, and support large scale end-to-end MDM project implementation
  • Monitor, analyze and participate in business requirement review, data modelling, data loading, data extraction
  • Perform data quality analysis on large and complex data sets.
  • Directly interact with client to lead and handle all design and development activities
  • Perform data quality improvements and helps to resolve data quality problems
  • Open to express and discuss ideas or issues with leads, architects or SMEs
  • To design and build the Data Governance policies in MDM, build the Data model and develop ETL flows for MDM Solutions.
  • To create enrichment solutions that includes logics like Validation, Match and merge and Survivorship.
  • Design, develop, test, maintaining and deploy MDM Applications, Data Sets & scripts and perform detailed analytics.
  • To support ongoing MDM Solutions and provide expertise in Data governance, implement row level securities and configure gateways.
  • Use knowledge of the different domains of MDM Space and perform Data Quality Analysis on heterogeneous source systems.
  • Perform data quality functions – data quality audit/assessment, entity resolution (matching), data profiling, data scorecard development, exception management configuration in MDM
  • Perform configuration of workflow in ActiveVOS (BPM) product
  • Perform Informatica EDC (Scanning/Profiling), MDM (Profiling and Mastering) and MDM Hub Configuration.
  • Development of Informatica MDM User Exits Match Rules.
  • Meet regularly with other Information Architects to review/enhance Information Architecture policies across the org
  • Develop best practices on implementing MDM solutions.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • Support the installations, maintenance, upgrades of MDM tools
  • Assist in the identification and resolution of issues related to Performance tuning of Application Database and Informatica MDM platform in test and production environments Support business development activities through both leading pursuits and developing strong relationships with existing clients

Skills and attributes for success

  • Be self-motivated and passionate about development, analysis and solving product issues
  • Ability to meet deadlines and manage project delivery
  • Superior communication and interpersonal skills


To qualify for the role, you must have

  • Should be at least around 7 years of experience in leading MDM implementations
  • Should have completed at least 2-3 full life cycle experience in MDM/DG project using any tools like Informatica
  • Strong on SQL and experience in Informatica MDM/DG
  • Well versed with Data consolidation/ ETL, Data Quality, Data Enrichment (D&B), Data Security, Data Governance and Data Harmonization concepts, practices and their implementation
  • Experience with developing workflows using Active VOS and developing User exits for business requirements
  • Must have hands-on experience across the various phases of a typical DQM solution - data profiling, data integration, validation, cleansing, standardization, matching, consolidation etc.
  • Should have understanding and experience of software development best practices
  • Excellent business communication, Consulting, Quality process skills
  • Understand and assess the Source to target map documents and provide the recommendations if any
  • Manage Enhancement on Informatica MDM / SQL server coding skills
  • Experience working independently, efficiently, and effectively under tight timelines and delivering results by critical deadlines
  • Experience with client-facing activities such as requirements gathering, facilitating meetings, presentation creation, and ability to prepare client ready deliverables
  • Experience of Agile and traditional SDLC delivery methodologies
  • Strong analytical and problem-solving skills


Diversity and Inclusion at EY

Diversity and inclusiveness are at the heart of who we are and how we work. We’re committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. We embrace diversity and are committed to combating systemic racism, advocating for the LGBT+ community, promoting our Neurodiversity Centre of Excellence and Accessibility initiatives, and are dedicated to amplifying the voices of Indigenous people (First Nations, Inuit, and Métis) nationally as we strive towards reconciliation. Our diverse experiences, abilities, backgrounds, and perspectives make our people unique and help guide us. Because when people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world.

EY | Building a better working world
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Apply now »