Develop advanced, high-performance SQL queries across large, complex datasets (multi-table joins, window functions, aggregations)
Optimize query performance using execution plans, indexing strategies, and query refactoring
Ensure data accuracy and integrity across reporting datasets
Troubleshoot and resolve data issues across database and application layers
Shape and structure data for efficient and intuitive dashboard visualization
Collaborate with ETL engineers and dashboard developers to ensure reliable, end-to-end data delivery

Requirements

Bachelor’s degree with 8–12 years of experience, or Master’s with 6–10 years of experience
U.S. Citizenship
Active TS/SCI with the ability to successfully pass a Polygraph
Expert-level SQL skills, including:
Complex joins across large datasets
Query optimization and execution plan analysis
Aggregations, subqueries, and window functions
Strong experience with relational databases (PostgreSQL, MySQL, Oracle, or similar)
Experience working with large-scale data supporting analytics/reporting
Proficiency in Linux environments
Ability to work independently and solve complex data challenges.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLquery optimizationexecution plan analysismulti-table joinswindow functionsaggregationssubqueriesrelational databasesPostgreSQLMySQL

Soft Skills

problem-solvingindependencecollaboration

Certifications

Bachelor's degreeMaster's degreeTS/SCI clearance