Lead Business Intelligence Engineer

Role Overview

We are looking for a talented and motivated Lead Business Intelligence Engineer to join our Enterprise Business Intelligence and Insights team. In this role, you will help transform complex data into meaningful, actionable insights that drive business decisions. You will lead the design and development of advanced data solutions, including impactful visualizations, dashboards, and self-service analytics tools, to empower stakeholders across the organization.

What You Will Do

Build analytics tools that utilize the data pipeline to provide actionable insight into customer acquisition, operational efficiency and other key business performance metrics. Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs.

Why It Might Be a Fit

The ideal candidate is a strategic thinker with strong technical and analytical skills, capable of understanding business challenges and developing both quantitative and qualitative solutions. The candidate must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.

Requirements

• Educational background in Computer Science or Engineering, Math, Statistics, Informatics, Information Systems or another quantitative field.
• 5+ years of experience in BI Engineering, including leading BI projects as a technical lead, with hands-on responsibility for guiding developers and stakeholders through the design, deployment, and ongoing management of BI projects that drive data-informed decision-making.
• 3+ years Experience with Microsoft Power BI, SSRS or similar analytical and reporting tools.
• Ability to design, develop, and maintain logical and physical dimensional data models (star schemas, snowflake schemas) for analytical workloads
• Strong Computer programming skills: SQL and Python
• Experience with relational SQL databases: MS SQL Server, Snowflake or equivalent.
• Experience with ETL Services: SSIS, Azure Data Factory, DBT or equivalent
• Experience with project management and collaboration tools such as Jira, Confluence, etc.
• Experience designing, building and optimizing scalable data pipelines and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Strong project management and organizational skills.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Intellectual curiosity to find new and unusual ways of how to solve data management issues.

Benefits

• Competitive compensation
• 401k matching
• Insurance plans (health, dental, vision)
• Maternity benefits
• Associate purchase and discount programs for new and pre-owned vehicles, services, parts, collision, accessories, and AutoGear
• Access to amazing deals and discounts through YouDecide, a website with offers from top providers and retailers
• Opportunity to participate in DRV PNK mission to raise and donate millions of dollars to cancer research and treatment