Technical Lead – Data Platforms

Zywave

Pune District

On-site

INR 2,000,000 - 3,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A global insurance solutions leader is seeking a Technical Lead – Data Engineering with deep expertise in Snowflake and SQL Server. The ideal candidate will lead the design and implementation of scalable data solutions while driving innovation and collaboration. This role requires strong leadership skills and at least 8 years of experience in data engineering, including technical leadership. Candidates based in Pune are preferred, and the position requires working from the Kharadi office daily.

Qualifications

  • 8–12 years in data engineering, including 3+ years in a technical leadership role.
  • Strong hands-on experience with Snowflake and SQL Server.
  • Deep understanding of Medallion Architecture and Data Mesh principles.

Responsibilities

  • Lead the design and development of data pipelines using Snowflake and SQL Server.
  • Architect and implement Medallion Architecture for data.
  • Collaborate with teams to translate requirements into solutions.

Skills

Snowflake
SQL Server
Data Mesh
Medallion Architecture
Python
ETL tools
Git
CI/CD pipelines
Data orchestration tools
Leadership

Education

Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field

Tools

Airflow
AWS
Azure

Job description

Technical Lead – Data Engineering (Snowflake, SQL Server, Data Architecture)

📍 Location: Kharadi, Pune (Work from Office – 5 Days a Week)

About the Role

We are looking for a Technical Lead with deep expertise in Snowflake, SQL Server, and modern data architecture principles (Medallion Architecture, Data Mesh) to lead the design and implementation of scalable, secure, and high-performance data solutions. The ideal candidate will be a strategic thinker with strong technical leadership skills and a passion for building data-driven ecosystems that empower business insights.

Key Responsibilities

  • Lead the end-to-end design and development of robust data pipelines using Snowflake and SQL Server.
  • Architect and implement Medallion Architecture (Bronze, Silver, Gold layers) for structured and semi-structured data.
  • Drive the adoption of Data Mesh principles to promote domain-oriented, decentralized data ownership.
  • Collaborate with data analysts, scientists, and business teams to translate requirements into scalable solutions.
  • Ensure data quality, governance, and lineage across all data assets.
  • Optimize data workflows for performance, scalability, and cost efficiency.
  • Mentor and guide data engineers, fostering a culture of technical excellence and innovation.
  • Stay current with emerging data engineering technologies and recommend continuous improvements.

Qualifications & Skills

  • Education: Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.
  • Experience: 8–12 years in data engineering, including 3+ years in a technical leadership role. ✅
  • Core Skills:
  • Strong hands-on experience with Snowflake (data ingestion, transformation, performance tuning).
  • Advanced proficiency in SQL Server and T‑SQL for complex data operations.
  • Deep understanding of Medallion Architecture and Data Mesh principles.
  • Experience with ELT/ETL tools, Git, and CI/CD pipelines.
  • Familiarity with data orchestration tools (Airflow, dbt) and cloud platforms (AWS or Azure).
  • Strong analytical, problem‑solving, and leadership abilities.
  • Good to Have:
  • Experience with Kafka, Spark Streaming, AWS, dbt, or Prompt Engineering.
  • Proficiency in Python or .NET for data processing.
  • Insurance domain knowledge is highly preferred.

Why Zywave

Join a global leader in cloud-based solutions for the insurance and employee benefits industry. At Zywave, you’ll design data systems that power insights and decisions for thousands of businesses worldwide — all within a collaborative, innovation-driven environment.

Please send your resume to mrigank.bhushan@zywave.com

📌 Email Subject: Technical Lead – Data Engineering (Snowflake, SQL Server, Data Architecture)

(Only candidates based in Pune or willing to relocate to Pune – Kharadi location – will be considered.)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integration Engineer
Data Integration Engineer

Zywave • Pune District

On-site
INR 800,000 - 1,200,000
Senior Software Engineer– .NET
Senior Software Engineer– .NET

Zywave • Pune District

Hybrid
INR 1,800,000 - 2,800,000
Opportunity to influence architecture and technical strategy
Collaborative environment with strong engineering practices
Focus on innovation and continuous learning
Snowflake Data Engineer | Techknomatic | Pune
Snowflake Data Engineer | Techknomatic | Pune

Techknomatic Services Private Limited • Pune District

On-site
INR 900,000 - 1,200,000
Data Engineer – Snowflake & Azure Data Factory
Data Engineer – Snowflake & Azure Data Factory

Zyoin Group • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Senior Data Architect
Senior Data Architect

Mployee.me • Pune District

On-site
INR 4,000,000 - 8,000,000
Competitive salary
Talent development
Cutting-edge technology
+3
Snowflake Engineer
Snowflake Engineer

Persistent Systems • Pune

Hybrid
INR 1,200,000 - 2,100,000
Competitive salary
Hybrid work model
Career development & certifications
+2
Senior Data Architect
Senior Data Architect

Persistent Systems • Pune District

On-site
INR 3,000,000 - 6,000,000
Hybrid work
Education sponsorship
Flexible hours
+3
Data and Cloud Architect
Data and Cloud Architect

Systems Plus • Pune District

On-site
INR 4,000,000 - 6,500,000
Senior Principal Data Engineer//Chennai//Pune
Senior Principal Data Engineer//Chennai//Pune

Hiresquad Resources • Chennai

On-site
INR 3,500,000 - 5,500,000
Sr. Tech Lead - SnowFlake Job
Sr. Tech Lead - SnowFlake Job

YASH Technologies Middle East • Pune

On-site
INR 2,500,000 - 4,500,000