Previous Job
MDM Architect
Ref No.: 18-70258
Location: Billerica, Massachusetts
Position Type:Contract
Start Date: 09/24/2018
Requirement Sharing Template
RR Number 115927
Job Location (with City & State) Billerica, MA
Duration Long Term
Expected Start date Immediate
Target Rate 70/hr. on C2C, 110K
No of openings/positions 1
Job Title/Role MDM Architect
Mandatory Skills MDM, data integration, Informatics, Data Architecture, Data Warehousing, Analytics, Visualizations and reporting
Hiring Mode – (TP / FTE / W2) TP/FTE
Preference on Work Authorization USC/GC/TN
Client Interview Needed for Selection (Yes / No) Yes
Detailed JD Please find below complete JD
Comments This is most critical position, we need your support on this.

Job Description:
  • Minimum of 10 years of experience in enterprise integration design, development, and implementation
  • Minimum 5 years of experience working as MDM architect and Solution Architect in a large enterprise ($500M+ annual revenue)
  • Minimum 7 years of experience in a data integration developer or BI developer role.
  • Proficient with Informatica MDM/IDQ (v 10.x) and other suite tools
  • Knowledge on various models of MDM implementation
  • Awareness of MDM trends, MDM Concepts and other technologies in the market
  • The candidate must have experience planning, designing, building, and implementing MDM Solution for a large-scale deployment
  • This individual must have led major IT deployment efforts and possess deep MDM expertise
  • Define/Design MDM solution/architecture
  • Create the MDM implementation roadmap
  • Lead the MDM application and technical architecture analysis, design, and implementation, and ensure that the product fulfils the requirements
  • Analysis, design, development and delivery of enterprise-wide Master Data Management solutions
  • Define and review to-be Processes and Governance model
  • Should be able to design and develop for a robust MDM platform that matches and consolidates key data subject areas.
  • This individual must produce MDM solutions meeting technical specifications and business requirements according to the established designs, participates in MDM design reviews.
  • The proposed candidate must have prior implementation experience with MDM implementation using Informatica MDM
  • Master Data Management (MDM) technical architecture/data modelling
  • MDM thought leader; Ability to interact with both technical and executive stakeholders as needed
  • MDM technical leadership across multiple domains, multiple technical areas: matching/merging/survivorship,data cleansing, workflows, UI, etc.
  • Accountable for technical MDM solution
  • Experience with data governance, data cleansing, and other data management areas
  • Excellent Communication skills - Previous experience dealing with stakeholders of the business etc.
  • Large-scale enterprise implementation experience including architecture and design of modern web, mobile, and integration (cloud/on premise) platforms
  • Excellent verbal and written communications, interpersonal, and analytical skills is required.
  • Experience with Agile development methodology.
  • Ability to interpret functional requirements, perform system analysis, and provide architectural expertise with a focus on Data Architecture
  • Utilize technical and domain knowledge to develop and implement effective software solutions; provide hands on mentoring to team members through all phases of the Systems Development Life Cycle (SDLC) using Agile practices
  • Present Architecture deliverables such as Ecosystem and Integration diagrams, ERD, Business Process Flows, Swimlanes, Visios and Mockups
  • Exhibit strong executive presence and ability to interact with key project sponsorsDrive operational excellence across the MDM platform
  • Experience in MDM platform including expertise with MDM data models, matching rules, trust frameworks, complex hierarchy relationship management and data governance
  • Identifies objects and data elements to be managed, specifies the policies and business rules for how master data is created and maintained, describes any hierarchies, taxonomies, or other relationships important to organizing or classifying objects, and explicitly assigns data-stewardship responsibility to individuals and organizations
  • Implements data policies, standards, procedures, and guidelines concerning data collection, access and management
  • Defines the overall MDM solution architecture and sets technical direction, defines component architecture, and reviews detailed designs for accuracy and overall compliance to defined architecture across the complete data lifecycle
  • Verifies design of overall Infrastructure and supports the build of the environments
  • Works with business process experts to help identify functional requirements
  • Supports Data Mapping Phases with proper technical analysis
  • Designs and plans testing and reporting for the impact assessment of additional functionality
  • Analyzes impact of future topology changes in the environment
  • Experience in playing the role of an MDM Architect and leading large MDM program for a full System Development Lifecycle.

  • The Data Architect is a high exposure role within Client's Informatics Architecture group that will be responsible for the architecture and modeling of all data solutions, identifying gaps in the current data architecture, and defining the future state solutions and capabilities necessary to enable Informatics Strategy adoption and Self-Service analytics
  • A successful candidate should have experience at multiple healthcare payers, navigating and negotiating data solutions in a complex and matrix organization, excellent communication and consulting skills, and the ability to operate both at a high level in defining data/informatics strategy as well as getting deep into the details of designing data models from scratch

  • Implementing analytics and data solutions using architectural models in a sustainable and agile manner
  • Provides expertise and guidance in the areas of Informatics, Data Architecture, Data Warehousing, Analytics, Visualizations and reporting.
  • Working with business and technology stakeholders – senior leadership, middle management and subject-matter experts –building a holistic business processes and information assets; linking the business mission, strategy and processes of the organization to its Enterprise Informatics Strategy.
  • Assists in the creation of the high-level architecture and data solutions, design data centric projects (conceptual model, integration model, sourcing) in alignment with the enterprise informatics strategy and translates enterprise or business needs into long-term information architecture solutions.
  • Applies enterprise vision to all technical and application projects, understanding and communicating different architectural models/strategies that are consistent with business strategies.
  • Lead the design, development and implementation of complex, multi-application transactional and analytical data models at the conceptual and logical levels using standard data modeling tools
  • Translate complex business requirements into tangible data requirements through collaborative work with both business and technical subject matter experts
  • Develops Logical models with an eye towards high performance, scalability, flexibility and usability
  • Publishes and conducts solution reviews and negotiate solutions with business and technical teams.
  • Analyzes and profiles large and complex data sets to Client and/or validate data quality issues and business rules.
  • Facilitates the development of data-related policies, processes, procedures and standardsActively researches philosophical and technological changes in data management and pursues an understanding of the organization's business plans and strategies.
  • Evaluates the value of these trends to the organization and presents the information to management and other team members.

  • Experience within health care, Clinical and knowledge of the business processes
  • 10+ years' experience architecting and modeling an enterprise use layer, semantic layer, distribution layer, dependent data marts and BI/reporting solutions against a very large Enterprise-wide Data Warehouse (30+ terabytes) according to industry standards
  • Superior communication skills (written, verbal, and presentation), resource will be the primary interface between operational and analytical areas in the business, enterprise architecture, and technical resources developing information management solutions

  • Extensive knowledge of data modeling concepts and best practices both in a multi-layer data warehouse and Hadoop ecosystem.
  • Experience with data modeling and metadata solutions including ERWin, System Architect, Informatica Metadata Manager, and leveraging those solutions to produce data dictionaries and enterprise data lineage documentation
  • Experience with data architecture for various layers of analytic data stores including data hub, ODS, EDW, ERP, Hadoop and Data Marts
  • Experience with data governance working with data stewards and business stakeholders to understand the impacts of data model changes, gain consensus on data definition and business rules, and communicating to all consuming systems
  • Demonstrated ability to lead and mentor data modelers and data analysts
  • Knowledge of transaction standards (834, NCPDP, HL7, etc.)
  • Experience with Master Data Management solutions, Informatica MDM and IBM Initiate
  • Experience with data profiling/quality solution, Informatica Data Quality (IDQ)
  • Demonstrated expertise in writing and analyzing complex SQL queries in a Very Large Database (VLDB) environment is required
  • Ability to work on multiple projects simultaneously and deliver within tight timelines while being flexible in adapting to new roles
  • Ability to work with multiple areas within organization to get business objectives, data requirements etc.
  • Ability to interpret data that is not well defined or documented and develop recommendations based on findings
  • Experience in big data / Hadoop ecosystems in an enterprise environment
  • Knowledge of various BI and data discovery tools
  • Knowledge of Hadoop integration with ERP systems and APIs.
  • Experience in ETL tools both in RDBMS and Big Data environments
  • Architecting and Modeling: 10 years (Required)
Big Data / Hadoop Ecosystems in an Enterprise Environment: 3 years (Preferred