Data Team Lead / Data Architect (MongoDB, Redshift, Glue) B2B SaaS

Confidential Company

Toronto

Remote

CAD 130,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Paid Vacation
Holidays
Benefits Program

Job summary

A growing technology firm in Toronto, Ontario is seeking a Lead Data Engineer to spearhead the migration of its data infrastructure from a monolithic to a microservices-based architecture. This is a high-level, hands-on role requiring at least 10 years of experience in data engineering, with expertise in MongoDB, Redshift, and tools such as AWS Glue and PySpark. The successful candidate will directly oversee data modernization initiatives while leading a small team in delivering innovative AI-driven solutions.

Qualifications

  • 10+ years in data engineering with a focus on modernizing legacy data systems.
  • Experience as a Data Lead/Data Architect with proven leadership skills.
  • Hands-on engineer who can manage the migration independently.

Responsibilities

  • Lead the transition from monolithic databases to microservices architecture.
  • Build and optimize ETL/ELT workflows using relevant technologies.
  • Define domain data models to meet cross-functional needs.
  • Integrate legacy systems and design data extraction strategies.
  • Administer and scale SQL and NoSQL platforms.
  • Implement monitoring and optimizations for data workloads.

Skills

Database Management
Database Administration
MongoDB
Domain Data Modeling
AWS Glue
PySpark
dbt
Python
ETL/ELT workflows
Data migration
Cloud architecture
Data visualization

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Confidential Company. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$130,000.00/yr - CA$160,000.00/yr

Fulltime position with paid Vacation & Holidays + Benefits Program

Must be CANADIAN Citizen or CAN Perm. Resident

100% Remote from within Canada (not Quebec). Must work on EST.

Small B2B SaaS cloud-based software company (less than 800 employees) that is experiencing high growth and is rolling out leading edge AI-enabled features. Need a Data Expert/Data Team Lead/Data Architect that can lead their migration from mono-to-micro. MongoDB over to Redshift…..using AWS Glue, PySpark, dbt, and Python.

This is NOT a typical SR Data Engineer role - This new hire must be the actual LEADER of the data migration! (Data Team Lead/Architect)

This Lead Data Engineer/Data Architect will be the highest-ranking Data Expert on the team and report to the VP of Technical Engineering. There is no one else.

This person must lead the way themselves and make suggestions on how to do it. This is NOT just be a Senior Engineer that follows orders and transition uses ETL to migrate or modernize the data.

  • Must be an expert in Database Management and Database Administration, especially MongoDB and Domain Data Modeling.

This seasoned Senior Data Engineer will help lead the modernization of our data infrastructure as we transition from a tightly coupled monolithic system to a scalable, microservices-based architecture. This role is central to decoupling legacy database structures, enabling domain-driven service ownership, and powering real-time analytics, operational intelligence, and AI initiatives across our platform.

Key Responsibilities
  • Monolith-to-Microservices Data Transition: Lead the decomposition of monolithic database structures into domain-aligned schemas that enable service independence and ownership.
  • Pipeline Development & Migration: Build and optimize ETL/ELT workflows using Python, PySpark/Spark, AWS Glue, and dbt, including schema/data mapping and transformation from on-prem and cloud legacy systems into data lake and warehouse environments.
  • Domain Data Modeling: Define logical and physical domain-driven data models (star/snowflake schemas, data marts) to serve cross-functional needs, BI, operations, streaming, and ML.
  • Legacy Systems Integration: Design strategies for extracting, validating, and restructuring data from legacy systems with embedded logic and incomplete normalization.
  • Database Management: Administer, optimize, and scale SQL (MySQL, Aurora, Redshift) and NoSQL (MongoDB) platforms to meet high-availability and low-latency needs.
  • Cloud & Serverless ETL: Leverage AWS Glue Catalog, Crawlers, Lambda, and S3 to manage and orchestrate modern, cost-efficient data pipelines.
  • Monitoring & Optimization: Implement observability (CloudWatch, logs, metrics) and performance tuning across Spark, Glue, and Redshift workloads.
Minimum Requirements
  • 10+ years in data engineering with a proven record in modernizing legacy data systems and driving large-scale migration from monolithic over to microservices (preparing modernized data to be ready for use in AI modules).
  • Must have experience as an actual Data Lead/Data Architect leading the way. NOT just a Senior Data Engineer following orders. Must be a LEADER. Must be able to give direction and make recommendations and give push back when needed.
  • Must be an expert in MongoDB and Redshift, and be an ace using AWS Glue, PySpark, dbt, and Python.
  • Must be “very hands-on” engineer. This is an individual contributor role. There are no other data engineers. You may be able to have some offshore assistance, but it will mostly be up to this person to handle the migration.
  • Must have great English communication skills and work well in a team environment. Position will work closely with solution architects and domain owners to design resilient pipelines and data models that reflect business context and support scalable, secure, and auditable data access for internal and external consumers.
  • Must be Canadian Citizen or Canadian Permanent Resident. We can NOT HIRE anyone in Quebec. Must live in Canada.
  • Must be comfortable working for a small company with less than 800 employees.
Seniority level
  • Mid-Senior level
Employment type
  • Full-time
Job function
  • Information Technology
Industries
  • IT System Custom Software Development

Referrals increase your chances of interviewing at Confidential Company by 2x

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration/ Modernization Lead
Data Migration/ Modernization Lead

Accenture PLC • Toronto

Hybrid
CAD 109,000 - 220,000
Data Migration/ Modernization Lead
Data Migration/ Modernization Lead

Accenture PLC • Ottawa

Hybrid
CAD 109,000 - 220,000
Data Architect
Data Architect

Galent • Toronto

On-site
CAD 110,000 - 125,000
Data Tech Lead/Architect (AWS)
Data Tech Lead/Architect (AWS)

DEDICATTED • Montreal

On-site
CAD 120,000 - 180,000
Data Architecture\\Consultant Lead
Data Architecture\\Consultant Lead

Accenture PLC • Toronto

Hybrid
CAD 109,000 - 220,000
Hybrid work model
Senior Data Engineer
Senior Data Engineer

Aeolus Data • Canada

Hybrid
CAD 95,000 - 125,000
Data Engineer
Data Engineer

DS Technologies Inc • Canada

Remote
CAD 90,000 - 130,000
Remote Data Team Lead & Architect: MongoDB to Redshift
Remote Data Team Lead & Architect: MongoDB to Redshift

Confidential Company • Toronto

Remote
CAD 130,000 - 160,000
Paid Vacation
Holidays
Benefits Program
AWS Data Tech Lead/Architect
AWS Data Tech Lead/Architect

Dedicatted • Quebec

On-site
CAD 110,000 - 170,000
Paid time off
Health insurance
Career growth opportunities
+4
Senior Data Engineer
Senior Data Engineer

Aarorn Technologies Inc • Markham

On-site
CAD 68,880 - 89,544