Snowflake Data Architect

8 to 10 Years
India
arrow-right-white All Jobs

Company Name:  ​   Blackstraw.ai

Office Location:  ​     Chennai

Job Type:​                   Full-time

Experience:​              8 to 10 Years

Job Summary:

Discovery and assessment on existing platform.
Develop technical design and integration approach for Snowflake and Tableau (high level)
Scope Limitations – This engagement is limited to discovery, planning and documentation.
It does not include implementation, software development, or live system integration.
The candidate must have at least minimum 2 years of hands on experience working in
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:

  • Should have excellent communication skills.
  • Should be self motivated and willing to work as part of a team.
  • Should be able to collaborate and coordinate with on shore and offshore teams.
  • Be a problem solver and be proactive to solve the challenges that come his way.

Company Profile :

Blackstraw.ai is an end-to-end technology services company specializing in Artificial Intelligence (AI) 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 operationalize 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 organizations 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-form-back

Apply to this Job

Fill in your information and submit your application.

Join our Talent Pool !