Data Engineer

Location
Springfield, Virginia
Posted
Sep 11, 2020
Closes
Oct 16, 2020
Ref
2000001203
Function
Administrative
Hours
Full Time
Description

NJVC, LLC

Company Job Title: Data Engineer

Clearance: Top Secret with ability to obtain SCI

Location: Springfield, VA

Reports To: Program Manager

FLSA Status: Exempt, Full Time, Regular

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.

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.

Work Environment: (The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.)
  • The employee will normally work in a temperature-controlled office environment, with frequent exposure to electronic office equipment.
  • During visits to areas of operations, may be exposed to extreme cold or hot weather conditions. Is occasionally exposed to fumes or airborne particles, toxic or caustic chemicals, and loud noise.

Chenega Corporation and family of companies is an EOE.

Equal Opportunity Employer/Veterans/Disabled

Native preference under PL 93-638.

We participate in the E-Verify Employment Verification Program.

Primary Location: United States-Virginia-Springfield

Organization: NJVC
Strategic Business Unit: Military Intelligence and Operations Support
Security Requirements: Top Secret
Job Schedule: Full Time Exempt
Recruiter: Jonas Patterson
Req ID: 2000001203

Similar jobs