Senior Software Engineer - Python, ETL, Databricks, AWS

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

The Data Engineering team within Enterprise Solutions & Intelligence owns the Data Lake for all of FactSet’s internal data and empowers employees across the company to leverage that data for insights, analysis, planning, and strategic initiatives. We support company functions in Sales, Finance, Human Resources, Business Operations, and beyond.

What You'll Do

• As a Senior Software Engineer on this team, you will play a significant role in developing solutions to ingest, maintain, enhance, and expose a variety of internal data from across the company.

• Design and develop data processing and storage workflows
• Collaborate with other engineers to integrate datasets to establish an end-to-end solution
• Build and enhance the Enterprise Data Warehouse using Kimball Methodologies and medallion architecture
• Excellent planning, organization, and leadership skills to estimate, track, and complete deliverables.
• Provide production support with occasional after-hours availability.
• You will collaborate with other engineers within the team, as well as those in Data Intelligence, Platform Infrastructure, and source system data teams to engineer efficient solutions to challenging big data problems.
• You will partner with stakeholders across FactSet on strategic projects that leverage our Data Lake to achieve concrete strategic outcomes. The team is modernizing our infrastructure, shifting from SQL to Databricks and AI-based solutions, and you will be an active contributor on that endeavour. Security and SOX compliance will be integral to the design and implementation of your work. 

What We're Looking For

• Bachelor’s degree, preferably in Computer Science or equivalent professional experience.
• 5+ years of hands-on experience in designing and implementing data pipelines using Databricks or similar ETL tools (AWS Glue)
• 2+ years of experience in Advanced SQL programming working with large data sets
• Strong hands-on experience in SQL and PySpark
• knowledge on Model Context Protocol (MCP) and its concepts
• Strong understanding of LLM models, including their capabilities, limitations, model selection and integration into GenAI applications
• Understanding of Lakehouse architecture using Delta Lake or Iceberg
• Understanding of REST APIs Integrations, Key Value data stores and Caching technologies
• Understanding of core concepts of distributed databases like Redshift, Snowflake etc.
• Strong technical, analytical, troubleshooting, and communication skills

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 Resource Groups open to all employees that serve as a catalyst for connection, growth, and belonging.

Learn more about our benefits here.

Company Overview: 

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 at www.factset.com and follow us on X and LinkedIn. 

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