Data Analyst Consultant Jobs in Raleigh, NC (NOW HIRING)

The Senior MDM Product Analyst – Informatica 360 is responsible for driving the architecture, design, and delivery of enterprise-scale Master Data Management (MDM) solutions across the organization. This role provides strategic leadership for MDM platforms, focusing on end-to-end data architecture, scalable integrations, and real-time data enablement.

The candidate will lead the implementation of Informatica Customer 360 and Reference 360, ensuring seamless data flow from source systems to downstream consumers. This role requires deep expertise in API-driven and event-driven architectures, data pipeline engineering (batch and real-time), and enterprise integration patterns—enabling a governed, unified, and high-quality customer data ecosystem across banking platforms

Duties & Responsibilities:
Data Enhancement - Leads the implementation of enhancements for the quality, management, and storage of enterprise data. Executes initiatives that improve profiling, exception reporting, and issue resolution as well as general fixes for the Enterprise Data Warehouse. Builds dashboards to modernize analytics and assists management with special data projects.
Business Support - Enforces data policies and procedures across the enterprise. Encourages discussion and feedback from associates in order to identify areas of improvement within data management capabilities. Completes month-end validations on reporting data to ensure the quality and completeness of data prior to business use. May assist in training or mentoring less experienced consultants in the work group.
Business Strategy - Facilitates strategies that develop the Bank’s data management capabilities. Assists management in creating and implementing a strategic road to achieve planned objectives. Works cross-functionally to mature department presence within Bank business units. Maintains a strong knowledge of current and emerging technologies or trends impacting the financial service industry.
Documentation - Creates and maintains technical documentation for the Enterprise Data Warehouse, which includes source-to-target mappings, data dictionaries, and other related materials. Identifies and creates centralized business critical reports.

Position Specific Skills:
Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes
Knowledge of data spreadsheets and databases
Understanding of Base SAS programming, SAS Enterprise Guide, Cognos, or related programs
Ability to write SAS programming language

Qualifications:

Bachelor's Degree and 6 years of experience in Data Management, Data Analytics OR High School Diploma or GED and 10 years of experience in Data Management, Data Analytics

Core MDM Expertise

• 12+ years of experience in data engineering, MDM development, or integration architecture.
• Experience working in Agile methodology, including writing user stories and test cases using Jira.
• Deep expertise in Customer/Party MDM (Individual & Non-Individual), golden record management, and match & merge frameworks.
• Strong background in the Finance/Banking domain.

Platforms & Tools

• Strong hands-on experience with Informatica Customer 360 & Reference 360 (mandatory; SaaS preferred).
• Familiarity with other MDM tools such as Reltio, IBM MDM (preferred).
• Strong proficiency in SQL and data integration tools (Informatica, ETL frameworks).
• Experience with API development (REST, GraphQL) and messaging/event platforms (Kafka, MQ, etc.).
• Experience building controls on data environments.

Data & Architecture

• Strong understanding of data modeling (logical & physical), data integration patterns, data governance, and data lineage.
• Proven experience designing real-time and batch data architectures.

Cloud & Data Platforms

• Experience with Snowflake or other cloud data platforms (preferred).
• Exposure to Azure, AWS, or hybrid cloud architecture.

Domain Knowledge

• Experience in banking or financial services, including familiarity with Core Banking, Customer Information Systems, and Fraud/Risk/Compliance (KYC preferred).

Leadership & Soft Skills

• Strong technical leadership and mentoring ability.
• Excellent communication and stakeholder engagement skills.
• Ability to lead enterprise-scale initiatives independently.

PREFERRED QUALIFICATIONS

• Experience in large-scale enterprise data transformation programs.
• Knowledge of microservices architecture and domain-driven design.
• Exposure to DevOps, CI/CD pipelines, and automation frameworks.

KEY DELIVERABLES

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.

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.