Apply now »

Master Data Analyst

Date:  Jul 13, 2021
Location: 

Hoffman Estates, IL, US, 60169

90864

About CDK Global, Inc

CDK Global (NASDAQ:CDK) is a leading provider of integrated data and technology solutions to the automotive, heavy truck, recreation and heavy equipment industries. Focused on enabling end-to-end, omnichannel retail commerce through open, agnostic technology, CDK Global provides solutions to dealers and original equipment manufacturers, serving nearly 15,000 retail locations in North America. CDK solutions connect people with technology by automating and integrating all parts of the dealership and buying process, including the acquisition, sales, financing, insuring, parts supply, repair and maintenance of vehicles. Visit cdkglobal.com.

 

Role is responsible for the generation and maintenance of all sellable products in both ERP systems. This includes scoping requirements, creating test data and assisting in modifications that allow us to begin selling.

 

Position Responsibilities & Essential functions

  • Joint Requirement Sessions are conducted with PCM Business, PCM IT and the product requestor and other product SMEs on requirements and PCM’s testing scope as it relates to the products
  • Regular review of JIRAs and testing in Item Hub web access tool
  • Customer expectation managing clear communication to product owners, including regular meetings, necessary requirement calls and the need to provide approvals
  • Handling 911 requests. PCM follows same process steps but under an escalated process, all actions are hand-held by PCM, determine LOE for set up and meet with Product Marketing and BDC. Escalation is sent to Product Marketing VP’s is there is a problem with meeting the request.
  • Defining test scenarios & test cases include regression testing, keep track of quotes, screenshots, clients, booked orders with final results.
  • Products need to be in Oracle prior to development (not just SQT or CPQ testing), some work can be done in tandem. Confirming codes have been entered into Oracle test environment before BDC contract testing.
  • Be available and resolve any billing related errors at least 2x monthly.  Once at billing cutoff and again at month end contract processing.
  • During the two week release cadence, daily calls are scheduled. Whoever is tasked with running the release, they are responsible for setting up the prioritization call with Product Owners, LOE call to review Jira tickets, updating and sending out daily status report, setting up post validation meeting with offshore team, confirming all requirements have been received and locked down, Oracle is updated for changes received during the two week cycle, Hot fixes or enhancements are brought into the release cycle if needed. Go-No Go meeting is scheduled if necessary, written communication is sent to Sales Ops for Newsflash release (Ahead of the Curve) communication, Jira tickets are moved to accepted status and complete list is sent to App support prior to that night’s release.
  • Team maintains established rotation schedule of duties that are handled on a daily basis. Checking PCM mailbox, open Jira’s, Service cloud tickets- working those tickets, responding and assigning out when necessary. Service Cloud tickets are checked multiple times a day during month end, critical to the business.
  • Product code creation, set-ups in Oracle, Tax request, Cat code request for QC items, 3rd Party and/or OEM accounts with Customer Hub, 3rd party data table information for CPQ, product requirement set-ups for Salesforce as well as supporting business requests.
  • PCM maintains documented cadence steps, checklist, changing and/or adding to notification templates ( QC notification, production notification, requirement approval request), Job Aide, End date process, Oracle steps and set ups including BOMS, Pricing, Charge types, and the Master Data File (excel spreadsheet) and the PCM request Form.
  • PCM performs SOX audits for any given month that products reconcile with Oracle set ups, Finance/Tax approvals etc.  
  • Master Data file is used to log all product Changes, Updates, Promo’s and New Product codes. There are also times when product codes are created that will not go into CPQ but still require the efforts as if a new product set up.
  • Work with business partners to update and load new and updates to Product Hierarchy reporting.
  • Mass load catalog numbers or charge types through Item Hub process steps.
  • Review IT error report log sent and resolve issues.
  • Send out weekly correspondence updates to users from both Sellable Items List from SharePoint, and also Open Requests.
  • Provide data stats for both process service level agreement, total catalogs and charge types processed, and other needed reportable items as determined.  Present in slide powerpoint format monthly to present to upper management and also included in monthly distribution newsletter.
  • Work with BDC Teams, Product Marketing, Revenue Recognition, BDC, Tax, and Legal for any new products and product bundles. See through end to end testing and then release to production environment.
  • Contribute and collaborate in weekly or monthly department meetings.
  • Reconcile and work with Rev Rec and BDC teams to resolve invalid charge type errors from report.
  • Ensures master data integrity in key systems as well as maintaining the processes to support the data quality.
  • Ensures quality of master data in key systems, as well as, development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity.
  • Provides assistance in resolving data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design collaborating with subject matter experts (SMEs).
  • Identifies areas for data quality improvements and helps to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies.
  • Assists in data management, governance, and data quality of master data requirements with other functional data owners to ensure functional master data integrity across the operation of financial systems is consistent and meets stated business rules and requirements. ◦Work closely with the business/IT to ensure alignment of master data rules and the operations of the application meet all requirements.
  • Collaborates with IT to translate business requirements for maintenance and backbill of existing data attributes and attribute additions, including rules for back-filling data for completeness
  • Conducts data cleansing to rid the system of old, unused data, or duplicate data for better management and quicker access.
     

Qualifications & Requirements

  • Oracle ERP
  • Sharepoint
  • Intermediate Excel
  • Procurement experience a plus
  • Contracting experience a plus
  • QTC lifecycle experience a plus
  • Travel <5%, on a possible project basis
  • Good analytical and problem-solving skills
  • Ability to work independently and as part of a team.
  • Good communication skills to communicate with customers, team members, and management.
     

PREFERRED ATTRIBUTES & Qualifications

  • Bachelors or equivalent experience
  • Project Management

 

CDK Global knows you have passions outside of work.  You have family, friends, sporting events, and lots of things going on.   That’s why we offer a comprehensive benefits package to not only take care of you but your family as well.   All of our benefits are effective the first day of employment including 401K matching, paid time off to re-energize, donate your time to volunteer in your community, and tuition reimbursement to name a few.

At CDK, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.  


Nearest Major Market: Chicago

Job Segment: Database, Outside Sales, Oracle, Developer, ERP, Technology, Sales

Apply now »