SQL Server Data Integration Developer

AVER, LLC
Washington, DC, United States
5 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$120,000 - $145,000
Working hours
Regular working hours

Tech stack

HTML .NET Framework Microsoft Excel C Sharp (Programming Language) Code Review Databases Data Files Data Integration Extract Transform Load (ETL) Data Transformation Database Design Web Development
+9 more
Microsoft Visual Studio Microsoft Software Microsoft SQL Server Software Maintenance Transact-SQL Data Processing Semi-structured Data Windows Services SQL Server Management Studio (SSMS)

Job description

AVER is seeking a SQL Server Data Integration Developer to support 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.\n \n \nResponsibilities Include:\n \n \n \n

  • Analyze incoming CSV, Excel, HTML, and other structured or semi-structured data files to identify fields, data types, relationships, and quality issues. \n

  • Convert and standardize source files into approved CSV formats for database imports. \n

  • Create and modify SQL Server tables using approved database designs. \n

  • Modify and maintain existing C# Windows Services using .NET Framework 4.8 to automate data-loading processes. \n

  • Configure and troubleshoot SQL Server bulk imports, data transformations, and processing errors. \n

  • Validate source data, converted files, and SQL Server results to ensure accuracy and completeness. \n

  • Review code and data-processing procedures and provide technical guidance to other developers. \n

  • Maintain documentation and follow established client development standards and security restrictions. \n

Requirements

  • Hands-on experience with Microsoft SQL Server, T-SQL, and SQL Server Management Studio (SSMS) \n

  • Experience reading, modifying, and maintaining C# applications using .NET Framework, preferably 4.8 \n

  • Experience with data imports, ETL processes, file conversions, or batch data processing \n

  • Experience analyzing and transforming CSV, Excel, or other structured data files \n

  • Ability to troubleshoot database and application-processing issues \n

  • Experience working with Visual Studio and established Microsoft development environments. \n

  • Strong attention to detail and ability to work independently within defined technical procedures. \n

Benefits & conditions

  • Ability to obtain and maintain a government security clearance, active Top Secret preferred \n

  • This role supports a government agency which requires U.S. citizenship. \n

Compensation Package:\n \n \nAt 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.\n \n \nTarget Salary: $ 120,000.00 - $ 145,000.00 /yr.\n \n \nAbout Us:\n \n \nAVER, 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.\n \n \nAVER is an Equal Opportunity Employer/Veterans/Disabled

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…