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 ResponsibilitiesReporting & 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 specificationsRequirements 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 requestsData 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 completenessDatabase 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 permissionsAdditional 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 informationMinimum RequirementsEach WingSwept employee is expected to adhere to our core values of being Honest, Eager, Accountable, Respectful, and a Team Player in all their interactionsMust be able to pass both Department of Defense and corporate criminal background checks and drug test. US citizenship is requiredHigh school diploma, secondary education preferredStrong SQL skills, including the ability to write and optimize complex MSSQL queriesExperience working with relational data models and mapping data between systemsExperience with data migration projects, from analysis through validationFamiliarity with database performance tuning, configuration, and security best practicesThree+ years of IT or related experienceGood verbal and written communication skills, including gathering requirements directly from customersStrong analytical and problem-solving skillsIf this sounds like a good fit for you, please apply today!Equal Opportunity Employer M/F/Disabled/Veteran