Fidelity Investments Header

Senior Software Engineer in Test (SQL, ETL, Data Lake, Reporting)

Smithfield, RI
Full-Time

Job Description

Job Description:

Senior Software Engineer in Test (SQL, ETL, DATA LAKE, REPORTING)

Fidelity Investments Workplace Investing (WI) organization is looking for a Senior Software Engineer specializing in test to join one of the Client Reporting squads within our Data Out - Client Reporting domain tasked with modernizing the outbound reporting platform and strategy within our market leading global equity compensation platform.

The Expertise You Have

  • Bachelor's Degree or equivalent in a technology related field (Computer Science, Engineering, etc.) required

  • 7+ years of relevant technical experience and experience in test automation

  • Experience with PL/SQL and complex queries, views, packages etc.

  • Strong SQL skills plus Java and Python development experience

  • 2+ years of Big Data, Data Lake or Data Warehouse experience is desired

  • Experience with ETL Data Pipeline testing of Data Warehouse platforms; exposure to iCEDQ test tool preferred

  • Experienced in Big Data Reporting Tools (OBIEE / Tableau / Power BI)

  • Familiarity with business intelligence reporting platforms, such as Power BI, would be advantageous

  • Playwright, Selenium knowledge good to have but not must

  • Strong working knowledge of relational databases, like Oracle or Postgres, and data lake/warehouse concepts, such as Snowflake

  • Knowledge of data pipeline testing will be a distinct advantage

  • Ability to work effectively with product development, external teams, and management

  • Knowledge of CI/CD Pipelines

  • ISTQB Certification (nice to have)

  • Experience as Software Engineer in test automation of RESTful services (Cucumber, Junit, Selenium, RestAssured, Git, Gradle, Maven)

  • Data Engineer working with the latest Big Data technologies and tools (Snowflake, Airflow, AWS, Azure)

  • Expert knowledge in test automation frameworks and demonstrate proficiency, quality and passion in your coding ability

  • Experience with UI and Microservices Architecture, Restful API's, Enterprise messaging like ActiveMQ, Kafka

  • Experience with DevOps, Continuous Integration and Delivery tools like Jenkins, Maven, uDeploy, Stash

The Skills You Bring

  • Your experience in executing projects in an Agile environment.

  • Your ability to collaborate with other technical and business experts in the team

  • Curiosity to stay current with new and emerging technologies and concepts, finding ways to apply those to business problems.

  • Your passion to follow modern test driven and automation driven software development methodologies.

  • Design, develop, maintain, and execute automated tests while adopting industry best practices and tools.

The Value you Deliver

  • Keeping the focus of the work in terms of Customer obsession.

  • Embrace continuous improvement regarding application quality and stability.

  • Strong sense of ownership for the quality of solution delivery.

  • Being candid and honest in all discussions to ensure the best outcomes.

The Team

You will be working with a team of business leaders and technologists focused on delivering a modern solution to Client Reporting via Automation, Continuous Integration and Test Data ecosystems. This role demands significant collaboration between members of various business and IT groups throughout the lifecycle of a typical project. As a technical associate, you will be working directly to shape our technology vision and will have a real impact on our Workplace Investing organization's success.

Certifications:

Category:

Information Technology

Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.

Please be advised that Fidelity's business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.

PDN-9fe57c48-aa78-4351-a5ae-6e9228d21032

Job Description:

Senior Software Engineer in Test (SQL, ETL, DATA LAKE, REPORTING)

Fidelity Investments Workplace Investing (WI) organization is looking for a Senior Software Engineer specializing in test to join one of the Client Reporting squads within our Data Out - Client Reporting domain tasked with modernizing the outbound reporting platform and strategy within our market leading global equity compensation platform.

