Senior Data Engineer, Analytics

Rippling, Inc.; Vancouver; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive compensation

Health & Wellness

4 weeks vacation

RRSP matching

Parental leave top-up

Education assistance

Mentorship & growth

Hybrid work model

Job summary

At CMLS Commercial, we seek a data engineer to own the Commercial Analytics data platform in Microsoft Fabric. You will manage data ingestion, modeling, and serving for Power BI reports and internal tools, guiding initiatives from stakeholder discussions to production.

You’ll migrate pipelines to Fabric, validate CI, and contribute to DevOps workflows. You will design ELT pipelines, dimensional models, and semantic layers, while ensuring security, monitoring, and performance as data scales.

Qualifications

• 3+ years of data engineering experience owning production pipelines and data models in a cloud environment.
• Hands-on Microsoft Fabric experience is preferred; familiarity with Synapse/Databricks is a plus.
• Advanced SQL on large relational datasets, including views and performance tuning.
• Experience building datasets for Power BI; understanding DAX and Power Query.
• Python (PySpark or pandas) for ingestion, validation and automation.
• Experience integrating REST APIs with authentication, pagination and rate limits.
• Git-based development and CI/CD, ideally with Azure DevOps.
• Daily use of AI coding tools; ability to ship reliable software.

Responsibilities

• Lead new initiatives end to end: meet stakeholders, design solutions and deliver to production.
• Decide architecture for ingestion, storage, and modeling across lakehouses and warehouses.
• Design and maintain ELT pipelines from SQL Server, Azure SQL, REST APIs and SaaS.
• Build dimensional data models for analytics and reporting.
• Develop Power BI semantic models and read/translate DAX and Power Query logic.
• Implement data validation, monitoring, and alerting to catch issues quickly.
• Optimize queries and pipelines as data grows.
• Manage access control, provisioning and data sharing with teams and partners.
• Document lineage, architecture and data processes; review code and patterns.
• Evaluate Fabric features, run proofs of concept, and propose improvements.

Skills

Data engineering

Microsoft Fabric

SQL

Python

Power BI

Power Query

REST APIs

Git & CI/CD

Azure Data Factory

Cloud data pipelines

Tools

Microsoft Fabric

Azure Data Factory

Synapse/Databricks

Databricks

Power BI

DAX

Power Query

Azure DevOps

Job description

Founded in 1974, CMLS Commercial is one of Canada's largest independently owned commercial mortgage services companies, providing financing solutions to real estate owners, developers, institutional investors, and many of the country's leading financial institutions.

Our expertise spans the full commercial mortgage lifecycle—from origination and underwriting to servicing, securitization, mortgage analytics, and market intelligence. Backed by decades of experience and a reputation for innovation, we help clients navigate complex financing opportunities with confidence.

Nesto Group is Canada's leading provider of mortgage technology and financing solutions, with more than CAD $80 billion in residential and commercial mortgages under administration. Trusted by many of the country's leading financial institutions, we combine over 50 years of mortgage expertise with proprietary cloud and AI technology to transform the future of lending.

Powered by our proprietary cloud and AI technology, nesto has become one of Canada's fastest-growing mortgage lenders, gaining market share across direct-to-consumer (D2C) residential lending, the broker channel, and multi‑family commercial lending. Recognized as Deloitte's Fast 50 companies for three consecutive years, we continue to push the industry forward through innovation, technology, and customer-focused solutions.

Operating through our family of brands— CMLS, nesto, and Nesto Cloud —our mission is to build Canada's mortgage ecosystem of the future and create a true Canadian champion in lending technology and financial services. Learn more at: https://nestogroup.ca/.

Life at CMLS Commercial

At CMLS Commercial, you'll work alongside industry experts on transactions that help shape communities across Canada. Whether you're supporting institutional clients, delivering market insights, or financing landmark developments, you'll be part of a collaborative team where expertise is valued and professional growth is continuous.

About the Role

