BI Engineer

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

You will take ownership of the business intelligence domain by building scalable data models and maintaining data flow across systems. You will also partner with cross-functional teams to generate actionable insights and drive data-driven decision-making.

The ideal candidate must have 2+ years of experience in business intelligence and data warehousing with advanced SQL skills. Proficiency in ETL/ELT development, cloud-based data architecture, and scripting languages like Python or Java is required.

• Medical insurance • Dental insurance • Vision insurance • HSA contributions • FSA options • 401K • RRSP • Paid vacation • Paid personal time • Paid sick time • Paid maternity leave • Paid paternity leave • Short-term disability • Long-term disability • Life insurance • AD&D insurance • Employee assistance program • Tuition reimbursement

• Visualisation de donnéesSouhaitée
• SQLSouhaitée
• JavaScriptSouhaitée
• JavaSouhaitée
• PythonSouhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• SQL
• Data warehousing
• Business intelligence
• ETL
• ELT
• Data pipelines
• Python
• JavaScript
• Java
• Scala
• Data modeling
• Domo
• Data visualization
• Cloud architecture
• A/B testing
• Predictive modeling
• Self-Starter
• Pipelines
• Complex Problem Solving
• Google Sheets
• Data Pipeline Management
• Curiosity
• Solution-Oriented
• Snowflake (Data Warehouse)
• Data-Driven Decision Making
• Java (Programming Language)
• JavaScript (Programming Language)
• Application Programming Interface (API)
• Automation
• Business Intelligence
• Dashboard
• Decision Making
• Data Architecture
• Data Engineering
• Dataflow
• Data Governance
• Extract Transform Load (ETL)
• Data Modeling
• Data Quality
• Data Visualization
• Data Warehousing
• Relational Databases
• Data Warehousing And Business Intelligence (DWBI)
• Employee Assistance Programs
• Sales
• Governance
• Leadership
• Scalability
• Innovation
• Problem Solving

• Data & Analytics
• Technology
• Software
• Engineering
• Business Intelligence Engineer
• Data Scientist
• Systems Analysts
• Data Scientists

Expérience minimale

2+ ans

Langue de l’offre

anglais

Heures de travail

40 heures par semaine