Data Engineer Sr (ETL) Advisor-Raleigh, NC

Responsibilities for this Position

Location: USA NC Raleigh
Full Part/Time: Full time
Job Req: RQ211361

Type of Requisition:
Regular

Clearance Level Must Currently Possess:
None

Clearance Level Must Be Able to Obtain:
None

Public Trust/Other Required:
MBI (T2)

Job Family:
Data Science and Data Engineering

Job Qualifications:

Skills:
Ab Initio, Ab Initio Extract Transform Load (ETL) Tool, Teradata SQL
Certifications:
None
Experience:
15 + years of related experience
US Citizenship Required:
No

Job Description:

Seize your opportunity to make a personal impact as a Performance Data Engineer supporting a key Federal agency. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career.

The Data Asset Services organization is responsible for the full lifecycle of ETL (extract, transform, load) application development, enhancement, and maintenance. This includes system and problem analysis, coding and system modifications, configuration management and change control, test script development, validation of program changes, application documentation, and implementation of security safeguards in accordance with government standards.

HOW A PERFORMANCE DATA ENGINEER WILL MAKE AN IMPACT

• Provides data modeling expertise and performance-tuning guidance to optimize ETL workloads and database queries, including those supporting MicroStrategy reporting within the EDS Application.
• Lead the engineering of a scalable, cloud-based Data Lakehouse platform, known internally as the Unified Analytics Platform (UAP), powered by Databricks and hosted in Microsoft Azure to enhance enterprise data governance, observability, and operational value.
• Application development and maintenance efforts that provide direct technical assistance.
• Provide remote support on a 247 on-call basis. This will provide support for production server applications, installation and upkeep of ETL solutions, and the delivery of complementary services required to meet customer and business needs.

WHAT YOU'LL NEED TO SUCCEED:

Education:

• Bachelor's degree in Computer Science, or a related field is highly preferred.

Experience:

• 15+ years of hands-on data modeling and querying experience

Required Skills and Abilities:

• Focus on development and maintenance of applications providing ETL services in support of the Postal Data Asset Services group.
• Significant experience with the Teradata optimizer is required
• The ability to read SQL "explain" plans and take action to effectively utilize the massive parallel nature of the database engine.
• Must have Teradata SQL, due to business logic embedded in the queries.
• Must have a thorough understanding of the internal "DBC Accounting" information to effectively measure the performance of application code.

Desired Skills and Abilities:

• A working knowledge of how MicroStrategy and other OLAP tools interact with Teradata.
• Knowledge of Ab Initio tools, architecture, process and analytics
• A working 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.
• A working knowledge of GDE (Graphical Development Environment - used by Ab Initio)
• A working knowledge of Web API development.
• A working knowledge of storing, reading and analyzing streaming data - i.e., Kafka, MQSeries, or similar technologies, such as JMS.
• A working knowledge of Cloud technology - developing and architecting.

Location:

• Raleigh, NC (Preferred)
• Remote Considered

Security Clearance Level:

• Must be able to obtain and maintain a Public Trust and successfully pass a thorough Government background screening process requiring the completion of detailed forms and fingerprinting
• This position has a U.S. residency requirement. The USPS security clearance process requires the selected candidate to have resided in the U.S. (including U.S. Territories) for the last five years as follows: U.S. Citizens cannot have left the U.S. (including U.S. Territories) for longer than 6 months consecutively in the last 3 years (unless they meet certain exceptions). Non-U.S. Citizens cannot have left the U.S. (including U.S. Territories) for longer than 90 days consecutively in the last 3 years.

GDIT IS YOUR PLACE:

• 401K with company match
• Comprehensive health and wellness packages
• Internal mobility team is 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

#DataEngineer #qwe726

The likely salary range for this position is $140,250 - $189,750. 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:
USA NC Raleigh

Additional Work Locations:
Any Location / Remote

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 50 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.

Join our Talent Community to stay up to date on our career opportunities and events at
gdit.com/tc.

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans

PI280666994

Seize your opportunity to make a personal impact as a Performance Data Engineer supporting a key Federal agency. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career.


The Data Asset Services organization is responsible for the full lifecycle of ETL (extract, transform, load) application development, enhancement, and maintenance. This includes system and problem analysis, coding and system modifications, configuration management and change control, test script development, validation of program changes, application documentation, and implementation of security safeguards in accordance with government standards.



HOW A PERFORMANCE DATA ENGINEER WILL MAKE AN IMPACT

• Provides data modeling expertise and performance-tuning guidance to optimize ETL workloads and database queries, including those supporting MicroStrategy reporting within the EDS Application.
• Lead the engineering of a scalable, cloud-based Data Lakehouse platform, known internally as the Unified Analytics Platform (UAP), powered by Databricks and hosted in Microsoft Azure to enhance enterprise data governance, observability, and operational value.
• Application development and maintenance efforts that provide direct technical assistance.
• Provide remote support on a 247 on-call basis. This will provide support for production server applications, installation and upkeep of ETL solutions, and the delivery of complementary services required to meet customer and business needs.

WHAT YOU'LL NEED TO SUCCEED:



Education:

• Bachelor's degree in Computer Science, or a related field is highly preferred.

Experience:

• 15+ years of hands-on data modeling and querying experience

Required Skills and Abilities:

• Focus on development and maintenance of applications providing ETL services in support of the Postal Data Asset Services group.
• Significant experience with the Teradata optimizer is required
• The ability to read SQL "explain" plans and take action to effectively utilize the massive parallel nature of the database engine.
• Must have Teradata SQL, due to business logic embedded in the queries.
• Must have a thorough understanding of the internal "DBC Accounting" information to effectively measure the performance of application code.

Desired Skills and Abilities:

• A working knowledge of how MicroStrategy and other OLAP tools interact with Teradata.
• Knowledge of Ab Initio tools, architecture, process and analytics
• A working 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.
• A working knowledge of GDE (Graphical Development Environment - used by Ab Initio)
• A working knowledge of Web API development.
• A working knowledge of storing, reading and analyzing streaming data - i.e., Kafka, MQSeries, or similar technologies, such as JMS.
• A working knowledge of Cloud technology - developing and architecting.

Location:

• Raleigh, NC (Preferred)
• Remote Considered

Security Clearance Level:

• Must be able to obtain and maintain a Public Trust and successfully pass a thorough Government background screening process requiring the completion of detailed forms and fingerprinting
• This position has a U.S. residency requirement. The USPS security clearance process requires the selected candidate to have resided in the U.S. (including U.S. Territories) for the last five years as follows: U.S. Citizens cannot have left the U.S. (including U.S. Territories) for longer than 6 months consecutively in the last 3 years (unless they meet certain exceptions). Non-U.S. Citizens cannot have left the U.S. (including U.S. Territories) for longer than 90 days consecutively in the last 3 years.

GDIT IS YOUR PLACE:

• 401K with company match
• Comprehensive health and wellness packages
• Internal mobility team is 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