Senior Software Engineer

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 USA (other states+not WA+Employee+Hybrid) Medical, Dental and Vision Insurance (Subsidized) Health Savings Account Flexible Spending Accounts (Healthcare, Dependent Care, Commuter) Short-Term and Long-Term Disability (Company Provided) Life and AD&D Insurance (Company Provided) Employee Assistance Program Unlimited access to LinkedIn learning solutions Matched 401(k) Retirement Savings Plan Paid Time Off Legal Plan and Identity Theft Protection Accident Insurance Employee Discounts Pet Insurance Employee Stock Purchase Program