SQL Developer

Insight Global; Fort Mill (SC); On-site; USD 100,000 - 130,000; Full time

Job summary

Insight Global seeks a Senior SQL Developer to join the Index Delivery & Product team, focusing on migrating index configurations, calculations, and historical data to the firm's strategic index management platform.

The role is highly data-driven, requiring strong SQL development, data modelling, and migration execution skills. Collaboration with SMEs, product teams, and engineers is essential to ensure data quality and successful migrations.

Qualifications

• 5+ years of SQL development experience.
• Strong SQL development experience with Microsoft SQL Server and T-SQL.
• Experience working with Sybase databases.
• Proven experience analysing and working with large datasets.
• Experience supporting data migration, platform migration, or transformation projects.
• Ability to independently investigate complex technical and business problems.
• Experience using AI tools as part of the software development or data analysis lifecycle.
• Financial Services, Capital Markets, or Index Management experience.

Responsibilities

• Analyse existing index configurations, historical index data, and legacy structures to determine effective migration approaches.
• Map data between differing systems and data models during migration.
• Develop and optimise SQL solutions for large datasets and migrations.
• Validate migrated data with business SMEs and engineers to ensure accuracy.
• Lead migrations from discovery through completion with ownership of data quality and integrity.

Skills

SQL Development

Microsoft SQL Server

T-SQL

Sybase

Data Migration

Data Analysis

AI Tools in Analytics

Stakeholder Collaboration

Financial Services / Capital Markets

Tools

PostgreSQL

MySQL

C#/.NET

UI-based Applications

Job description

Insight Global is seeking a Senior SQL Developer to join the Index Delivery & Product team within a leading global financial markets organisation. This role sits within the Index Migration team and will focus on migrating index configurations, index calculation logic, and historical index data from legacy platforms onto the firm's strategic index management platform.

This is a highly data-focused role where the majority of your time will be spent analysing existing index structures, investigating data models, understanding calculation methodologies, and determining how index configurations and historical data should be mapped between systems. While exposure to .NET applications and UI-based platforms is beneficial, this is fundamentally a database engineering and data migration position rather than a traditional software development role.

The successful candidate will combine strong SQL development skills with exceptional analytical thinking, ownership, and problem-solving abilities. You will be trusted to drive migrations independently, make informed technical decisions, validate the accuracy of migrated data, and ensure the quality and integrity of business-critical index information.

This is an AI-first engineering environment where developers are encouraged to leverage AI tools responsibly to improve productivity, accelerate analysis, and support delivery, whilst maintaining full accountability for the quality, accuracy, and outcome of their work.

Day-to-Day

As a SQL Developer within the Index Migration team, you will be responsible for analysing existing index configurations, historical index data, and legacy platform structures to determine the most effective migration approach into LSEG's strategic platforms. You will work extensively with Microsoft SQL Server and Sybase databases, investigating complex data models, understanding how index calculations are performed, mapping data between differing systems, and validating historical index records. You will develop and optimise SQL solutions, perform large-scale data analysis, reconcile migrated data, and troubleshoot migration challenges throughout the lifecycle of each project. Working closely with business SMEs, product teams, and engineers, you will take ownership of individual migrations from discovery through completion, ensuring data quality, accuracy, and consistency at every stage.

Must Haves

5+ years of SQL Development experience

Strong SQL development experience working with Microsoft SQL Server, T-SQL development skills etc

Experience working with Sybase databases

Proven experience analysing and working with large datasets

Experience supporting data migration, platform migration, or transformation projects

Experience investigating existing systems and determining migration approaches

Experience mapping and transforming data between different data models

Ability to independently investigate complex technical and business problems

Experience working with business stakeholders to understand requirements and data relationships

Experience using AI tools as part of the software development or data analysis lifecycle

Financial Services, Capital Markets, or Index Management experience

Plusses

Experience working with Equity Indices or Index Calculation methodologies

Previous experience migrating historical datasets between platforms

Understanding of index configurations and index lifecycle management

Exposure to C#/.NET applications

Exposure to UI-based applications that sit alongside database platforms

Experience with legacy platform modernisation initiatives

Experience working with PostgreSQL or MySQL

Experience analysing and reconciling historical data spanning multiple years

Experience leveraging AI tools to improve analysis, validation, or engineering productivity