BI Engineer

Location: CAN - ON - Toronto (AutoVIN, OPENLANE, TradeRev)

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
• Sound like a match? Apply Now - We can't wait to hear from you!

Compensation Range of

Annual Salary: $110,000.00 - $120,000.00 CAD

(Depending on experience, skill set, qualifications, and other relevant factors.)