Strategic Analyst, Revenue Operations

OPENLANE; Carmel (IN); On-site; USD 69,000 - 83,000; Full time

Benefits offered by this job

Competitive pay

Health benefits

401K / RRSP

Paid time off

Tuition reimbursement

Job summary

OPENLANE is seeking a Strategic Analyst to bridge complex data architecture and actionable business strategy. You will optimize the lead-to-revenue lifecycle across Sales, Marketing, and Customer Success, delivering data-backed insights.

You will partner with RevOps to identify growth opportunities, build data models in Snowflake, and create executive dashboards in Looker and Domo, ensuring real-time, accurate metrics for leadership.

Qualifications

• 5-7+ years in strategic consulting and business analytics.
• Advanced SQL skills with relational databases.
• ETL/ELT development and data pipeline management.
• Data visualization in Looker and Domo.
• Scripting knowledge in Python, JavaScript, Java or Scala.
• Strong data modeling and governance foundations.
• Advanced spreadsheet skills (Excel/Google Sheets).
• Self-starter with strategic thinking and problem solving.

Responsibilities

• Partner with RevOps leadership to identify growth opportunities and bottlenecks.
• Query large-scale datasets in Snowflake to build robust data models.
• Design executive dashboards in Looker and Domo.
• Conduct rapid ad-hoc analyses using Sheets and Pivot Tables.
• Collaborate cross-functionally with Product, Sales, Operations, and Data Engineering.
• Maintain data integrity across revenue systems.

Skills

Strategic thinking

Data visualization

SQL proficiency

ETL/ELT development

Snowflake/Redshift/Oracle/SQL Server

Looker LookML / Domo

Python / JavaScript / Java / Scala

Data modeling & governance

Excel / Google Sheets

Strong problem-solving

Tools

Snowflake

Redshift

Oracle

SQL Server

Looker

Domo

Job description

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 looking for a high-impact Strategic Analyst to join our Revenue Operations team. Reporting directly to the Analytics Manager, you will be the bridge between complex data architecture and actionable business strategy. You will play a critical role in optimizing the lead-to-revenue lifecycle by uncovering insights that drive growth, efficiency, and predictability across Sales, Marketing, and Customer Success.

You Ar e:

• A Strategic Thinker: Ability to see the "big picture" and understand how individual data points impact the overall business strategy.
• A Data Visualization Expert: A keen eye for design and the ability to tell a compelling story through data.
• Rigorously Analytical: Strong attention to detail with the ability to reconcile complex datasets and ensure 100% accuracy.
• Communicative: Capability to present technical findings to non-technical stakeholders in a clear and persuasive manner.

You Will:

• Strategic Business Insights: Partner with RevOps leadership to identify growth opportunities, churn risks, and operational bottlenecks. Translate business questions into analytical frameworks.
• Data Modeling & Synthesis: Query large-scale datasets in Snowflake using advanced SQL to build robust data models that serve as the "single source of truth" for revenue metrics and Domo, ensuring data is intuitive, real-time, and actionable.
• Operational Excellence: Utilize Google Sheets and Pivot Tables for rapid-response ad-hoc analysis, financial modeling, and data validation.
• Cross-Functional Collaboration: Act as a consultant to department heads, providing data-backed recommendations on territory planning, quota setting, and marketing attribution.
• Data Integrity: Ensure high standards of data hygiene across the revenue tech stack, identifying and resolving discrepancies between systems.
• Advanced Visualization: Design and maintain sophisticated executive dashboards in Looker

Who You Will Work With:

This role reports into the Manager of Revenue Operations and Analytics 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:

• 5-7+ years of experience in strategic consulting and business analytics
• 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
• Data visualization experience in Looker (LookML preferred) and Domo
• 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

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: $95,000.00 - $115,000.00 CAD

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