Sr. Snowflake Architect / Developer

Position: Cloud Data Architect (Snowflake, AWS, SQL)

Location: Atlanta, GA (Onsite)

Type of Employment: Full-time.

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.

InfoCepts is a global leader of end-to-end data and analytics solutions with nearly 20 years’ experience enabling customers to derive value from a variety of data-driven capabilities. Unique among its peers, InfoCepts operates with the scale of a global consulting firm, yet the expertise of a niche partner.

At InfoCepts, you’ll be challenged to think innovatively, while growing your own personal and professional skills designed with the future in mind. We have more than 1200 global professionals working on cutting-edge technology solutions with a single mission: transforming our customers' journey through data-driven modernisation.

Key Result Areas and Activities:

• Design, 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

Work and Technical Experience:

• Must Haves :

• Strong hands-on experience with Snowflake Data Cloud.

• Experience working with AWS services such as S3, Lambda, Glue, EC2, IAM, and related data services.

• Strong expertise in SQL Server , T-SQL, and database development.

• Proven experience in data warehouse modernization and migration projects .

• Strong SQL and data modelling skills.

• Experience with ETL/ELT frameworks and data integration tools.

• Knowledge of performance tuning and query optimization in Snowflake.

• Understanding of data governance, security, and access controls.

• Understanding of performance tuning and workload optimisation in Snowflake

• Familiarity with CI/CD and version control (Git/Azure DevOps)

• Experience in driving team through delivery, UAT, & productionisation (Release planning,

• Migration Experience

• Experience migrating workloads from on-premise or legacy platforms to Snowflake.

• Experience handling source system changes and interface redesigns.

• Ability to perform impact analysis and develop migration roadmaps.

• Knowledge of data validation, reconciliation, and cutover planning.

• Good to have:

• 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