Business Intelligence Analyst II

Cox Automotive Inc.; Atlanta (GA); Hybrid; USD 74,000 - 111,000; Full time

Benefits offered by this job

Vacation with pay

Seven paid holidays

Wellness hours

Bereavement leave

Time off to vote

Jury duty leave

Volunteer time off

Military leave

Parental leave

Job summary

Cox Automotive Inc. in Atlanta seeks a Business Intelligence Analyst to acquire, synthesize, and organize dealer and broker performance data from RDS and Trade Desk systems, and to create reports and analyses to meet business needs. You will consult with stakeholders and contribute to data governance and strategic planning.

The role emphasizes BI deliverables, data pipelines, and self-service reporting with a focus on KPIs across dealer and marketplace data. A hybrid work model is supported.

Qualifications

• Authorized to work in the United States without sponsorship.
• Must live within commutable distance to Atlanta and follow an in office, hybrid schedule.
• BA/BS degree with 2+ years of experience, MS with up to 2 years' experience, or equivalent.
• Must have 2 years experience as a Business Intelligence Analyst.
• Proficiency in Tableau to develop straightforward dashboards or charts and perform basic troubleshooting.
• Strong SQL skills and data analysis methods.
• Strong communication and problem-solving abilities.
• Ability to prioritize, multi-task, and meet deadlines.

Responsibilities

• Delivers recurring performance analytics for RDS, tracking Core Client conversion, Inspection Volume, Sales, and MMI Sales Conversion metrics; communicates trends to stakeholders.
• Supports MMI reporting by validating sales conversion metrics against thresholds and correcting classification logic with stakeholders.
• Builds and maintains Trade Desk broker performance reporting and dashboards with impact tracking for new programs.
• Translates ad hoc data requests into recurring, self-service reporting assets.
• Investigates data discrepancies affecting reporting accuracy and resolves ETL timing or join logic issues.
• Works with related functions to understand business KPIs and priorities.
• Applies methods/tools to identify, gather, and analyze datasets.
• Delivers basic Business Intelligence work streams including revenue and marketplace analytics; develops reports and distributes them.
• Produces BI by querying data repositories and generating reports.
• Participates in standard, recurring, and ad-hoc projects and analyses.
• Assists in developing data pipelines, workflows, and queries.
• Manages data integrity, efficiency, and availability.

Skills

SQL

Tableau

Data analysis

Communication

Education

BA/BS in relevant field

MS in relevant field (optional)

Tools

Tableau

SQL

Job description

Acquires, synthesizes, and organizes dealer and broker performance data from RDS (Remote Dealer Services) and Trade Desk systems and other internal and external sources - including Core Client, inspection, sales, and MMI conversion data for RDS, and Trade Desk's applications and bid data. Creates specifications for RDS and Trade Desk reports and analyses based on business need and available data elements. Provides consultation to RDS and Trade Desk stakeholders on optimal methods to access, analyze, and derive meaning from produced datasets and reports. May analyze complex business issues across both domains, constructing forecasts, recommendations, and strategic/tactical plans based on dealer and marketplace data. Contributes to development and ensures ongoing application of data governance structures and controls for RDS and Trade Desk reporting.

What You'll Do

Primary responsibilities/duties

• Delivers recurring performance analytics for Remote Dealer Services (RDS), tracking Core Client conversion (inspections-based methodology), Inspection Volume, Sales, and MMI Sales Conversion metrics, and communicates trends to RDS stakeholders.
• Supports MMI reporting by validating sales conversion metrics against business-approved thresholds and correcting classification logic in coordination with business stakeholders.
• Builds and maintains Trade Desk broker performance reporting (e.g., broker overview dashboards), incorporating impact tracking for new program initiatives and bid-activity metrics to support Trade Desk leadership decision-making.
• Partners with Trade Desk and RDS stakeholders to translate ad hoc data requests into recurring, self-service reporting assets.
• Investigates and resolves data discrepancies (e.g., ETL timing gaps, join logic errors) impacting RDS and Trade Desk reporting accuracy.
• Works closely with allied / supported functions and commercial teams to understand business priorities and key performance indicators (KPIs).
• Applies accepted methods and tools to identify, gather, develop and analyze appropriate datasets.
• Takes responsibility for and delivers basic Business Intelligence work-streams, including revenue, marketplace, consumer and related analytics for designated business areas, data synthesis and insight generation, report development and distribution.
• Produces business intelligence by querying data repositories and generating reports.
• Works on standard, recurring and ad-hoc projects and analyses.
• Assists in the development and enhancement of data pipelines, workflows and queries.
• Manages the flow of information including integrity, efficiency, and availability of data.

Who You Are

Required Experience & Specialized Knowledge and skills

• Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. No OPT, CPT, STEM/OPT or visa sponsorship now or in future.
• Must live within a commutable distance to Atlanta and follow an in office, hybrid schedule
• BA/BS degree with 2+ years of experience, MS with up to 2 years' experience, OR equivalent combination of education and experience.
• Must have 2 years experience as a Business Intelligence Analyst
• Must have proficiency in Tableau to develop straightforward dashboards or charts and perform basic troubleshooting
• Understanding methods, techniques, and tools used for data analysis (SQL, Tableau, AI).
• Must have strong proficiency in SQL
• Demonstrates strong knowledge of technical, process and business principles, industry practices and standards.
• Strong analytical and problem-solving skills, able to interpret data patterns, break down business problems, and propose basic solutions.
• Strong communication and interpersonal skills, open to feedback, share progress and ask questions to ensure alignment with team goals.
• Ability to prioritize, multi-task, and meet deadlines.
• Desire to continually learn and grow analytical skillset.
• Other duties as needed or required
• Requires physical ability and mental acuity to execute the duties of the position successfully within required timeframes to meet business requirements.

USD 74,000.00 - 111,000.00 per year

Compensation

Compensation includes a base salary in the range of $74,000.00 - $111,000.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate's knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.

Benefits

The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company's needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.

Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship.

EOE, including disability/vets