BI Analyst (Remote)

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.

Position Overview

We are seeking a Business Intelligence Analyst to be part of our Global BI team. We work in a fast-paced environment that is hungry for analytics and insights. Our growing business is investing heavily in technology and people, and we want to measure the progress we are making and find new paths forward.  

In this role you will collaborate with business stakeholders to define business outcomes and conduct detailed operational data analysis to build recommendations.  You will acquire data, build models, and turn data into insights, enabling business partners to make informed decisions and break through ambiguity. 

ET/CT Time zone preferred

Responsibilities and Duties:

Data Analysis & Reporting:

• Design, develop, and maintain BI reports and dashboards using DOMO, Snowflake, SQL Server, and Crystal Reports.

• Implement intuitive data visualization solutions for National Accounts and Operations.

• Create and manage client-facing and internal reports, ensuring accuracy, clarity, and relevance.

• Monitor and support the BI reporting infrastructure, including daily, weekly, and monthly reports for clients and internal customers.

• Automating report distribution and improving reporting efficiency.

• Assemble and maintain compelling dashboards with leading indicators and business results metrics across multiple data sources and lead conversations leveraging the tools you create. 

• Leverage SQL to prototype concepts, troubleshoot issues, and explore ad hoc business problems

Collaboration & Solution Design:

• Collaborate with business partners to understand processes, identify areas for improvement, and recommend modern data reporting solutions.

• Work closely with various departments to develop solutions that meet business objectives and improve data-driven decision-making.

• Design and implement solutions for ad hoc requests from client partners and internal customers, guiding the organization in making informed business decisions.

Mentorship & Training:

• Mentor users and peers to improve analytical skill sets across the organization.

• Provide training and support to team members on BI tools, report generation, and data interpretation.

• Conduct training sessions for clients on how to use and interpret BI reports and dashboards.

Data Management:

• Ensure data integrity, accuracy, and consistency across all reports and data sources.

• Manage FTP processes for secure data transfer between systems and external partners.

• Collaborate with IT and data engineering teams to optimize data collection, storage, and retrieval processes.

Client Interaction:

• Act as a liaison between the company and clients, ensuring that their reporting needs are met.

• Present data insights to clients in a clear and concise manner, providing recommendations based on the data.

Required Skills:

• Advanced data visualization using DOMO(Or similar Reporting & Visualization tool) e.g. Crystal /Tableau Reports.

• Strong experience with SQL, preferably with Snowflake and SQL Server.

• Knowledge of efficiency reporting principles and practices.

• Campaigns for data-driven marketing initiatives.

• Understanding of querying efficiency and streamlining reporting processes.

Preferred Skills:

• Strong oral and written communication skills 

• Excellent analytical and problem-solving skills 

• Experience with SQL server databases structures (ex. Tables, BI Reporting DB) 

• Working knowledge of FTP for data transfer and DOMO

• Experience with analyzing data in semi-structured and unstructured data sets. 

• Working knowledge of efficiency in querying and streamline reporting processing time.

• Working knowledge of automation tools to send out reporting to customers. 

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 

Compensation Range of

(Depending on experience, skill set, qualifications, and other relevant factors.)