ETL Developer with Security Clearance

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.