Data and System Support Analyst

WingSwept is an award-winning, employee-owned technology services company seeking a Database & Reporting Analyst within our application development division, to strengthen data, reporting, and database capabilities for our Case Management and Tracking System (CMTS) across both cloud-hosted and on-premise deployments.

This position combines advanced SQL development, data migration, requirements gathering, and database performance tuning to support government agencies investigating fraud and abuse. Compensation for this position includes competitive base pay and excellent benefits, including employee stock ownership, profit sharing, and a fully-vested 401(k) with matching contributions.

Primary Responsibilities

• Reporting & Report Development Design and build complex custom reports using MSSQL queries for internal and external customers Develop and maintain deep expertise in CMTS's data model to support advanced reporting requests Build queries within the application to support custom data sets, extracts, and notifications Translate customer reporting and statistical requirements into technical report specifications

Requirements

• Gathering & Customer Collaboration Meet directly with customers to gather reporting and statistical needs Clarify ambiguous or incomplete requirements through follow-up discussion with stakeholders Communicate technical concepts and tradeoffs clearly to non-technical customers Partner with the team to scope effort and timelines for report and data requests
• Data Migration Analyze data from external and legacy systems to understand structure and quality Map external data sources into the CMTS data model Write complex queries to extract, transform, and load migrated data Validate and test migrated data for accuracy and completeness
• Database Performance & Administration Monitor and optimize MSSQL database performance Identify poor-performing queries and recommend or implement tuning solutions Review and adjust database configuration settings Maintain and audit database security settings and access permissions
• Additional

Responsibilities

• Support other technical initiatives across the team as needed Investigate new tools, technologies, and techniques to improve data and reporting processes Document data models, migration processes, and reporting procedures for team continuity Maintain confidentiality of client data and sensitive information

Minimum Requirements

• Each Wing
• Swept employee is expected to adhere to our core values of being Honest, Eager, Accountable, Respectful, and a Team Player in all their interactions
• Must be able to pass both Department of Defense and corporate criminal background checks and drug test.
• US citizenship is required
• High school diploma, secondary education preferred
• Strong SQL skills, including the ability to write and optimize complex MSSQL queries
• Experience working with relational data models and mapping data between systems
• Experience with data migration projects, from analysis through validation
• Familiarity with database performance tuning, configuration, and security best practices
• Three+ years of IT or related experience
• Good verbal and written communication skills, including gathering requirements directly from customers
• Strong analytical and problem-solving skills
• If this sounds like a good fit for you, please apply today!

Equal Opportunity Employer

M/F/Disabled/Veteran