BI Engineer

Openlane; Toronto; Remote; CAD 110,000 - 120,000; Full time

Benefits offered by this job

Medical benefits

RRSP with company match

Paid vacation

Job summary

OPENLANE in Toronto is seeking a Business Intelligence Engineer who will own the BI domain, surface actionable insights, and drive data-driven decisions across product, sales and operations.

You will design scalable data models, pipelines and dashboards using SQL, DOMO and cloud data architectures, mentor teammates, and partner with cross-functional teams to improve data quality and analytics capabilities for the business.

Qualifications

• Minimum 2+ years in Data Warehousing and BI.
• Advanced SQL skills with relational databases.
• Experience with ETL/ELT and data pipelines.
• Experience with data visualization and dashboards (DOMO preferred).

Responsibilities

• Own the BI domain, surface insights, and drive data-driven decisions across product, sales, and operations.
• Partner with stakeholders to ensure data quality and availability for decision-making.
• Design and optimize data models, pipelines, and dashboards for scalable analytics.
• Support and mentor colleagues to enhance analytics capabilities across the organization.

Skills

SQL

Data Warehousing

ETL/ELT

Python

Data Modeling

Domo

Cloud Data Architecture

Analytics

Tools

Snowflake

Redshift

Oracle

SQL Server

DOMO

Excel

Google Sheets

Job description

## BI EngineerApply: Remote: CAN - ON - Toronto (AutoVIN, OPENLANE, TradeRev): Full time: Posted Today: R-254907**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.)