Snowflake Platform Architect - Data Migration & ETL Lead

InfoCepts; Atlanta (GA); On-site; USD 140,000 - 190,000; Full time

Job summary

InfoCepts seeks an experienced Snowflake Architect to design, develop, and modernize data platforms on Snowflake. You will lead migrations from legacy systems, integrate AWS services, and optimize ETL/ELT pipelines while ensuring governance and security across enterprise environments.

You will collaborate with business and technical stakeholders, provide architectural guidance, and drive CI/CD and version control for dbt deployments.

Qualifications

• 10+ years of experience in data engineering / data warehousing.
• Bachelor’s or master’s degree in engineering / IT or related field.

Responsibilities

• Design, build, and optimize Snowflake data solutions in partnership with stakeholders.
• Lead data migration initiatives from legacy to Snowflake.
• Analyse source system changes and assess downstream impact.
• Design and optimize ETL/ELT pipelines for large-scale data movement.
• Develop and optimize SQL queries, stored procedures, and data integration processes.
• Collaborate with business users, architects, and dev teams on migration strategies.
• Support data validation, reconciliation, and quality assurance during migration.
• Troubleshoot performance issues and propose optimization strategies.
• Ensure adherence to data governance, security, and compliance standards.
• Provide technical leadership and guidance to development teams.

Skills

Snowflake

AWS

SQL Server

Data integration

ETL/ELT

Migration

Data governance

CI/CD

Version control (Git/Azure DevOps)

Data modelling

Education

Bachelor's or Master's in Engineering/IT or related field

Tools

Terraform

dbt

Job description

InfoCepts seeks an experienced Snowflake Architect to design, develop, and modernize data platforms on Snowflake. You will lead migrations from legacy systems, integrate AWS services, and optimize ETL/ELT pipelines while ensuring governance and security across enterprise environments.

You will collaborate with business and technical stakeholders, provide architectural guidance, and drive CI/CD and version control for dbt deployments.