Log in Sign up free
Apply now

Posted yesterday

Data Architect (Snowflake, DBT & AWS Focused)

@ Enterprise Solutions Inc.

View all jobs

Markham, Ontario

Contract
Apply now
SIGNALS

Requirements summary:

  • Extensive experience 8 years in data architecture and engineering with a proven track record in largescale data transformation programs ideally in insurance or financial services
  • Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS
  • Deep expertise in Snowflake with hands on experience delivering Snowflake as an enterprise capability
  • Handson experience with AWS Glue for ETLELT Apache Airflow for orchestration and dbt for transformation preferably deployed on AWS ECS
  • Proven experience in DBT to manage and automate complex data transformations within Snowflake ensuring modular testable and version controlled transformation logic
  • Experience in implementing the lake house solution Medallion architecture for financial or insurance carriers
Source and dates

Source type not verified · apify-linkedin

Employer posting date
2026-11-09
First seen by our source
2026-11-10
Source record updated
2026-11-10

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Apply now

Enterprise Solutions Inc.

View all jobs
FieldValue
Open jobs on Jobsy2
Job description

Job Title: Data Architect

Location: Markham, ON (Hybrid)

Type: Contract

Primary Skills

  • Architect and implement advanced data solutions using Snowflake on AWS ensuring scalable secure and high performance data environments
  • Extensive experience 8 years in data architecture and engineering with a proven track record in largescale data transformation programs ideally in insurance or financial services
  • Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS
  • Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETLELT Snowflake OpenFlow and Apache Airflow for workflow automation enabling seamless ingestion of different data from diverse sources
  • Deep expertise in Snowflake with hands on experience delivering Snowflake as an enterprise capability
  • Handson experience with AWS Glue for ETLELT Apache Airflow for orchestration and dbt for transformation preferably deployed on AWS ECS
  • Proficiency in SQL data modelling ETLELT processes
  • Proven experience in DBT to manage and automate complex data transformations within Snowflake ensuring modular testable and version controlled transformation logic
  • Experience in implementing the lake house solution Medallion architecture for financial or insurance carriers
  • Experience in optimizing and tune Snowflake environments for performance cost and scalability including query optimization and resource management
  • Experience in architecting lead migration of workloads from Cloudera to Snowflake
  • Experience in evaluating the data technology platform including data governance suites data security products
  • Develop robust data models and data pipelines to support data transformation integrating multiple data sources and ensuring data quality and integrity
  • Document architecture data flows and transformation logic to ensure transparency maintainability and knowledge sharing across teams
  • Strong knowledge of data lifecycle mgmt data retention data modelling and working knowledge of cloud computing and modern development practices

Secondary Skills

  • Familiarity with data mesh principles data product delivery and modern data warehousing paradigms
  • Experience in Designing Streamlit apps and define new capabilities and data products leveraging snowflake ML and MLOPS capabilities
  • SnowPro advanced certification preferred
  • Knowledge of scripting languages PythonJava
  • Experience with data governance metadata management and data quality frameworks eg Collibra Informatica
  • Experience in Insurance Domain
  • Experience in converting policydata conversion from legacy to modern platform
  • Exposure to enterprise Datawarehouse solution like Cloudera AWS Redshift and informatica tool sets IDMC powercenter BDM

Skills

Mandatory Skills: Data Architecture, Data lakehouse Architecture

We are an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees

Similar jobs

  • Data Architect

    Toronto, ON
    Full Time

    MPA Recruitment

    Candidates need strong data architecture experience across modelling, metadata, migration and master data, plus technology selection and mentoring. They must be highly proficient in at least three mainstream data technologies and comfortable engaging clients.

  • Sr Data Architect (AWS & Databricks)

    Mississauga, ON
    Full Time

    Ccube

    8+ YOECandidates need 8–10 years in data architecture or engineering, strong AWS or Azure experience, and expertise in Medallion architecture and lakehouses. Strong SQL, Python, Spark and Databricks skills are required.

    Databricks, Spark, Kafka, Airflow, dbt, Snowflake

  • Data Architect

    Toronto, ON
    Contract

    CONFLUX SYSTEMS

    10+ YOECandidates need 10 to 15 years of experience with hands-on AWS and SAS, plus expert skills in data modeling, cloud data architecture and data governance. Advanced knowledge of SQL, NoSQL, data lakes and warehouses, and ETL/ELT frameworks is required, and a bachelor's degree in a related field is expected.

    AWS Glue, PySpark, SAS, Redshift, Snowflake

  • Data Architect

    Toronto, ON
    Full Time

    BrainRidge Consulting

    8+ YOECandidates need 8 to 12 years of data architecture or engineering experience, deep Snowflake and AWS expertise, and knowledge of data governance frameworks and financial regulation. They also need strong SQL and Python skills and excellent executive communication.

    Snowflake, AWS, Collibra, Alation, Informatica, dbt

  • Data Architect - Technical Architect

    Toronto, ON
    Full Time

    K&K Global Talent Solutions INC.

    6+ YOECandidates need 6+ years of experience with ETL, Azure, Azure Data Factory, Databricks, big data and AWS. They must be able to design data models and data integration strategies for batch and real-time processing.

    Databricks, AWS, Azure

  • Data Architect

    Toronto, ON
    Contract

    Iris Software Inc.

    Candidates need experience designing data architecture and streaming pipelines with Apache Flink and Kafka, plus hands-on work with AWS data services such as S3, Kinesis, Glue and EMR. Strong data modelling and cloud platform knowledge are expected.

    Apache Flink, Apache Kafka, AWS S3, AWS Kinesis, AWS Glue, AWS EMR

  • Data Architect - Hybrid

    Mississauga, ON
    $125k–$140k/yrFull Time

    Randstad Canada

    7+ YOECandidates need at least 7 years of experience as a Cloud Architect and deep AWS expertise, including Kubernetes, Terraform and cloud migrations. Strong leadership, communication and presentation skills are also required, and experience in the financial sector is an asset.

    AWS, Kubernetes, Terraform, LeanIX

  • Data Architect - 12 month contract

    Oakville, ON
    HybridContract

    Euna Solutions: Euna Solutions® is a leading provider of purpose-built, cloud-based software that helps public sector and government organizations streamline…

    Euna Solutions needs senior data architecture experience with production AWS systems, including S3 lakehouse designs and layered architectures. Candidates should know managed AWS data services and how to handle data classification, PII, access control, lineage and residency.

    AWS Glue, AWS Lake Formation, AWS DMS, Redshift, dbt, n8n

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.