Data Engineer

careers-fedwriters; Bailey's Crossroads (VA); Hybrid; USD 115,000 - 125,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Long-term and Short-term Disability

Life Insurance

401(k) Plan

Holiday Pay

Paid Time Off

Job summary

FWI is hiring a Data Engineer to design, build, and maintain enterprise data pipelines for the National Guard analytics program, using Databricks, Spark, and SQL to enable governance and scalable analytics.

Based in the National Capital Region with a hybrid schedule (1–2 days on site), you will partner with data scientists, analysts, and government stakeholders to deliver timely, accurate data for decision support while upholding regulatory and security requirements.

Qualifications

• Active DoD Secret clearance (final, in current scope).
• Bachelor's or Master's degree in a related field.
• 3+ years of directly related experience as a Data Engineer.
• Proficiency in ETL processes with Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks.
• Demonstrated experience with large datasets and big data technologies.
• Knowledge of data modeling, visualization, governance, and regulatory practices.
• Based in the National Capital Region or willing to relocate, able to report to Arlington site.
• U.S. citizenship is required for the clearance.

Responsibilities

• Design, develop, and implement end-to-end data pipelines using ETL processes and technologies including Databricks, Python, Spark, Scala, JavaScript/JSON, and SQL
• Build and optimize pipelines from scratch with scalability, reliability, and high-performance processing
• Collaborate with cross-functional teams to understand data requirements and design models/architectures
• Perform data cleansing, integration, and quality assurance on large datasets
• Apply big data technologies to process and analyze data efficiently
• Partner with data scientists, analysts, and government stakeholders to deliver timely, accurate data for decision-making
• Troubleshoot complex data problems and develop practical solutions
• Implement and enforce data governance policies ensuring regulatory compliance

Skills

Databricks

Python

Spark

Scala

JavaScript/JSON

SQL

Jupyter Notebooks

Education

Bachelor's or Master's degree in a related field

Tools

Databricks

Palantir Foundry

Jupyter Notebooks

Job description

Overview

Most data engineering jobs are maintenance. This one is construction. You would be standing up ETL on Databricks and Spark for a National Guard analytics platform that is still being built, designing the models, setting the governance, and deciding how it works rather than inheriting a decade of someone else's decisions.

FWI is hiring a Data Engineer to support enterprise data analytics and AI/ML modernization for the National Guard Bureau, part of a larger Office of the Under Secretary of War for Personnel and Readiness (OUSW(P&R)) data analytics program. You will design, build, and maintain the data infrastructure behind a National Guard community data and analytics environment, the pipelines, models, and governance that make enterprise personnel and readiness data usable. This is hands-on pipeline engineering at enterprise scale, on a platform where data quality has direct operational consequences.

FWI is expanding rapidly and has been recognized as a 2024, 2025, and 2026 Top Workplace, offering excellent growth opportunities in a collaborative environment.

Work Schedule and Location:

Hybrid: This role is based in Arlington, Virginia and works on a hybrid schedule, typically 1–2 days on site per week, with the balance remote. We are looking for someone in the National Capital Region who can be on site when the mission calls for it, not only on a fixed schedule. Working alongside the government team in person is part of how this role builds the relationships the work depends on.

Responsibilities

• Design, develop, and implement end-to-end data pipelines using ETL processes and technologies including Databricks, Python, Spark, Scala, JavaScript/JSON, and SQL


• Build and optimize pipelines from scratch, with scalability, reliability, and high-performance processing as first-order requirements


• Work with cross-functional teams to understand data requirements and design the data models and architectures to meet them


• Perform data cleansing, integration, and quality assurance to maintain the accuracy and integrity of large datasets


• Apply big data technologies to process and analyze large datasets efficiently


• Partner with data scientists, analysts, and government stakeholders to deliver timely, accurate data that supports decision-making


• Troubleshoot complex data problems and develop practical solutions


• Implement and enforce data governance policies and procedures, ensuring compliance with regulatory requirements and industry best practice

Qualifications

Required:

• Active DoD Secret clearance (final, in current scope)


• Bachelor's or Master's degree in a related field


• 3+ years of directly related experience as a Data Engineer


• Proficiency in ETL processes, with firsthand experience across technologies such as Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks


• Demonstrated experience working with large datasets and using big data technologies to process and analyze data efficiently


• Working understanding of data modeling and visualization, database design principles, and data governance practice


• Based in the National Capital Region, or willing to relocate, and able to report to the Arlington site as needed


• U.S. citizenship (required for the clearance)

Desired:

• Experience supporting the Department of War mission and familiarity with its associated datasets


• Prior work in Advana or the War Data Platform


• API development and integration experience


• Experience with machine learning models and/or generative AI


• Experience building in Palantir Foundry, including Workshop, Ontology Manager, and Gaia

FWI is an Equal Opportunity Employer, including disability/vets.

Why Join Our Team

At FWI, we place the highest importance on creating an exceptional employee experience. You'll have opportunities to achieve your career aspirations through internal promotions, professional development, and other recognition and rewards programs. Join our team and take advantage of the many benefits we offer, including:

• Health Insurance


• Dental Insurance


• Vision Insurance


• Long-term and Short-term Disability Insurance808;li>Life Insurance


• 401(k) Plan


• Holiday Pay


• Paid Time Off

Pay Range

$115,000 – $125,000 annually, depending on experience, education, and clearance level.