Data and System Support Analyst

WingSwept; Garner (NC); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Employee stock ownership

Profit sharing

401(k) matching

Job summary

WingSwept is seeking a Database & Reporting Analyst in Garner, NC to strengthen data, reporting, and database capabilities for the CMTS across cloud-hosted and on-premise deployments. You will work with advanced SQL, data migration, and performance tuning to support government agencies investigating fraud and abuse.

Join a collaborative, employee-owned team that values precision and security; we offer strong benefits including stock ownership, profit sharing, and a fully-vested 401(k) with

Qualifications

• Pass Department of Defense and corporate background checks; US citizenship required.
• High school diploma; secondary education preferred.
• Strong SQL skills with the ability to write and optimize complex MSSQL queries.
• Experience 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.

Responsibilities

• Reporting & Report Development: Design and build complex custom reports using MSSQL queries for internal and external customers
• Requirements Gathering & Customer Collaboration: Meet directly with customers to gather reporting and statistical needs
• Data Migration: Analyze data from external and legacy systems to understand structure and quality
• Database Performance & Administration: Monitor and optimize MSSQL database performance
• Additional Responsibilities: Document data models, migration processes, and reporting procedures for team continuity

Skills

SQL development

MSSQL queries

Data migration

Relational data models

Reporting

Data analysis

Database performance tuning

Education

High school diploma

Job description

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 WingSwept 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