Apply Now

Job Description:

Job Summary:
The Data Engineer will work with product owners and data stewards to deliver high quality technical solutions in response to business requirements. You will be counted on to provide your peers with technical expertise that will offer solutions for difficult programming problems.

Duties and Responsibilities:
SQL Server Integration Services (SSIS) including UI and custom code features.
Write or create stored procedures, SQL scripts, SSIS packages that can be used to:
Move data from source databases to target databases
Clean / Condition data
Convert or transform data
Reconcile and confirm converted data
Find data errors
Validate data to business rules
Ability to examine existing ETL scripts and track data back to source
SQL Server administration, tuning, and workbench.
Work with business experts to understand data and complete data mappings.
Focus on the development of extract, transform, and load (ETL) jobs currently using Microsoft SQL, Server, and SSIS.
The environment currently supports hundreds of related ETL jobs that move data between 30 different source systems and between multiple classifications.
Part of the challenge as a data engineer will be to find scalable and efficient coding solutions that plug into this extensible system in order to add more data to the Enterprise data store.
Other duties as assigned

Minimum Qualifications: (To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.)
Bachelor’s Degree in Statistics, Mathematics, Computer Science or another quantitative field
Equivalent years of experience in lieu of degree
4 years of relevant experience with the following software / tools:
Experience with Microsoft SQL
Prior experience supporting IC/DoD
The existing data warehouse is built on Microsoft SQL hosted on Amazon Web Services (AWS), so experience developing solutions that scale well in these environments is a plus.
Active Top-Secret Clearance with ability to obtain SCI

Knowledge, Skills and Abilities:
Ability to work independently and yet be effective within a team setting
Must be capable of managing multiple efforts with time related constraints in a fast-paced contracting environment
Demonstrated ability to effectively communicate and collaborate with diverse internal and external stakeholder groups and individuals
Friendly presence, helpful attitude, good interpersonal skills, and ability to work well with others.
Excellent skills in Microsoft Word, Excel, and other Office applications
Proficient with Microsoft Office Applications, and experience working in a home office setting as well as the ability to train end users on frequently asked technical issues.
Ability to provide technical assistance and support over the phone; good phone skills, professional demeanor, previous customer service experience strongly desired.