We are seeking a highly analytical and data-focused Senior Software Engineer to play a pivotal role in our upcoming platform migration. This is a high-impact, data-intensive role requiring deep expertise in relational databases (Microsoft SQL Server and Sybase), complex data transformation, and meticulous data validation. You will work extensively with large datasets—including Index Histories—ensuring absolute data integrity, accuracy, and consistency as we modernize our technology stack. While prior financial index knowledge is a bonus, your ability to reverse-engineer legacy systems, map complex data models, and build robust migration solutions is essential. Req.#1105387855

Responsibilities Migration Leadership:

Lead and contribute to the end-to-end migration of index configurations and historical data from legacy platforms to the current BAU platform

System & Data Analysis:

Analyse existing index configurations and data structures to understand their mechanics and define the optimal migration strategy

Data Transformation:

Translate and convert configurations across different data models while strictly maintaining business requirements and data integrity

Database Engineering:

Leverage Microsoft SQL Server and Sybase to investigate, analyse, transform, validate, and move large-scale datasets (including Index Histories)

Data Quality & Reconciliation:

Perform detailed data validation and reconciliation to guarantee that migrated data is complete, accurate, and consistent. Identify data quality issues, root causes, and implement robust fixes

Development:

Write efficient, scalable SQL queries, stored procedures, and data transformation processes suitable for a production environment

System Investigation:

Explore existing applications and legacy systems to understand how data and configurations are processed

Collaboration & Communication:

Work closely with business analysts, engineers, and stakeholders to clarify requirements, resolve migration roadblocks, and communicate complex technical findings to both technical and non-technical audiences

Continuous Improvement:

Contribute to the automation, testing, and optimization of migration processes while mentoring and sharing knowledge with fellow engineers

Requirements Experience:

8+ years of professional experience in software engineering, data engineering, application development, or a closely related technical discipline

Database Expertise:

Strong, hands-on experience with

Microsoft SQL Server and Sybase SQL Mastery:

Advanced SQL skills, including complex queries, stored procedures, data analysis, and performance optimization

Big Data Handling:

Proven experience working with large, data-intensive, and complex datasets

Analytical Mindset:

Exceptional problem-solving skills with a track record of independently investigating unfamiliar systems, reverse-engineering data models, and designing mapping/transformation strategies

Migration Experience:

Demonstrated hands-on experience with data migration, transformation, reconciliation, or legacy-to-modern modernization projects

Quality Focus:

An uncompromising focus on data quality, accuracy, and integrity

Environment:

Experience working in an Agile software development lifecycle

Soft Skills:

Outstanding communication and interpersonal skills, with the ability to explain technical concepts clearly to diverse stakeholders Nice to have Experience within Index Management, financial indices, or broader financial markets Knowledge of index configuration and index lifecycle processes Experience with C# / .NET and familiarity with .NET applications Familiarity with UI technologies (Angular, JavaScript, HTML/CSS) Experience with PostgreSQL Exposure to cloud platforms such as AWS Experience with automated testing, CI/CD pipelines, Python, or Java/Spring Boot