Performance Data Engineer ETL

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 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. 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. 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 con About Seneca Resources: At Seneca Resources, we are more than just a staffing and consulting firm—we are a trusted career partner. With offices across the U.S. and clients ranging from Fortune 500 organizations to government agencies, we connect professionals with opportunities that drive meaningful impact and support long-term career growth. When you join Seneca, you gain a team committed to your success. We offer competitive compensation, comprehensive health, dental, and vision coverage, 401(k) plans, and continuous support throughout your assignment. Our recruiters and account managers invest in understanding your goals and placing you in roles aligned with your talents and ambitions. Seneca Resources is proud to be an Equal Opportunity Employer, dedicated to building a diverse and inclusive workplace where all qualified applicants are encouraged to apply.