OPENLANE Logo

OPENLANE

BI Engineer

Posted One Month Ago
Be an Early Applicant
In-Office
Toronto, ON, CAN
Junior
In-Office
Toronto, ON, CAN
Junior
Own the Business Intelligence domain by building scalable data models, dashboards, reports, data pipelines, and actionable insights. Partner with Product, Sales, Operations, Data Engineering, and leadership to improve data quality and decision-making. Transform large datasets using SQL and scripting, conduct experiments, develop predictive models, improve analytical infrastructure, and mentor colleagues.
The summary above was generated by AI

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.)

Similar Jobs

Yesterday
Hybrid
Toronto, ON, CAN
Mid level
Mid level
Fintech • Financial Services
Build and evolve a Microsoft Fabric-based data platform, develop ETL/ELT pipelines, design semantic data models, and deliver optimized Power BI solutions. The role uses SQL, Python, Spark, DAX, and Power Query while supporting automation, CI/CD practices, documentation, and business decision-making. Effective communication in both English and French is required.
Top Skills: SparkAzure Data FactoryAzure DevopsAzure Synapse AnalyticsCi/CdData VaultDaxGitKimball Dimensional ModelingMicrosoft FabricPower BIPower Bi EmbeddedPower Query (M)PythonRow-Level SecuritySQL
Senior level
Financial Services
Designs and maintains enterprise dashboards, reports, scorecards, data models, and analytical solutions using Power BI and SQL. Partners with stakeholders to define KPIs, establish reporting standards, govern data quality, and create a trusted single source of truth. Performs data validation, trend analysis, documentation, testing, release management, troubleshooting, and continuous improvement for operational, workforce, and performance reporting.
Top Skills: Power BISQL
5 Days Ago
In-Office
Guelph, ON, CAN
Junior
Junior
Biotech • Agriculture
Designs, develops, tests, deploys, and supports data pipelines, lakehouses, warehouses, semantic models, Power BI dashboards, and AI-enabled solutions. Integrates data from D365, operational applications, and legacy platforms while maintaining SQL Server, SSIS, and SSAS systems. The role also supports data governance, security, documentation, modernization to Microsoft Fabric, and collaboration with technical and business stakeholders.
Top Skills: AzureCopilot StudioD365Dataflows Gen2DaxEtl/EltMicrosoft FabricOnelakePower BIPower PlatformSQLSQL ServerSsasSsisT-Sql

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account