Analyst II, CAF Technical Support and Reporting

CarMax Business Services; Atlanta (GA); On-site; USD 68,000 - 103,000; Full time

Benefits offered by this job

Paid sick leave

Vacation time

Holiday pay

Paid time off

Accommodations for applicants

Job summary

CarMax is seeking a data analyst to conduct root cause analysis and solve complex data challenges. You will retrieve data from multiple systems, become a subject matter expert in data elements, and translate them into business metrics. You’ll maintain CAF dashboards and design enhancements to transform data interaction.

The role offers on-site collaboration and growth through mentoring and diverse tools. Based in Atlanta, GA (CarMax Auto Finance Office) with on-site presence four days a week;

Qualifications

• Bachelor’s degree preferred in an analytical or technical field.
• 1–3 years of experience in an analytical or technical role.
• Excellent verbal, written, and interpersonal skills.
• Experience SQL and DBMS; Snowflake preferred; Teradata, MS SQL Server, Oracle or other major data applications acceptable.

Responsibilities

• Conduct root cause analysis and solve data challenges.
• Leverage systems and databases to retrieve data.
• Identify critical data elements and translate into key business metrics.
• Maintain and optimize dashboards and reports for CAF.
• Assist in designing enhancements to reports and dashboards.
• Learn and utilize various tools with mentors to develop advanced skills.
• Provide frontline support on data-related questions or issues.
• Improve operational efficiency with data.

Skills

SQL

Data analysis

Interpersonal skills

Communication

Education

Bachelor’s Degree preferred in analytical/technical major

Tools

Snowflake

Teradata

Microsoft SQL Server

Oracle

SSRS

PowerBI

Tableau

Python

GitHub

Job description

What you will do

Conduct root cause analysis, solving basic to complex data challenges
Leverage a variety of systems and databases to retrieve data
Become a subject matter expert in system data and leverage that knowledge to identify critical data elements, translating those into key business metrics
Maintain existing business reporting and monitoring dashboards for all areas of CAF to support the business in driving execution and managing performance
Assist in the design and development of enhancements to reports and dashboards to transform the way CAF interacts with data
Learn and utilize different tools, processes, and services, and work with mentors and peers to developed advanced technical and analytical skills
Provide front line support on system’s data related questions or issues
Optimize operational efficiency with data

Qualifications and Requirements

• Bachelor’s Degree preferred, in an analytical or technical major
• 1-3 years of experience in an analytical or technical role
• Excellent verbal, written, and interpersonal skills
• Experience required in SQL and DBMS technology; Snowflake preferred; Teradata, Microsoft SQL Server, Oracle, or other major data application acceptable
• Experience preferred in: SSRS/PowerBI Tableau Python GitHub or other version control software

Work Location And Arrangement

• This role will be based out of Atlanta, GA CarMax Auto Finance Office (Kennesaw, GA). Associates will work onsite 4 days per week.
• This role will be based out of the CarMax Home Office (Richmond, VA) and associates will work onsite 4 days per week

Work Authorization

Applicants must be currently authorized to work in the United States on a full-time basis. Sponsorship will not be considered for this specific role

About CarMax

CarMax disrupted the auto industry by delivering the honest, transparent and high-integrity experience customers want and deserve. This innovative thinking around the way cars are bought and sold has helped us become the nation’s largest retailer of used cars, with over 200 locations nationwide. Our amazing team of more than 25,000 associates work together to deliver iconic customer experiences. Along the way, we help every associate grow their career and achieve their best, at work and in their community. We are recognized for our commitment to training and diversity and are one of the FORTUNE 100 Best Companies to Work For®.

CarMax is an equal opportunity employer, and all qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, protected veteran status, disability status, or any other characteristic protected by law.

The annual salary for this position is: $68,300.00 - $102,500.00 May be eligible for bonus and equity.

Benefits

• Except as otherwise required by state law, CarMax Associates are entitled to the following paid sick, vacation, and holiday time.
• Associates that are considered full-time hourly or commission/incentive eligible: To earn up to 48 hours of sick time per year accrued on a per pay period basis and between 80 hours and 200 hours per year of vacation time after a 90 day waiting period depending on years of continuous service with the Company.
• For 8 hours of pay for each of a total of 6 paid scheduled holidays per year plus 1 floating holiday. If such an Associate does work on a scheduled holiday due to business need, they are eligible for Holiday Premium Pay.
• Associates considered full-time salaried are entitled to paid time away with no specified limit as needed for sick, vacation, bereavement, jury duty, holidays, floating holiday, etc. subject to manager approval.
• CarMax will consider reasonable accommodation to complete the CarMax Job Application.