Senior Data Analyst

Company

Cox Automotive - USA

Job Family Group

Data Intelligence & Science

Job Profile

Business Intelligence Sr Analyst

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

Compensation

Compensation includes a base salary of $87,200.00 - $130,800.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.

Job Description

Senior Data Analyst will use a variety of data platforms, data sources, and BI tools to develop and communicate meaningful business insights to various internal stakeholders including the Financial Planning and Executive Leadership teams.  We are looking for a hard-working and creative problem solver to join our dynamic team of analysts.  Senior Data Analyst will work collaboratively with team members owning various stages of the data modeling process to iterate on and strengthen our data modeling and analytics capabilities.   Subject matter will be initially focused on sales, financial performance, and client segmentation.  A major focus of this position is the development and distribution of complex enterprise scale reporting through use of queries, BI tools and excel.  As an analytic SME, Senior Data Analyst will perform the analysis of key questions, sales performance scenarios, hypothesis development and testing, and modeling of recommended solutions. They may also interact with and communicate finding/recommendations/results to senior business leaders on behalf of the team.

WHAT YOU'LL DO

Responsibilities

• Develop, manage and maintain complex SQL views in the Finance Snowflake database to extract required information for reporting.
• Collaborate closely with members of the Sales Finance and Engineering teams to develop and maintain actionable data models.
• Develop and maintain KPI reporting, ad hoc analysis, and dynamic self-service user reports and dashboards with a focus on sales financial performance. 
• Participate in stakeholder meetings to understand user needs and capture development requirements.  Work iteratively with stakeholders to improve and expand existing modeling and reporting capabilities.
• Champion data quality, accuracy, usability and reliability by documenting and applying best practices in development and implementation.
• Create useful documentation, lead hands-on training, and support general understanding and usage by internal data stakeholders and governed data models.
• Develop creative solutions to automate manual processes. 

WHO YOU ARE

Qualifications

• Bachelor’s degree in Business, Mathematics, Statistics, Computer Science, Economics, or related field and 4 years related experience. A minimum of 8 years combined education and experience is required without a degree.
• Be a self-starter - work independently with minimal direction or oversight.
• Excel in a fast-paced, high-pressure environment where speed and quality are paramount.
• 4+ years of experience querying databases and working with large data sets. 
• 3+ years of advanced data modeling and SQL coding experience. 
• 3+ years of analytics experience developing insights using Business Intelligence tools/platforms.
• Strong working knowledge of Microsoft Excel including logical calculations.
• Excellent communication skills, including the ability to clearly and effectively communicate analysis findings to stakeholders at all levels.
• Produce high-quality work that is accurate, insightful, and actionable with attention to detail.

Preferred:

• Experience with Snowflake and DBT

Drug Testing

To be employed in this role, you’ll need to clear a pre-employment drug test. Cox Automotive does not currently administer a pre-employment drug test for marijuana for this position. However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.

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 additiona