Strategic Analyst, Revenue Operations

Openlane; Canada; On-site; CAD 95,000 - 115,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

RRSP/401K with company match

Paid vacation and sick time

Tuition reimbursement

Job summary

OPENLANE is seeking a Strategic Analyst to bridge data architecture and business strategy within Revenue Operations. You’ll transform complex data into insights guiding growth, efficiency, and predictability across Sales, Marketing, and Customer Success.

You will build robust data models in Snowflake, create real-time dashboards in Looker, and collaborate with Product, Sales, and Data Engineering to optimize the lead-to-revenue lifecycle.

Qualifications

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

Responsibilities

• Strategic Business Insights: Partner with RevOps leadership to identify growth opportunities and bottlenecks.
• Data Modeling & Synthesis: Query large-scale datasets in Snowflake to build robust data models for revenue metrics.
• Operational Excellence: Utilize Google Sheets and Pivot Tables for ad-hoc analysis and financial modeling.
• Cross-Functional Collaboration: Advise department heads on territory planning, quota setting, and marketing attribution.
• Data Integrity: Maintain data hygiene across revenue tech stack and resolve discrepancies.
• Advanced Visualization: Design and maintain executive dashboards in Looker.

Skills

Strategic thinking

SQL (advanced)

Data visualization

ETL/ELT development

Python/JavaScript/Java/Scala

Data modeling

Looker LookML

Domo

Excel/Google Sheets

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 Are:

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

OPENLANE makes wholesale easy so our customers can be more successful. Our end-to-end platform serves the remarketing needs of the world’s largest OEMs, dealers, fleet operators, rental companies and financial institutions. We’re a technology company delivering next generation tools to accelerate and simplify remarketing. We’re an analytics company leveraging data to inform and empower our customers with clear, actionable insights. And we’re an auction company powering the world’s most advanced digital used vehicle marketplaces. In 2021, OPENLANE sold nearly 2.6 million vehicles valued at over $40 billion through our auctions and generated approximately $2.3 billion in revenue. Our integrated digital marketplaces and vehicle logistics centers reduce risk, improve transparency and streamline the experience for customers in about 75 countries. OPENLANE continues to make investments in innovation, strategic acquisitions and integrations to better serve our customers. Headquartered in Carmel, Indiana, OPENLANE has about 5,000 employees and maintains business units across North America, Europe, the Philippines and Uruguay. Together, the OPENLANE brands provide a complete remarketing solution for our customers.

California Residents: Click here to learn more about the personal information we collect in the application process. Also, click here for how we adhere to the California Fair Chance Act. Canadian Residents: Click here to learn more about how we adhere to the provincial Human Rights Codes and any accessibility and/or disability legislation

OPENLANE is an equal opportunity employer and a drug-free workplace.