Snowflake Data Architect

Blackstraw AI; Chennai District; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

A technology services company is seeking a Snowflake Data Architect based in Chennai, India. The role involves designing cloud-native data architectures on AWS, optimizing data solutions, and leading engineering projects. Candidates should have 8-10 years of experience and a strong background in AWS data services, ETL pipelines, and data modeling. This position provides the opportunity to work on complex data challenges and collaborate with cross-functional teams.

Qualifications

• 8 to 10 years of experience required.
• Strong hands-on experience with AWS data services including S3, Lambda, Step Functions, and CloudWatch.
• Deep proficiency in designing robust ETL/ELT pipelines.

Responsibilities

• Design and implement cloud-native data architectures on AWS.
• Develop and orchestrate ETL/ELT pipelines.
• Optimize data warehousing solutions on Amazon Redshift.

Skills

AWS Expertise

ETL/ELT Engineering

Data Modeling

Architecture Leadership

Pre-sales & Consulting

Performance Tuning & Partitioning

Job description

Snowflake Data Architect

Blackstraw.ai

Chennai, India — Full-time

8 to 10 Years’ experience required.

Job Summary

Discovery and assessment of existing platform. Develop technical design and integration approach for Snowflake and Tableau (high level). Scope limited to discovery, planning and documentation; does not include implementation, software development, or live system integration. Minimum 2 years of hands‑on experience with Snowflake and Tableau based big‑data processing projects.

Key Responsibilities

• Design and implement cloud‑native data architectures on AWS, including data lakes, data warehouses, and streaming pipelines using services like S3.
• Develop and orchestrate ETL/ELT pipelines.
• Optimize data warehousing solutions on Amazon Redshift/Other, including schema design, workload management, data distribution strategies, and materialized views.
• Ensure data security, access control, and lineage through Lake Formation, IAM policies, and encryption at rest/in transit.
• Automate data operations and deployments using CloudFormation, CDK, or Terraform, and integrate with CI/CD pipelines (e.g., CodePipeline, GitHub Actions).
• Establish and enforce standards for data modelling (Star/Snowflake, 3NF, Data Vault), data quality, and governance within AWS ecosystems.
• Collaborate closely with cross‑functional teams, including data scientists, business stakeholders, and DevOps, to align solutions with business objectives.
• Lead code and architecture reviews, mentor junior engineers, and enforce engineering best practices across the team.

Participate in pre‑sales and consulting activities such as:

• Engaging with clients to gather requirements and propose AWS‑based data engineering solutions.
• Supporting RFPs/RFIs, technical proposals, and client solution demos.
• Estimating cloud costs, implementation efforts, and timelines for AWS data initiatives.

Must‑Have Qualifications

• AWS Expertise: Strong hands‑on experience with AWS data services including S3, Lambda, Step Functions, and CloudWatch.
• ETL/ELT Engineering: Deep proficiency in designing robust ETL/ELT pipelines.
• Data Modeling: Advanced knowledge of dimensional (Star/Snowflake) and normalised data modeling, optimised for Redshift and S3‑based lakehouses.
• Architecture Leadership: Demonstrated experience leading large‑scale AWS data engineering projects across teams and domains.
• Pre‑sales & Consulting: Proven experience working with clients, responding to technical RFPs, and designing cloud‑native data solutions.
• Performance Tuning & Partitioning: Proven ability to debug and optimize jobs through custom partitioning strategies, broadcast joins, caching, and checkpointing.

Key Traits

• Effective communication skills.
• Self‑motivated and willing to work as part of a team.
• Collaborative with on‑shore and offshore teams.
• Proactive problem solver.

Company Profile

Blackstraw.ai is an end‑to‑end technology services company specialising in Artificial Intelligence and Engineering solutions across Data Science, Data Engineering, LLM/GenAI and LLMOps. Founded in 2018, we help global enterprises across North America, Europe and Asia to build and operationalise AI systems that create measurable business impact. Our mission is to make AI adoption simpler, faster and scalable through a blend of deep domain expertise, reusable accelerators, and proven engineering practices. With a 450+ strong team of engineers, data scientists and AI specialists, we partner with organisations to deliver real‑world outcomes in areas such as predictive analytics, computer vision, natural language processing and generative AI. At Blackstraw.ai, we’re passionate about solving complex business challenges through intelligent automation, modern data architectures and next‑gen AI applications – enabling enterprises to move from AI experimentation to transformation. Headquartered in Florida (USA) with operations in Canada and India, Blackstraw.ai continues to empower global enterprises to unlock the true potential of AI.

Apply to this Job

Fill in your information and submit your application.