SQL Developer

Job Description

Snr SQL Developer

Client: LSEG
Start Date: ASAP
Location: Fort Mill , 3 days a week onsite
Contract: 12 MONTHS
Bill Rate: $1,140 / day - $142.5 / HR
Open Roles: 3

Interview Process
Stage 1: 30-minute team interview
Stage 2: 30min Final interview with Hiring Manager

Interview times:
1st round: Wed after 12pm
2nd: 2pm Thursday or 3pm onwards friday
Location: Fort Mill, SC (Hybrid, 3 Days Onsite)
Contract Length: 12-Month Contract
Hours: 40 Hours Per Week
Hiring Manager: Simon Miller

Interview Process
Round 1 - Codility Assessment
SQL Development
Data Analysis
Database Problem Solving
Round 2 - Technical Problem Solving
Pseudocode exercises
SQL-based scenarios
Data investigation exercises
Migration and analytical thinking assessment
Round 3 - Engineering & Delivery Discussion
Technical decision-making
Quality assurance approach
Testing and validation methodology
Ownership and problem-solving mindset
Migration approach and implementation strategy
Final Round - Culture & Team Fit
Collaboration style
Ownership mindset
Communication skills
Ability to operate independently
Alignment with team values

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

Skills and Requirements

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

Key Screening Questions
Tell me about the largest SQL-focused project you've worked on. What was your involvement and what challenges did you face?
Have you worked on any data migration or platform migration projects? Walk me through your approach.
What experience do you have with SQL Server and Sybase databases?
How do you validate and reconcile data after a migration?
Tell me about a time you had to investigate a complex data issue with limited documentation.
How do you approach understanding an unfamiliar data model or business process?
Have you worked with financial data, market data, or index-related products before?
How have you used AI tools to improve productivity, analysis, or delivery in your day-to-day work?

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].