Lead Business Intelligence Engineer

Lead Business Intelligence Engineer

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.

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. Success in this role requires a blend of technical expertise, business acumen, and strong communication skills, as well as the ability to adapt and deliver results in a fast-paced, dynamic environment. This position is remote.

This role is remote, with the option to work in a hybrid capacity if you are located near one of our offices in NYC, FLL, or TX.

Job Responsibilities

This role follows a hybrid schedule, with work both onsite and remotely, based out of our White Plains, NY office.

• 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 including the Executive, Product, Marketing, Data, Engineering and Operations teams to assist with data-related technical issues and support their data infrastructure needs.
• Collaborate and create data tools for analytics and data science team members that assist them in building and optimizing our product into an innovative industry leader.
• Create, maintain and enhance dashboards, reports and other visualizations for stakeholders.
• Tightly collaborate with Product and Engineering teams on project planning and design processes.
• Anticipates the impact on the business of any changes to existing systems and advises internal customers as appropriate.
• Formulates options, including assessing their relative merits and risks, and works to determine the best solution.

You Should Have

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.

Exciting Benefits and Perks Await You:

• Competitive compensation and 401k matching
• Enjoy a healthy work-life balance with insurance plans (health, dental, vision) and maternity benefits.
• Associate purchase and discount programs for new and pre-owned vehicles, services, parts, collision, accessories, and AutoGear
• Access amazing deals and discounts through YouDecide, a website with offers from top providers and retailers
• Join our DRVPNK mission to raise and donate millions of dollars to cancer research and treatment, partnering with cancer charities nationwide

AutoNation is one of the largest automotive retailers in the United States, offering innovative products, exceptional services, and comprehensive solutions, empowering our customers to make the best decisions for their needs. With a network of dealerships nationwide strengthened by a recognized brand, we offer a wide variety of new and used vehicles, customer financing, parts, and provide expert maintenance and repair services. Through DRV PNK, we have raised over $40 million for cancer-related causes, demonstrating our commitment to making a positive difference in the lives of our Associates, Customers, and the communities we serve.

AutoNation is committed to creating a diverse, equitable, and inclusive environment in our workplace and the services we provide. We welcome candidates from all backgrounds who are passionate about making a positive impact. Even if you do not meet every requirement, we encourage you to apply. Join our team and help us foster a culture of belonging while contributing to our revolutionary work in the automotive industry. We value innovation, teamwork, and a commitment to making a positive impact in the world.