Performance Data Engineer ETL

Performance Data Engineer (ETL)Location: Remote or Raleigh, NC (Preferred) Contract to Hire Pay: 60/hr on W2Overview Seize the opportunity to make a meaningful impact as a Performance Data Engineer supporting a key Federal agency. In this role, you will serve as a senior technical expert responsible for ETL performance optimization, Teradata data engineering, and modern cloud analytics enablement. You will work within the Data Asset Services organization, supporting mission-critical systems that operate at enterprise scale. Key ResponsibilitiesETL & Data Engineering • Design, develop, enhance, and maintain high-performance ETL applications supporting enterprise data assets. • Perform system analysis, coding, configuration management, change control, and application documentation. • Develop and execute test scripts, validate program changes, and implement security safeguards in compliance with government standards. • Provide direct technical assistance for application development and operational support. Teradata Performance Optimization (Primary Focus) • Serve as a subject-matter expert in Teradata performance tuning and optimization. • Analyze and act on SQL EXPLAIN plans to maximize use of Teradata’s massively parallel processing (MPP) architecture. • Leverage DBC Accounting and system tables to measure, analyze, and improve ETL and query performance. • Optimize SQL workloads supporting MicroStrategy and other reporting tools. • Provide data modeling expertise to ensure design decisions support optimal ETL and query performance. Cloud & Advanced Analytics • Lead the engineering of a scalable, cloud-based Unified Analytics Platform (UAP) built on Databricks and hosted in Microsoft Azure. • Support enterprise data governance, observability, and analytics modernization initiatives. • Contribute to the integration of on-premise and cloud-based data platforms. Operational Support • Participate in a 24×7 on-call rotation to support production environments. • Provide support for production server applications, ETL installations, and ongoing operational maintenance. • Ensure system reliability, performance, and availability to meet customer and business needs. Required QualificationsEducation • Bachelor’s degree in Computer Science or a related field (highly preferred). Experience • 15+ years of hands-on experience in data modeling, querying, and ETL development. Required Technical Skills • Expert-level Teradata SQL, including complex business logic embedded in queries. • Extensive experience with the Teradata Optimizer. • Proven ability to read and interpret Teradata EXPLAIN plans and implement performance improvements. • In-depth knowledge of DBC Accounting and system metrics for performance analysis. • Strong background in enterprise ETL application development and maintenance. Desired Skills & Experience • Experience with MicroStrategy or other OLAP/BI tools interacting with Teradata. • Knowledge of Ab Initio tools, architecture, and analytics (including GDE). • Strong understanding of data warehouse modeling techniques, including Third Normal Form (3NF) and Dimensional Modeling. • Experience with Web API development. • Knowledge of streaming data technologies (Kafka, MQSeries, JMS, or similar). • Experience designing or developing solutions in cloud environments, particularly Azure. Security & Clearance Requirements • Must be able to obtain and maintain a Public Trust clearance. • Must successfully complete a government background investigation, including fingerprinting. • U.S. residency requirement applies: • U.S. Citizens must not have resided outside the U.S. (including territories) for more than 6 consecutive months in the past 3 years (exceptions may apply). • Non-U.S. Citizens must not have resided outside the U.S. (including territories) for more than 90 consecutive days during the required period. About Seneca Resources: SenecaResources is client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry. Seneca Resources is a leading IT services provider with offices in Reston, Virginia, Alabama and Columbia, Maryland that service clients throughout the United States. The key to our success lies within our strong corporate culture which drives our business. We challenge our staff through engaging work, and we reward our staff through competitive compensation, extensive professional training, and excellent opportunities for career advancement. In turn, we look for only the best and brightest to join our team. We are an Equal Opportunity Employer and value the benefits of diversity in our workplace.