Technical Architect

Job Title: Technical Architect – Snowflake & SQL

Experience: 12–18 Years

Location: Remote

Job Summary:

We are looking for an experienced Solution Architect with 12–18 years of experience in designing, governing, and delivering end-to-end enterprise solutions across application, data, integration, cloud, and reporting architectures.

The ideal candidate will have strong expertise in AWS data platforms, Snowflake, data warehousing, data modeling, ETL/data processing, and analytics/reporting ecosystems. The candidate should be capable of translating complex business requirements into scalable technical solutions and should have strong experience working with clients, architects, engineering teams, and senior stakeholders.

Key Responsibilities:

• Design and govern end-to-end enterprise solution architectures covering application, data, integration, cloud, and reporting layers.
• Translate business and functional requirements into scalable, secure, reliable, and cost-effective technical solutions.
• Architect and implement solutions leveraging AWS cloud services, particularly AWS-based data platforms.
• Design data solutions using Amazon S3, Athena, ETL/data processing frameworks, and other AWS services.
• Define data architecture, data warehousing, data modeling, integration, and analytics strategies.
• Architect solutions leveraging Snowflake for enterprise data warehousing and analytics.
• Design scalable data pipelines and ETL/ELT processes, ensuring performance, security, reliability, and maintainability.
• Define appropriate integration patterns and APIs for connecting enterprise applications and data platforms.
• Work closely with engineering, data, cloud, security, and reporting teams to ensure successful solution implementation.
• Conduct and lead architecture reviews, design walkthroughs, and technical governance sessions.
• Identify and manage technical risks, architectural dependencies, scalability challenges, and performance considerations.
• Establish architecture standards, principles, reusable patterns, and best practices.
• Collaborate with clients and senior stakeholders to understand business objectives and provide appropriate technical recommendations.
• Provide technical leadership throughout the solution lifecycle, from requirements and architecture through implementation and deployment

Required Skills:

• 12+ years of experience in IT, data engineering, data warehousing, database technologies, and technical solution design.
• Strong hands-on expertise in Snowflake architecture, development, and administration.
• Advanced SQL expertise, including complex joins, CTEs, window functions, stored procedures, subqueries, and query optimization.
• Strong understanding of enterprise data warehouse architecture and data modeling principles.
• Experience designing and implementing ETL/ELT pipelines and enterprise data integration solutions.
• Expertise in database architecture, performance tuning, workload optimization, and large-scale data processing.
• Strong knowledge of Snowflake features, including Streams, Tasks, Dynamic Tables, Snowpipe, Time Travel, Zero-Copy Cloning, and Secure Data Sharing.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Strong understanding of data security, role-based access control (RBAC), encryption, data governance, and compliance.
• Experience with Git, CI/CD pipelines, version control, and automated deployment practices.
• Ability to create architecture blueprints, technical design documents, and enterprise-level technical solutions.

About Atain:

(http://www.atain.com)

Atain is an enterprise orchestration partner that aligns people, processes, and platforms with AI to redefine work and deliver assured outcomes. It is enabled through the SMART Framework driving superior metrics with AI-redefined work, the TechBud platform, a GenAI foundation built on zero-pilot architecture and ISO 42001 standards, a robust partner ecosystem, and deep domain expertise. Atain's Unified Hub continuously senses, predicts, and re-orchestrates work across people, processes, and platforms to deliver assured outcomes. The centers of skill and scale combine deep expertise with AI to deliver assured outcomes. For more information, visit www.atain.com

Atain is ISO 27001:2013, CMMI SVC Level 5 and ISAE-3402 compliant for IT, and COPC Certified v6.0, ISO 27001:2013 and PCI DSS 3.2 certified for BPO processes. The organization follows Six Sigma rigor for process improvements.

It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.