Data Engineer II

The Data Engineer II - Advertising and Operations role is responsible for creating and maintaining high quality business critical datasets, enabling Analytics teams and other peer teams within the Cox Retail Consumer Solutions to perform and scale their work.

This position reports to Director, Data Science Advertising & Operations and will work in partnership directly with Sales and other Analytics peer groups to understand client business issues, to creatively evaluate the Cox Automotive Retail Consumer solutions/programs designed to address those issues, provide analytics and insights at scale to optimize those solutions/programs.

• Manages the extraction, analysis and interpretation of site traffic, industry and/or survey data using sophisticated data methods, exploration, analysis, and visualization tools.
• Responsible for creation and maintenance of high-quality business critical datasets and dashboard friendly tables in Snowflake providing data pipelining as a service to enable other analytics professionals in the department
• Create reliable automated data solutions based on the identification, collection and evaluation of business requirements. Including but not limited to data models, database objects, stored procedures and views.
• Partners with senior marketing, business and sales stakeholders to help optimize on our core business and campaign KPIs
• Designs, conducts and leads complex analyses that mine, extract, track, report and analyze performance metrics and other data source systems and summarize findings
• Leads the development and creation of new KPIs/Reports/Dashboards by leveraging existing and incorporating the use of new datasets and analytics platforms
• Partners with key stakeholders and cross-functional peers to formulate plan and execute solutions for analytic needs of the client and internal Sales partners
• Manages the development of unique innovative analyses and methodologies that will help support Cox Automotive client revenue goals
• Creates queries and basic statistical analysis (SQL, R, Studio etc.) to develop analyses in response to inquiries from internal customers and partners.
• Leverages the latest state-of-the-art data mining tools and modeling techniques while staying abreast of industry-wide best practices.
• Collaborates with different departments and defines requirements to improve our reporting suite
• Other duties as needed or required

Qualifications:

• Where permitted by applicable law, must be fully vaccinated against COVID-19 to be considered for this U.S. based job. (Reasonable accommodations for medical and religious objections will be considered.)
• Bachelors degree in computer science, data science, analytics or marketing analytics and 3 years of experience with data engineering and business analytics, with 2 years of experience in digital marketing analytics or an equivalent combination of education and work-related experience

Preferred Qualifications:

• Automotive industry experience
• Ability to translate vague questions into specific data analysis
• Self-motivated, with the ability to deliver consistently on time and in scope.
• Experience successfully collaborating on complex analytics projects involving a matrix of cross-functional teams
• Strong organizational skills and the ability to effectively multi-task and prioritize in a deadline-driven atmosphere.
• Excellent communication and presentation skills with an ability to synthesize complex analyses to senior audiences - internal and external
• Must be able to understand, analyze data, and synthesize large volumes of data into a coherent narrative or story to answer non-standard/complex questions.
• Knowledge of marketing strategies: digital trends, social media, and both direct and programmatic media buying.
• Ability to performance basic statistical analysis (descriptive, variance, regression, probability, etc.)
• Strong data wrangling and data mining skills using R and/or Python
• Advanced SQL experience and strong knowledge of data warehousing and data lakes architecture & design (e.g. Snowflake, Hadoop, Hive, Google BigQuery and/or AWS Redshift, etc.)
• Intermediate level skill and experience with business intelligence & data visualization systems (e.g. MicroStrategy, Microsoft Power BI, Google Data Studio and/or Tableau)
• Intermediate experience with web / digital analysis and related software preferred (e.g., Adobe Analytics / Omniture and Google Analytics)
• Intermediate experience in data visualizations, often generated through BI tools like Tableau, Microsoft Power BI or MicroStrategy
  

Who We Are

About Cox Automotive

Theres nothing ordinary about Cox Automotive. We are people of every background driven by our passion for mobility, innovation, client success and community outreach. We make buying, selling and owning (or simply using) cars easier for everyone. Touching more than 40,000 clients across five continents, we bring together the best brands and the best teams to propel the automotive industry forward. Some of those team members work for our iconic consumer brands like Autotrader and Kelley Blue Book, while others are creating the future of automotive at industry-facing brands like Dealer.com, Manheim and vAuto.

About Cox

We are the Cox family of businesses. Weve been making our mark since 1898 by building and evolving world-class businesses, staying true to our values, and encouraging top talent to always look for growth and impact while building a career with us. Our primary divisions - Cox Communications and Cox Automotive - are driving a new wave of innovation, powering smart cities with powerhouse broadband communications and pioneering greener, more progressive transportation alternatives for individuals and fleet operators. Were also expanding into new spaces like cleantech and healthcare to rev up our momentum toward building a better future for the next generation. Were looking for the talent today who will be our leaders tomorrow. Sound intriguing? Learn more about where we are today, where we hope youll be going with us, and the common purpose that unites us at coxenterprises.com.

Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page.

Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individuals age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.

Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.