About the Opportunity

Title Senior Data Engineer I

Department ISS

Location Bengaluru

Reports To Data Engineers - Lead

Level 5

We share a commitment to making things better for clients and each other. We continually explore new technology and different ways of working to put our clients first. So, bring your boldest ideas to our team and feel like you are making progress.

CSP Data Engineering Chapter is an engineering group that supports the CSP Platform.

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.

This role is appropriate for a senior data aengineer 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

• 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
• Design and 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
• Establish documentation standards and ensure comprehensive system documentation
• Lead troubleshooting efforts and resolve complex database performance issues
• Design and implement integrations between Oracle systems and cloud services, particularly AWS S3
• Lead code reviews and establish best practices for database development
• Design and implement data migration strategies from legacy systems to modern cloud-based solutions
• Work within an Agile framework, taking a leadership role in sprint planning and technical discussions

Required Qualifications:

• 8-12 years of experience with Oracle databases, including advanced SQL and PL/SQL development
• Strong knowledge of data modelling principles and database design patterns
• Proficiency with Python for data processing and automation
• Extensive experience implementing and maintaining data quality controls
• Proven ability to reverse engineer existing database schemas and understand complex data relationships
• Strong experience with version control systems, preferably Git/GitHub
• Excellent written communication skills for technical documentation
• Demonstrated ability to work within and help guide Agile development methodologies
• Strong knowledge of investment management industry concepts, particularly security reference data, fund reference data, transactions, orders, holdings, and fund accounting

Additional Qualifications:

• Knowledge of SQL Server development
• Experience with ETL tools like Informatica and Control-M
• Unix shell scripting skills for data processing
• Experience with CI/CD pipelines for database code
• Familiarity with AWS services, particularly S3, Lambda, and Step Functions
• Knowledge of database security best practices
• Experience with data visualization tools (Tableau, Power BI)
• Experience mentoring junior developers

Feel rewarded

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. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.

For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.