Analytics Engineer – Data Modeling & Migration - Jobs in Vancouver (or remote), British Columbia, V5V2A5

Job Description

Job Title: Analytics Engineer – Data Modelingamp; MigrationLocation: Remote (Canada)Department: Dataamp; AnalyticsReports To: Manager, Data Integrationamp; ArchitectureMogo 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 CADWhat You’ll Doamp; Key Responsibilities: 1. 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.

2. Data Engineeringamp; Migration (50%)

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

3. Cultureamp; High Performance

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

What you will bring:

• 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#LI-Remote
• Comprehensive Health and Wellness - Access medical, dental, and vision coverage plus a Health Spending Account
• Stock Options - Have a stake in the company #39;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 #39;s equitable so that all can prosper. One that #39;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