Sr. Analyst, CAF Technical Support and Reporting

CarMax•Atlanta, GA

1d•Hybrid

About The Position

The Sr. Analyst, Technical Support and Business Monitoring at CarMax Auto Finance (CAF) reviews, analyzes, and evaluates the most complex Information Technology systems operations tickets to provide application support to CarMax end-users. This support can be either reactive to production problems, systems outages, and immediate business changes; or, this support can be proactive to support planned business objectives. The role will also mentor new or junior support analysts in the performance of their duties and the understanding of the company systems. Additionally, the Senior Analyst, Technical Support and Reporting will provide leadership in the operational reporting and dashboard efforts to ensure that CAF Operations has the information needed to effectively run the business.

Requirements

Bachelors degree in IT related course of study preferred and/or 4+ years of experience in a technical/support role
Microsoft SQL Server scripting and Data models
SQL Transmitter, DB artesian and Teradata
Relational DB Design/Dimensional Modeling
Database Schemas, Data Migration and Scripting
Security and Data Protection, Security Compliance & Data Storage Solutions
Reusable Code and Libraries
Server Side Logic
Authentication/Authorization and Unit Testing
Automated/Performance Testing
Applicants must be currently authorized to work in the United States on a full-time basis.

Responsibilities

Provide business monitoring to all areas of CAF Operations by determining key metrics or data needs, leverage a variety of company systems and databases to obtain data needed, extract needed data using code and translate the key metrics into standardized reports.
Conduct data analysis and evaluate trending information including Service-Now reporting and monitoring.
Lead and/or support the planning, development, testing, implementation, customer reporting, and user support for IT systems applications.
Develop functional specifications and perform functional analysis, module configuration, data conversion, and testing.
Mentor more Junior analysts in their work.
Debug and troubleshoot basic to complex system challenges.
Evaluate the ROI of a request and effectively influence and evaluate to balance the needs of the business and the effort needed to execute on the request.
Perform complex root cause analysis through multiple applications, business scenarios, and identify short & long term solutions.
Interact with business users at CAF and Home Office IT to better understand system issues, causes and contributing factors to assist in determining a resolution to the problem.
Develop a visual reporting framework to help the business have the right tools available.