SQL Engineer SME

Leidos•St. Louis, MO

1d•Onsite

About The Position

This is an opportunity for a SQL Engineer SME to support a highly visible, data-driven application that powers analytics and reporting across the organization. The role is for cleared engineers ready for real impact, who take pride in their craft and deliver results seen by senior leaders. In this role, you’ll write complex queries, shape data for dashboards, optimize performance at scale, and deliver high-quality datasets that stakeholders rely on every day. The primary development team operates out of Gaithersburg, MD, with support for onsite engineers in Alexandria, VA; Chantilly, VA; Aurora, CO; St. Louis, MO; and Tucson, AZ. This position stands out due to its high impact on real-time decision-making, high visibility through partnerships with engineering teams and key stakeholders, career growth opportunities in large-scale data systems and performance optimization, and challenging work tackling complex data problems.

Requirements

Bachelor’s degree with 12-15 years of experience, or Master’s with 10-13 years of experience. May possess a Doctorate in technical domain
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

Nice To Haves

Experience with Grafana or similar visualization tools
Python for data manipulation (pandas, scripting, automation)
Experience with materialized views, caching strategies, or query acceleration techniques

Responsibilities

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