Data Engineer | TS(SCI Eligible)

Job Description

Job Description

Connect Talent Solutions is a fast growing, innovative staffing firm offering direct placement, contract and contract to hire solutions. We are uniquely positioned and experienced to support your requirements from IT and engineering to general labor and customer service positions. At Connect, people are the center of our universe and we go to great lengths to ensure that our customers and candidates have the most enjoyable and informational hiring experience that will encourage and foster fruitful, long term relationships and careers.

Job Description :

In your role as data engineer, you will be assigned to an agile scrum team that focuses 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. 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. Experience with other data ingest pipelines such as NIFI is also desired as this contract is likely to evolve over the next 5 years to keep up with industry best practices.

In this role you 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.

Qualifications

Desired Core Skills :

• SQL Server Integration Services (SSIS) including UI and custom code

features.

Ability to write or create stored procedures, SQL scripts, SSIS packages

that can be used to :

o Move data from source databases to target databases

o Clean / Condition data

o Convert or transform data

o Reconcile and confirm converted data

o Find data errors

o Validate data to business rules

o Ability to examine existing ETL scripts and track data back to

source

Ability to work with business experts to understand data and complete

data mappings.

Preferable Secondary Skills :

disparate sources.

down large tasks into smaller story / point based tasks.

to databases and specifically.

Shell, PERL, Python).

of SQL to include SQL Server Integration Services, SSIS - (both Scale-

Out and non-Scale-Out)

length and performance.

understanding of monitoring the SSRS core database tables with

regards to report run- time and slow reporting performance.

Connect Talent Solutions is an Equal Opportunity Employer- Minorities / Females / Veterans / Individuals with Disabilities.  Individuals with disabilities, including disabled veterans or veterans with service-connected disabilities, are encouraged to apply.

Job Location : Springfield, VA