Data Engineer

Springfield, Virginia
Dec 16, 2020
Jan 16, 2021
Full Time

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 tosource
  • SQL Server administration, tuning, and workbench.
  • Work with business experts to understand data and completedata 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.

Good problem-solving skills; ability to visualize a problem/situation and think abstractly to solve it

Physical Demands: (The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
  • While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is frequently required to walk; use hands to finger, handle, or feel and reach with hands and arms. The employee is occasionally required to stand; climb or balance and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision.


Similar jobs