Talent.com
S.i. Systems
Senior AWS Data Engineer/Architect (10+ years) to migrate an on-premises SQL Server/SSIS dataS.i. Systems • Vancouver
Senior AWS Data Engineer/Architect (10+ years) to migrate an on-premises SQL Server/SSIS data

Senior AWS Data Engineer/Architect (10+ years) to migrate an on-premises SQL Server/SSIS data

S.i. Systems • Vancouver
4 days ago
Job type
  • Full-time
Job description

Our public sector client is seeking a Senior AWS Data Engineer/Architect (10+ years) to migrate an on-premises SQL Server/SSIS data warehouse to an AWS-based data lakehouse architecture using AWS, dbt, Apache Airflow, and Redshift

Join a modernization initiative focused on transforming an on-premises data warehouse into a scalable AWS-based data lakehouse environment. This role provides technical leadership across data pipeline design, CI/CD deployment systems, monitoring, security, and migration activities involving SQL Server, Oracle, APIs, and AWS services. The project includes collaboration with IT and Data Management teams supporting cloud-based analytics and data platform capabilities. The engagement supports a single high-visibility project within a remote delivery environment.

Must Haves

  • 10+ years in data engineering, applied data science, or software engineering
  • AWS data engineering expertise including S3, AWS Glue, Redshift, CloudFormation, and CloudWatch
  • SQL, Python, dbt, and Apache Airflow for data pipeline and orchestration development
  • SQL Server, SSIS, Oracle, MySQL, and API data integration across multiple source systems
  • Degree in computer science, computer engineering, systems engineering, big data and statistics, or equivalent work experience

Nice to Have

  • Experience with large-scale data migrations or cloud modernization projects
  • Familiarity with DevOps best practices and AI code assistance tools
  • Experience architecting highly scalable distributed systems using AWS tools
  • Experience mentoring and guiding team members

Responsibilities

  • Develop data pipeline and orchestration design patterns using AWS tools including DMS, S3, AWS Glue, Managed Workflows for Apache Airflow, and dbt
  • Develop patterns for data pipeline monitoring, data quality monitoring, and alerting
  • Convert SQL Server and SSIS data warehouse models and code to dbt, Airflow, and Redshift
  • Ensure security and data access practices align with IAM roles, encryption, credential management, and organizational security policies
  • Collaborate with IT and Data Management teams to design a CI/CD deployment system for AWS data lake environments
  • Provide technical leadership and guidance for the migration to an AWS data lakehouse architecture


Create a job alert for this search

Senior AWS Data Engineer/Architect (10+ years) to migrate an on-premises SQL Server/SSIS data warehouse to an AWS-based data lakehouse architecture using AWS, dbt, Apache Airflow, and Redshift • Vancouver

Similar jobs

Senior Data Engineer — Remote Canada (Snowflake DW)

Infostrux Solutions Inc.Vancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A leading data consultancy in Canada seeks a Senior Data Engineer to guide customers in building cloud-based data warehouses using Snowflake.The role involves data ingestion, transformation, and op... Show more

 • Promoted

Data Engineer Focused on AWS and AI

Remarcable, Inc.Vancouver, Metro Vancouver Regional District, CA
Full-time

Elevate your career with Remarcable as a Data Engineer, specializing in AWS and AI/ML infrastructure.Contribute to transformative solutions for trade contractors across North America.In this role, ... Show more

 • Promoted

SDE II - Aurora Database Services Team

Amazon Web Services (AWS)Vancouver, Metro Vancouver Regional District, CA
Full-time

Amazon Web Services seeks an SDE II to enhance Aurora database services, focusing on distributed database solutions in the cloud.Use your coding and design expertise to impact millions of users.As ... Show more

 • Promoted

Miratech Senior Data Engineer Role

MiratechVancouver, Metro Vancouver Regional District, CA
Full-time

Embark on a career as a Senior Data Engineer with Miratech, focusing on advanced backend solutions for IVR systems.Develop SQL-based databases in a forever remote setup.As part of Miratech's team, ... Show more

 • Promoted

Senior Integrations Engineer: Cloud Data Pipelines

PlanHubVancouver, Metro Vancouver Regional District, CA
Full-time

A leading pre-construction SaaS platform is looking for a developer to design and maintain cloud-native systems.The ideal candidate will have expertise in AWS services and experience building robus... Show more

 • Promoted

