Analytics Engineer – Data Modeling & Migration

Mogo; Vancouver; Remote; CAD 80,000 - 100,000; Full time

Job summary

Mogo is seeking an Analytics Engineer to work remotely in Canada, focusing on data modeling in Snowflake and contributing to data migration projects. The role blends technical execution with business collaboration, ideal for a mid-senior level professional experienced in Python and data engineering. Attractive benefits include comprehensive health coverage, stock options, and flexible vacation policies.

Benefits

Healthcare coverage

Stock options

Flexible vacation

Wellbeing programs

Qualifications

• 4-7 years experience in data engineering or analytics engineering.
• Experience with Python for ETL workflows.
• Strong proficiency in building data models.

Responsibilities

• Design and maintain semantic data models in Snowflake.
• Support data migration initiatives and ETL pipeline implementations.
• Collaborate with finance teams for KPI definitions and reporting.

Skills

Python

Data Modeling

SQL

Tools

Snowflake

Streamlit

Job description

Job Title: Analytics Engineer – Data Modeling & Migration

Job Title: Analytics Engineer – Data Modeling & Migration

Location: Remote (Canada)

Department: Data & Analytics

Reports To: Manager, Data Integration & Architecture

Mogo is seeking an Analytics Engineer who thrives at the intersection of business understanding and technical execution. In this dual-focus role, you will work closely with stakeholders across the finance business to define and build semantic models in Snowflake, while also contributing to upcoming data migration initiatives that involve rebuilding and modernizing our core Python-based ETL pipelines.

This position is a 50/50 blend of business-facing semantic modeling and production-grade data engineering, offering a unique opportunity to drive both insight accessibility and data infrastructure modernization. You will become the subject matter expert (SME) for Mogo’s core consumer finance products and help shape the next generation of AI-powered analytics at Mogo.

Base salary for this role: $80,000 - $100,000 CAD

What You’ll Do & Key Responsibilities:2. Data Engineering & Migration (50%)3. Culture & High PerformanceWhat you will bring:

• Business-Facing Semantic Modeling (50%)
• Design and maintain semantic data models in Snowflake to support our products, powering self-service analytics via Cortex Analyst
• Partner with Finance, Product, and Risk teams to define KPIs, translate business logic into reusable data models, and ensure consistent reporting
• Collaborate on the development of an AI-powered chatbot using Streamlit (Python) that answers natural language questions based on semantic models
• Act as the SME for Mogo’s core consumer finance products, ensuring models are well-aligned with business workflows and financial reporting needs
• Support and lead aspects of data migration initiatives by analyzing, redesigning, and implementing production-grade Python ETL pipelines
• Ensure new data pipelines are reliable, scalable, and observable, with appropriate documentation and governance
• Work closely with other teams to integrate ETL pipelines into the broader production environment
• Embody and model Mogo’s high-performance attributes: ownership, collaboration, innovation, speed, and impact
• Share knowledge and best practices across teams to foster data-driven decision-making
• 4–7 years experience in a data engineering, analytics engineering, or hybrid data role
• Strong proficiency in Python for building, testing, and maintaining ETL workflows
• Experience building or maintaining semantic data models in Snowflake or similar platforms
• Strong understanding of SQL, data modeling, and dimensional modeling practices
• Ability to work closely with stakeholders to capture requirements and translate them into robust data structures
• Experience working with AI powered analytics tools or interfaces (e.g., Cortex Analyst, conversational analytics)
• Familiarity with best practices in production-grade ETL deployment: testing, monitoring, observability
  
  

Preferred Qualifications

• Experience with data orchestration tools (e.g., Talend, Airflow)
• Experience with data visualization tools (e.g., Looker)
• Familiarity with financial services, particularly lending, credit risk, or loan servicing
• Experience contributing to data platform modernization or migration initiatives
  
  

What Success Looks Like

• Lending business teams rely on your semantic models for fast, self-serve answers to critical questions
• You have redesigned and deployed reliable Python ETLs that support Mogo’s modern data infrastructure
• You’re known across teams as the go-to expert for our core data and a trusted technical partner in data transformation efforts
  
  

Benefits of working with us:

• ALWAYS FULLY REMOTE WORK - Enjoy the flexibility of remote work, supported by necessary resources
• Comprehensive Health and Wellness - Access medical, dental, and vision coverage plus a Health Spending Account
• Stock Options - Have a stake in the company's success through stock options
• Flex Vacation - Benefit from paid time off, including vacation days, holidays, and personal days
• Wellbeing Programs - Access counselling services, mental health support, and additional wellness resources
  
  

About Us:

We help make it easy for Canadians to achieve financial freedom while making a positive impact.

We live in the most innovative and technologically advanced era, yet so much struggle exists. Most of us are far from where we want to be financially.

We all want a better future. A better world where reaching financial freedom is a question of when, not if. One that's equitable so that all can prosper. One that's safe from the impact of climate change.

Our money has the power to change the world. It’s up to us to do things differently.

Apply today! Do you know anyone who would be a great fit for this role or other roles on our career page? Please share this job posting with them! Mogo is an inclusive place to spend your work life. We hire team members for their talent and diverse backgrounds. Bring your unique perspective to Mogo and help our customers achieve their best financial lives.

Powered by JazzHR

qxKfhILITW

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Internet Publishing

Referrals increase your chances of interviewing at Mogo by 2x

Get notified about new Data Engineer jobs in Vancouver, British Columbia, Canada.

Analytics Engineer - AI & Semantic Modeling

Associate Software Engineer - Remote in Canada

Richmond, British Columbia, Canada 11 hours ago

Python and Kubernetes Software Engineer - Data, AI/ML & Analytics

Freelance Data Analyst (Python) - AI Trainer

Freelance GenAI Developer - Prompt Engineering & Data Workflows

Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics

Full Stack Software Engineer (Geospatial Analytics)

Intermediate Build & Platform Software Engineer (Unreal Engine 5)

Software Engineer III, Fulfillment and Ops

Software Engineer (Python/Linux/Packaging)

Senior Software Engineer, Machine Learning Infrastructure

Graduate Software Engineer, Open Source and Linux, Canonical Ubuntu

Senior Software Engineer, Backend - Fintech

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.