Senior Software Engineer

EPAM Systems; Fort Mill (SC); On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, Dental and Vision Insurance (

401(k) Retirement Savings Plan

Paid Time Off

Employee Discounts

Employee Stock Purchase Program

Life Insurance

Job summary

EPAM Systems seeks a highly analytical Senior Software Engineer to lead a critical platform migration, focusing on large-scale data transformation and preserving data integrity across MS SQL Server and Sybase.

You will reverse-engineer legacy data models, map configurations to the new BAU platform, and drive robust migration solutions with cross-functional teams in an Agile environment. Strong communication and collaboration are essential.

Qualifications

• 8+ years of professional experience in software engineering, data engineering, or related technical discipline.
• Hands-on experience with MS SQL Server and Sybase.
• Strong SQL skills including complex queries, stored procedures, and performance optimization.
• Experience with data migration, transformation, reconciliation, or legacy-to-modern modernization projects.

Responsibilities

• Lead end-to-end migration of index configurations and historical data.
• Analyze existing configurations and data structures to define the migration strategy.
• Translate configurations across data models while preserving business requirements.
• Validate migrated data for completeness and integrity, with issue root-cause analysis.
• Develop scalable SQL queries and transformation processes for production use.
• Investigate legacy systems to understand data processing paths.
• Collaborate with analysts, engineers, and stakeholders to resolve roadblocks.
• Contribute to automation, testing, and optimization of migration workflows.

Skills

SQL

Migration

Data Transformation

Data Quality

Reverse Engineering

Tools

Microsoft SQL Server

Sybase

PostgreSQL

C# / .NET

Python/Java

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.#1105387855ResponsibilitiesMigration Leadership: Lead and contribute to the end-to-end migration of index configurations and historical data from legacy platforms to the current BAU platformSystem & Data Analysis: Analyse existing index configurations and data structures to understand their mechanics and define the optimal migration strategyData Transformation: Translate and convert configurations across different data models while strictly maintaining business requirements and data integrityDatabase 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 fixesDevelopment: Write efficient, scalable SQL queries, stored procedures, and data transformation processes suitable for a production environmentSystem Investigation: Explore existing applications and legacy systems to understand how data and configurations are processedCollaboration & 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 audiencesContinuous Improvement: Contribute to the automation, testing, and optimization of migration processes while mentoring and sharing knowledge with fellow engineersRequirementsExperience: 8+ years of professional experience in software engineering, data engineering, application development, or a closely related technical disciplineDatabase Expertise: Strong, hands-on experience with Microsoft SQL Server and SybaseSQL Mastery: Advanced SQL skills, including complex queries, stored procedures, data analysis, and performance optimizationBig Data Handling: Proven experience working with large, data-intensive, and complex datasetsAnalytical Mindset: Exceptional problem-solving skills with a track record of independently investigating unfamiliar systems, reverse-engineering data models, and designing mapping/transformation strategiesMigration Experience: Demonstrated hands-on experience with data migration, transformation, reconciliation, or legacy-to-modern modernization projectsQuality Focus: An uncompromising focus on data quality, accuracy, and integrityEnvironment: Experience working in an Agile software development lifecycleSoft Skills: Outstanding communication and interpersonal skills, with the ability to explain technical concepts clearly to diverse stakeholdersNice to haveExperience within Index Management, financial indices, or broader financial marketsKnowledge of index configuration and index lifecycle processesExperience with C# / .NET and familiarity with .NET applicationsFamiliarity with UI technologies (Angular, JavaScript, HTML/CSS)Experience with PostgreSQLExposure to cloud platforms such as AWSExperience with automated testing, CI/CD pipelines, Python, or Java/Spring BootWe offerMedical, Dental and Vision Insurance (Subsidized)Health Savings AccountFlexible Spending Accounts (Healthcare, Dependent Care, Commuter)Short-Term and Long-Term Disability (Company Provided)Life and AD&D Insurance (Company Provided)Employee Assistance ProgramUnlimited access to LinkedIn learning solutionsMatched 401(k) Retirement Savings PlanPaid Time OffLegal Plan and Identity Theft ProtectionAccident InsuranceEmployee DiscountsPet InsuranceEmployee Stock Purchase ProgramEPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our clients, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.Engineer the Future with a Career at EPAMApplications will be accepted on a rolling basis.EPAM will not provide new H-1B visa sponsorship for this position. Candidates with existing transferable H-1B status may be considered.