Lead Data Platform Engineer - SQL Server VLDB Specialist

Citi; Irving (TX); On-site; USD 126,000 - 189,000; Full time

Benefits offered by this job

Medical, dental & vision coverage

401(k)

Life, accident & disability insurance

Wellness programs

Paid time off & holidays

Job summary

Citi is seeking a Lead Data Platform Engineer in Irving, TX, to lead VLDB projects and SQL Server optimization within a Microsoft BI ecosystem. You will mentor junior engineers and drive robust data pipelines that deliver high-quality business insights.

The role emphasizes data modeling, security (TDE), and AI-assisted development to improve code quality and performance, with collaboration across a DBA team.

Qualifications

• 6+ years of apps development or systems analysis with SQL Server expertise.
• VLDB experience: develop/optimize VLDB solutions in SQL Server 2019+.

Responsibilities

• VLDB management: develop, optimize VLDB SQL Server solutions.
• Performance tuning: query optimization, indexing, performance improvements.
• Collaborate with DBA team to ensure best practices and reliability.
• Lead data loading & ETL using Microsoft BI tools; mentor ETL developers.

Skills

SQL Server

VLDBs

Performance tuning

Data modeling

ETL architecture

Microsoft BI (SSIS/SSAS)

NoSQL (MongoDB/CouchDB)

Security (TDE)

AI-assisted development

Leadership & mentoring

Project management

Communication

Python/PySpark (nice to have)

Education

Bachelor’s degree or equivalent

Master’s degree preferred

Tools

SSIS

SSAS

Job description

Citi is seeking a Lead Data Platform Engineer in Irving, TX, to lead VLDB projects and SQL Server optimization within a Microsoft BI ecosystem. You will mentor junior engineers and drive robust data pipelines that deliver high-quality business insights.

The role emphasizes data modeling, security (TDE), and AI-assisted development to improve code quality and performance, with collaboration across a DBA team.