SQL Server Data Integration Developer (On-site DC)

AVER, LLC; Washington (District of Columbia); On-site; USD 120,000 - 145,000; Full time

Job summary

AVER, LLC is seeking a SQL Server Data Integration Developer to support data-processing reporting applications for the Department of Homeland Security (DHS). You will analyze incoming data files, prepare and import data into SQL Server, and modify existing C# Windows Services built on .NET Framework 4.8 to maintain established Microsoft technologies.

You will troubleshoot data issues in MS SQL and ensure reliable database imports to improve reporting for a prominent OCIO at DHS.

Qualifications

• Hands-on experience with MS SQL Server, T-SQL, and SSMS.
• Experience reading, modifying, and maintaining C# applications on .NET Framework (preferably 4.8).
• Experience with data imports, ETL, file conversions, or batch data processing.

Responsibilities

• Analyze incoming CSV, Excel, HTML, and other 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 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 for accuracy.

Skills

T-SQL

SQL Server

SSMS

C#

.NET Framework 4.8

ETL

Data imports

Batch processing

Visual Studio

Windows Services

Tools

Visual Studio

SSMS

Windows Server

Job description

AVER, LLC is seeking a SQL Server Data Integration Developer to support data-processing reporting applications for the Department of Homeland Security (DHS). You will analyze incoming data files, prepare and import data into SQL Server, and modify existing C# Windows Services built on .NET Framework 4.8 to maintain established Microsoft technologies.

You will troubleshoot data issues in MS SQL and ensure reliable database imports to improve reporting for a prominent OCIO at DHS.