Senior Business Intelligence Manager

Role Overview

• Develop SQL queries from scratch to answer client business questions, working within Snowflake and other data warehouse environments
• Analyze media performance and on-site consumer behavior to surface recommendations that drive revenue and improve campaign ROI for OEMs, Tier 2 groups, and Tier 3 dealerships
• Establish innovative approaches to solve complex analytics problems, discovering patterns and trends that yield valuable data-driven insights
• Integrate new data sources proactively to enhance analysis capabilities and deliver differentiated client value
• Own and deliver monthly performance reports and Quarterly Business Reviews (QBRs) that distill complex analyses into clear, concise and actionable narratives for client executives
• Lead weekly meetings with internal stakeholders and external clients to communicate insights, address questions, and align on priorities
• Respond to ad-hoc analysis requests by rapidly developing insights that answer client business questions
• Create and deliver customized challenger sales presentations, program recaps, and solution recommendations with minimal manager support
• Translate technical findings into strategic recommendations that align with client business objectives and Cox Automotive Media capabilities
• Collaborate with Data Science and Engineering teams to define requirements and improve the analytics suite
• Conduct full technical discovery and architect client solutions that address gathered business and technical requirements
• Present optimization opportunities to internal teams and inform them of new product solutions tailored to individual client goals

Requirements

• 8+ years in an analytics-focused role, preferably in digital marketing analytics and web/site analysis
• Bachelor's degree required; Master’s preferred in Analytics, Marketing, Economics, Finance, Statistics, Mathematics, or related quantitative field
• Advanced SQL proficiency: Ability to independently write complex queries to extract, transform, and analyze data in response to ad-hoc client questions
• Intermediate to advanced experience with data warehousing platforms (Snowflake, BigQuery, Redshift, Hadoop/Hive)
• Proficiency with BI and visualization tools (Power BI, Tableau, Google Data Studio, MicroStrategy)
• Ability to perform statistical analysis (descriptive, variance, regression, probability) with general understanding of advanced statistical methods
• Proven ability to condense complex analysis into executive-ready presentations that drive business decisions
• Strong consultative skills with demonstrated ability to influence stakeholders as a subject matter expert
• Experience anticipating stakeholder needs and delivering proactive insights that build thought leadership partnerships
• Excellent organizational skills with ability to manage multiple priorities in a deadline-driven environment

Tech Stack

• Amazon Redshift
• BigQuery
• Hadoop
• SQL
• Tableau

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
• Up to 160 hours of paid wellness annually for their own wellness or that of family members
• Additional paid time off in the form of bereavement leave
• Time off to vote
• Jury duty leave
• Volunteer time off
• Military leave
• Parental leave
• Health care insurance (medical, dental, vision)
• Retirement planning (401(k))
• Paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO)