Senior SQL Developer & Data Integration Lead

Franklin Fitch; Dallas (TX); On-site; USD 150,000 - 190,000; Full time

Benefits offered by this job

Annual bonus

Retirement benefits

Health, dental, vision and life 보험

Flexible time off

Learning and development budget

Job summary

Franklin Fitch is seeking a talented SQL-focused engineer to own the integration layer for hedge fund clients. You can choose a hands-on SME path or lead a small team as a manager, shaping the role to match your strengths.

You'll design end-to-end ETL/ELT pipelines, build data APIs (Databricks, Snowflake, REST) and collaborate with DBAs to optimise performance, with a bonus opportunity and comprehensive benefits.

Qualifications

• 7+ years of software engineering with leadership experience.
• Advanced T-SQL skills and OLTP performance optimisation.
• Experience delivering data solutions across data warehouses/lakes and reporting.
• Authorization to work in the US without visa sponsorship.

Responsibilities

• Own end-to-end delivery of integrations from scoping to production support.
• Design and evolve ETL/ELT pipelines to load, normalise and version data across systems.
• Build data access APIs and platform endpoints (Databricks, Snowflake, REST).
• Set data quality standards with validation, audit trails and reconciliation.
• Collaborate with DBA on performance tuning of SQL Server objects.
• Build monitoring, runbooks and incident response.
• Mentor engineers and lead a small team when scoped to manager.
• Apply AI-enabled tools to speed up development and improve test coverage.

Skills

7+ years engineering leadership

Advanced T-SQL + data modelling

OLTP performance optimisation

ETL/ELT pipelines design

Data warehouses & lakes

REST APIs for data access

Tools

Databricks

Snowflake

SQL Server

REST API

Job description

Franklin Fitch is seeking a talented SQL-focused engineer to own the integration layer for hedge fund clients. You can choose a hands-on SME path or lead a small team as a manager, shaping the role to match your strengths.

You'll design end-to-end ETL/ELT pipelines, build data APIs (Databricks, Snowflake, REST) and collaborate with DBAs to optimise performance, with a bonus opportunity and comprehensive benefits.