Business Intelligence Analyst II

Responsibilities

• Build, maintain, and continuously improve dashboards and reports that help vAuto dealers make smarter inventory, pricing, appraisal, and operational decisions every day.
• Partner directly with vAuto customers to understand their reporting needs, ask the right questions, and translate dealer requirements into clear, actionable data products.
• Develop deep, end-to-end knowledge of the underlying data models, pipelines, and definitions that feed customer-facing reports and use that knowledge to confidently explain results, debug data questions, and guide customers through their data.
• Leverage AI tools to accelerate product discovery, rapidly prototype new dashboard and reporting concepts, and shorten the cycle from customer conversation to delivered insight.
• Partner with engineering, product, and data teams on platform and data migration work that strengthens the foundation of our customer-facing analytics.
• Document data sources, business logic, and report definitions so customers and internal stakeholders have a clear, shared understanding of what the data represents and how it should be used.

Requirements

• Bachelor's degree in a related discipline and minimum 2 years of business intelligence, analytics, or reporting experience. The right candidate could also have a different combination, such as a master's degree and up to 2 years of experience; or 6 years of experience in a related field.
• Hands-on experience writing SQL to query, join, and aggregate data from relational databases.
• Experience building dashboards and reports in a business intelligence tool such as Power BI, Tableau, Looker, or similar.
• Experience working with relational databases and/or cloud data warehouses (e.g., Snowflake, Redshift, BigQuery, SQL Server).
• Experience working in a customer-facing or stakeholder-facing role, gathering requirements and presenting data/findings.
• Preferred
• Experience working with automotive industry data, dealer software, or other industry-specific data platforms.
• Hands-on experience using AI tools (e.g., ChatGPT, Claude, Copilot) for product discovery, rapid prototyping, or accelerating analytics work.
• Experience with Snowflake, dbt, or other modern cloud data warehouse and transformation tools.
• Experience supporting data and platform migration projects (e.g., legacy reporting platform to a modern BI stack, on-prem to cloud data warehouse).
• Hands-on experience migrating dashboards/reports between BI platforms.
• Experience translating business questions from non-technical users (e.g., dealers, sales, operations) into reports and data products.
• Drug Testing

Benefits

Additional Information

Company Cox Automotive - USA Job Family Group Data Intelligence & Science Job Profile Business Intelligence Analyst II Management Level Individual Contributor Flexible Work Option Hybrid - Ability to work remotely part of the week Travel % Yes, 5% of the time Work Shift Day

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Cox Automotive? Share your experience