GDIT is looking to solve the problem of providing services to federal civilian agencies to help the government ensure the well-being of U.S. citizens, specifically in the area of data engineering and ETL application development, enhancement, and maintenance.
Requirements
- Ab Initio
- Ab Initio Extract Transform Load (ETL) Tool
- Teradata SQL
- SHARE
- 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.
Responsibilities
- 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 24×7 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.
- 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
- Must have Teradata SQL, due to business logic embedded in the queries.
Other
- Bachelor’s degree in Computer Science, or a related field is highly preferred.
- 15+ years of hands-on data modeling and querying experience
- 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
- Travel Required: None
