Sr. Business Intelligence Engineer

The Sr. Business Intelligence 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 Data Engineering 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 will be used to inform and drive data-driven decisions by internal stakeholders and external clients.

What You’ll Do

Responsibilities

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. 
• Up to 5% travel required. 
• Other duties as needed or required. 

Who You Are 

Minimum

• BA/BS in a related discipline or an equivalent combination of education and work-related experience required.   
•  4+ years of performing analysis and building data processes preferred experience with the Automotive industry highly desired  
• Expertise in writing SQL queries from scratch or altering existing code.  
• Must have working experience using Power BI or Tableau   
• Experience with Snowflake is a plus  
• Working experience in building data warehouse ETL tools, Alteryx, and Informatica is preferred.   
• Experience solving business problems using advanced quantitative methods or statistical models (clustering, regression, ANOVA, etc.) preferred.  
• Strong analytical mindset - masterful with Excel and experienced in analyzing performance and sales data to draw conclusions and make recommendations.  
• Desired to have Automotive experience and understanding of Dealer and Consumer Metrics and Analytics  
• Excellent written and verbal communication skills  
• Self-directed, driven, and enthusiastic  
• Strong teambuilding skills with demonstrated problem-solving abilities  
• Require physical ability and mental acuity to successfully execute the position's duties within required timeframes to meet business requirements. 

What’s In It For You 

Here’s a sneak peek of the benefits at your disposal as a Cox employee:​​

• A competitive salary and top-notch bonus/incentive plans. ​
• Exceptional work-life balance, flexible time-off policies and accommodating work schedules. ​
• Comprehensive healthcare, with multiple options for individuals and families. ​
• Generous 401(k) retirement plans with up to 8% company match. ​
• Mental health support, including counseling and access to virtual wellness resources such as CALM.
• Access to Care.com, with up to 10 days of subsidized care for children, seniors and pets.

​

Check out all our benefits. ​