Data Engineer Sr Advisor

Little Ferry, NJ, United States

Job Description:

Type of Requisition:

Pipeline

Clearance Level Must Currently Possess:

None

Clearance Level Must Be Able To Obtain:

None

Suitability:

Public Trust/Other Required:

MBI (T2)

Job Family:

Data Science

Skills:

Job Qualifications:

Ab Initio, Ab Initio Extract Transform Load (ETL) Tool, Teradata SQL

Certifications:

Experience:

10 + years of related experience

US Citizenship Required:

No

Job Description:

Seize your opportunity to make a personal impact as a Data Engineer Sr Advisor supporting Data Asset Services. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career.

At GDIT, people are our differentiator. As a Data Engineer Sr Advisor you will be given the responsibility to perform ETL (extraction, transformation and load) application development/enhancement/maintenance in support of the Data Asset Services’ existing applications.

HOW A DATA ENGINEER SR ADVISOR WILL MAKE AN IMPACT

Application development and maintenance to provide direct support and technical assistance for remote support activities on a 24X7 on-call basis. Support includes but not limited to:

Systems/problem analysis, systems modification (coding)

Configuration management/change control

Test script writing.

Verification/validation of program changes (testing)

Application documentation and systems security safeguards in accordance with the client’s standards and guidelines.

Data modeling support as well as performance and tuning guidance to optimize ETL jobs and database queries including those queries/views that support Microstrategy reports utilized in the EDS Application.

Education:

WHAT YOU’LL NEED TO SUCCEED:

A degree from an accredited College/University in the applicable field of services is preferred, but not required

Required Experience:

10+ years of related professional experience

Required Technical Skills:

Demonstrated experience with Ab Initio ETL Coding in GDE

Demonstrated experience with Ab Initio Metadata Hub Lineage

Demonstrated experience with Ab Initio TRMC

Demonstrated experience with ANSI SQL and Teradata SQL extensions

Demonstrated experience with Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support

Demonstrated experience with Teradata Utilities for EDS Support

Demonstrated Azure/Databricks Support experience

Required Skills & Abilities:

Knowledge and experience with UNIX commands and concepts to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files.

Knowledge and experience Knowledge and experience with Linux Shell scripting to read and create driver scripts.

A working knowledge of how Ab Initio conducts data extract, transformations, and loading – especially to and from Teradata

Strong working knowledge of development of graphs, plans, PSETs and how to develop tests and debug.

Demonstrated experience with PDL scripting

Desired Skills & Abilities:

Strong knowledge of how Microstrategy and other OLAP tools interact with Teradata

Strong knowledge of the major competing Data Warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report queried, and unstructured data analysis

Strong klnowledge of Web API development

Strong knowledge of storing, reading, and analyzing streaming data – i.e., kafka, mqseries, or similar technologies, such as JMS

Strong knowledge of Cloud technology - developing and architecting

Security Clearance Level:

Must be able to obtain and maintain a Position of Trust and successfully pass a thorough Government background screening process requiring the completion of detailed forms and fingerprinting

The Public Trust security clearance for this program requires the selected candidate to have resided in the U.S. for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days in the past five years.

Location

Remote in the U.S.

On site in Raleigh, NC with a hybrid work schedule (3 days remote; 2 days in office)is preferred

GDIT IS YOUR PLACE:

Full-flex work week to own your priorities at work and at home

401K with company match

Comprehensive health and wellness packages

Internal mobility team dedicated to helping you own your career

Professional growth opportunities including paid education and certifications

Cutting-edge technology you can learn from

Rest and recharge with paid vacation and holidays

The likely salary range for this position is $122,366 - $204,360. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Scheduled Weekly Hours:

40

Travel Required:

None

Telecommuting Options:

Remote

Work Location:

Any Location / Remote

Additional Work Locations:

Total Rewards At GDIT:

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.

We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation’s most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

#J-18808-Ljbffr