Data Coordinator

Summary

Join Affinitiv's award-winning team as a Data Coordinator! You will be responsible for gathering, analyzing, and organizing data from various sources to support dealership objectives. This role involves data entry, maintaining data integrity, and summarizing findings. You will also perform administrative tasks, assist with CRM records, and ensure data accuracy. The ideal candidate possesses strong organizational and data management skills, proficiency in Microsoft Excel, and excellent attention to detail. Affinitiv offers a comprehensive benefits package and a flexible Work from Here program.

Requirements

• 1+ years of work experience
• Proficiency in Microsoft Excel, including formulas, pivot tables, and data visualization
• Strong organizational and data management skills
• 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

Responsibilities

• Pull and compile data from third-party sources, CRM 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 clients, multiple departments, and team members

Preferred Qualifications

Experience with CRM systems

Benefits

• Medical, dental, vision and 401K effective day 1
• Generous PTO
• Remote work and the utmost flexibility