Data Engineer II

About your team ISS Data Engineering Chapter is an engineering group comprised of three sub-chapters - Data Engineers, Data Platform and Data Visualisation that supports the ISS Department.

Fidelity is embarking on several strategic programmes of work that will create a data platform to support the next evolutionary stage of our Investment Process. These programmes span across asset classes and include Portfolio and Risk Management, Fundamental and Quantitative Research and Trading.

About your role This role sits within the ISS Data Engineering. The Data Engineering team is responsible for building and maintaining the data applications and platform that enables the ISS business to operate.

This role is appropriate for a senior data engineer capable of taking ownership and a delivering a subsection of the wider data platform or data applications.

Strategic Impact

As a Senior Data Engineer, you will directly contribute to our key organizational objectives:

• Cost Efficiency

Improve productivity through automating routine maintenance tasks

Decrease time to deliver continuous improvement initiatives

Optimize infrastructure costs through efficient database design

• Risk Mitigation

Improve system documentation and knowledge transfer

Increase automated testing coverage

Enhance system and location resiliency

Key Responsibilities

• Develop and optimize SQL queries, stored procedures, and data models for Oracle-based systems
• Maintain data pipelines for extract, transform, and load (ETL) processes
• Execute data quality controls and validation processes to ensure data integrity
• Work with team members to understand business requirements and implement technical solutions
• Create and update documentation for database procedures and configurations
• Identify and resolve database performance issues through query optimization
• Support integration between Oracle systems and cloud services, particularly AWS S3
• Participate in code reviews and follow best practices for database development
• Assist in migrating data and processes from legacy systems to modern cloud-based solutions
• Work within an Agile framework, participating in sprint activities and team ceremonies

About you

Required Qualifications:

• 5-8 years of experience with Oracle databases, SQL, and PL/SQL development
• Good understanding of data modelling principles and database design
• Working knowledge of Python for data processing
• Experience with data quality validation and controls
• Ability to understand existing database schemas and data relationships
• Experience with version control systems, preferably Git/GitHub
• Good written communication skills for technical documentation
• Understanding of Agile development methodologies
• Familiarity with investment management industry concepts, particularly security reference data, fund reference data, and basic fund accounting

Additional Qualifications:

• Knowledge of SQL Server development
• Experience with ETL tools like Informatica or Control-M
• Unix shell scripting capabilities
• Understanding of CI/CD principles
• Familiarity with AWS services, particularly S3, Lambda, and Step Functions
• Knowledge of database security principles
• Experience with data visualization tools (Tableau, Power BI)
• Experience collaborating with team members