ETL DEVELOPER (CI POLYGRAPH REQUIRED)

NorthHill Technology Resources LLC; Reston (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

NorthHill Technology Resources LLC is seeking a skilled BI and Data Analytics Software Engineer to support an enterprise data warehouse with BI solutions, ETL pipelines, and advanced data analytics in a fast-paced, customer-focused government contractor setting.

The ideal candidate will design and optimize ETL/ELT workflows, develop dbt models, and write complex SQL for data extraction and analysis, while collaborating with a cross-functional team to deliver reliable data services on-site in

Qualifications

• 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.

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

Skills

ETL Development

SQL/PLSQL

Data warehousing

Analytical thinking

Education

Bachelor's degree in Computer Science or related field

Tools

dbt

SSIS

Oracle

MariaDB

Job description

Business Intelligence $ Data Analytics Software Engineer

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.


• 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'sdegree 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 andETLprocesses.


• 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 DataStageETL.


• 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.