BI Engineer

Openlane; Toronto; On-site; CAD 110,000 - 120,000; Full time

Benefits offered by this job

Competitive pay

Medical, dental, and vision benefits

RRSP/401K with company match

Paid vacation, personal, and sick time

Maternity/Paternity leave

Disability insurance (short/long-term)

Tuition reimbursement

Volunteer day

Career development opportunities

Job summary

OPENLANE is seeking a Business Intelligence Engineer in Ontario to lead data-driven initiatives, build scalable data models, and partner across teams to inform decision-making. You will work with Product, Sales, Operations, and Data Engineering to maintain data quality and unlock growth.

This role requires 2+ years in BI/Data Warehousing, strong SQL, ETL/ELT, and experience with cloud data architectures. Competitive compensation and comprehensive benefits offered.

Qualifications

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

Responsibilities

• Take ownership of BI domain, surface insights, and drive data-driven decisions.
• Partner with product, sales, and operations to ensure data quality and usage.
• Manipulate and transform large datasets using SQL and scripting languages.
• Design and analyze A/B tests and other experiments to optimize strategies.
• Apply data science fundamentals to build predictive models and trends.
• Develop scalable data models, dashboards, and reports (Domo).
• Continuously improve data pipelines, infrastructure, and analytics capabilities.
• Mentor colleagues to foster a data-driven culture.

Skills

BI & Data Warehousing

Advanced SQL

ETL/ELT development

Scripting languages

Data modeling & governance

Data visualization

Excel/Google Sheets

Problem solving

Tools

Snowflake

Redshift

Oracle

SQL Server

Domo

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 the BI Manager 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 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

Compensation Range of Annual Salary:

$110,000.00 - $120,000.00 CAD (Depending on experience, skill set, qualifications, and other relevant factors.)

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.

California Residents: Click here to learn more about the personal information we collect in the application process. Also, click here for how we adhere to the California Fair Chance Act.

Canadian Residents: Click here to learn more about how we adhere to the provincial Human Rights Codes and any accessibility and/or disability legislation

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