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
Top Skills
What We Do
Panum, a Maryland-based company, provides a continuum of services and strategies to accelerate innovation and transformation for the federal government in meeting its mission. Panum has had significant growth in the last 5 years due to its people, process, and innovative solution and services offered to its federal customers. Panum brings innovative ideas with a passion and a culture of “expect excellence” in Project Portfolio Management (PPM), Health Sciences, Digital Transformation, Cybersecurity, FOIA Support, Logistics, Training, and Organizational Change Management. It provides these services to more than 25 federal agencies. Panum has received numerous excellence awards from its federal customers including the Department of Homeland Security and the US Department of Agriculture. Panum provides its employees with work-life balance, an opportunity to innovate, learn, and grow their skills while working on solving the most complex federal government problems. Panum's management team consists of seasoned executives with both industry and government experience. This team boasts decades of business experience in diverse businesses with domestic and international operations, as well as small and large businesses. Why choose Panum? We are readily available to assist our customers with the necessary expertise and support to accomplish their mission.
