Lead Software Engineer - Python. AWS, SQL

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.

What We’re Looking For

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 and Perl is a plus.
• Advanced knowledge of at least one distributed, massively parallel columnar database - Vertica, AWS Redshift, Redshift Spectrum, Apache Druid, MS Azure SQL Data Warehouse (Azure Synapse).
• Familiarity with AWS Cloud technologies – Redshift, S3, Spectrum, Lambda, DynamoDB.
• Practical knowledge of working with SQL and NoSQL databases.
• Ability to translate business requirements into data warehouse design (ETL, schema, query design).
• Hands-on experience working with large-scale datasets.
• Self-starter with a willingness to learn new technologies and languages.
• Good problem-solving skills.

Desired skills

• Familiarity with one or more cloud-based ETL tools - AWS Glue, Matillion, Stitch.
• Familiarity with C++.
• Experience creating a REST API.
• Knowledge/experience with web technologies – HTML, CSS, JavaScript, JQuery, Ajax.
• Knowledge/experience with performance-tuning databases and queries.

What’s In It For You

At FactSet, our people are our greatest asset, and our culture is our biggest competitive advantage. Being a FactSetter means:

• 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 Resourc…