Data Integration & Application Support Specialist

AVER 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 IncludeProcess data received from external providers, converting various file formats, troubleshooting data issues, and importing information into SQL ServerAnalyze incoming CSV, Excel, HTML, and other structured or semi-structured data files to identify fields, data types, relationships, and quality issuesConvert and standardize source files into approved CSV formats for database imports. Create and modify SQL Server tables using approved database designsModify and maintain existing C# Windows Services using .NET Framework 4.8 to automate data-loading processesConfigure and troubleshoot SQL Server bulk imports, data transformations, and processing errorsValidate source data, converted files, and SQL Server results to ensure accuracy and completenessReview code and data-processing procedures and provide technical guidance to other developersMaintain documentation and follow established client development standards and security restrictionsRequired ExperienceHands-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.8Experience with data imports, ETL processes, file conversions, or batch data processingExperience analyzing and transforming CSV, Excel, or other structured data filesAbility to troubleshoot database and application-processing issuesExperience working with Visual Studio and established Microsoft development environmentsStrong attention to detail and ability to work independently within defined technical proceduresExperience working in federal space with understanding of processes, procedures and timelines would be important to adapt and manage cadence of the roleProactive, attentive, and patient to ask questions or identify technical requirements that may not yet be fully formulatedAbility 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 ExperienceC# Windows Services and Windows ServerSQL Server bulk-loading techniquesLegacy application maintenance and supportExperience working in restricted Federal Government environmentsLocation:Washington, DCON SITE- 5 days per weekSecurity Requirements:Ability to obtain and maintain a government security clearance, active Top Secret preferredThis 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