Marketing Data Strategist
Job Description
The Mission
As a Marketing Data Strategist at AutoIQ, you are the technical heartbeat of our dealer campaigns. You sit at the intersection of raw automotive data and high-impact marketing execution. Your mission is to transform messy Dealer Management System (DMS) exports into precision-targeted audiences that drive vehicle sales and service ROs.
You are a master of the "Monthly Pulse"—the consistent, high-accuracy extraction and refinement of data that fuels our DataMineIQ and GeoTrackIQ engines.
The Core Pillars of the Role
- Data Engineering & List Management (70%)
- Precision Extraction: Execute complex monthly data pulls for email, direct mail, and SMS campaigns across a diverse portfolio of automotive dealers.
- The "Clean Room": Use advanced Excel (Power Query, VLOOKUPs, Macros) and light scripting/Python/SQL to normalize fragmented DMS data and ensure 100% data hygiene.
- Suppression Logic: Build and manage rigorous exclusion lists (recent purchasers, do-not-contact, service-only vs. sales-only) to protect dealer reputation and budget.
- Quality Control: Serve as the final line of defense. You will audit every list for accuracy before it hits the "send" button.
- Analytical Insights & Reporting (20%)
- Match-Back Attribution: Use your analytical mind to connect the dots between our marketing lists and the dealer’s actual sales, proving the ROI of the AutoIQ suite.
- Templated Reporting: Populate and refine high-level performance dashboards that translate "rows of data" into "business stories" for our clients.
- Anomaly Detection: Identify trends in dealer databases (e.g., shrinking service loyalty or high database decay) and alert the account team to strategic opportunities.
- Client Strategy & Communication (10%)
- The "Expert Voice": Join high-level monthly reviews with General Managers or Dealer Principals to explain the technical "why" behind our audience segmentation.
- Process Innovation: Collaborate with our Programming and Automation teams to find ways to "work smarter," automating repetitive list-pull tasks to increase our scaling velocity.
What You Bring to the Table
- The "Data Eye": You have a near-obsessive attention to detail. You catch the missing area code or the duplicate VIN that others miss.
- Technical Toolbelt: Advanced Excel proficiency is non-negotiable. Experience with mySQL, PostgreSQL, Python, or data visualization tools (Tableau/Power BI) is a major plus.
- Automotive Fluency: (Preferred) You understand what a DMS is (CDK, Reynolds & Reynolds, etc.) and know the difference between a "Lost Soul" in service and an "In-Market Equity" lead.
- The "Switcher" Personality: You enjoy the "flow state" of deep data work but can pivot instantly to a professional, confident communication style when presenting to stakeholders.
Success Metrics (KPIs)
- Accuracy Rate: 0% error rate on live marketing deployments (Direct Mail/Email).
- Processing Efficiency: Meeting all "Monthly Pulse" deadlines with increasing speed as you optimize your workflows.
- Insight Value: Identifying at least one "Strategic Pivot" per month based on data trends (e.g., "We should move this budget from Conquest to Retention based on this month's DMS decay").
What We Offer
At AutoIQ, we believe that high-level data work deserves high-level support. While we are a precision-focused engineering firm, our culture is built on collaboration, growth, and the energy of a team that actually enjoys working together.
- 100% Company-Paid Benefits: We’ve got you covered. AutoIQ pays 100% of your premiums for Medical, Dental, and Vision insurance.
- Investing in Your Future: A generous 401(k) matching program to help you build long-term wealth while you help us build the future of automotive marketing.
- Work-Life Balance: Paid Time Off (PTO) because we know that the best "Data Strategists" are the ones who have time to recharge.
- The "Phoenix Pulse": This is a full-time, in-office position based at our Phoenix, AZ headquarters. You’ll be working in a high-energy, collaborative environment where your ideas are heard, and your wins are celebrated in person.
- Rapid Career Trajectory: As a fast-growing firm, we don't believe in "staying in your lane." You will have the opportunity to influence our processes, help us automate our workflows, and grow alongside the company.
Experience & Qualifications
- Excel Mastery: Advanced proficiency in Excel (XLOOKUP, Pivot Tables, Power Query) with experience managing and cleaning datasets of 10,000+ rows.
- Data Integrity: A proven track record of "Zero-Defect" work, specifically in list management and suppression logic (ensuring the right people get the right offer).
- Automotive Context: (Preferred) Familiarity with DMS/CRM platforms (CDK, Reynolds, etc.) and an understanding of how data drives dealership sales and service.
- Analytical Storytelling: Ability to turn complex data into simple, templated reports and present key "So What?" insights to clients or leadership.
- Technical Agility: Exposure to light coding (SQL, Macros, or Python) or a strong desire to use tech to automate repetitive manual tasks.
- Presence: A professional, confident communication style suitable for high-stakes dealer meetings.
- In-Office: Ability to work full-time at our Phoenix, AZ headquarters.
Pay
$55,000.00 - $65,000.00 per year
Benefits
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Retirement plan
- Vision insurance
Work Location
In person