Snowflake Architect

InfoCepts; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

InfoCepts is seeking a Sr. Snowflake Architect / Senior Developer in Atlanta, GA to lead data platform initiatives, modernize data solutions on Snowflake, and support migration projects.

You will work with business and technical stakeholders to design, develop, and optimize data pipelines, integrating with AWS services and SQL Server environments. The role requires hands-on Snowflake expertise, strong SQL skills, and experience delivering large-scale data migration programs within enterprise

Qualifications

• 10+ years in data engineering or data warehousing.
• Bachelor’s or Master’s in engineering/IT or related field.

Responsibilities

• Design and implement scalable Snowflake data solutions.
• Lead data migration initiatives from legacy to modern platforms.
• Collaborate with stakeholders to define migration strategies.
• Ensure data governance, security, and audit readiness.
• Provide technical leadership during project execution.

Skills

Snowflake

AWS

SQL Server

data warehousing

ETL/ELT

data integration

performance tuning

governance & security

CI/CD

Git

Education

Bachelor’s or Master’s in engineering/IT

Tools

Azure DevOps

Job description

Position:Snowflake Architect
Location: Atlanta, GA
Type of Employment: Full-Time
Compensation:USD 140K+
Purpose of the Position: We are seeking an experienced Sr. Snowflake Architect / Senior Developer to support ongoing data platform initiatives, including application development, data warehouse enhancements, integration projects, and migration programs. The role involves working closely with business and technical stakeholders to design, develop, modernize, and optimize data solutions on Snowflake while supporting changes to source systems, interfaces, and downstream applications. The ideal candidate will have strong hands-on expertise in Snowflake, AWS, SQL Server, and data integration technologies, with experience delivering both new development and migration projects in enterprise environments.

Key Result Areas and Activities

• 1Design, develop, and implement scalable data solutions using Snowflake and AWS.
• Lead data migration initiatives involving legacy and modern data platforms.
• Analyse changes in source systems and interfaces and assess downstream impact.
• Design and optimize ETL/ELT pipelines for large-scale data movement and transformation.
• Develop and optimize SQL queries, stored procedures, and data integration processes.
• Collaborate with business users, architects, and development teams to define migration strategies.
• Support data validation, reconciliation, and quality assurance activities during migration.
• Troubleshoot performance issues and recommend optimization strategies.
• Ensure adherence to data governance, security, and compliance standards.
• Provide technical leadership and guidance to development teams during project execution.
• Provide architectural oversight to ensure adherence to standards and solution design
• Collaborate with stakeholders to align migration approach with business needs
• Support governance, documentation, and lineage approach for audit readiness
• Enable CI/CD practices and version control for dbt deployments
• Identify risks and recommend mitigation strategies during migration lifecycle

Roles and Responsibilities

Essential Skills:

• Strong hands‑on experience with Snowflake Data Cloud.
• Experience with AWS services including S3, Lambda, Glue, EC2, IAM, and related data services.
• Strong expertise in SQL Server, T‑SQL, database development, and data modeling.
• Proven experience in data warehouse modernization and migration projects.
• Experience with ETL/ELT frameworks and data integration tools.
• Strong knowledge of Snowflake performance tuning, query optimization, and workload optimization.
• Understanding of data governance, security, and access controls.
• Familiarity with CI/CD practices and version control tools (Git/Azure DevOps).

Desirable Skills:

• Experience in migration accelerators or reusable frameworks
• Exposure to data governance and lineage tools
• Knowledge of Terraform or infrastructure automation
• Experience working with distributed or multi-team migration programs

Qualifications:

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

Qualities:

• Strong architectural mindset with attention to detail.
• Ability to enforce standards with diplomacy and influence.
• Analytical thinking with problem-solving approach
• Proactive in identifying risks and ensuring smooth migration execution
• Collaborative, with strong communication across technical and business teams.
• Detail-oriented with focus on data accuracy and reliability

“Infocepts is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.”