Senior Software Engineer (SQL and 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.

Sr. Software Engineer ( SQL and AWS. )

About Factset

FactSet Research Systems Inc. is a global provider of integrated financial information, analytical applications and industry-leading services for investment and corporate communities. As a publicly traded company (NYSE: FDS | NASDAQ: FDS) recently added to the S&P 500 index, FactSet delivers superior content, analytics, and flexible technology to help more than 162,000 users see and seize opportunity sooner. For over 40 years, the company has served financial professionals, which include portfolio managers, investment research professionals, investment bankers, risk and performance analysts, wealth advisors and corporate clients. FactSet gives our clients the edge to outperform with informed insights, workflow solutions across the portfolio lifecycle, and industry-leading support from dedicated specialists.

At FactSet, we celebrate diversity of thought, experience, and perspective. We are committed to disrupting bias and a transparent hiring process. All qualified applicants will be considered for employment regardless of race, color, ancestry, ethnicity, religion, sex, national origin, gender expression, sexual orientation, age, citizenship, marital status, disability, gender identity, family status or veteran status. FactSet participates in E-Verify.

Department Brief:

Our teams are focused on developing cutting-edge web applications that drive the business forward through innovative solutions. We leverage modern frontend and backend technologies to build scalable and highly performant web platforms. The challenge, scope, and versatility of this development work provide an exciting opportunity to make a significant impact on our products and client offerings.

Join our dynamic team and contribute to building robust, reliable, and scalable web applications using VueJS, Node.js, and AWS. You will work on both internal and external client-facing applications that shape the user's experience and drive FactSet's growth through technological innovations.

Job Responsibilities:

• Work on the Data Lake/DAM platform handling millions of documents annually. Focus on developing new features while supporting and maintaining existing systems, ensuring the platform's continuous improvement.
• Participate in weekly On Call support to address urgent queries and issues in common communication channels, ensuring operational reliability and user satisfaction.
• Create comprehensive design documents for major architectural changes and facilitate peer reviews to ensure quality and alignment with best practices.
• Collaborate with product managers and key stakeholders to thoroughly understand requirements and propose strategic solutions, leveraging cross-functional insights.
• Actively participate in technical discussions with principal engineers and architects to support proposed design solutions, fostering a collaborative engineering environment.
• Work effectively as part of a geographically diverse team, coordinating with other departments and offices for seamless project progression
  
  

Job Requirements :

• Bachelor’s or master’s degree in computer science, Engineering, or a related field is required.
• 5-6 years of experience in software development, with a focus on Database systems handling & operations.
• Writing and optimizing complex SQL queries, stored procedures, views, triggers
• Developing and maintaining database schema and structures
• Creating ETL pipelines for data ingestion and transformation
• Troubleshooting data issues and performance bottlenecks
• Mentoring junior developers
• Proven experience working with APIs, ensuring robust connectivity and integration across the system.
• Working experience with AWS services such as Lambda, EC2, S3, and AWS Glue is beneficial for cloud-based operations and deployments.
• Strong analytical and problem-solving skills are critical for developing innovative solutions and optimizing existing platform components.
• Excellent collaborative and communication skills, enabling effective interaction with geographically diverse teams and key stakeholders.
• Capability to address system queries and provide weekly On Call support, ensuring system reliability and user satisfaction.
• Ability to prioritize and manage work effectively in a fast-paced environment, demonstrating self-direction and resourcefulness.
  
  

Desired Skills:

• Deep RDBMS knowledge (e.g., SQL Server, Oracle, PostgreSQL)
• Strong T-SQL/PLSQL scripting
• Query tuning and performance optimization
• Data modelling and DWH concepts
• Often part of app development or analytics teams
• Stored procedures, functions, views, triggers
• Query optimization techniques
• Execution plan analysis
• Indexing strategies
• Partitioning and table optimization
• Logical and physical data modelling
• Normalization/denormalization
  
  

Diversity:

At FactSet, we celebrate diversity of thought, experience, and perspective. We are committed to disrupting bias and a transparent hiring process. All qualified applicants will be considered for employment regardless of race, color, ancestry, ethnicity, religion, sex, national origin, gender expression, sexual orientation, age, citizenship, marital status, disability, gender identity, family status or veteran status. FactSet participates in E-Verify.

Return to Work:

We are here to support you! If you have taken time out of the workforce and are looking to return, we encourage you to apply and chat with our recruiters about our available support to help you relaunch your career.

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.