Analytics Engineer - AI & Semantic Modeling

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

Job summary

Join a leading financial technology company as an Analytics Engineer. In this role, you will bridge business needs and data through advanced AI solutions, working with Snowflake to design semantic models and engage with stakeholders to ensure quality insights. Your expertise in data analytics will be crucial for enabling natural language access to analytical tools and supporting effective decision-making processes.

Benefits

Fully remote work

Comprehensive health and wellness coverage

Stock options

Flex vacation

Wellbeing programs

Qualifications

• Experience with Snowflake for semantic modeling and performance tuning.
• Strong grasp of data modeling principles.
• Excellent communication skills for business engagement.

Responsibilities

• Design and maintain business-aligned semantic models in Snowflake.
• Co-develop an AI-powered chatbot that navigates Snowflake models.
• Ensure data quality and usability for business users.

Skills

Data modeling principles

Communication

Stakeholder engagement

Financial products understanding

Education

3–6 years experience in data analytics or engineering

Tools

Snowflake

Cortex Analyst

Looker

Job description

Job Title: Analytics Engineer - AI & Semantic Modeling
Location: Remote (Canada)
Department: Data & Analytics
Reports To: Manager, Data Integration & Architecture
Mogo is seeking an Analytics Engineer with a passion for bridging business and data through AI-powered solutions. You will play a central role in designing and implementing semantic data models in Snowflake, enabling our AI chatbot to answer complex business questions about our products. This is a business-facing role requiring strong communication skills, a deep understanding of financial data, and the ability to model and surface data in an intuitive, AI-ready way.

You will become the subject matter expert (SME) on Mogo’s business data, working closely with stakeholders to translate business logic into scalable semantic layers for Cortex Analyst, while also ensuring the underlying ETLs are understood and aligned with model requirements.

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

What You’ll Do & Key Responsibilities:

AI-Driven Data Access

• Co-develop an AI-powered chatbot that navigates Snowflake semantic models to answer business questions.
• Enable natural language access to analytics through Cortex Analyst, ensuring the semantic layer supports business needs.

Semantic Modeling & Data Abstraction

• Design and maintain business-aligned semantic models in Snowflake
• Serve as the bridge between raw data and self-service analytics, modeling entities, facts, and metrics that align with Mogo’s financial products.

Business Engagement & Domain Expertise

• Partner with stakeholders across different teams to understand KPIs, metrics, and operational context.
• Act as the SME for our business data, ensuring data quality, clarity, and usability for business users and AI tools.
• Proactively identify gaps in data or semantic logic and recommend solutions.

ETL Understanding & Support

• Investigate and document Python-based ETL pipelines that bring raw data into Snowflake.
• Collaborate with the Data Engineering team to ensure semantic models are built on accurate, well-understood foundations.

Culture & 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 Bring:

• 3–6 years experience in a data analytics, analytics engineering, or data engineering role.
• Experience working with Snowflake, including semantic modeling and performance tuning.
• Familiarity with Cortex Analyst or similar natural language-to-SQL platforms.
• Experience working with BI reporting tools in the past, preferably Looker
• Strong grasp of data modeling principles, including entity-relationship modeling, metric layer design, and business logic mapping.
• Deep understanding of financial products, or a strong interest in acquiring this expertise quickly.
• Excellent communication and stakeholder engagement skills.

Preferred Qualifications

• Prior experience in a fintech or financial services environment.
• Exposure to Looker, dbt, or other semantic layer tooling.
• CompetentPythonskills, for supporting light data transformation and automation tasks.

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