DescriptionAVER is seeking a Data Integration & Application Support Specialist to manage and maintain established data-processing reporting applications for the Department of Homeland Security (DHS). Analyze incoming data files, prepare and import data into SQL Server, and modify existing C# Windows Services built on .NET Framework 4.8 and perform data integration and application maintenance. This role will not require hands on modern .Net web application development, instead you will troubleshoot data issues in MS SQL and maintaining established Microsoft technologies utilizing C#, .NET Framework 4.8, Windows Services, and SQL Server. Maintain and adapt existing code, process incoming datasets, and support reliable database imports for improved reporting functionality in a prominent OCIO at the Department of Homeland Security. Join a collaborative team who values AVER's mission, focus, and culture of delivering exceptional client service with great people and transformative technology solutions that ensure Government mission success.
Responsibilities Include
- Process data received from external providers, converting various file formats, troubleshooting data issues, and importing information into SQL Server
- Analyze incoming CSV, Excel, HTML, and other structured or semi-structured data files to identify fields, data types, relationships, and quality issues
- Convert and standardize source files into approved CSV formats for database imports.
- Create and modify SQL Server tables using approved database designs
- Modify and maintain existing C# Windows Services using .NET Framework 4.8 to automate data-loading processes
- Configure and troubleshoot SQL Server bulk imports, data transformations, and processing errors
- Validate source data, converted files, and SQL Server results to ensure accuracy and completeness
- Review code and data-processing procedures and provide technical guidance to other developers
- Maintain documentation and follow established client development standards and security restrictions
Required Experience
- Hands-on experience with Microsoft SQL Server, T-SQL, and SQL Server Management Studio (SSMS)
- Experience reading, modifying, and maintaining C# applications using .NET Framework, preferably 4.8
- Experience with data imports, ETL processes, file conversions, or batch data processing
- Experience analyzing and transforming CSV, Excel, or other structured data files
- Ability to troubleshoot database and application-processing issues
- Experience working with Visual Studio and established Microsoft development environments
- Strong attention to detail and ability to work independently within defined technical procedures
- Experience working in federal space with understanding of processes, procedures and timelines would be important to adapt and manage cadence of the role
- Proactive, attentive, and patient to ask questions or identify technical requirements that may not yet be fully formulated
- Ability to work directly with customer and set the cadence for development, timelines, define schedule and communicate progress- GitHub or Azure DevOps documentation maybe beneficial for requirements and tracking status through to completion.
- Ability to solicit feedback at each stage of the process independently, as well as pivot to achieve vision of CIO office
Desired Experience
- C# Windows Services and Windows Server
- SQL Server bulk-loading techniques
- Legacy application maintenance and support
- Experience working in restricted Federal Government environments
Location:
- Washington, DC
- ON SITE- 5 days per week
Security Requirements:
- Ability to obtain and maintain a government security clearance, active Top Secret preferred
- This role supports a government agency which requires U.S. citizenship.
Compensation Package:
At AVER, we believe our people are the foundation of our success and are committed to providing meaningful work, competitive compensation, and a supportive environment where employees can grow while making a direct impact on critical Government missions. AVER offers a competitive total compensation package designed to support our employees both professionally and personally. Eligible employees receive a comprehensive benefits package that includes health and wellness coverage, paid time off and holidays, retirement benefits, and opportunities for career growth.
Target Salary: $ 120,000.00 - $ 145,000.00 /yr.
About Us:
AVER, LLC is a Data & Digital Transformation company that delivers exceptional client service with great people and transformative technology solutions to enable Government mission success. We provide customers with specialized technical skills and deep subject matter expertise focused on Homeland Security, Biometrics, Law Enforcement and Healthcare domains to meet the complex mission challenges today and tomorrow. We are a verified Service-Disabled Veteran-Owned Small Business (SDVOSB) that strives to provide a customer-centric experience building trusted partnerships with our clients and people.
AVER is an Equal Opportunity Employer/Veterans/Disabled
