Data Engineer

Company Overview

Pantheon Data (a Kenific Holding company) is a private, small business based in the Washington, DC, area. Pantheon Data was founded in 2011, initially providing acquisition and supply chain management services to the US Coast Guard. Our service offerings have grown in the past ten years, including infrastructure resiliency, contact center operations, information technology, software engineering, program management, strategic communications, engineering, and cybersecurity. We have also grown our customer base to include commercial clients. The company has used this experience to expand our service offerings to other agencies within the Department of Homeland Security (DHS), the Department of Defense (DoD), and other Federal Civilian Agencies.

DHA Overview

The Defense Health Agency (DHA) is a joint, integrated Combat Support Agency that enables the Army, Navy, and Air Force medical services to provide a medically ready force and a ready medical force to Combatant Commands during peacetime and wartime. Established to enhance the delivery of integrated, affordable, and high-quality health services, the DHA supports Military Health System (MHS) beneficiaries and drives the integration of clinical and business processes across the MHS. The agency plays a pivotal role in ensuring military personnel and their families receive comprehensive healthcare, thus maintaining operational readiness and overall force health protection.

Position Overview

Pantheon Data is seeking a Data Engineer with a strong background in designing and implementing data-centric technical solutions to support the Defense Health Agency (DHA). The ideal candidate will have hands-on experience with data integration, migration, and transformation pipelines, preferably in healthcare or federal environments, and a willingness to quickly adapt and learn new technologies. This role will directly support DHA's modernization initiatives by migrating and integrating data from legacy health IT systems into secure, cloud-first architectures. The Data Engineer must be able to communicate clearly with both technical peers and non-technical stakeholders, such as program managers and clinical staff, to ensure data solutions meet mission objectives.

Responsibilities

• Conduct data profiling, quality assessments, and validation of relational databases (e.g., SQL Server, Oracle, PostgreSQL) to define mapping rules and support DHA data governance.
• Design and develop ETL pipelines to support data integration and migration from legacy systems (including health and HR systems) into modern platforms such as Salesforce, AWS GovCloud, and Advana-aligned data environments.
• Support the development of authoritative data repositories and data lakes to enable interoperability and analytics across DHA's enterprise health IT ecosystem.
• Work collaboratively within a growing engineering team to build and sustain scalable, secure, and resilient technical solutions that support DHA's enterprise data strategy.
• Partner with technical leads and program stakeholders to design and deliver solutions that align with DHA's mission, exceed customer expectations, and comply with DoD standards (HIPAA, FedRAMP, DoD IL).

Required Skills and Experience

• 5 years professional, hands-on experience in a data engineering role.
• Bachelor's degree in Computer Science or a related field.
• Expert-level SQL, relational databases.
• Experience with ETL or data migration.
• Excellent verbal communication skills with the ability to interact clearly and succinctly in peer review and design sessions.
• Willing to learn/contribute meaningfully across technical areas of our projects.
• Working knowledge of CI/CD methodology and related tools for database development.
• Working knowledge of Agile Scrum methodology.
• Detail-oriented, self-motivated, and organized
• Ability to work effectively remotely in cross-functional teams.
• Ability to meet deadlines and produce quality work.
• Proficient in Microsoft Suite software including Outlook, Word, Excel, SharePoint, and PowerPoint.

Preferred Skills and Experience

• Strong experience with Python.
• Experience integrating data from SalesForce.
• Experience writing ETL source-target documentation.
• Experience with legacy ETL tools such as Informatica and SSIS.
• Experience with cloud-based ETL tools such as DBT and Airflow.
• AWS (Amazon Web Services) and/or Microsoft Azure. Certification(s) a plus.
• Experience with cloud-hosted databases, either AWS or Azure.
• Experience using big data technologies (Hadoop, Hive, HBase, Spark, EMR, etc.)
• Experience with AI/ML a plus.

Clearance Requirements

U.S. Citizenship with the ability to obtain and maintain a DoD Secret clearance.

Work Location: Remote - Falls Church, VA

*The Government reserves the right to change where this work will be performed, and light travel may be requested occasionally based on government requirements. Ideal cities and states with access to Government facilities are: Falls Church, VA, Washington, DC, San Antonio, TX, and Aurora, CO.

• Our company prioritizes the benefits of flexibility and collaboration, whether that happens in person or remotely.
• If the position is remote or hybrid, you may periodically work from a Pantheon Data office location or client site.
• If this position is assigned to a Pantheon Data office location or client site, you'll work with colleagues and clients in person, as needed for specific client requirements.

Compensation

The salary range for this position is $115,000 - $130,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Benefits Overview

We are always looking for good people! Pantheon Data is committed to providing its employees with competitive salaries and benefits in order to increase employee satisfaction and productivity.In addition to our benefits, we also offer SmartBenefits through the Washington Metro Area Transportation Authority, where you specify an amount of your pre-tax wages be paid directly to your SmarTrip account. In some cases, tuition assistance may be available for continuing education expenses and certifications related to their position. Additional details may be found at https://pantheon-data.com/careers/

Pantheon Data Important Information

All qualified applicants will be considered for employment without regard to disability, status as a protected veteran, or any other status protected by applicable federal, state, local, or international law.

As part of the application process, you are expected to be on camera during interviews and assessments. We reserve the right to take your picture to verify your identity and prevent fraud.

If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to our Talent Team at Recruiting@pantheon-data.com or by phone (571) 363-4020.

This company uses E-Verify to confirm each employee's work authorization. For more information, click here E-Verify Participation Poster