Senior Software Engineer - Python Data Engineer

We're seeking a Senior Python Data Engineer to design, build, and optimize robust ETL workflows, vendor onboarding and deprecation processes, and scalable data integration pipelines fueling our key data products (including the MVA and Third-Party Identifier systems). You'll independently own and execute engineering projects, often handling complex, multi-step work with evolving business requirements. Your technical expertise and communication skills will make you a go-to resource for the team leading in technical architecture, process automation, documentation, problem solving, and mentorship.

What You'II Do

• Lead end-to-end design and delivery of efficient, fault-tolerant Python and SQL data pipelines for batch and streaming ingestion, transformation, and vendor onboarding.
• Drive complex, ambiguous projects: independently plan and execute multi-stage initiatives from discovery through implementation, including integrating new vendors/data, migrating legacy workflows, and automating deprecation logic.
• Own technical direction and design: produce clear architecture diagrams, process documentation, and hands-on technical reviews for new data workflow components and enhancements.
• Mentor and collaborate: act as a resource for peers, contribute to team knowledge sharing, and support onboarding, code reviews, and informal collaboration across teams and functions.
• Production support and reliability: diagnose and resolve job failures, resource bottlenecks, and data issues; implement fault-tolerance and graceful error-handling in production pipelines.
• Communicate with stakeholders: regularly update project status, share technical risks, and present findings to engineering leadership and non-technical partners.
• Automate operational processes: streamline onboarding of new data sources/types using CI/CD tools (eg, GitHub Actions) and practice strong DevOps.
• Continually improve codebase: refactor large code segments, enhance unit test coverage, structure repeated logic, and set standards for maintainability.

What we're Looking For

• Minimum3+yearshands-on development with Python in a data engineering or ETL environment.
• Deep knowledge of SQL for transforming and integrating large, complex datasets.
• Hands-on experience designing, building, and supporting scalable production ETL pipelines on Databricks (including Databricks notebooks, workflows Jobs, Delta Lake, and Spark on Databricks).
• Strongtrack recordin delivering and leading complex projects with ambiguous or evolving requirements.
• Experience designing technical architecture, producing process documentation, and driving solution adoption across teams.
• Experience automating workflows, managing vendorfeedsor external data integrations.

Mandatory:

• Proven experience working with cloud platforms, specifically Databricks on AWS (EC2, S3, Lambda, and Databricks).
• Excellent debugging, troubleshooting, and production support (CPU/memory, bottlenecks, late jobs, unhealthy queues).
• Excellentcommunicationcapable of explaining technical concepts to engineers and business partnersalike, andproducing high-quality written documentation.
• Practice inmentoring, team code reviews, and onboarding new engineers.

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 SP 500 company with over 45 years of sustainable growth powe'red 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.