Back to jobs

Senior Data Engineer, Analytics

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: SALARIED_FT
From the employer’s posting

What you’ll work on

Full posting

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.

  • Lead new initiatives end to end, from stakeholder requirements to production

  • Design and maintain ELT pipelines from SQL Server, Azure SQL, REST APIs and SaaS platforms

  • Design and maintain dimensional data models for analytics and reporting

  • Build views, stored procedures and curated tables behind Power BI models and dashboards

  • Manage access control, database and user provisioning, and data sharing

From the employer’s posting
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.
Lead new initiatives end to end: meet directly with stakeholders and clients to gather requirements, design solutions and deliver them to production.
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
Manage access control, database and user provisioning, and data sharing with internal teams and external partners.

About Nesto Group

Backed by decades of experience and a reputation for innovation, we help clients navigate complex financing opportunities with confidence.

In the employer’s words · Read in context

Apply at Nesto Group

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 29, 202653 days ago
Recorded sightings
47
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 53

Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

Nesto Group is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Databricks
  • dbt
  • Power BI
  • Power Query
  • SQL Server
  • SSRS
  • pandas
  • PySpark
Where the posting names them
- 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.
- 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.
- 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.
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
- 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 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.
- DBA-adjacent experience: creating databases, users and permissions, and data masking. - dbt or a similar transformation framework. - Experience with migration projects.
- 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.
- 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.
- Financial services, mortgage or lending data. - Row-level security in Power BI or Fabric. - DP-700 or DP-600 certification.
Nice to Have - SSRS experience. - DBA-adjacent experience: creating databases, users and permissions, and data masking.

Your next step

Complete your application on ats.rippling.com. The employer’s form will show what is required.

Applying through Rippling

  • “The résumé will be parsed to fill in the application details”: check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗


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

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

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Vancouver, Canada

If you require accommodation during any stage of the recruitment process, we are committed to working with you to meet your needs. #LI-Hybrid
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.