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

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