Data Coordinator (Automotive Advertising)

Join our award-winning A-Team! 

Ready to produce exceptional results with exceptional people?  Get in touch, we would love to get to know you. 

Affinitiv is the largest provider of end-to-end, data-driven marketing and software solutions exclusively focused on the automotive customer lifecycle. Backed by 20+ years of automotive and marketing expertise, we pride ourselves on being the go-to experts in the industry. Not only do we work with over 6,500 dealerships and every major manufacturer in the country, we’re well-versed in OEM standards and the intricacies of a dealership or group’s local business.

Position Summary:

The Data Coordinator is responsible for gathering, analyzing, and organizing data from various first and third-party sources to support dealership objectives. This role includes pulling budget figures, entering data into spreadsheets, maintaining data integrity, and summarizing findings in a clear and actionable format. The Data Coordinator will also perform administrative tasks related to data management, assist in pulling CRM records, and ensure data is consistently up-to-date and accurate.

Position Responsibilities:

• Pull and compile data from third-party sources, CRM and CDP systems, and budget records.
• Organize data into structured, easy-to-read spreadsheets for efficient access.
• Ensure data accuracy through diligent entry and verification processes.
• Assist with administrative duties related to data management.
• Analyze and summarize data to provide insights and actionable conclusions.
• Prepare periodic reports, dashboards, and data summaries for business leaders.
• Create and format marketing decks for ad-hoc proposals and projects.
• Generate Lead Source Comparison reports to track and assess lead performance.
• Track monthly third-party fees and ensure accurate billing records.
• Update the pacing sheet multiple times per week to monitor performance and goal tracking.
• Produce annual lead reports as requested to support long-term strategy and planning.
• Conduct competitive analysis to provide insights into industry trends and market positioning.
• Interacts with multiple departments, and team members.

Position Requirements:

• 1+ years of work experience

• Proficiency in Microsoft Excel, including formulas, pivot tables, and data visualization.
• Strong organizational and data management skills.
• Experience with CRM systems is a plus.
• Excellent attention to detail and accuracy in data entry and reporting.
• Ability to manage multiple data sources and prioritize tasks efficiently.
• Strong written and verbal communication skills for preparing reports and summaries.
• Ability in Microsoft PowerPoint for creating professional presentations and visual storytelling.
• Positive attitude with a team-oriented approach and a willingness to tackle routine or repetitive tasks as part of the role.

Affinitiv Equal Opportunity Statement

At Affinitiv, we celebrate diversity, equality and an inclusive environment.  Affinitiv is committed to providing an environment of mutual respect where equal employment opportunities to all employees and applicants for employment. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.  

All aspects of employment are decided on the basis of qualifications, competence, merit and business needs.  Affinitiv is proud to be an equal opportunity employee