Senior ETL Development Engineer 5/30/2018

TACG, LLC Beavercreek, OH

Company
TACG, LLC
Location
Beavercreek, OH
AJE Ref #
581984002
Job Classification
Full Time
Job Type
Regular
Company Ref #
P_AAAAAAEAAADLiADwIK_mQa
Experience
Mid-Career (2 - 15 years)
Education
Bachelors Degree

JOB DESCRIPTION

APPLY
Senior ETL Development Engineer

Position Summary:

TACG is looking for a highly skilled, Senior ETL Development Engineer to assist in the development of an Operational Data Store (ODS) within our client s Common Computing Environment (CCE) Azure Cloud. The ODS will be used to ingest, stage, perform data quality and provide access to data in support of the Governments Supply Chain Planning reengineering efforts. This is a senior role that will help deploy data feeds for a new enterprise Advanced Planning and Scheduling capability. Activities will involve staging and analyzing data from the Government legacy environment and preparing it for use by a commercially hosted off the shelf solution. Tasks include source-to-target mapping, ETL design, metadata capture, feed scheduling and management, and ETL development using Azure SQL Database and SQL Server Integration Services (SSIS) with some refactoring of Basic Teradata Query (BTEQ) scripts and Informatica ETL.

ESSENTIAL JOB FUNCTIONS:

* Conduct or participate in meetings with key system owners to understand the Governments current data and systems environment

* Analyze source system data to assess data quality and work with technical and business representatives to determine strategies for handling identified data anomalies

* Design ETL processes and develop source to target data mappings

* Develop, test, and deploy ETL routines using ETL tools and external programming/scripting languages, as necessary

* Integrate ETL routines into production job streams

* Monitor and optimize the performance of the ETL routines and environment

* Administer and maintain the ETL environment, including performing configuration management activities related to the ETL environment

* Knowledge and experience with various operating systems (e.g., Unix, Linux, Windows Server)

* Use of software version control tools (i.e., Subversion)

* Understanding of Web Services

EDUCATION:

* Bachelor of Science or Arts is required

* Degree preferred in Computer Science, or related technical field

EXPERIENCE:

* 4+ years designing ETL processes and developing source-to-target mappings

* 4+ years experience developing, testing, and deploying ETL solutions

* Experience implementing database solutions in an Azure Cloud SQL environment

* Very strong SQL skills required

* Experience optimizing ETL routines and environments

* Experience administering and maintaining ETL environments

* Experience working in Agile environments is a strong plus

PREFERRED EXPERIENCE:

* 2-5 years of experience related to Information Technology capabilities related to acquisition, development, implementation and fielding within the Department of Defense (DoD)

* Microsoft Certified Solutions Expert (MCSE), specifically Data Platform

REQUIRED:

* Proficient in Microsoft Office suite

* Strong analytical and problem-solving skills

* Ability and desire to work in a fast-paced, team-based environment

* Ability to prioritize duties based on shifting demands

* Excellent verbal communication, technical writing, and collaboration skills with business and technical communities

* Excellent organizational skills and strong attention to detail

* DoD 8570.01-M Information Assurance Technical (IAT) Level II (e.g., Security+ CE)

* All applicants must be U.S. Citizens or Authorized to work in the United States

* All applicants must be able to complete and pass a background investigation and drug test

Work Environment:

* The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job

* Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

* All work will be performed in an office environment

Physical Requirements:

* The physical demands described here are representative of those that much 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

* The employee is frequently required to talk or listen. The employee is occasionally required to stand, walk; reach with hands and arms to stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by the job include close vision.

Citizenship: United States
Security Clearance: Currently NACLC, but SECRET required in future so must be clearable at that level.
Percent of Travel Required: Up to 10%
FLSA Status: Full-time, Exempt

TACG is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Overview

TACG is a Federally Recognized Alaskan Tribal 8(a) firm focused on the public sector and aerospace industries. Our corporate capabilities are: Information Technology, Logistics and Supply Chain, Financial Management, and Healthcare Management.

Our handpicked staff are the heartbeat of our diverse company, and we are proud to have many veterans at the core of our team.

In 2016 and 2017, TACG was honored on the Inc. 5,000. TACG has received the Alfred P. Sloan Award for Excellence in Workplace Effectiveness and Flexibility for 3 years running. TACG features an industry-leading competitive benefits package.


Company Size:
51-200 Employees
Industry
Consulting
Founded:
2006
Social Media: