• Build and maintain ETL/ELT pipelines using APIs, SFTP, and third-party integrations (Salesforce, Zuora, RevenueCat, affiliate platforms, legacy systems) • Extract and transform Salesforce data to support B2B funnel reporting and attribution • Monitor pipelines, troubleshoot issues, resolve errors, and document ETL logic and data models • Validate data and investigate discrepancies across sources and pipelines • Support creation of clean, well-structured datasets for dashboards, campaign tracking, and lifecycle reporting across our cybersecurity brands • Perform data validation and ensure consistency across platforms and reports • Contribute to reusable datasets and maintain data warehouse hygiene • Use key marketing and sales metrics (MRR, funnel stages, LTV, churn) to validate data accuracy

• Partner with Product & Engineering teams to understand their goals and translate them into metrics, reports, and dashboards. • Build reporting products within the application. • Build, maintain, and enhance core business dashboards using Power BI. • Utilize AI to maximize efficiency. • Use SQL and Python to extract, analyze, and transform data to support reporting and ad hoc analysis. • Own the design and documentation of key business metrics, ensuring clarity and consistency across teams. • Proactively identify trends, anomalies, and opportunities in data and share insights with stakeholders. • Collaborate with Data Engineering and Analytics Engineering to ensure data models meet reporting needs and support self-service analytics. • Contribute to the development of team-wide best practices for visualization, dashboard UX, and storytelling with data. • Create training, documentation, and data literacy resources to enable others to access and interpret data effectively. • Participate in sprint planning and help shape the BI roadmap by identifying high-value projects and recurring requests. • Mentor and teach data-savvy stakeholders and serve as a subject matter expert in the BI toolset and analytics best practices.

• Support backend data operations and assist with data integration, quality checks, and operational flows • Build and maintain ETL/ELT pipelines using APIs, SFTP, and third-party integrations • Extract and transform Salesforce data to support B2B funnel reporting and attribution • Monitor pipelines, troubleshoot issues, and document ETL logic and data models • Validate data and investigate discrepancies across sources and pipelines • Contribute to reusable datasets and maintain data warehouse hygiene

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 Director of Performance Optimization Analytics of the 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 or Superset 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!