Business Intelligence $ Data Analytics Software EngineerReston, 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.
- Develop and maintain data transformation workflows using dbt.
- 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.
