Data Architect (Snowflake + AWS)

About Birlasoft:

Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run businesses with unmatched efficiency and innovation. As part of the CK Birla Group, a multibillion-dollar enterprise, we boast a 12,500+ professional team committed to upholding the Group's 162-year legacy. Our core values prioritize Diversity, Equity, and Inclusion (DEI) initiatives, along with Corporate Sustainable Responsibility (CSR) activities, demonstrating our dedication to building inclusive and sustainable communities. Join us in shaping a future where technology seamlessly aligns with purpose.

About the Job – We are seeking a highly skilled Sr Data Architect with 12-15 years of experience in in end-to-end data analytics strategy, design, and architecture for Snowflake, AWS Glue, Matillion Cloud,

Job Title – Data Architect with Snowflake with AWS Glue

Experience- 12 to 15 Years of experience

1. Location: Pune, Mumbai, Noida, Bangalore, Chennai, Hyderabad
2. Educational Background – Any Graduate
3. Skills Required – Snowflake, AWS Glue, Matillion

Key Responsibilities:

• Experience in end-to-end data analytics strategy, design and architecture for AWS Cloud Services (EC2, SQS, S3, Glue, MWAA (Airflow), Snowflake, Matillion Cloud, and Visual Code Studio.

• 10+ years of experience in DWH, including 4 years of experience in implementing DWH on Snowflake.
• Strong knowledge of AWS Platform.
• Design and develop/review ETL programs primarily using AWS Glue and Matillion Cloud.
• Design and implementation of Data Platform projects in a large-scale enterprise data warehouse environment.
• At least 2 successful implementations of AWS Glue with Snowflake or Matillion with Snowflake.
• Technical reviews, data validation & end-to-end testing of ETL objects, source data analysis, and data profiling.
• Handle multiple projects in parallel and deliver solution designs while working closely with the architecture team.
• Understand business requirements and convert them into detailed technical specifications for data models and ETL programs.
• Collaborate with business users to create architecture in alignment with business needs.
• Lead in developing project requirements for end-to-end data integration processes using ETL for structured, semi-structured, and unstructured data.
• Experience with data security and data access controls and design in Snowflake.
• Design the data warehouse and provide guidance to the team in implementation using Snowflake SnowSQL.
• Experience in migrating data from on-premise databases and files to Snowflake.
• Strong understanding of ELT/ETL and integration concepts and design best practices.
• Experience in performance tuning of snow pipelines and troubleshooting quickly.
• Experience in Snowsql, Snowpipe, and Snowpark.

Primary Skillset-

• AWS Glue
• MWAA (Airflow)
• Snowflake
• Matillion