- Location
- Garner, NC, US
- Department
- Customer Service
- Education
- High School
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
