This site uses cookies. To find out more, see our Cookies Policy

Sr. MDM Data Analyst in Raleigh, NC at Advance Auto Parts

Date Posted: 5/11/2019

Career Snapshot

  • Employee Type:
  • Location:
    Raleigh, NC
  • Career Type:
  • Experience:
    Not Specified
  • Date Posted:

Career Description

Job Description

The primary purpose of this position is to support the Advance Auto Parts (AAP) Enterprise Data Governance activities, focusing primarily on the Professional / Commercial Customers and providing influence and oversight of the other data domains such as Product, Location, Retail Customer, and Vendor.

The Data Analyst for the Master Data Management (MDM) is expected to be proficient in the data governance framework and strong business acumen and understanding of Master Data Management. Team up with the subject matter experts and data stewards to define and implements data strategy, policies, controls, and programs to ensure the enterprise data is accurate, complete, secure, and reliable.

The ideal candidate will be highly motivated and strong working experience in implementing the MDM solution along with the business & technical knowledge to analyze the data issues and articulate a data governance process to avoid in the future.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

  • Converting the data quality issues into a solution, ability to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies collaborating with subject matter experts and data stewards.
  • Helps design and implement Data Quality Controls, directs all aspects of data use and requirements across the enterprise and promotes treatment of data and information as critical enterprise assets.
  • Ability to profile the data using the Cloud and On-Premise tools to provide clear understanding to the business stakeholders on the current state of the data and roadmap to monitor those metrics in the sustain state of the data governance framework.
  • Leader within the team to establish the KPIs and build a process to govern them.
  • Monitors scorecard process/execution and provides feedback to the Data Governance Office (DGO).
  • Play an active role in the Data Governance Organization for the Professional Customer domain, and be a strong advocate for the tool integration and standards.
  • Organizational commitment to ensure ongoing effective communication between all facets of the business with regard to the Professional Customer domain.
  • Work closely with the Business & IT to ensure the alignment of master data management’s cleanse and the business rules are applied accordingly and all the applications are in sync with MDM
  • Strong knowledge in using SQL to query the data on the various systems within AAP to understand the data & harmonization issues.
  • Manage the data lineage, business rules, cleansing rules, transformation to the AAP list of values across the enterprise in the Metadata Management Tool.
  • Very strong on the Master Data Management & data steward activities such as – Merge the Customers, Unmerge Cross-Walk, Survivorship rules, Hierarchies, etc.,


To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Strong problem solving and analytic skills

Excellent verbal and written communication skills

Working knowledge on the MDM tool (it can be On-premise or Cloud)

Experienced in using the data profiling tools (Example: Trillium, Collibra, Trifacta, etc,)

Strong knowledge on the SQL

Working knowledge on troubleshooting the data harmonization issues in Enterprise Service Bus (ESB), Cloud Solution (Example: SalesForce.Com), On-Premise data store (Example: Oracle RDBMS)

Working knowledge on the workflow management tool is plus

Data quality and data risk management expertise, including understanding of standards, methods, processes, tools, and controls to manage enterprise-wide

Retail/Wholesale Automotive experience a plus

Ability to travel as necessary to meet organizational and administrative demands (up to 30% of the time)


Bachelor’s Degree in relevant field; 7-10+ years data analyst, master data management, data profiling, integration projects or equivalent combination of education and experience.

Recent 5 years data quality & master data management experience is a must.




Ability to manage the Systems Integration (SI) Vendor’s resources


The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.