Senior Engineer - Data Dashboards Development

DatabricksVancouver
Full-time

Shape the future of data analytics at Databricks as a Senior Engineer specialized in Data Dashboards.Build user-friendly interfaces that facilitate insightful data exploration and visualization.In ... Show more

 • Promoted

Senior Data Engineer

Spring FinancialVancouver
Full-time +1

Spring Financial is a Canadian financial technology company focused on making every day financial services simpler, faster, and more accessible.We build technology that helps Canadians build credit... Show more

 • Promoted

Senior Data Architect: Oracle EBS & Cloud Integrations

Stantec Consulting International Ltd.Burnaby, Metro Vancouver Regional District, CA
Full-time

A global consulting firm is seeking a Senior Data Architect to enhance workflows and optimize collaboration between project teams.This role involves integrating existing applications with a focus o... Show more

 • Promoted

Senior Engineer Specializing in Data Architecture

HRBVancouver, Metro Vancouver Regional District, CA
Full-time

Shape the future of our software as a Senior Engineer specializing in Data Architecture.Collaborate with a talented team to create features that enhance data management and user interaction effecti... Show more

 • Promoted

Senior Big Data Architect & Platform Lead

PowerToFlyVancouver, Metro Vancouver Regional District, CA
Full-time

A leading technology firm in Peel Region, Mississauga is seeking a Senior Big Data Developer to establish and implement scalable big data application systems mainly using Hadoop/Spark.This role req... Show more

 • Promoted

Remote Cloud Data Platform Engineer (AWS)

My RecruiterVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A recruiting firm is hiring a Platform Engineer in Toronto, Canada for a global software services client.The engineer will develop a cloud-based data platform and collaborate with various teams.Can... Show more

 • Promoted

Senior Databricks Architect — Lead Cloud Data Platform

Data ElephantVancouver, Metro Vancouver Regional District, CA
Full-time

A leading data consulting firm in Canada is seeking a Senior Databricks Architect to guide clients through their data modernization journeys.In this senior technical leadership role, you will be re... Show more

 • Promoted

Senior Data Engineer – Spark, Airflow, AWS (Remote Quebec)

GoToVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A leading remote work technology company seeks a Senior Software Developer to work on complex data processing and software releases.The ideal candidate will have hands-on expertise in Spark, Airflo... Show more

 • Promoted

Senior Data Platform Engineer, Data Cloud

P2PVancouver, Metro Vancouver Regional District, CA
Full-time

The engineering team at Chainalysis is inspired by solving the hardest technical challenges and creating products that build trust in cryptocurrencies.We’re a global organization with teams in the ... Show more

 • Promoted

Remote AWS DevOps Engineer — Python, CI/CD & SQL

BrightOrder Inc.Vancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A leading technology company in Canada is seeking a Mid-Senior level Backend Developer to join their fully remote engineering team.You will be responsible for designing and maintaining Python-based... Show more

 • Promoted

Senior Databricks Solutions Architect on AWS (Remote)

LumenaltaVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A global technology firm is seeking a Senior Solution Architect with extensive experience in Databricks and AWS to design scalable data solutions.This fully remote role requires strong design and a... Show more

 • Promoted

Senior Cloud Database Engineer Position

Marqeta, Inc.Vancouver, Metro Vancouver Regional District, CA
Full-time

Shape the future of database architecture at Marqeta as a Senior Cloud Database Engineer.Focus on automation and innovative solutions with AWS Aurora and other cloud technologies.In the heart of Ma... Show more

 • Promoted

Senior Cloud Systems Engineer - Production, AWS & Terraform

ClioVancouver, Metro Vancouver Regional District, CA
Full-time

A leading legal technology firm is seeking a Senior Systems Engineer to join their Platform Team.This role centers on designing and maintaining AWS infrastructure to support production environments... Show more

 • Promoted

Senior Data Engineer — Remote, Cloud Data Pipelines

DatatonicVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A premier AI data company in Canada seeks a Data Engineer to enhance cloud infrastructure and develop scalable data pipelines.Collaborate with project teams and clients to implement effective data ... Show more

 • Promoted

Senior Data Architect for Strategic Data Governance and Solutions

PathlionVancouver, Metro Vancouver Regional District, CA
Full-time

Take the lead as a Senior Data Architect, specializing in strategic governance and innovative data solutions in a federated ecosystem.Foster data quality and collaboration across multiple initiativ... Show more