AWS Snowflake Architect

UniQtal Solutions LLC; Sacramento (CA); Hybrid; USD 78,000 - 99,000; Full time

Job summary

UniQtal Solutions LLC is seeking an AWS Snowflake Architect to lead enterprise data transformation initiatives. You will design and implement Snowflake on AWS, build scalable data pipelines, and collaborate with data governance and security teams.

Expertise in ETL/ELT using AWS Glue, Airflow, and dbt is required, along with experience migrating workloads from legacy systems to modern lakehouse architectures.

Qualifications

• Extensive data architecture and engineering experience (8+ years).
• Experience with large-scale data transformation programs, preferably in insurance/financial services.
• Proven Snowflake on AWS delivery and data solution design.

Responsibilities

• Architect and deliver Snowflake on AWS for enterprise data platforms.
• Design and operate ETL/ELT pipelines with AWS Glue.
• Orchestrate workflows using Apache Airflow and Snowflake OpenFlow.
• Develop modular, testable data transformations with dbt.
• Lead lakehouse implementations and Medallion architecture migrations.
• Optimize Snowflake for performance and cost, ensuring data quality.

Skills

Snowflake

AWS

Airflow

dbt

AWS Glue

Python

SQL

Tools

SnowflakeOpenFlow

Job description

Title:

AWS Snowflake Architect

Location:

Markham, ON (3 days per week- Hybrid)

Duration:

6 to 12 Months

Experience and Capabilities:

Extensive experience ( 8 + years) in data architecture and engineering, with a proven track record in large - scale 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 ETL/ELT , SnowflakeOpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of different data from diverse sources.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 carriersExperience 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 SnowflakeDesign Streamlit apps and define new capabilities and data products leveraging snowflake ML and LLOPS capabilities .Experience in evaluating the data technology platform including da ta governance suites, data security productsExposure to enterprise Data Warehouse solution like Cloudera , AWS Redshift and Informatica tool sets - IDMC, PowerCenter, BDMDevelop 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.Experience with data governance, metadata management, and data quality frameworks (e.g., Collibra, Informatica ).Experience in converting policy/data conversion from legacy to modern platformDeep expertise in Snowflake (Snowpro advanced certification preferred), with hands - on experience delivering Snowflake as an enterprise capability.Hands - on experience with AWS Glue for ETL/ELT, Apache Airflow for orchestration, and dbt for transformation (preferably deployed on AWS ECS).Proficiency in SQL, data modeling, ETL/ELT processes, and scripting languages (Python/Java).