Job Requirements Reston, VA Top Secret/SCI CI Polygraph Mid Level Career (5+ yrs experience) $160,000 - $180,000 Job Description ETL Developer Reston, VA 20190
Security Clearance Requirement:
TS/SCI CI
Poly Location Note:
On-Site Support Required Position Description:
Working within a collaborative government and contractor team, the successful candidate will support an enterprise data warehouse environment by developing business intelligence solutions, optimizing data processes, supporting complex data analytics and reporting, and delivering responsive customer support. The ideal candidate combines strong technical expertise with outstanding analytical, communication, and customer service skills.
Duties and responsibilities:
Design and develop ETL processes Design, develop, and maintain reliable ETL/ELT data pipelines. Write complex and optimized SQL queries for data extraction, transformation, and analysis. Build and maintain dbt models, sources, tests, snapshots, and documentation. Convert existing PL/SQL procedures into SSIS packages Troubleshoot existing ETL solutions Education and qualifications: U.S. Citizenship. Active TS/SCI security clearance. Current CI Polygraph or ability to obtain one. Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical discipline (or equivalent experience). Demonstrated experience developing and supporting enterprise software applications. 5 years of ETL Development experience Strong experience with SQL and PL/SQL development. Experience with Oracle Database, MariaDB, or comparable relational database platforms. Experience supporting enterprise data warehouse environments and ETL processes. Strong analytical, troubleshooting, and problem-solving skills. Ability to work effectively in a fast-paced, customer-focused environment. Excellent written and verbal communication skills. Experience developing technical documentation and supporting software testing activities.
Preferred Qualifications:
Experience with IBM DataStage ETL. Knowledge of Federal financial management or acquisition systems. Experience supporting Intelligence Community or other federal agencies. Experience with enterprise system interfaces and data integration. Experience with data analytics, reporting, and performance optimization.