Snowflake Data Architect

6 days ago

Markham, Ontario, Canada Galent Full time $120,000 - $200,000 per year

Job description

Snowflake Data Architect

Location Markham Ontario CA

Working model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu Fri

Primary Skills

Architect and implement advanced data solutions using Snowflake on AWS ensuring scalable secure and highperformance 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 handson 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 versioncontrolled 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 architectinglead 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

Qualifying Questions

1How many Data transformation programmes delivered Ans Minimum 23 transformation programs on snowflake

2Do you have experince in AWS cloud platform and services like AWS Glue ECS Airflow Ans Yes

3Do you have experince in Designing Streamlit apps and snowflake ML MLOPS capabilities Ans Yes

4Do you have Experince in designing complex transformations in DBT Ans Yes

5Do you have experience in architectinglead migration of workloads from Cloudera to Snowflake Ans Yes

  • Data Architect

    1 week ago

    Markham, Ontario, Canada TechDoQuest Full time $120,000 - $180,000 per year

    Role Overview :We are seeking aData Architectwith 8+ years of experience.Must have skills:Data architectureSnowflakeData governanceRole Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of the existing...

  • Senior Data Architect

    2 weeks ago

    Markham, Ontario, Canada Entellux Full time $120,000 - $180,000 per year

    Position:Data ArchitectLocation:MarkhamMode of Work : Hybrid (3 days a week)Role Overview :Must have skills:Data architectureSnowflakeData governanceRole Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of...

  • Senior Enterprise Data Architect

    2 weeks ago

    Markham, Ontario, Canada Logic Horizon inc Full time $120,000 - $180,000 per year

    Role Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of the existing Data Warehouse solution to Snowflake.Technology platform evaluations in the data and analytics space.Collaborate with cross-functional...

  • Senior Enterprise Data Architect

    2 weeks ago

    Markham, Ontario, Canada Logic Horizon Inc Full time $120,000 - $180,000 per year

    The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of the existing Data Warehouse solution to Snowflake.Technology platform evaluations in the data and analytics space.Collaborate with cross-functional teams (data...

  • Snowflake Data Platform Administrator – AWS

    1 week ago

    Markham, Ontario, Canada Recrute Action Full time $120,000 - $180,000 per year

    Snowflake Data Platform Administrator – AWS & TerraformOpportunity for a seasoned cloud data specialist in the insurance industry, focused on Snowflake administration, AWS integration, and PostgreSQL management. Drive high-impact digital transformation and cloud migration initiatives in a hybrid setup based in Markham, ON. Ideal for those with strong cloud...

  • Snowflake administrator

    6 days ago

    Markham, Ontario, Canada Logic Horizon Inc Full time $120,000 - $180,000 per year

    Job Summary:We are seeking a highly skilled Senior Snowflake Administrator to manage and optimize our Snowflake cloud data platform. The ideal candidate will have extensive experience in Snowflake implementation, AWS services, PostgreSQL administration, and on-prem to cloud migration. This role involves performance tuning, cost optimization, and...

  • Snowflake DBT Lead

    1 week ago

    Markham, Ontario, Canada LTIMindtree Full time $110,000 - $145,000 per year

    Role descriptionSnowflake DBT LeadLocation Markham,Ontario OnsiteWorking model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu FriPrimary SkillsExtensive Experience 15 years of professional experience delivering over 10 highimpact data projects from inception through warranty5 years of Snowflake dbt CoreCloud and...

  • Data Engineer

    6 days ago

    Markham, Ontario, Canada Recutify Inc. Full time $120,000 - $180,000 per year

    Position-: Data EngineerLocation: Markham,ONPosition: Full time/SubconMode: Hybrid (Mandatorily need to visit office 3 days a week)This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, high level and low-level solutionengineering design, analysis, and...

  • Data Engineer Lead

    1 week ago

    Markham, Ontario, Canada Wireframe Solutions-IT Consulting Company Full time $120,000 - $200,000 per year

    Must Have skills:SnowflakedBTAWSKey ResponsibilitiesTechnical Leadership: Define and drive the data engineering strategy, standards, and best practices across the organization.Solution Design: Develop high-level and low-level solution architectures, ensuring alignment with business and technical goals.Data Pipeline Development: Lead the design and...

  • Sr Data Engineer Lead

    6 days ago

    Markham, Ontario, Canada Recutify Inc. Full time $120,000 - $180,000 per year

    Sr Data Engineer Lead - AWS, Cloud TechnologiesLocation: Markham,ONPosition: Full time/SubconMode: Hybrid (Mandatorily need to visit office 3 days a week)This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, high level and low-level solutionengineering...