Senior Software Engineer in Test (SQL, ETL, Data Lake, Reporting)
Yesterday• North Smithfield, RI
Merrimack, NH
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
Want more jobs like this?
Get jobs in North Smithfield, RI delivered to your inbox every week.
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.
Client-provided location(s): North Smithfield, RI, Merrimack, NH
Job ID: Fidelity-2116220
Employment Type: OTHER
Posted: 2025-09-16T23:41:30
Perks and Benefits
Health and Wellness
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
- HSA
- HSA With Employer Contribution
- Fitness Subsidies
- On-Site Gym
- Pet Insurance
- Mental Health Benefits
- Virtual Fitness Classes
Parental Benefits
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- Fertility Benefits
- Adoption Assistance Program
- Family Support Resources
- Adoption Leave
Work Flexibility
- Flexible Work Hours
- Remote Work Opportunities
- Hybrid Work Opportunities
Office Life and Perks
- Commuter Benefits Program
- Casual Dress
- Snacks
- Company Outings
- On-Site Cafeteria
- Holiday Events
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Leave of Absence
Financial and Retirement
- 401(K)
- 401(K) With Company Matching
- Company Equity
- Performance Bonus
- Relocation Assistance
- Financial Counseling
- Profit Sharing
Professional Development
- Tuition Reimbursement
- Promote From Within
- Mentor Program
- Shadowing Opportunities
- Access to Online Courses
- Lunch and Learns
- Internship Program
- Work Visa Sponsorship
- Leadership Training Program
- Associate or Rotational Training Program
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at Fidelity Investments.