Senior Software Engineer

EPAM Systems; United States; On-site; USD 115,000 - 155,000; Full time

Job summary

EPAM Systems seeks a Senior Software Engineer to drive a platform migration, leveraging deep expertise in Microsoft SQL Server and Sybase to move large datasets and validate data integrity. You will reverse-engineer legacy systems, map complex data models, and implement robust migration solutions in a fast-paced, Agile environment.

The role emphasizes data transformation, analytical problem solving, and collaboration with business analysts and engineers to ensure accurate, scalable migration

Qualifications

• ,

Responsibilities

• Lead and contribute to end-to-end migration of index configurations and historical data
• Analyze existing index configurations and data structures to define migration strategy
• Translate and convert configurations across data models while maintaining data integrity
• Leverage SQL Server and Sybase to move large-scale datasets and validate results
• Perform data validation and reconciliation to ensure completeness and accuracy of migrated data
• Write efficient, scalable SQL queries, stored procedures, and data transformation processes
• Investigate legacy systems to understand data flows and processing
• Collaborate with analysts, engineers and stakeholders to clarify requirements and resolve roadblocks
• Contribute to automation, testing, and optimization of migration processes while sharing knowledge

Skills

SQL

Data analysis

Data migration

Data transformation

Relational databases

Problem solving

Agile

Communication

Tools

Microsoft SQL Server

Sybase

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