MDM Architect

Company: Experis
Location: Albany
Posted on: January 26, 2023

Job Description:

MDM Architect Albany, NY (Hybrid - 1 week onsite, 1 week remote) 36 months (Extendable) Mandatory Qualifications:

• More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as an Architect.
• Four or more years of experience in building Master Data Management systems in a large-scale enterprise MDM environment using Informatica Master Data Management.
• Four or more years of experience in designing, implementing, reviewing data architecture of an eligibility and enrollment, case management, financial management, or claims systems. Desirable Qualifications:
• Five or more years of experience in Data architecture and designs across multiple IT Functional Areas.
• Five or more years of experience with enterprise data management technologies, including database platforms, data integration tools, Analytics & Reporting tools.
• Four or more years of experience in designing and developing data migration processes.
• Experience in enforcing standards for database security and configuration for all production databases and for non-production databases that may contain PHI or other sensitive data protected under HIPAA, Sarbanes Oxley, or other state or federal regulatory requirements.
• Experience with Enterprise Architecture documentation of various business processes and modeling to build data flow diagrams, process models, ER diagrams, relational and dimensional data models, and event modeling.
• Seven or more years of experience with designing, implementing and maintaining conceptual, logical and physical data models in an Online Transactional Processing (OLTP) and/or Online Analytical Processing (OLAP) environments.
• Five or more years of experience with ERWin or other data modeling tools.
• Knowledge of Oracle & SQL Server architecture and database design. Duties/Responsibilities:

• Lead efforts in identification and analysis of Data Requirements to drive data models and data structures.
• Identify business rules that govern how data is transformed, integrated and used.
• Develop data architecture and architectural considerations supporting IES Projects.
• Develops database solutions by designing proposed system; defining database physical structures and functional capabilities, security, back-up, and recovery specifications.
• Ensure architectural rules and design of the MDM process are documented and best practices are adhered to.
• Design and develop data architecture for scalable technical solutions in the areas of data optimization, data management, performance and efficiency.
• Design, develop and translate business requirements and processes for data matching and merging rules, survivorship criteria, and data stewardship workflows using master data management solutions.
• Assist in establishment of policies, procedures and guidelines regarding all aspects of Master Data Management.
• Work with ETL Developers and DBA teams to determine best practices as it relates to data transformations, data movement and derivations.
• Collaborate with ITS, NYSOH and NYC technical resources on continuous assessment of existing solutions for reuse on IES projects.
• Collaborate with IES Technical Architects to develop data management strategies.
• Collaborate with ITS Chief Technology Office to align with enterprise standards.
• Collaborate with internal and external partners ensuring technology decisions and data designs align with overall stewardship model.
• Participate in technical discussions with state, local and vendor implementation teams and technical deliverables to ensure alignment between proposed solutions and the program's data standards.
• Other duties as assigned.

Keywords: Experis, Albany , MDM Architect, Professions , Albany, New York