Senior SQL Developer – Federal Data & BI Analytics

Sprymethods; Virginia (MN); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical Coverage

Dental Coverage

Vision Coverage

Paid Holidays

PTO accrual

Training Benefit

401(k) with company match

Job summary

Spry Methods is seeking a SQL Developer to support a DOJ FBI laboratory program. The role focuses on designing, developing, and maintaining T-SQL queries and SSIS-style scripts, with Power BI data modeling to enable enterprise reporting.

The ideal candidate has a TS clearance, strong SQL Server expertise, and experience migrating data to cloud platforms. You will thrive in a secure, collaborative environment delivering mission-critical data solutions.

Qualifications

• U.S. Citizenship with an active Top Secret clearance.
• 6+ years of relevant experience in SQL development and database administration.
• Bachelor’s degree in Computer Science, IT, or related field.
• Strong expertise in T-SQL development, performance tuning, and query optimization.
• Solid understanding of database architecture, design principles, and normalization.
• Proven ability to troubleshoot and resolve complex T-SQL performance problems.
• Strong communication, analytical, and organizational skills.
• Ability to work independently and collaboratively in a team environment.

Responsibilities

• Design, develop, optimize, and maintain complex T-SQL queries, stored procedures, functions, views, and scripts.
• Monitor and tune database performance through query optimization, indexing strategies, and execution plan analysis.
• Develop, manage, and optimize index management and statistics.
• Develop and optimize Power BI datasets and ensure integration with SQL data models.
• Develop and optimize Power BI DAX expressions for advanced reporting and analytics.
• Experience with complex data structures and data model design across units.
• Create entity relationship diagrams to aid data governance.
• Ensure database performance through proactive query optimization.

Skills

T-SQL

Communication

Analytical thinking

Organizational skills

Team collaboration

Education

Bachelor’s degree in CS/IT or related field

Tools

SQL Server

Power BI

AWS

Job description

Spry Methods is seeking a SQL Developer to support a DOJ FBI laboratory program. The role focuses on designing, developing, and maintaining T-SQL queries and SSIS-style scripts, with Power BI data modeling to enable enterprise reporting.

The ideal candidate has a TS clearance, strong SQL Server expertise, and experience migrating data to cloud platforms. You will thrive in a secure, collaborative environment delivering mission-critical data solutions.