Senior Data Engineer - PL/SQL

Habitat For Humanity Of Durham; Durham (NC); On-site; USD 120,000 - 150,000; Full time

Job summary

Fidelity Investments seeks a data engineer to join the Asset Management Technology team in Durham to build scalable data processing solutions and robust data models that power critical investment decisions.

Ideal candidates bring Oracle PL/SQL, ETL tooling (Informatica), Snowflake, and DevOps practices with CI/CD (Maven, Jenkins, Git, Docker). The role requires on-call rotation for production support and adherence to Agile methods.

Qualifications

• Extensive experience crafting data engineering solutions in finance.
• Strong software development background in the financial industry.
• Expertise in Oracle PL/SQL, SQL scripting, and performance tuning.
• Proficient with ETL tools like Informatica and data warehousing platforms such as Snowflake.
• Interest in learning new technologies and data analysis to identify gaps and build solutions.
• Ability to independently address technical challenges and deliver innovative solutions.
• Solid data modeling skills using quantitative and multidimensional analysis.
• Understanding of data composition incl. Transactional, Data Mart, Data Warehouse structures.
• Basic proficiency in Java, Python, REST API, and AWS is advantageous.
• A dedication to delivering high-quality software with DevOps, CI/CD (Maven, Jenkins, Git, Docker) and Agile (Kanban/SCRUM).
• Strong analytical and problem-solving skills; excellent written and oral communication.

Responsibilities

• Develop scalable data processing solutions and robust data models.
• Design and implement ETL pipelines to support investment decisions.
• Apply DevOps and Agile practices to data engineering projects.
• Collaborate with teams across Fidelity AMT to maintain production systems.
• Participate in on-call rotation for production support.

Skills

Oracle PL/SQL

AutoSys

Data warehousing

SQL scripting

Informatica

Snowflake

Java

Python

REST API

AWS

DevOps

CI/CD

Maven

Jenkins

Git

Docker

Agile Kanban/SCRUM

Tools

Jenkins

Maven

Docker

Git

Job description

Fidelity will not provide immigration sponsorship for this position.

Job Description:

The Role

Join a skilled Fidelity’s Asset Management Technology team to develop advanced data engineering solutions that power critical investment decisions. This role involves developing scalable data processing solutions, designing robust data models and ETL pipelines, and applying modern DevOps and Agile practices. Ideal candidate is deeply enthusiastic about innovation in financial technology, with extensive proficiency in Oracle PL/SQL, AutoSys, data warehousing.

The Expertise and Skills You Bring

You bring a wealth of experience and skills that are critical to our success. These include:

• Years of demonstrated expertise in crafting high-quality data engineering solutions
• Strong software development background in the Financial Industry
• Expertise in Oracle PL/SQL development, SQL Scripting, and database performance tuning
• Proven understanding of ETL tools like Informatica and Data Warehousing platforms such as Snowflake
• A passionfor learning new technologies and analyzing data to identify gaps and build solutions
• The ability to independently address technical challenges and develop innovative solutions
• Strong data modeling skills using Quantitative and Multi-Dimensional Analysis
• In-depth knowledge of data composition concepts including Transactional, Data Mart, and Data Warehouse structures
• Basic proficiency in Java, Python, REST API, and AWS is advantageous
• A dedication to delivering high-quality software using DevOps, Continuous Integration, and Continuous Delivery practices (Maven, Jenkins, Git, Docker)
• Experience with Agile methodologies (Kanban and SCRUM) is a plus
• Strong analytical and problem-solving skills
• Excellent written and oral communication skills

Note: This position requires participation in an after-hours, on-call rotation to provide production support, including troubleshooting, incident response, and maintaining the stability of production systems.

The Team

Asset Management Technology (AMT) offers global technology and assistance to the Investment Management, Research, Trading, and Investment Operations departments at Fidelity. Our team develops top-tier data solutions for Fidelity Strategic Advisor Inc.'s managed account offerings. We are responsible for a multi-terabyte data platform that underpins crucial investment management functions for Fidelity’s leading wealth management services. Our platform caters to investment professionals and clients who regularly engage in significant market investment decisions.

Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.

Certifications:

Category:

Information Technology

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.