The Expertise You Have

  • Bachelor's Degree or equivalent in a technology related field (Computer Science, Engineering, etc.) required

  • 7+ years of relevant technical experience and experience in test automation

  • Experience with PL/SQL and complex queries, views, packages etc.

  • Strong SQL skills plus Java and Python development experience

  • 2+ years of Big Data, Data Lake or Data Warehouse experience is desired

  • Experience with ETL Data Pipeline testing of Data Warehouse platforms; exposure to iCEDQ test tool preferred

  • Experienced in Big Data Reporting Tools (OBIEE / Tableau / Power BI)

  • Familiarity with business intelligence reporting platforms, such as Power BI, would be advantageous

  • Playwright, Selenium knowledge good to have but not must

  • Strong working knowledge of relational databases, like Oracle or Postgres, and data lake/warehouse concepts, such as Snowflake

  • Knowledge of data pipeline testing will be a distinct advantage

  • Ability to work effectively with product development, external teams, and management

  • Knowledge of CI/CD Pipelines

  • ISTQB Certification (nice to have)

  • Experience as Software Engineer in test automation of RESTful services (Cucumber, Junit, Selenium, RestAssured, Git, Gradle, Maven)

  • Data Engineer working with the latest Big Data technologies and tools (Snowflake, Airflow, AWS, Azure)

  • Expert knowledge in test automation frameworks and demonstrate proficiency, quality and passion in your coding ability

  • Experience with UI and Microservices Architecture, Restful API's, Enterprise messaging like ActiveMQ, Kafka

  • Experience with DevOps, Continuous Integration and Delivery tools like Jenkins, Maven, uDeploy, Stash

The Skills You Bring

  • Your experience in executing projects in an Agile environment.

  • Your ability to collaborate with other technical and business experts in the team

  • Curiosity to stay current with new and emerging technologies and concepts, finding ways to apply those to business problems.

  • Your passion to follow modern test driven and automation driven software development methodologies.

  • Design, develop, maintain, and execute automated tests while adopting industry best practices and tools.

The Value you Deliver

  • Keeping the focus of the work in terms of Customer obsession.

  • Embrace continuous improvement regarding application quality and stability.

  • Strong sense of ownership for the quality of solution delivery.

  • Being candid and honest in all discussions to ensure the best outcomes.

The Team

You will be working with a team of business leaders and technologists focused on delivering a modern solution to Client Reporting via Automation, Continuous Integration and Test Data ecosystems. This role demands significant collaboration between members of various business and IT groups throughout the lifecycle of a typical project. As a technical associate, you will be working directly to shape our technology vision and will have a real impact on our Workplace Investing organization's success.

Certifications:

Category:

Information Technology

Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.

Please be advised that Fidelity's business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.

PDN-9fe57c48-aa78-4351-a5ae-6e9228d21032

About Fidelity Investments

At Fidelity, since our founding in 1946, we have been dedicated to strengthening and security our clients’ financial well-being through exceptional service and innovative solutions. We empower over ~50 million people to achieve their most important financial goals, manage employee benefit programs for nearly 24,000 businesses, and support more than 16,000 wealth management firms and institutions with cutting-edge investments and technology. Our diverse business portfolio and independence provide us with a comprehensive view of the market and the stability to deliver long-term value for our customers. As the financial industry evolves and customer needs grow more complex, Fidelity continues to reinvent, innovate, and transform to meet the challenges of tomorrow’s financial landscape.
 

*Specifically serviced by our Clearing & Custody team within Fidelity Institutional

 

Fidelity TalentSource, is the in-house temporary staffing provider for Fidelity Investments. Unlike traditional staffing agencies, we are an internal business unit within Fidelity’s Talent Acquisition team, dedicated to recruiting talent from various backgrounds for roles in Fidelity’s regional and investor center locations. Our mission is to help you experience Fidelity’s diverse and inclusive workplace while expanding your skill set and professional network, with the ultimate goal of conversion to full-time employment as part of Fidelity’s long-term strategy. To learn more about temporary positions at Fidelity Investments, visit FidelityTalentSource.com.

Related Jobs

Apply For This Job
Senior Software Engineer in Test (SQL, ETL, Data Lake, Reporting)
Fidelity Investments
Smithfield, RI
Sep 17, 2025
Full-time
Your Information
First Name *
Last Name *
Email Address *
This email belongs to another account. Please use a diferent email address or Sign In.
Zip Code *
Password *
Confirm Password *
Create your Profile from your Resume
By clicking the Apply button, you agree to the terms of use and privacy policy and consent to receive emails from us about job opportunities, career resources, and other relevant updates. You can unsubscribe at any time.
Supercharge Your Resume with AI

Boost your resume with AI-driven enhancements. The tool analyzes and refines your content, highlighting your strengths and tailoring it for maximum impact. Get personalized suggestions and apply improvements instantly to stand out in the job market.

©2025 International Association of Women.
Powered by TalentAlly.