Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank

Phoenix (AZ)

On-site

USD 110,000 - 140,000

Full time

2 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 seeks a data management professional to partner with business and technology teams to onboard and integrate data into the MDM platform.

You will profile source data, map to targets, and define data quality rules while collaborating across stakeholders to ensure governance and trusted reference data.

Experience with MDM tools, SQL proficiency, and Agile delivery will help drive data onboarding, validation, and continuous improvement across data domains.

Qualifications

  • Bachelor's degree plus 4+ years in Data Management, Governance or related field.
  • Experience with source onboarding and data integration projects.
  • Strong SQL skills for data analysis, profiling, reconciliation, and validation.
  • Experience with MDM platforms such as Informatica, SAP MDG, IBM MDM or Oracle MDM.

Responsibilities

  • Support onboarding of new source systems into enterprise MDM platforms.
  • Analyze source data structures and business processes to guide integration requirements.
  • Develop and maintain source-to-target mappings and transformation specs.
  • Define data quality rules, controls, metrics and KPIs for data onboarding.

Skills

SQL skills
Analytical thinking
Data analysis
Cross-functional collaboration
Communication
Requirements gathering

Education

Bachelor's degree or equivalent
4+ years in data-related field

Tools

Informatica MDM
PowerCenter
SSIS
Denodo
Collibra
R360
Informatica IDMC
SAP MDG

Job description

Overview

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), Raleigh (NC)

Hybrid
USD 90,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
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
MDM Data Analyst I
MDM Data Analyst I

US Tech Solutions • Lexington (MA)

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