Senior Data Engineer

Diagram; Remote; CAD 90,000 - 110,000; Full time

Job summary

A leading mortgage technology firm in Canada is seeking a Senior Data Engineer to manage cloud-based data infrastructure. This role involves designing scalable data pipelines and ensuring data security. The ideal candidate will have 5–10 years of experience, proficiency in SQL and Python, and a Bachelor's degree in Computer Science. With a commitment to diversity and collaboration, the firm offers comprehensive benefits, 4 weeks vacation, and a supportive environment for growth.

Benefits

Premium benefits plan

Unlimited telemedicine access

4 weeks of vacation

Qualifications

• 5–10 years of professional data engineering experience, preferably within Financial Services or FinTech.
• Expert-level SQL optimization skills and proficiency in Python for scripting and data manipulation.
• Deep hands-on experience with SQL Server, Azure Data Factory, and modern transformation tools.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines in Azure and GCP.
• Take ownership of the Power BI environment including administration and security.
• Implement enterprise-grade data security and privacy standards.

Skills

SQL optimization

Python scripting

Data visualization

Education

Bachelor’s degree in Computer Science or equivalent

Azure or GCP Data Engineering certifications

Tools

SQL Server

Azure Data Factory

Google Cloud Platform

Job description

Join nesto — proudly named Canadian Rocketship 2025*. A Deloitte Fast 50 company evolving alongside Canada’s top tech innovators and disrupting a 2.1 Trillion-dollar mortgage industry at light speed by building the mortgage ecosystem of the future.

BUILD lending technology with the best developers, AI engineers, and mortgage experts in the country. Work on a modern tech stack and a development framework designed to unlock your full potential and accelerate your career.

Why join us

• Hypergrowth: Deloitte Fast 50 — 3 years in a row
• Tech community credibility: TechTO Canadian Rocketship 2025*
• Industry leadership: CLA Lending Company of the Year — 4 consecutive years
• Talent magnet: CMP Top Mortgage Employer 2025
• Trusted technology: powering major financial institutions across Canada
• An entrepreneurial culture built on trust, speed, uncomfortable ambition, being stronger together, and a relentless obsession with our clients.

About nesto and Nesto Cloud

nesto is Canada’s leading provider of mortgage technology and financing solutions, managing $73B+ CAD in residential and commercial mortgages, with 1,000+ team members across 12 offices nationwide. You will be working on Nesto Cloud, Canada’s most advanced cloud platform, delivering end-to-end technology solutions for lenders in the digital age.

Senior Data Engineer you will join our Data Operations team. You will be a key architect and owner of our cloud‑based data infrastructure, responsible for designing, building, and optimizing pipelines that manage the full mortgage lifecycle—from initial application to funding and servicing.

In this role, you will bridge the gap between legacy systems and modern cloud maturity, ensuring our data is scalable, secure, and highly available for critical business decision‑making.

Who You Are

• A "Doer": You are comfortable jumping into a fast‑paced environment and taking immediate ownership of the reporting backlog.
• A Visual Storyteller: You don't just put charts on a page; you build dashboards that tell a clear story and drive action.
• The "Admin" Mindset: You enjoy the organization and governance required to keep a BI environment running smoothly.

Key Responsibilities

Data Pipeline & Infrastructure Engineering

• Pipeline Development: Design and maintain scalable ETL/ELT pipelines in Azure and GCP using Azure Data Factory, Fabric, dbt, Fivetran, SSIS, and other solutions.
• Database Management: Optimize and manage structured and unstructured data across SQL Server, Azure SQL, Data Lakes, and BigQuery.
• Modernization: Lead the migration of data systems from IaaS (on‑prem SQL Server) to PaaS/SaaS environments.

BI & Reporting Enablement

• Power BI Administration: Take ownership of the Power BI environment, including workspace administration, security, and capacity management.
• Data Modeling: Build and maintain robust data models optimized for high‑performance Power BI dashboards and SSRS reports.

Operations & Governance

• Security & Compliance: Implement enterprise‑grade data security, privacy standards, and disaster recovery procedures.
• Automation: Proactively identify opportunities to automate workflows and reduce manual "toil."
• Observability: Build comprehensive monitoring and alerting for data pipelines to minimize downtime and ensure data reliability.

Documentation: Maintain high‑quality documentation of data lineage, system architectures, and process flows.

Required Skills & Qualifications

Technical Expertise

• Experience: 5–10 years of professional data engineering experience, preferably within Financial Services or FinTech.
• SQL & Programming: Expert‑level SQL optimization skills and proficiency in Python for scripting and data manipulation.
• Microsoft Data Stack: Deep hands‑on experience with SQL Server (DBA‑level knowledge), SSIS, SSRS, Azure Data Factory, and Synapse.
• Cloud & Modern Tools: Familiarity with Google Cloud Platform (BigQuery) and modern transformation tools like dbt.
• SDLC: Strong knowledge of Git‑based workflows, CI/CD pipelines, and automated testing.

Education & Certifications

• Education: Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
• Certifications: Azure or GCP Data Engineering certifications (e.g., Azure Data Engineer Associate) are a significant plus.

Time Zone: Must be located in or able to work consistently within the EST time zone (9:00 AM – 5:00 PM) to ensure synchronized collaboration with our national teams.

The Reward

The A-Team: Work alongside high‑performing talent in the industry.

Accelerated Growth: The slope of your learning curve here will be vertical. You will touch more production systems in one year than you would in five years at a bank.

Top‑Tier Coverage: Premium benefits plan fully paid by nesto, including comprehensive insurance and unlimited access to telemedicine and mental health services for you and your family.

Rest & Recharge: 4 weeks of vacation to ensure you stay at peak performance.

Best‑in‑Class Tools: Access to the resources and tech you need to execute without friction.

Working framework: the environment that makes you productive and enables teamwork.

Diversity & Inclusion

At nesto, we believe that creativity and collaboration are the result of a diverse team. We are committed to fostering a culture of diversity, equity, inclusion, and belonging, and we strongly encourage women, people of color, LGBTQIA+ individuals, and individuals with disabilities to apply. We are committed to creating a workplace that is inclusive and welcoming to all.
#LI-Remote