Job description

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

Requirements

Must-haves

We are seeking a highly analytical and data-focused Senior Software Engineer to play a pivotal role in our upcoming platform migration.
Req.#1105387855
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)
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
Continuous Improvement: Contribute to the automation, testing, and optimization of migration processes while mentoring and sharing knowledge with fellow engineers
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

Nice-to-haves

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.
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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagileangularjavascriptawsci/cdpythonjava

Platform: epam
Effort: medium