Product Insights Analyst

Role Overview

• Own analytics for one of our core Orion product areas across Intelligent Investing, Orion’s wealth product, and Mogo, Orion’s lending product.
• Help the business understand customer behavior, product performance, funnel health, engagement, retention, risk, and operational friction.
• Analyze customer journeys across acquisition, onboarding, application flows, activation, funding, product usage, engagement, repayment, retention, support friction, and long-term customer behavior.
• Connect customer data, product behavior, survey feedback, engagement signals, marketing data, financial data, risk data, and operational data into a unified view of what is happening.
• Build datasets, dashboards, and definitions that become part of how Orion operates.
• Analyze marketing and funnel performance, including source quality, conversion, activation, retention, and downstream customer value.
• Identify where customers are dropping off, where the product is creating friction, where reporting is misleading, and where business performance is improving or deteriorating.
• Help teams understand the relationship between customer behavior, product experience, business performance, and long-term outcomes.
• Surface insights, risks, and opportunities before they become obvious.
• Define, standardize, and document KPIs so teams are making decisions from consistent and trusted metrics.
• Translate complex business logic into scalable, reusable data structures that support consistent reporting across teams.
• Use AI aggressively to accelerate analysis, automate manual work, improve documentation, generate analytical workflows, and raise the quality and speed of your outputs.
• Work with Product and Engineering to ensure key customer events, product flows, and business processes are instrumented correctly and available for analysis.
• Develop and maintain SQL to support reporting, analytics, and operational decision-making.
• Design, develop, and maintain semantic data models in Snowflake or similar platforms.
• Contribute to data modernization initiatives, including redesigning existing reporting pipelines and improving analytical datasets.
• Work with Data Engineering and Architecture to ensure analytical datasets are reliable, scalable, governed, and well-documented.
• Apply best practices for testing, monitoring, documentation, and data quality.
• Identify missing, inconsistent, or unreliable data before it becomes embedded in business reporting.
• Support the integration of analytical assets into Orion’s broader data platform.
• Bring ownership, intensity, and a bias toward action. Challenge unclear metrics, weak assumptions, inconsistent definitions, and reporting that does not reflect business reality.
• Operate as a business partner, not a report-builder. Share knowledge and strengthen analytical capability across the team.
• Grow into more complex product analytics, data modeling, platform, and AI-powered analytics work over time.

Requirements

• 3–5 years of experience in Business Intelligence, Data Analytics, Product Analytics, Analytics Engineering, or a related field.
• Strong SQL skills with experience designing analytical data models.
• Strong product analytics instincts, including funnel analysis, segmentation, cohort analysis, customer journey analysis, survey analysis, and behavioral analysis.
• Ability to connect user-level behavior to business outcomes such as conversion, engagement, retention, revenue, repayment, operational efficiency, risk, customer lifetime value, or long-term product performance.
• Experience with Snowflake, Looker, Tableau, Power BI, or similar modern analytics platforms.
• Solid understanding of dimensional modeling, KPI design, and reporting best practices.
• Strong judgment. You can distinguish signal from noise, challenge misleading metrics, and explain what the business should do next.
• Strong judgment on data reliability. You know when a metric is ready to use and when it is not.
• Comfort working with imperfect or evolving data and creating clarity from ambiguity.
• Strong communication skills. You can explain technical concepts clearly to non-technical stakeholders.
• Comfort working directly with Product, Engineering, Finance, Risk, Marketing, Operations, and other business teams.
• Cutting-edge use of AI in your analytical workflow. You use AI daily to move faster, eliminate manual work, improve quality, and increase your personal output.
• A clear point of view on which parts of analytics work should no longer be done manually.

Tech Stack

• SQL
• Tableau

Benefits

• Fully Remote Work
• Unless otherwise specified in the job posting, Orion offers flexible remote work, supported by the tools and resources needed to succeed.
• Comprehensive Health Benefits
• Access to medical, dental, and vision coverage plus a Health Spending Account
• Stock Options
• Meaningful equity participation aligned with long-term value creation and company growth
• Flex Vacation
• Benefit from paid time off, including vacation and personal days
• Wellbeing Programs
• Access counselling services, mental health support, and additional wellness resources