Data Engineer

Data Engineer

ISS Delivery provides the design and delivery of all changes in processes and/or technology solutions that support the growth for Fidelity's Global Investment Solutions & Services business (ISS). We support Investment Management, Asset Management Operations and Distribution team primarily located in London, Hong Kong, Tokyo, Toronto, Australia, Singapore and China.

We are seeking an experienced Data Engineer to join our team, focusing on designing, implementing, and maintaining robust data solutions primarily using Oracle technologies while integrating with modern cloud services. This role bridges our existing data infrastructure with evolving cloud-based systems, requiring both deep database expertise and adaptability to new technologies.

As a 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

• Design, develop, and optimize complex SQL queries, stored procedures, and data models for Oracle-based systems
• Create and maintain efficient data pipelines for extract, transform, and load (ETL) processes
• Implement data quality controls and validation processes to ensure data integrity
• Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications
• Document database designs, procedures, and configurations to support knowledge sharing and system maintenance
• Troubleshoot and resolve database performance issues through query optimization and indexing strategies
• Integrate Oracle systems with cloud services, particularly AWS S3 and related technologies
• Participate in code reviews and contribute to best practices for database development
• Support migration of data and processes from legacy systems to modern cloud-based solutions
• Work within an Agile framework, participating in sprint planning, refinement, and retrospectives

Essential Skills and Experience

• 3+ years of experience with Oracle databases, including advanced SQL development
• Strong knowledge of data modeling principles and database design
• Proficiency with Python for data processing and automation
• Experience implementing and maintaining data quality controls
• Experience with AI-assisted development (GH copilot, etc..)
• Ability to reverse engineer existing database schemas and understand complex data relationships
• Experience with version control systems, preferably Git/GitHub
• Excellent written communication skills for technical documentation
• Demonstrated ability to work within Agile development methodologies
• Knowledge of investment management industry concepts, particularly security reference data, fund reference data, transactions, orders, holdings, different asset classes and fund accounting.

Desirable Skills and Experience

• Experience with PL/SQL development (stored procedures, functions, packages)
• Knowledge of SQL Server and T-SQL development
• Experience with ETL tools like Informatica and Control-M
• Unix shell scripting skills for data processing and automation
• Familiarity with CI/CD pipelines for database code
• Experience with AWS services, particularly S3, Lambda, and Step Functions
• Knowledge of database security best practices
• Experience with data visualization tools (Tableau, Power BI)
• Background in mentoring junior developers or knowledge sharing
• Experience of front office investment risk and/or analytics systems

For starters, we'll offer you a comprehensive benefits package. We'll value your wellbeing and support your development. And we'll be as flexible as we can about where and when you work – finding a balance that works for all of us. It's all part of our commitment to making you feel motivated by the work you do and happy to be part of our team.