Senior Data Engineer

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.

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

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.

As a 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.

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

• 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 Big Query.
• Modernization:
  Lead the migration of data systems from IaaS (on‑prem SQL Server) to PaaS/SaaS environments.

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

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

• Experience:
  
  5–10 years of professional data engineering experience, preferably within Financial Services or Fin Tech.
• 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 (Big Query) and modern transformation tools like dbt.
• SDLC:
  Strong knowledge of Git‑based workflows, CI/CD pipelines, and automated testing.

• Education:
  
  Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
• Certifications:
  
  Azure or GCP Data Engineering…