Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens
Phoenix, AZ, United States
1 day ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Adobe InDesign Data Analysis JIRA Customer Data Management Data Validation Data Discovery Data Governance Data Integration Extract Transform Load (ETL) Data Mapping Data Profiling Data Structures
+13 more
Database Queries Meta-Data Management Oracle (Applications) Scrum Methodology Reference Data Standard Sql SQL Server Integration Services Enterprise Data Management Data Ingestion Data Lineage Collibra SAP MDG Data Management

Job description

This role is responsible for partnering with business, technology, data governance, and source system teams to support the onboarding, analysis, and integration of enterprise data into the MDM platform The individual will contribute to ensuring source data is accurately profiled, mapped, standardized, governed, and integrated to support trusted master data across customer, organization, and reference data domains., Support Data Ingestion and Source Onboarding

  • Support onboarding activities for new source systems into enterprise Master Data Management platforms.
  • Analyze source system data structures and business processes to understand integration requirements.
  • Participate in data discovery, profiling, and source assessment activities.
  • Develop and maintain source-to-target mapping documentation and transformation requirements.
  • Support definition and validation of data standardization, matching, survivorship, hierarchy, and integration rules.
  • Identify data quality concerns, onboarding issues, and assist with remediation planning.

Perform Data Analysis and Data Quality Assessments

  • Conduct data profiling and analysis to assess completeness, accuracy, consistency, and conformity of incoming data.
  • Investigate data quality issues and support root cause analysis activities.
  • Assist in defining and monitoring data quality rules, controls, metrics, and KPIs.
  • Analyze ingestion exceptions and support implementation of process improvements.
  • Participate in validation, reconciliation, and testing activities during project delivery and production support.

Partner with Business and Technology Stakeholders

  • Collaborate with business users, Product Owners, Architects, Tech Leads, and Engineering teams to understand data requirements.
  • Document business requirements, functional specifications, and data mapping requirements.
  • Participate in design, requirements gathering workshops, stakeholder discussions.
  • Ensure recommendations align with enterprise data standards and governance policies for MDM Sources.
  • Present findings, analysis results, and recommendations to project teams and stakeholders.

Support Data Governance and Reference Data Management

  • Ensure compliance with enterprise data standards and MDM-related reference data requirements.
  • Work with Data Governance teams and source system owners to support data stewardship and ownership processes.
  • Contribute to maintenance of data definitions, business definitions, onboarding standards , metadata and documentation activities.

Support MDM Operations and Continuous Improvement

  • Identify opportunities to improve source onboarding processes, controls, and data quality outcomes.
  • Support operational activities, release validation, and production issue analysis.
  • Contribute to process improvement initiatives across data onboarding and integration functions.
  • Support knowledge sharing

Requirements

Data Analysis, Master Data Management (MDM), Data Management, Master Data Management (MDM), Analysis Skills, Onboarding, Enterprise Data Integration, Data Quality, Data Management, Technical Delivery, The ideal candidate possesses strong analytical skills, foundational data management expertise, and the ability to collaborate effectively across business and technology teams to deliver high-quality data onboarding and integration delivery., Minimum Required Education and Experience: Bachelor’s Degree and 4 years’ experience OR High School Diploma or GED/Equivalent and 8 years’ experience in Data Management, Financial Analysis, or similar

Preferred Skills

  • 7+ years of experience in Data Management, Data Governance, Data Quality, Data Integration, Business Analysis, or Master Data Management.
  • 3+ years of experience supporting enterprise MDM initiatives.
  • Experience working with source system onboarding and data integration projects.
  • Experience gathering, documenting, and validating business and functional requirements.
  • Strong SQL skills for data analysis, profiling, reconciliation, and validation.
  • Experience with source-to-target mapping and business rule documentation.
  • Strong analytical and problem-solving skills.
  • Ability to work effectively with cross-functional stakeholders.
  • Experience working in Agile delivery environments and using Jira.
  • Banking or financial services industry experience.
  • Experience with Informatica MDM or other MDM platforms such as Reltio, Semarchy, IBM MDM, Oracle MDM, or SAP MDG.

  • Experience with Customer, Party, Organization, Product, or Reference Data domains.
  • Familiarity with integration technologies such as Informatica IDMC, PowerCenter, SSIS, Denodo, or equivalent ETL platforms.
  • Knowledge of Data Governance, Metadata Management, Data Lineage, and tools such as Collibra or R360.
  • Familiarity with KYC, Customer Lifecycle Management, and Enterprise Customer Data initiatives.
  • Experience supporting Data Quality monitoring and remediation initiatives.

Key Competencies

Data Management

  • Master Data Management (MDM) , SQL
  • Data Quality: Data Profiling, Data Analysis, Data Quality Monitoring
  • Data Governance: Metadata Management, Reference Data Management
  • Source-to-Target Mapping, Data Integration, Data Validation and Reconciliation
  • JIRA, SCRUM

Other Competencies

  • Requirements Gathering and Documentation
  • Root Cause Analysis, Process Improvement
  • Stakeholder Collaboration
  • Communication and Presentation Skills
  • Critical Thinking and Problem Solving
  • Working Effectively in Cross-Functional Teams

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…