Lead Software Engineer - Python AWS SQL ETL

FactSet; Hyderabad; On-site; INR 4,000,000 - 7,000,000; Full time

Benefits offered by this job

Health insurance

Life insurance

Disability insurance

Employee stock purchase program

Paid time off

Job summary

FactSet is seeking a Lead Software Engineer for Data Solutions Engineering in Hyderabad. You will guide the team, drive new feature development, and optimize cloud infrastructure for timeliness and cost efficiency.

The role requires leadership across agile teams, collaboration with product stakeholders, and ownership of project delivery from design through deployment.

Qualifications

• Bachelor’s or Master’s degree in computer science.
• 5–8 years of software/data engineering experience.
• 3+ years of people management experience.
• Hands-on Python experience in new implementations.
• Strong SQL with window functions, CTEs, joins, and optimization.

Responsibilities

• Provide technical leadership with product teams to build and execute roadmaps.
• Take on-call responsibilities within the team.
• Design, develop, and deploy new features and products for clients.
• Proactively propose technical solutions with clear communication.
• Perform code reviews and ensure best practices.

Skills

Python

Advanced SQL

ETL pipelines

PySpark

AWS

Analytical skills

People management

Education

Bachelor’s or Master’s in computer science

Tools

Databricks

Perl

C++

Pandas

Lambda

Job description

Job Description:

FactSet creates flexible, open data and software solutions for over 200,000 investment professionals worldwide, providing instant access to financial data and analytics that investors use to make crucial decisions.

At FactSet, our values are the foundation of everything we do. They express how we act and operate, serve as a compass in our decision-making, and play a big role in how we treat each other, our clients, and our communities. We believe that the best ideas can come from anyone, anywhere, at any time, and that curiosity is the key to anticipating our clients’ needs and exceeding their expectations.

Your Team's Impact

FMA Lead Software Engineer, Data Solutions Engineering

FactSet Market Aggregates is looking for a talented senior engineer to join our team and help us continue developing the product and achieve our strategic goals.

FMA is a content provider of index/benchmark level financial data. We run aggregates and analytics on security constituents collected from various FactSet sources like benchmarks, pricing, estimates, and fundamentals. We also maintain client-facing databases for most of our content, accessed via traditional means such as FQL and Screening.

We're seeking a Lead Software Engineer who can lead the team technically, is passionate about learning new technologies, and can guide us as we transition to scale our cloud infrastructure for better timeliness and cost efficiency while building new products and features.

What You'll Do

• Provide technical leadership in collaboration with product teams to build, implement, and execute projects and their respective roadmaps.
• Take up on-call responsibilities within the team.
• Design, develop, and deploy new features/products to clients.
• Proactive in providing technical solutions with effective communication & collaboration skills.
• Perform Code Reviews and ensure best practices are followed.
• Work in an agile team environment and collaborate with internal teams to ensure smooth product delivery.
• Improve existing processes and reduce technical debt.
• Develop high-performing solutions to enhance the overall client experience.
• Take ownership of projects and work on bug fixes and enhancements.
• Effectively communicate with stakeholders on project scope and timelines.

Required Skills

• Bachelor’s or Master’s degree in computer science
• Minimum 5-8 years of overall experience in Software Engineering/Data Engineering
• 3+ years of people management experience
• Hands‑on experience with Python (every new implementation is in Python)
• Practical knowledge of working with Advanced SQL — window functions, CTEs, joins on composite grain, execution plans(as all the transformations(ETL), business logic are implemented in SQL). Also, SQL query optimization.
• Experience with ETL(extract transform & load) pipeline & data warehouse design
• Experience with PySpark (Spark SQL)
• Familiarity with AWS - Redshift, EMR Serverless, S3, IAM
• Analytical skills & Debugging/tracing ability Analytical/debugging

Desired Skills

• Familiarity with Perl
• Familiarity with C++
• Experience in Databricks
• Knowledge/experience with System design
• Knowledge/experience with Pandas and Lambda

What's In It For You

• The opportunity to join an S&P 500 company with over 45 years of sustainable growth powered by the entrepreneurial spirit of a start-up.
• Support for your total well-being. This includes health, life, and disability insurance, as well as retirement savings plans and a discounted employee stock purchase program, plus paid time off for holidays, family leave, and company-wide wellness days.
• Flexible work accommodations. We value work/life harmony and offer our employees a range of accommodations to help them achieve success both at work and in their personal lives.
• A global community dedicated to volunteerism and sustainability, where collaboration is always encouraged, and individuality drives solutions.
• Career progression planning with dedicated time each month for learning and development.
• Business Resource Groups open to all employees that serve as a catalyst for connection, growth, and belonging.

Company Overview

Learn more about our benefits here.

FactSet (NYSE:FDS | NASDAQ:FDS) helps the financial community to see more, think bigger, and work better. Our digital platform and enterprise solutions deliver financial data, analytics, and open technology to more than 8,200 global clients, including over 200,000 individual users. Clients across the buy-side and sell-side, as well as wealth managers, private equity firms, and corporations, achieve more every day with our comprehensive and connected content, flexible next-generation workflow solutions, and client-centric specialized support. As a member of the S&P 500, we are committed to sustainable growth and have been recognized among the Best Places to Work in 2023 by Glassdoor as a Glassdoor Employees’ Choice Award winner. Learn more atwww.factset.comand follow us onXandLinkedIn.

At FactSet, we celebrate difference of thought, experience, and perspective. Qualified applicants will be considered for employment without regard to characteristics protected by law.