Software Engineer II - Python Data Engineer

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 We are seeking a detail-oriented Python Data Engineer with a passion for collaboration, process improvement, and scalable data solutions. In this mid-level role, you'll partner with product managers, business users, and senior engineers to design, implement, and maintain data pipelines that power critical business workflows. You'll balance feature development, vendor data onboarding, bug fixing, and support responsibilities-growing your technical skills while contributing to ongoing enhancements across our large-scale data systems. What You'II Do Develop & Enhance Data Pipelines: Build, update, and optimize Python/SQL-based ETL workflows integrating new vendor feeds and third-party data sources. Translate business requirements into robust data processes, ensuring operational stability and scalability. Vendor Integration & Data Onboarding: Participate in onboarding, testing, and deploying new external data sources or APIs. Collaborate across teams to clarify requirements and deliver maintainable integration solutions. Operational Support & Troubleshooting: Monitor pipeline jobs, investigate and resolve data issues and errors, and join in on-call support rotation as needed. Quality & Continuous Improvement: Actively contribute to code reviews, refactor code for clarity and efficiency, and help improve unit test coverage and script reliability. Automation & DevOps Collaboration: Automate repetitive workflows using CI/CD tools (GitHub Actions, Jenkins, etc.), and work with DevOps for release management and smooth production deployments. Documentation & Communication: Create clear docstrings, process guides, onboarding docs, and process diagrams. Confidently explain solutions and participate in team discussions and ceremonies. Team Engagement & Learning: Join in sprint planning, standups, backlog grooming, and share updates and knowledge with cross-functional teammates. What We're Looking For Mandatory: 3+ years of hands-on experience with Python for data engineering, ETL, or workflow development, including production experience in Databricks (Databricks notebooks, Delta Lake, Databricks Jobs, and Spark on Databricks). Mandatory: Strong SQL skills; experience working with large databases and performing complex data integration/transformation on Databricks. Mandatory: Solid experience with ETL frameworks and workflow/orchestration tools, specifically Databricks (Prefect, Airflow, and/or Databricks required ). Exposure to onboarding and integrating vendor/third-party feeds or external data APIs, preferably via Databricks workflows. Proficiency with Git, pull requests, and code reviews; understanding of CI/CD principles as applied to Databricks deployments. Basic cloud experience (preferably AWS: S3, EC2, Lambda, Databricks). Strong troubleshooting/debugging skills for both code and production job failures, especially for Databricks pipelines. Good communication skills (spoken and written); able to document work and collaborate effectively with technical and business partners. Bonus/Preferred Skills: Experience creating or updating technical documentation, diagrams, or onboarding guides Experience with dashboarding/visualization tools (Power BI, Tableau, etc.) Familiarity with automation tools (GitHub Actions, Jenkins) or infrastructure as code (Terraform) Interest in business data, analytics, and operational reporting 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 . Salary is just one component of our compensation package and is based on several factors including but not limited to education, work experience, and certifications. 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.