Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank

Phoenix, Raleigh (AZ, NC)

Hybrid

USD 90,000 - 140,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

First Citizens Bank is seeking a Data Management Analyst to support onboarding of new source systems into enterprise MDM platforms. You will analyze data structures, map transformations, and define data quality rules while collaborating with business users, Product Owners, architects, and engineering teams.

The role emphasizes governance adherence, data lineage, and metadata management across customer, organization, and reference data domains.

Qualifications

  • Bachelor's degree required with 4+ years of data management, or equivalent experience.
  • Experience in data onboarding, governance and integration.
  • Strong SQL skills for profiling, reconciliation and validation.
  • Experience with MDM platforms and data quality controls.

Responsibilities

  • Support onboarding of new source systems into enterprise MDM platforms.
  • Analyze source data structures and define data mappings and transformation requirements.
  • Perform data profiling, quality assessments, and issue remediation.
  • Collaborate with business and tech teams to ensure governance standards are followed.
  • Support data governance and reference data management activities.

Skills

MDM
SQL
Data Quality
Data Governance
Source-to-Target Mapping
Data Integration
Data Validation
JIRA
SCRUM

Education

Bachelor's Degree
High School Diploma or GED

Tools

Informatica MDM
Reltio
Semarchy
IBM MDM
Oracle MDM
SAP MDG
Informatica IDMC
PowerCenter
SSIS
Denodo
Collibra
R360

Job description

Overview

This is a hybrid role, with the expectation that time working will regularly take place inside and outside of a company office: NC, AZ

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.

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.

Responsibilities & Qualifications
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

Qualifications: 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
Additional Information

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst, Enterprise Data Management (MDM Ingestion)
Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank • Phoenix (AZ)

On-site
USD 110,000 - 140,000
Data Analyst, Enterprise Data Management (MDM Ingestion)
Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank • Raleigh (NC)

Hybrid
USD 110,000 - 140,000
MDM Ingestion & Data Governance Analyst
MDM Ingestion & Data Governance Analyst

First Citizens Bank • Raleigh (NC)

Hybrid
USD 110,000 - 140,000
MDM Data Ingestion Analyst — Enterprise Data
MDM Data Ingestion Analyst — Enterprise Data

First Citizens Bank • Phoenix (AZ), Raleigh (NC)

Hybrid
USD 90,000 - 140,000
MDM Ingestion & Data Quality Analyst
MDM Ingestion & Data Quality Analyst

First Citizens Bank • Phoenix (AZ)

On-site
USD 110,000 - 140,000
Master Data Analyst
Master Data Analyst

PrimeSource Building Products, Inc. • Irving (TX)

On-site
USD 70,000 - 90,000
Senior Enterprise Data Analyst- (Charlotte, NC, Raleigh, NC or Phoenix, AZ)
Senior Enterprise Data Analyst- (Charlotte, NC, Raleigh, NC or Phoenix, AZ)

First Citizens Bank • Raleigh (NC)

On-site
USD 110,000 - 150,000
Benefits package
Advisor-Data Engineer MDM
Advisor-Data Engineer MDM

OP RaaS • Tennessee

Hybrid
USD 140,000 - 190,000
Senior Data Analyst – Enterprise Data Management
Senior Data Analyst – Enterprise Data Management

Bank of America Corporation • Charlotte (NC)

On-site
USD 110,000 - 140,000
Senior Manager, Enterprise Data Products
Senior Manager, Enterprise Data Products

First Citizens Bank • Charlotte (NC)

Hybrid
USD 120,000 - 180,000
Benefits package