Sr BI Engineer

Company

Cox Automotive - USA

Job Family Group

Engineering / Product Development

Job Profile

Sr Data Engineer

Management Level

Individual Contributor

Flexible Work Option

Hybrid - Ability to work remotely part of the week

Travel %

No

Work Shift

Day

Compensation

Compensation includes a base salary of $97,100.00 - $161,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

The Sr Data Engineer will become an integral member of a team focused full-time on driving data-driven decision-making and continuous improvement of the Consumer / Retail solution, a division of Cox Automotive. This role is responsible for providing data and insights for sales to deliver performance-based strategies. This role will serve as an expert in setting up data analytics and supporting teams to develop Business Intelligence solutions to enable sales organization. This role will serve as an expert to influence the growth of the strategic account strategy, optimization, and overall revenue through data-based insight and analyses of activities that occur on Cox Automotive Consumer Solutions platforms and products.   

  

This position interacts with various teams to understand strategic issues and provide information to support business decisions with a customer-focused mindset. You will collaborate and work closely with business users, data engineers, and other cross-functional teams to understand requirements and solution deliverables that drive business growth and efficiency. You will provide business insights that would be used to inform and drive data-driven decisions by internal stakeholders and external clients. 

 Report/Dashboard Design and Development  

• Design and develop intuitive, visually appealing dashboards and reports that meet business needs.   

• Define and implement best practices in data visualization and stay abreast of industry trends while optimizing reporting solutions and processes.   

• Play a critical role in data literacy, which performs an ability to explore, understand, and communicate with data meaningfully to various stakeholders across the Sales organization.    

• Develop and maintain BI solutions based on Microsoft Power BI and Power Platform, such as Automate, to enable data availability and meet stakeholders' requirements.  

Data Gathering, Integration and Validation    

• Collect and integrate data from multiple sources, ensuring quality, completeness, and consistency.   

• Perform data transformations and modeling to prepare data for reporting and analysis.  

• Work with internal and external data providers on data validation, providing feedback, and making customized changes to data feeds and mappings.  

 Metric and Ad-Hoc Solutions  

• Define key performance indicators (KPIs) or OKRs for reporting and dashboard aligning with organization goals.  

• Innovate metrics and leverage advanced analytics techniques to provide in-depth analyses.   

• Support ad-hoc data analysis and customized reporting requests from business stakeholders, delivering timely insights and recommendations.   

• Perform trend analysis and advanced data analytics techniques to support the initiatives.   

 Project Management   

• Understand the organization's day-to-day work and partner with them to design viable data solutions.   

• Recommend improvements to processes, technology, and interfaces that improve the team's effectiveness and reduce technical debt.   

• Effectively communicate with cross-functional teams for projects and task planning and be able to manage projects independently, including timelines, customer interaction, requirements, and others.  

Documentation and Continuous Improvement   

• Document the development process, including data sources, transformations, and visualization techniques.   

• Improve the effectiveness and efficiency of reporting and dashboarding processes, including adopting new technologies, refining existing methods, and incorporating user feedback to enhance their experiences on reports/dashboards.

Minimum Qualification

• Bachelor’s degree in a related discipline and 4 years’ experience in a related field. The right candidate could also have a different combination, such as a master’s degree and 2 years’ experience; a Ph.D. and up to 1 year of experience; or 8 years’ experience in a related field

• Strong team building skills with demonstrated problem-solving abilities  

• Self-directed, driven, and enthusiastic  

• Excellent written and verbal communication skills  

• Desired to have Automotive experience and understanding of Dealer and Consumer Metrics and Analytics  

• Strong analytical mindset - masterful with Excel and experienced in analyzing performance and sales data to draw conclusions and make recommendations.  

• Experience solving business problems using advanced quantitative methods or statistical models (clustering, regression, ANOVA, etc.) preferred.  

• Must have working experience using Power BI or Tableau   

• Expertise in writing SQL queries from scratch or altering existing code.  

Preferred

• Experience with Snowflake is a plus

•  4+ years of performing analysis and building data processes preferred experience with the Automotive industry highly desired   

• 
  

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 additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, parental leave, and COVID-19 vaccination leave.

About Us

Through groundbreaking technology and a commitment to stellar experiences for drivers and dealers alike, Cox Automotive employees are transforming the way the world buys, owns, sells – or simply uses – cars. Cox Automotive employees get to work on iconic consumer brands like Autotrader and Kelley Blue Book and industry-leading dealer-facing companies like vAuto and Manheim, all while enjoying the people-centered atmosphere that is central to our life at Cox. 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 individual’s 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.