Data Engineer

Public Trust Eligibility Required

About Aretum

Aretum is a mission-driven organization committed to delivering innovative technology-enabled solutions to our customers across defense civilian and homeland security sectors. Our teams work at the intersection of strategy technology and transformation helping agencies solve their most critical challenges. We believe in investing in our people and creating a culture where collaboration inclusion and professional growth are at the forefront.

Job Summary

Aretum is seeking a skilled and highly motivated Data Engineer. As a Data Engineer you will build and manage all data ingestion transformation reconciliation and analytics pipelines.

Due to the nature of our work as a federal consulting organization employees may be expected to handle Controlled Unclassified Information (CUI) and must adhere to applicable safeguarding and compliance requirements.

Responsibilities

• Ingest data from FHIR APIs CDW and other VA sources
• Normalize and reconcile medication and patient data
• Build transformation pipelines for risk scoring inputs
• Support batch and near-real-time processing
• Ensure data quality consistency and traceability

• Programming:Python (primary) SQL (advanced) optional Scala
• Data Processing Frameworks:Apache Spark AWS EMR Databricks (preferred)
• ETL/ELT Design:Pipeline orchestration incremental vs full loads data validation
• API Integration:REST APIs JSON parsing pagination authentication (OAuth2)
• FHIR Data Handling:Patient MedicationRequest Observation etc.
• Data Modeling:Relational and semi-structured schema design
• Data Quality & Validation:Deduplication reconciliation logic anomaly detection
• Streaming vs Batch Processing:Understanding tradeoffs and implementation patterns
• Storage Technologies:S3 relational DBs NoSQL basics
• Performance Optimization:Partitioning parallelization query tuning
• Versioning & Lineage:Data version control reproducibility of datasets

Travel Requirements

This is a remote position; however occasional travel may berequiredbased on project needs client meetings team collaboration events or training is expected to be less than 10% and will be communicated in advance whenever possible.

EEO Statement

Aretum is committed to fostering a workplace rooted in excellence integrity and equal opportunity for all. We adhere to merit-based hiring practices ensuring that all employment decisions are made based on qualifications skills and ability to perform the job without preference or consideration of factors unrelated to job performance.

As an Equal Opportunity Employer Aretumcomplies withall applicable federal state and local employment laws.

We are proud to support our nations veterans and military familiesprovidingcareer opportunities that honor their service and experience.

If you require reasonable accommodation during the hiring process due to a disability pleasecontactforassistance.

Equal Opportunity Employer/Veterans/Disabled

U.S. Work Authorization

Due to federal contract requirements only U.S. citizens are eligible for this position. This position supports a federal government contract and requires the ability to obtain andmaintaina Public Trust or Suitability Determination depending on the agencys background investigation requirements.

• Health Care Plan (Medical Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic Voluntary & AD&D)
• Paid Time Off
• Family Leave (Maternity Paternity)
• Short Term & Long-Term Disability
• Training & Development

Required Experience:

IC