BI Engineer

BLC BACKLOTCARS Inc; Carmel (IN); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, and vision benefits

Employer 401K with match

Paid vacation and sick time

Parental leave

Job summary

OPENLANE in Carmel, Indiana is seeking a Business Intelligence Engineer who is proactive and data-driven. You will lead initiatives, maintain data flow, build scalable models, and partner with product, sales, and operations to inform decisions.

The role requires 2+ years in BI and data warehousing, deep SQL, ETL/ELT, data visualization (DOMO preferred), and scripting languages. You will mentor teammates and help scale analytics across a global organization.

Qualifications

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

Responsibilities

• Own the BI domain, surface insights, and drive data-driven decisions.
• Partner with product, sales, and operations to ensure data quality and availability.
• Transform large datasets using SQL and scripting to generate insights.
• Design, execute, and analyze A/B tests and experiments to optimize strategies.
• Apply data science fundamentals to build predictive models and trend analyses.
• Develop scalable data models, dashboards, and reports using tools like Domo.
• Continuously improve data pipelines, infrastructure, and analytics capabilities.
• Mentor colleagues to foster a data-driven culture.

Skills

BI

SQL

Data Warehousing

ETL/ELT

Data Modeling

Visualization

Python/Script

Tools

Snowflake

Redshift

Oracle

SQL Server

DOMO

Looker

Job description

Who We Are

At OPENLANE we make wholesale easy so our customers can be more successful. We’re a technology company building the world’s most advanced—and uncomplicated—digital marketplace for used vehicles. We’re a data company helping customers buy and sell smarter with clear, actionable insights they can understand and use. And we’re an innovation company accelerating the future of wholesale remarketing through curiosity, collaboration, and an entrepreneurial spirit.

Our Values: Driven Waybuilders. We pursue challenges that inspire us to build, create, and innovate. Relentless Curiosity. We seek to understand and improve our customers’ experience. Smart Risk-Taking. We transform risk into progress through data, experience, and intuition. Fearless Ownership. We deliver what we promise and learn along the way.

We’re Looking For

We are seeking a Business Intelligence Engineer who is solutions-oriented, proactive, and thrives in ambiguity. This individual will not simply respond to requests but will lead initiatives, identify opportunities, and use data to unlock business growth. You will play a key role in maintaining data flow across systems, building scalable data models, and partnering across teams to inform decision-making. The ideal candidate will have 2+ years of experience in Business Intelligence and Data Warehousing, with deep expertise in SQL, data pipelines, visualization tools, and cloud-based data architecture.

You Are

Proactive. You take full ownership of your domain and drive action independently. Insightful. You generate meaningful, data-driven insights that fuel decision-making. Collaborative. You work closely with cross-functional stakeholders to solve complex problems and improve processes. Technical. You have a strong command of data engineering, visualization, and analytical tools.

You Will

• Take ownership of the Business Intelligence domain, 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 impactful 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

Who You Will Work With

This role reports into Director of Performance Optimization Analytics of the and collaborates cross-functionally with Product, Sales, Operations, and Data Engineering teams. You will also work closely with senior leadership to support key strategic initiatives.

Must Have’s

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

Nice to Have’s

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

What We Offer

• Competitive pay
• Medical, dental, and vision benefits with employer HSA contributions (US) and FSA options (US)
• Immediately vested 401K (US) or RRSP (Canada) with company match
• Paid Vacation, Personal, and Sick Time
• Paid maternity and paternity leave (US)
• Employer-paid short-term disability, long-term disability, life insurance, and AD&D (US)
• Robust Employee Assistance Program
• Employer paid Leap into Service Day to volunteer
• Tuition Reimbursement for eligible programs
• Opportunities to expand your skill set and share your knowledge across a publicly traded, global organization
• Company culture of internal promotions, diverse career paths, and meaningful advancement

OPENLANE makes wholesale easy so our customers can be more successful. Our end-to-end platform serves the remarketing needs of the world’s largest OEMs, dealers, fleet operators, rental companies and financial institutions. We’re a technology company delivering next generation tools to accelerate and simplify remarketing. We’re an analytics company leveraging data to inform and empower our customers with clear, actionable insights. And we’re an auction company powering the world’s most advanced digital used vehicle marketplaces. In 2021, OPENLANE sold nearly 2.6 million vehicles valued at over $40 billion through our auctions and generated approximately $2.3 billion in revenue. Our integrated digital marketplaces and vehicle logistics centers reduce risk, improve transparency and streamline the experience for customers in about 75 countries. OPENLANE continues to make investments in innovation, strategic acquisitions and integrations to better serve our customers. Headquartered in Carmel, Indiana, OPENLANE has about 5,000 employees and maintains business units across North America, Europe, the Philippines and Uruguay. Together, the OPENLANE brands provide a complete remarketing solution for our customers.

OPENLANE is an equal opportunity employer and a drug-free workplace.