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 Requirements 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 be required based on project needs, client meetings, team collaboration events, or training sessions. Travel 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, Aretum complies with all applicable federal, state, and local employment laws. We are proud to support our nation’s veterans and military families, providing career opportunities that honor their service and experience. If you require reasonable accommodation during the hiring process due to a disability, please contact [email protected] for assistance. 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 and maintain a Public Trust or Suitability Determination, depending on the agency’s background investigation requirements. Benefits 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