Data Engineer

Job Title: Senior Data Engineer

Location: Merrimack, NH OR Durham, NC

Work Mode: Hybrid (Onsite every alternate week Monday to Friday)

Duration: Long-Term Contract

Important Notes

• Must be open to alternate week onsite (5 days/week onsite every other week)
• Only local or nearby candidates preferred (no relocation)
• Strong financial domain experience preferred
  
  

Role Overview

We are seeking a highly skilled Senior Data Engineer to join Fidelity s Asset Management Technology (AMT) team. This role focuses on building scalable, high-performance data solutions supporting investment management platforms, including mutual funds and ETFs.

The ideal candidate will have strong expertise in Oracle PL/SQL, SQL scripting, ETL processes, and modern data warehousing technologies, along with the ability to work in a fast-paced, Agile-driven environment.

Key Responsibilities

Data Engineering & Development

• Design, develop, and maintain scalable data pipelines and data solutions
• Build high-quality, efficient, and reliable data processing systems
• Develop and optimize Oracle PL/SQL code and SQL scripts
  
  

ETL & Data Warehousing

• Work with ETL tools like Informatica
• Develop and manage data workflows in Snowflake Data Warehouse
• Ensure data quality, integrity, and consistency
  
  

Data Modeling & Analysis

• Design data models using:
• Transactional systems
• Data marts
• Enterprise data warehouses
• Perform quantitative and multidimensional data analysis
• Identify data gaps, patterns, and optimization opportunities
  

Performance Optimization

• Tune database performance and optimize queries
• Improve data processing efficiency and scalability
  
  

Cloud & Modernization

• Work with cloud technologies (AWS preferred)
• Support modernization initiatives using:
• APIs
• Java-based applications
  

DevOps & Agile Practices

• Follow CI/CD processes using:
• Git
• Jenkins
• Maven
• Docker
• Participate in Agile methodologies (Scrum / Kanban)
• Collaborate with cross-functional teams
  

Experience

Required Qualifications

• Strong experience as a Data Engineer in financial services domain
• Proven experience building enterprise-scale data engineering solutions
  
  

Technical Skills

• Expertise in:
• Oracle PL/SQL
• SQL scripting
• Database performance tuning
• Strong knowledge of:
• ETL tools (Informatica)
• Data warehousing (Snowflake)
• Strong data modeling experience
• Understanding of:
• Data marts
• Data warehouses
• Transactional systems
  

Additional Skills (Nice To Have)

• Python
• Java
• REST APIs
• AWS / Cloud technologies
• Microservices exposure
  
  

Soft Skills

• Strong analytical and problem-solving skills
• Ability to work independently and in team environments
• Excellent communication skills (written & verbal)
  
  

Team Overview

The Asset Management Technology (AMT) team supports:

• Investment management
• Trading
• Research
• Investment operations
  
  

They Manage a Multi-terabyte Data Platform Used For

• Mutual funds
• ETFs
• Strategic advisor products
  
  

This platform directly supports high-value financial decision-making impacting billions of dollars in investments