Technical Lead Data Engineer

About Vanguard
Founded in 1975, Vanguard is one of the world's leading investment management companies. The firm offers investments, advice, and retirement services to tens of millions of individual investors around the globe—directly, through workplace plans, and through financial intermediaries.

Vanguard’s India Office

Vanguard’s office in India is a significant milestone in our global expansion. We are committed to establishing an enduring technology center in Hyderabad, Telangana and are excited to be adding talent who will focus on Artificial Intelligence (AI), mobile, and cloud-based technologies that drive our business outcomes and deliver a world-class experience for our clients.

Role Summary

The Senior Specialist, Data Engineering (Technical Lead) will provide technical leadership in designing, building, and scaling enterprise data solutions on AWS. This role requires a seasoned data engineering professional with deep expertise in AWS data platforms, ETL development, data architecture, data modeling, and modern data management practices.
The successful candidate will lead multiple data engineering initiatives, partner with cross-functional stakeholders, drive technical direction across teams, and ensure the delivery of scalable, reliable, and high-performing data solutions that support business and analytics objectives.

Strong understanding of the Plan Sponsor and Workplace Investing business, including 401(k) and retirement plan ecosystems, sponsors, consultants, advisors, participants, and recordkeeping operations. Experience supporting data and analytics solutions that leverage CRM, sales, marketing, and client engagement data to power business applications, client insights, lead generation, campaign execution, and relationship management capabilities.

Responsibilities

• Lead the design, development, and optimization of scalable data engineering solutions and ETL/ELT pipelines using AWS technologies and industry best practices.

• Architect and implement data integration solutions that ingest and transform data from APIs, enterprise systems, databases, and third-party platforms into trusted and consumable datasets.

• Design and maintain robust AWS-based data platforms utilizing services such as AWS Glue, Amazon Redshift, S3, and other AWS data services to support analytics and reporting needs.

• Define and implement data architecture and data modeling standards to ensure scalability, consistency, performance, and long-term maintainability.

• Develop high-quality, performant data solutions using Python and advanced SQL, ensuring adherence to coding standards, security requirements, and engineering best practices.

• Partner with business stakeholders, product teams, architects, and engineering teams to analyze requirements, design solutions, and deliver business value.

• Troubleshoot and resolve complex data quality, consistency, integrity, and performance issues across data pipelines and platforms.

• Lead database design and optimization activities across relational and non-relational environments, ensuring efficient storage, retrieval, and processing of large datasets.

• Provide technical leadership and mentorship to engineers across multiple pods/teams, promoting engineering excellence and data best practices.

• Drive technical direction, establish standards, conduct design reviews, and contribute to strategic data engineering initiatives across the organization.

• Collaborate with cross-functional teams to enable data-driven decision-making through reliable, scalable, and well-governed data solutions.

• Support continuous improvement initiatives and evaluate emerging technologies to enhance the organization's data engineering capabilities.

Qualifications and Skills

• Bachelor's or Master's degree in Computer Science, Data Engineering, Information Technology, or a related field.

• Minimum 10 years of relevant technology experience, including at least 5 years in a Technical Lead role.

• Strong experience in Data Engineering, data integration, and enterprise data platform development.

• Proven experience designing and implementing ETL/ELT solutions in large-scale environments.

• Deep expertise in AWS cloud services, with hands-on experience building data solutions using: AWS Glue, Amazon Redshift, Amazon S3, Other AWS data engineering services

• Strong proficiency in Python for data processing, automation, and engineering solutions.

• Advanced SQL skills, including query optimization, performance tuning, and complex data transformations.

• Strong understanding of data architecture, data modeling, and data management principles.

• Experience working with both relational and non-relational databases, including SQL and NoSQL technologies.

• Experience integrating data from APIs, enterprise applications, third-party systems, and diverse data sources.

• Demonstrated ability to diagnose and resolve data consistency, accuracy, integrity, and performance issues.

• Ability to collaborate across multiple teams, influence technical decisions, and drive solution design from concept through implementation.

• Strong stakeholder management, communication, and leadership skills.

Location

This role is based in Hyderabad, Telangana at Vanguard’s India office. Only qualified external applicants will be considered.

Our mission

Vanguard adheres to a simple purpose: To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.

Our commitment to you

Vanguard takes the same long-term view of your success—at work and in life—with Benefits and Rewards packages that reflect what you care about, throughout all the phases and stages of your life. Our Total Rewards programs provide you and your loved ones with wellness support for key areas in your life:

Financial wellness
We're committed to enabling your financial success and provide competitive offers and programs.

Physical wellness
We're committed to providing benefits that support your physical health and wellness.

Personal wellness
We're committed to providing resources that help support the full scope of your life.

How we work

Vanguard has implemented a hybrid working model for most of our employees (crew members), designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.