BI Engineer

Socket.dev

Toronto

On-site

CAD 110,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, dental, and vision benefits

RRSP/401K

Paid vacation and personal time

Job summary

OPENLANE is seeking a Business Intelligence Engineer who champions data-driven decisions and owns end-to-end data initiatives. You will maintain data flow across systems, build scalable models, and collaborate with product, sales, and operations to unlock growth.

Designed dashboards and reports in Domo, mentored teammates, and partnered across teams to optimize strategies through rigorous analysis and governance.

Qualifications

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

Responsibilities

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

Skills

SQL

Data Warehousing

ETL/ELT

Data Visualization

Domo

Data Modeling

Python

JavaScript

Cloud Architecture

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