DeveloperJobs.io
← Back to all jobs

Job Description

General Dynamics Information Technology is seeking a Senior Performance Data Engineer to support a Federal agency. This hybrid role in Raleigh, NC focuses on end-to-end ETL lifecycle work, ETL and query performance tuning, and the engineering of a scalable cloud-based Data Lakehouse platform.

Role Summary

This senior position includes performance data engineering responsibilities supporting production ETL workloads and database queries, with an emphasis on Teradata SQL and optimizer capabilities. Work also supports reporting needs within the EDS Application (including MicroStrategy reporting). The role requires 24x7 on-call remote support and eligibility to obtain and maintain a Public Trust clearance, including completion of detailed forms and fingerprinting. The position also has a U.S. residency requirement tied to the USPS security clearance process.

Responsibilities

  • Provide data modeling expertise and performance-tuning guidance to optimize ETL workloads and database queries, including queries 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 support enterprise data governance, observability, and operational value.
  • Perform application development and maintenance activities that provide direct technical assistance.
  • Deliver remote support on a 24×7 on-call basis, including support for production server applications, installation and upkeep of ETL solutions, and delivery of complementary services needed to meet customer and business needs.

Required Qualifications

  • Bachelor’s degree in Computer Science (or related field) is highly preferred.
  • 15+ years of hands-on experience in data modeling and querying.
  • Experience developing and maintaining applications providing ETL services in support of the Postal Data Asset Services group.
  • Significant Teradata optimizer experience is required.
  • Ability to read SQL “explain” plans and take action to effectively use the database engine’s massively parallel architecture.
  • Must have Teradata SQL experience, as business logic is embedded in queries.
  • Thorough understanding of DBC Accounting information to measure performance of application code.
  • Ability to obtain and maintain a Public Trust and successfully pass a government background screening process, including detailed forms and fingerprinting.
  • U.S. residency requirement for the USPS security clearance process: 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 exceptions apply). Non-U.S. Citizens cannot have left the U.S. (including U.S. Territories) for longer than 90 days (additional conditions apply as described in the screening process).

Technologies

  • Ab Initio
  • Ab Initio Extract Transform Load (ETL) Tool
  • Teradata SQL
  • Teradata optimizer
  • MicroStrategy
  • Databricks
  • Microsoft Azure
  • SQL “explain” plans
  • DBC Accounting
  • GDE (Graphical Development Environment)
  • Web API development
  • Kafka
  • MQSeries
  • JMS
  • JDBC

Key Skills for Success

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

Desired Skills and Abilities

  • Working knowledge of how MicroStrategy and other OLAP tools interact with Teradata.
  • Knowledge of Ab Initio tools, architecture, process, and analytics.
  • Working knowledge of major competing data warehouse modeling techniques, including Third-Normal-Form and Dimensional modeling, and how data modeling decisions affect ETL performance, structured report queries, and unstructured data analysis.
  • Working knowledge of GDE (Graphical Development Environment, used by Ab Initio).
  • Working knowledge of Web API development.
  • Working knowledge of storing, reading, and analyzing streaming data (for example, Kafka, MQSeries, or similar technologies such as JMS).
  • Working knowledge of cloud technology, including developing and architecting solutions.

Location

  • Raleigh, NC (preferred)
  • Remote considered

Travel Requirements

Travel required: None

Compensation

Salary range: USD 129,813 to 166,750 per year.

Identity Verification Process

  • Completion of an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud.
  • Requirement to be on camera during virtual interviews.
  • The company reserves the right to take a picture to verify identity and prevent fraud.
  • Authorization is required for the collection, processing, and use of biometric data for identity verification and security purposes.

Similar Jobs