Senior Data Engineer, Analytics

Nesto; Vancouver; Hybrid; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Health & Wellness

Time to Recharge

Learning & Growth

RRSP matching

Job summary

Nesto Group is seeking a data engineer to own and evolve the Commercial Analytics data platform in Microsoft Fabric. You will manage ingestion, modeling, security and serving for Power BI reports, client extracts and internal tools, guiding initiatives from discovery through production.

The role focuses on migrating Azure Data Factory pipelines and legacy reports to Fabric, adding CI validation, and strengthening DevOps pipelines, with a strong emphasis on scalable analytics architecture.

Qualifications

• 3+ years of data engineering experience with production pipelines and data models in a cloud environment.
• Hands-on Microsoft Fabric experience preferred; strong Azure Data Factory, Synapse or Databricks experience a good fit.
• Advanced SQL on large relational datasets; including views, stored procedures, performance tuning and incremental patterns.
• Experience building datasets for Power BI and reading semantic models with DAX/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, preferably with Azure DevOps.
• Daily use of AI coding tools; knowledge of Claude Code preferred.
• Experience leading data projects end to end from requirements to production.
• Strong communication skills with technical and non-technical stakeholders.

Responsibilities

• Lead new initiatives end to end: meet with stakeholders and clients to gather requirements and deliver them to production.
• Make architecture decisions across ingestion, transformation, storage and modeling.
• Design and maintain ELT pipelines with incremental loads and safe reruns.
• Design and maintain dimensional data models for analytics and reporting.
• Build views, stored procedures and curated tables for Power BI models and internal tools.
• Implement data validation, monitoring, logging and alerting to catch issues quickly.
• Tune queries and pipelines for performance as data volumes grow.
• Manage access control, provisioning, and data sharing with internal teams and partners.
• Document lineage, architecture and data processes.
• Review code and help set engineering standards.
• Evaluate Fabric features, run proofs of concept and adopt improvements.

Skills

Data engineering

Microsoft Fabric

Azure Data Factory

SQL

Python

REST APIs

CI/CD

AI coding tools

Power BI

Data modeling

Tools

Databricks

Synapse

SSRS

Job description

About this position

Future-Forward. Client-Focused.

About Us

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 one of 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 , 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

Future-Forward. Client-Focused.

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

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 one of 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 , 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.
• Strong dimensional modeling experience, using Kimball methodology.
• 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:
90,000 - 110,000 CAD per year(Vancouver)