Senior Engineer - Azure Synapse + Snowflake

Position: Azure Synapse Data Engineer 

Purpose of the Position:  Design, develop, and optimize enterprise-scale data engineering solutions for the Saint-Gobain Mobility business using Azure Synapse, Snowflake, dbt, and SQL. The role is responsible for building and maintaining ETL/ELT pipelines, supporting data platform modernization initiatives, and enabling reliable analytics and reporting through scalable data solutions 

Location: Nagpur, Pune. Chennai and Bengaluru 

Type of Employment: Full-time 

Key Result Areas and Activities: 

1: Data Pipeline Development - Design, develop, and maintain robust ETL/ELT pipelines using Azure Synapse Analytics.  

2: Data Platform Optimization  - Analyze and optimize SQL queries, stored procedures, data models, and processing workflows to improve performance and reliability.  

3: Cloud Data Engineering - Manage data ingestion, transformation, and storage processes using Azure Synapse, ADLS, and Snowflake.  

4: Migration & Modernization - Support Synapse-to-Snowflake/dbt migration activities, ensuring successful implementation and data integrity.  

5: Stakeholder Collaboration & Governance - Collaborate with business and technical teams, follow Agile practices, maintain documentation, and support delivery governance 

Essential Skills: 

• Strong SQL development including complex queries, joins, CTEs, DDL/DML, and query optimization. 
• Hands-on experience with Azure Synapse Analytics (Dedicated SQL Pool & Synapse Pipelines). 
• Experience in building and maintaining ETL/ELT solutions. 
• Working knowledge of Snowflake. 
• Working knowledge of dbt (Data Build Tool). 
• Experience with Azure Data Lake Storage (ADLS). 
• Azure DevOps experience for version control and deployment management. 

Desired Skills:

• Experience with SQL Server. 
• Experience with SSIS. 
• Prior cloud data platform migration experience. 
• Knowledge of Jira and Confluence. 
• Experience working in Agile delivery environments. 

Work Experience:  

• 5+ years of experience in Data Engineering, ETL/ELT development, and cloud-based data platforms.  
• Proven experience working with Azure Synapse Analytics, SQL, and modern data warehousing technologies. 

Education:  

• Bachelor's degree in computer science, Information Technology, Data Engineering, Electronics, or a related technical field. 
• Relevant Azure or Snowflake certifications will be an added advantage. 

Qualities: 

• Strong analytical and problem-solving skills. 
• Excellent written and verbal communication skills. 
• Customer-focused mindset with strong stakeholder management capabilities. 
• Ability to work effectively in onsite-offshore distributed teams. 
• Adaptable and capable of managing multiple priorities in a fast-paced environment. 
• Strong ownership, accountability, and collaboration skills. 
• Good understanding of Agile methodologies and continuous improvement practices.