BI Engineer

OPENLANE•Carmel, IN

About The Position

OPENLANE is seeking a proactive, solutions-oriented Business Intelligence Engineer who thrives in ambiguity and takes ownership of the BI domain. The role leads initiatives, identifies opportunities, and uses data to support business growth and decision-making. The engineer maintains data flow across systems, builds scalable data models, and partners with teams across the business. The position requires 2+ years of experience in Business Intelligence and Data Warehousing, with expertise in SQL, data pipelines, visualization tools, and cloud-based data architecture. The role reports to the Director of Performance Optimization Analytics and collaborates with Product, Sales, Operations, and Data Engineering teams, as well as senior leadership, to support strategic initiatives.

Requirements

2+ years of experience in Data Warehousing and Business Intelligence.
Advanced SQL skills and experience with relational databases such as Snowflake, Redshift, Oracle, or SQL Server.
Strong experience in ETL/ELT development and data pipeline management.
Proficiency in scripting languages such as Python, JavaScript, Java, or Scala.
Strong foundation in data modeling, governance, and structuring datasets for long-term use.
Expertise in data visualization and dashboarding; Domo is preferred.
Advanced spreadsheet skills in Excel or Google Sheets.
Self-starter with strong problem-solving and strategic thinking capabilities.

Nice To Haves

Experience working with Looker or Domo.
Understanding of cloud-based data architectures and security best practices.
Experience creating and implementing data governance strategies.
Background in data science or machine learning applications.
Familiarity with API integrations and automation techniques.

Responsibilities

Take ownership of the Business Intelligence domain by surfacing insights, solving problems, and driving data-driven decisions.
Partner with stakeholders in Product, Sales, and Operations to ensure data quality, availability, and effective usage.
Manipulate and transform large datasets using SQL and scripting languages to generate business insights.
Design, execute, and analyze A/B tests and other experiments to optimize strategies.
Apply data science fundamentals to build predictive models and trend analyses.
Develop scalable data models, dashboards, and reports using tools such as Domo.
Continuously improve data pipelines, infrastructure, and analytical capabilities.
Mentor colleagues to enhance analytics capabilities and foster a data-driven culture.

Benefits

Competitive pay.
Medical, dental, and vision benefits with employer HSA contributions in the US and FSA options in the US.
Immediately vested 401K in the US or RRSP in Canada with company match.
Paid vacation, personal, and sick time.
Paid maternity and paternity leave in the US.
Employer-paid short-term disability, long-term disability, life insurance, and AD&D in the US.
Robust Employee Assistance Program.
Employer-paid Leap into Service Day to volunteer.
Tuition reimbursement for eligible programs.
Opportunities to expand skills and share knowledge across a publicly traded, global organization.
Company culture of internal promotions, diverse career paths, and meaningful advancement.