4 Database Management jobs in Canada

Job Description

Job Description

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:

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

**Description**
Do you want to be at the forefront of insurance industry innovation and leadership? Do you want to partner with insurers across North America to help deliver cutting-edge capabilities across their organizations? Do you want to work with the original Insurtech, driving performance improvement through our technology? If so, this might be the opportunity for you!
WTW is looking for an experienced P&C data scientist in the North American market with predictive modeling and advanced analytics experience to join as a Property & Casualty (P&C) Associate Director in our Insurance Consulting and Technology (ICT) practice. In this role, you will collaborate with our team of pricing, portfolio management, underwriting, finance and claims experts to design and implement cutting-edge solutions to challenges faced by the top insurers.
ICT provides a powerful combination of advisory services for insurance companies, integrated with leading-edge technology solutions and software, all underpinned by unparalleled analytical capability. WTW has ambitious growth plans for our North America P&C propositions. Our goal is to substantially increase our footprint as we advise our insurance clients, with analytics and data science being a clear enabler of transformation throughout their organizations.
This position can be based in a major North American market and is open to remote/virtual work.
Note that visa employment-based non-immigrant visa sponsorship and/or assistance is not offered for this specific job opportunity.
**The Responsibilities**
+ Develop integrated consulting and technology solutions for our clients
+ Combine extensive knowledge of data science market practice in an insurance context and innovation to build robust analytics processes that deliver insights to decision makers at the point of decision making
+ Develop and implement data strategies for clients
+ Design, build, test and run data science processes for clients
+ Design data science technology infrastructures for clients' analytical and operational functions
+ Build effective predictive models, analytical tools and processes using a wide range of analytical and data science techniques
+ Meet billable hour target and revenue goals, operating as a highly respected and effective consultant
+ Prepare proposals and presentations leveraging marketing resources, practice groups, subject matter experts and client relationship managers for existing clients
+ Serve as a mentor and project manager to more junior colleagues, training them on both the technical and theoretical aspects of insurance as well as project delivery methods
+ Contribute to the development of WTW's intellectual capital and future proposition development, including go-to-market strategy
**Qualifications**
**The Requirements**
+ At least 5 years P&C insurance experience
+ At least 3 years predictive modeling experience
+ Experience working on a data science or analytics team at an insurance company or consulting firm
+ Strong analytical skills including ability to draw conclusions and identify trends from data in a logical, systematic way
+ Solid experience with data manipulation
+ An understanding of machine learning and statistical theory
+ An understanding of how to utilize technology to optimize outcomes within an organization
+ Awareness of main data enrichment sources and open source data assets most valuable to insurance companies
+ Awareness of Insurtech activities in this space
+ Capable of leveraging past experience and expertise to adapt to current projects and challenges outside of core skill set
+ Comfortable navigating ambiguity and developing innovative solutions
+ Committed to training and mentoring less experienced colleagues
+ Practiced in managing complex projects and delegating work to senior and junior colleagues
+ Available to travel as needed
**Nice to Haves**
+ Experience with Radar software
+ Experience leading or participating on actuarial or underwriting transformation projects
+ Knowledge of North American insurance marketplace and carriers
+ Professional designation such as CSPA or ACAS
**This position will remain posted for a minimum of three business days from the date posted or until a sufficient/appropriate candidate slate has been identified.**
**Compensation and Benefits**
Base salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for revenue generation (Producer roles only).
**Compensation**
The base salary compensation range being offered for this role is $150,000 - $230,000 USD per year. This role is also eligible for an annual short-term incentive bonus.
**Company Benefits**
WTW provides a competitive benefit package which includes the following (eligibility requirements apply):
+ **Health and Welfare Benefits:** Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Group Accident, Group Critical Illness, Life Insurance, AD&D, Group Legal, Identify Theft Protection, Wellbeing Program and Work/Life Resources (including Employee Assistance Program)
+ **Leave Benefits:** Paid Holidays, Annual Paid Time Off (includes paid state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off ( **Retirement Benefits:** Contributory Pension Plan and Savings Plan (401k). All Level 38 and more senior roles may also be eligible for non-qualified Deferred Compensation and Deferred Savings Plans.
_Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles County Fair Chance Ordinance for Employers, we will consider for employment qualified applicants with arrest and conviction records._
At WTW, we trust you to know your work and the people, tools and environment you need to be successful. The majority of our colleagues work in a "hybrid" style, with a mix of remote, in-person and in-office interactions dependent on the needs of the team, role and clients. Our flexibility is rooted in trust and "hybrid" is not a one-size-fits-all solution.
We understand flexibility is key to supporting an inclusive and diverse workforce and so we encourage requests for all types of flexible working as well as location-based arrangements. Please speak to your recruiter to discuss more.
**EOE, including disability/vets**