Head of Data Engineering

Job Title - Head of Data Engineering

Location: Kharadi, Pune

Experience: 15+ years overall | 10+ years in Data Engineering & Analytics Platforms

Domain: US-based / Global Investment Banking & Financial Services

Role Summary

We are looking for a seasoned Head of Data Tools to lead, modernize, and scale enterprise data platforms supporting US-based and global Investment Banking clients. This role will own the end-to-end data ecosystem, covering ingestion, transformation, storage, analytics, and performance optimization across cloud-native and onprem environments.

The role demands deep hands-on expertise in SQL, AWS, Snowflake, Redshift, and Qlik (Q), coupled with strong client-facing leadership, system reengineering, and AIenabled data engineering practices to deliver high-quality, high-performance, low-defect data solutions.

Key Responsibilities

Data Platform Architecture & Strategy

• Own architecture and roadmap for enterprise-scale data platforms, including:
• AWS cloud-based data stacks
• Snowflake and Amazon Redshift
• Large, complex SQL-based data models
• Design and drive modernization of legacy data platforms into scalable, cloud-native architectures.
• Ensure data platforms meet performance, scalability, security, and regulatory requirements for global investment banks.
• Define standards for data modeling, partitioning, optimization, and query performance.

Data Engineering & Tooling

• Lead the development and optimization of:
• Enterprise SQL pipelines
• ELT / ETL frameworks
• Batch and nearreal-time data processing
• Oversee analytics and visualization platforms including Qlik (Q) for business and operational insights.
• Drive consistent engineering practices across ingestion, transformation, and consumption layers.
• Implement strong data governance, lineage, metadata management, and quality controls.

Delivery Excellence & Quality

• Drive engineering discipline to achieve:
• High data accuracy
• Minimal reconciliation issues
• Near-zero production data defects
• Establish automated data validation, reconciliation, and monitoring frameworks.
• Enforce SLAs and SLOs for data availability and performance.
• Lead root-cause analysis and permanent fixes for data incidents.

Client Engagement & Innovation

• Act as senior data advisor to client leadership (COOs, Heads of Data, Technology leads).
• Lead client discussions on:
• Data platform transformation
• Performance optimization
• Cost optimization in cloud data platforms
• Propose innovative enhancements to existing data ecosystems that improve decision-making and business outcomes.
• Translate complex business requirements into scalable data solutions.

People & Practice Leadership

• Lead and manage a large data organization (50+ resources) including:
• Data Engineers
• Analytics Engineers
• BI Developers
• Platform / Cloud Data Engineers
• Build a high-performance data engineering culture focused on ownership, quality, and continuous improvement.
• Mentor senior engineers, architects, and emerging leaders.
• Drive capability building across modern data tools and cloud platforms.

AIEnabled Data Engineering

• Champion usage of AI across the data SDLC, including:
• SQL and pipeline acceleration using Copilotstyle tools
• AIassisted query optimization
• Intelligent data validation and anomaly detection
• Apply AI to:
• Improve development velocity
• Reduce data defects and manual reconciliation
• Enhance performance tuning and cost optimization
• Ensure AI adoption aligns with enterprise governance and compliance standards.

Hands-on Technical Leadership

• Remain hands-on at critical points to:
• Review complex SQL logic and data models
• Guide performance optimization in Snowflake and Redshift
• Support resolution of highimpact data issues
• Act as the technical escalation point for complex data problems.

Required Skills & Experience

Must-Have

• 15+ years of overall IT experience with 10+ years in data engineering
• Strong experience supporting US-based or global Investment Banking clients
• Deep expertise in:
• Advanced SQL
• AWS Cloud (data services)
• Snowflake
• Amazon Redshift
• Qlik (Q)
• Proven experience leading 50+ member data teams
• Strong understanding of data security, governance, and regulatory requirements
• Excellent client-facing communication and leadership skills

Leadership & Soft Skills

• Exceptional leadership, communication, and stakeholder-management capabilities
• Ability to inspire, motivate, and scale large technical teams
• Strong problem-solving and decision-making skills
• Comfortable engaging senior client and executive stakeholders

Good to Have

• Experience building a Data Center of Excellence (CoE)
• Exposure to real-time or streaming data platforms
• Cloud cost optimization experience
• Certifications in AWS, Snowflake, or data architecture

Interested candidates can share their updated resume at shubham.saklani@ipivot.io or contact me at +91-9667834493.

If the call is not reachable, please drop a message on WhatsApp on the same number, and I will get back to you.