You’ll own the Commercial Analytics data platform in Microsoft Fabric — how data is ingested, modeled, secured and served across our Power BI reports, client extracts and internal tools. You’ll lead new initiatives from first stakeholder conversation through to production. In your first year, you’ll get up to speed on our pipelines and reporting, help migrate Azure Data Factory pipelines and legacy SSRS reports to Fabric, and add CI validation alongside our existing DevOps pipelines.

Key Responsibilities

• Lead new initiatives end to end: meet directly with stakeholders and clients to gather requirements, design solutions and deliver them to production.
• Make architecture decisions across ingestion, transformation, storage and modeling, including how lakehouses, warehouses, workspaces and environments are organized.
• Design and maintain ELT pipelines from SQL Server, Azure SQL, REST APIs and SaaS platforms, with incremental loads, safe reruns and clear failure handling.
• Design and maintain dimensional data models for analytics and reporting.
• Build the views, stored procedures and curated tables behind our Power BI semantic models, dashboards and internal tools, including reading existing DAX and Power Query and moving logic upstream where it belongs.
• Implement data validation, monitoring, logging and alerting to catch and resolve issues quickly.
• Tune queries and pipelines for performance as data volumes grow.
• Manage access control, database and user provisioning, and data sharing with internal teams and external partners.
• Document lineage, architecture and data processes.
• Review code, share patterns and help set the team's engineering standards.
• Evaluate new Fabric features and tools, run proofs of concept and bring the team improvements worth adopting.

Skills and Qualifications

• 3+ years of data engineering experience, including owning production pipelines and data models in a cloud environment.
• Hands‑on Microsoft Fabric experience is preferred. Strong experience with Azure Data Factory with Synapse or Databricks, or with Databricks on another cloud, is also a great fit.
• Advanced SQL on large relational datasets, including views, stored procedures, performance tuning and incremental and merge patterns.
• Experience building datasets for Power BI, and enough DAX and Power Query to read a semantic model and understand what it does.
• Python (PySpark or pandas) for ingestion, validation and automation.
• Experience integrating REST APIs, including authentication, pagination and rate limits.
• Experience with governance practices such as access control, data security and usage monitoring.
• Git-based development and CI/CD, ideally with Azure DevOps.
• Daily use of AI coding tools, with a clear understanding of everything you ship. Claude Code is strongly preferred.
• Experience leading data projects end to end, from requirements to production.
• Strong communication skills with both technical and non‑technical stakeholders.

Nice to Have

• SSRS experience.
• DBA‑adjacent experience: creating databases, users and permissions, and data masking.
• dbt or a similar transformation framework.
• Experience with migration projects.
• Financial services, mortgage or lending data.
• Row‑level security in Power BI or Fabric.
• DP-700 or DP-600 certification.

Why You’ll Love Working Here

We believe great people do their best work when they're supported professionally, personally, and financially. That's why we offer a comprehensive rewards package designed to help you thrive at every stage of your career.

• Competitive Rewards — Competitive compensation, performance incentives (where applicable), and recognition for your contributions.
• Health & Wellness — Comprehensive medical, dental, and vision coverage, Health & Wellness Spending Accounts (where applicable), telemedicine, Employee Assistance Programs, and mental health support for you and your family.
• Time to Recharge — Generous vacation (4 weeks), floater days, and statutory holidays to help you recharge.
• Planning for the Future — RRSP matching to support your long‑term financial wellbeing.
• Family Support — Enhanced maternity and parental leave top‑up programs.
• Learning & Growth — Education assistance, mentorship, training, and opportunities to build your career across Nesto Group.
• Tools for Success — Modern technology, collaborative teams, and the resources you need to do your best work.

Diversity, Equity & Inclusion

At Nesto Group, we believe diverse perspectives make us stronger. We are committed to fostering an inclusive workplace where everyone feels respected, supported, and empowered to succeed.

We welcome applications from people of all backgrounds, including Indigenous Peoples (First Nations, Inuit, and Métis), persons with disabilities, members of racialized communities, women, and members of the 2SLGBTQIA+ community.

If you require accommodation during any stage of the recruitment process, we are committed to working with you to meet your needs.

#LI-Hybrid

The pay range for this role is: