BI Analyst (Remote)
US - IN - Carmel (OPENLANE)
Full Time Entry-level / Junior USD 65K - 90K
OPENLANE
Dealers’ preferred US marketplace for used vehicles. Wholesale made easy with better outcomes, the inventory you need and lowest fees.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
Annual Salary: $65,000.00 - $90,000.00(Depending on experience, skill set, qualifications, and other relevant factors.)
Tags: Business Intelligence Data analysis Data management Data visualization Engineering Snowflake SQL Tableau Unstructured data
Perks/benefits: 401(k) matching Career development Competitive pay Equity / stock options Health care Insurance Medical leave Parental leave
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.