Data Analyst

MBD Customer Rewards/Fee Waivers

• Using Cognos, save a copy of the ‘3PA MBD Customer Rewards Tracking Report – All Dealer Contract Lines’ to a defined Sharepoint folder.
• Maintain and publish the file of ‘Advanced Integration’ catalogs monthly, and update Cognos queries with any new Advanced Integration catalogs prior to running the ‘Recurring Charges’ report.
• Maintain a file of all dealers no longer contracted for fee waivers.

• Using Cognos, execute the ‘Recurring Charges’ report monthly, 1 day prior to each month’s billing cut-off date.
• Email the ‘Recurring Charges’ file to CDK associates.
  
  

• Using Cognos and Excel, generate a file monthly, of ship-to CMF catalog contract lines, that should have monthly fees turned back on to bill.
• Email the Dealer ‘LSS’ file to CDK Billing & CSM teams.
  
  

• Respond to Customer rewards/Fee Waiver requests from CDK associates. Some examples are as follows:
• MBD enrollments and fees for specified ship-to CMFs, broken out by Basic & Advanced Integration.
• Status of fee waiver catalog contract line enrollment status for ship-to CMF(s).
• Dealer letters confirming dealer is part of the MBD fee waiver program
• On a weekly basis, update the count of dealer groups and ship-to CMFS marked installed on a fee waiver catalog.
• Provide fee waiver reporting for Project Bumblebee on a weekly basis – updates vary by week and then current areas of focus.
  
  
Project Bumblebee

• Host Project Bumblebee stand-up calls (currently on Mondays and Wednesdays)
• Record and post updates to Sharepoint folder.
  
  

• Create Bumblebee Power Point deck each week for weekly status meeting (currently on Wednesdays)
• Distribute to recipient list each Monday.
• Confirm updates by all associates are entered in the deck prior to the weekly status calls.
• Sync-up w/ Trey Gerlich every ELT reporting week to confirm status and updates of all Bumblebee workstreams.
  

Requirements

3+ years hands on experience with SQL Server and ETL.

Salesforce Reporting

Solid use of MS Excel to tract and organize data

Strong analytical skills to support, troubleshoot, and report on data.

Power BI Experience Preferred

Ability to work well in a fast-paced, dynamic environment

Able and willing to learn new concepts/skills quickly

At CDK, we believe inclusion and diversity are essential in inspiring meaningful connections to our people, customers and communities. We are open, curious and encourage different views, so that everyone can be their best selves and make an impact.

CDK is an Equal Opportunity Employer committed to creating an inclusive workforce where everyone is valued. Qualified applicants will receive consideration for employment without regard to race, color, creed, ancestry, national origin, gender, sexual orientation, gender identity, gender expression, marital status, creed or religion, age, disability (including pregnancy), results of genetic testing, service in the military, veteran status or any other category protected by law.

Applicants for employment in the US must be authorized to work in the US. CDK may offer employer visa sponsorship to applicants.