Senior Data Engineer

Our client is a Canadian financial services company undergoing significant growth and modernization of its data ecosystem. The team is building a scalable cloud-based data platform that will serve as a foundation for analytics, reporting, and data-driven decision-making across the organization.
 

You will join the Core Data Platform team and take ownership of designing and developing enterprise-grade data solutions.

Responsibilities

• Design and implement scalable data models in Snowflake.
• Build, optimize, and maintain ELT/ETL pipelines using dbt.
• Develop and support workflow orchestration using Airflow or Dagster.
• Write clean, reusable, and maintainable Python code for data processing and monitoring.
• Collaborate with Tech Leads, analysts, and business stakeholders to define requirements and deliver solutions.
• Participate in architecture discussions and drive technical decisions.
• Ensure high code quality through reviews, testing, documentation, and CI/CD practices.
• Work with cloud-native services across AWS and Azure environments.
• Contribute to metadata management, logging, monitoring, and production support.

Must Have

• 7+ years of experience in Data Engineering.
• Strong hands-on experience with Python and advanced SQL.
• Experience with Apache Spark or similar large-scale data processing frameworks.
• Solid experience with workflow orchestration tools (Apache Airflow or Dagster).
• Strong expertise in Snowflake and enterprise data warehouse architectures.
• Experience designing secure data platforms, including:
  • data security implementation;
  • access control;
  • data masking policies;
  • handling sensitive and PII data.
• 3+ years of experience with cloud platforms (AWS, Azure, or GCP).
• Experience building and maintaining CI/CD pipelines.
• Strong understanding of software engineering best practices, testing, and documentation.
• Ability to work independently and take ownership of end-to-end delivery.
• Excellent communication skills and experience working directly with stakeholders.
• Upper-Intermediate/Advanced English level (C1).

Nice to Have

• Experience with Data Mesh architecture.
• Experience with Snowflake UniStore and Hybrid Tables.
• Infrastructure as Code experience (Terraform, Ansible).
• Experience working in the financial domain.
• AWS certifications.

Tech Stack

• Snowflake
• dbt Core / dbt Cloud
• Apache Airflow / Dagster
• Python
• SQL
• Apache Spark
• AWS, Azure
• Terraform
• GitHub Actions

Interview Process

• HR Interview
• Technical Interview
• Short video introduction (2–3 minutes)
• Client Interview