Data Analyst

Posted 21 Days Ago
Be an Early Applicant
Hyderabad, Telangana
Mid level
Artificial Intelligence • Machine Learning • Software
We transform the way retail and automotive brands use their data while also transforming ourselves.
The Role
The Data Analyst will maintain and generate reports using Cognos and Excel, support customer rewards and fee waiver requests, and manage Project Bumblebee updates. Responsibilities include executing recurring charges reports, maintaining dealer fee waiver files, and hosting weekly status meetings for Project Bumblebee.
Summary Generated by Built In

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.

Top Skills

SQL
The Company
HQ: Austin, TX
9,000 Employees
On-site Workplace
Year Founded: 2006

What We Do

We’re Neuron at CDK Global. We use artificial intelligence and machine learning to produce predictive data insights for dealers and automakers. We’re committed to helping dealers connect and serve their customer base while growing their businesses in the way they envision.

After the acquisition of Square Root on February 1st, our enterprise software, CoEFFICIENT®, is further breaking through organizational silos, uncovers each dealership's unique needs, and helps achieve business goals to improve customer experiences.

Why Work With Us

Our culture is at the core of everything we do. As we grow, we’re not only looking to hire the best and brightest, but we’re also looking for people who share our values of Own It, Stay Curious, Be Open and Create Possibilities. We pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different

Gallery

Gallery

Similar Jobs

Zeta Global Logo Zeta Global

Data Analyst

AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
Easy Apply
Hybrid
Hyderabad, Telangana, IND
2194 Employees

MassMutual India Logo MassMutual India

Data Analyst

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana, IND

Crunchyroll Logo Crunchyroll

Staff Data Analyst

Digital Media • eCommerce • Gaming • Mobile • News + Entertainment
Hybrid
Hyderabad, Telangana, IND
1200 Employees

Crunchyroll Logo Crunchyroll

Principal Data Analyst

Digital Media • eCommerce • Gaming • Mobile • News + Entertainment
Hybrid
Hyderabad, Telangana, IND
1200 Employees

Similar Companies Hiring

InCommodities Thumbnail
Renewable Energy • Machine Learning • Information Technology • Energy • Automation • Analytics
Austin, TX
234 Employees
RunPod Thumbnail
Software • Infrastructure as a Service (IaaS) • Cloud • Artificial Intelligence
Charlotte, North Carolina
53 Employees
Hedra Thumbnail
Software • News + Entertainment • Marketing Tech • Generative AI • Enterprise Web • Digital Media • Consumer Web
San Francisco, CA
14 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account