ATA is seeking a Data Scientist to support data pipeline development, validation, and analysis within a cloud-based Health IT data platform. This role is hands-on and delivery-focused, with an emphasis on building reliable, reproducible data workflows using SQL, Python, and PySpark in an Azure Synapse environment.
A core expectation of this role is the ability to work across the full data lifecycle, from ingestion through transformation to final dataset delivery, while maintaining data quality and traceability. The ideal candidate is comfortable debugging data issues end-to-end, understands how data structure and join logic impact outputs, and applies disciplined validation and documentation practices. This role also supports exploratory data analysis and the development of derived datasets to enable analytics and downstream use cases. The position will work extensively with healthcare data originating from EHR systems and interface feeds, including HL7 v2 and FHIR data, clinical terminology, and source-to-target data mappings.
Key Responsibilities:
Data Pipeline Development
PySpark.
ATA, LLC | 752 Walker Road | Suite D | Great Falls, VA 22066 | www.ata-llc.com
Advanced Technology Applications
debugging and documentation.
JSON/NDJSON, and Parquet.
Work within ETL/ELT pipelines across raw, curated, and production data layers.
Ingest, profile, map, and transform healthcare data from EHR systems and interface
feeds while preserving source lineage and clinical context
Data Quality and Validation
detection, schema validation, and allowed value enforcement.
transformation errors across pipeline stages.
fixes, and ensuring data reliability prior to downstream use.
systems during data conversion and migration activities.
Data Analysis and Dataset Development
concerns.
cases.
metrics.
Data Modeling and Structure Awareness
and composite keys, and table relationships.
many) impact row counts and outputs.
Debugging and Troubleshooting
Trace data issues from source ingestion through transformation logic to final outputs.
Use logs and debugging approaches to diagnose and resolve pipeline issues.
Document data transformations, assumptions, mappings, and validation results in a
clear and consistent manner.
integrity, and alignment with requirements.
ATA, LLC | 752 Walker Road | Suite D | Great Falls, VA 22066 | www.ata-llc.com
Advanced Technology Applications
members.
Minimum Qualifications:
Hands-on experience writing SQL queries for data transformation and analysis.
Experience using Python (e.g., pandas) for data processing.
Hands-on experience using PySpark for distributed data processing.
Experience working within cloud-based data platforms, preferably Azure Synapse or
similar.
Understanding ETL/ELT concepts and data pipeline architecture.
Parquet).
Familiarity with Git and collaborative development workflows.
Strong problem-solving and debugging skills across data pipelines.
Ability to validate and ensure data quality through structured checks and testing
practices.
Preferred Qualifications:
particularly HL7 v2 and FHIR.
LOINC, RxNorm, or CPT.
between RPMS and Oracle Health/Cerner—or a comparable legacy-to-modern EHR
migration.
validation across source and target systems
General personal traits we know will connect well with the team:
Dependable, self-directed, and able to meet commitments.
Comfortable learning new subject areas and solving unfamiliar problems.
Enjoys collaborating across technical and subject-matter disciplines.
Pragmatic and able to select the appropriate tool for the requirement.
ATA, LLC | 752 Walker Road | Suite D | Great Falls, VA 22066 |
Advanced Technology Applications
About ATA: A leading provider of full-stack data and AI solutions with deep mission experience supporting the Department of Defense, Department of Homeland Security, IC, and federal agencies. Founded in 2008 and headquartered in Virginia, ATA specializes in secure, scalable, and operationally ready technologies that transform data into actionable insight. With a proven track record in advanced analytics, software development, and technology integration, ATA is uniquely positioned to accelerate federal organizations in a number of ways by leveraging powerful contracting options and delivering cutting-edge, automation-enhanced, AI-assisted capabilities—tailored to need and mission assurance imperatives. We believe our diversity of infrastructure, data, and application experience is valuable and is one of the attributes that sets ATA apart.
Summary of Benefits: We expect each member of our team to fully engage creatively and work collaboratively and perform each day to the best of their ability.To support this, we have created a benefit package focused on professional growth, achieving a healthy work-life balance, and participation in the long-term success of the company.Our benefits include generous paid time-off; an employee incentive program; continuous learning culture, Internal
Investment Projects (IIP), virtual brown-bags/level-ups, and other professional development activities; recruiting bonuses; 3% 401k Safe Harbor contributions; Medical/Dental/Vision, Long & Short-term Disability, AD&D insurance, and Life Insurance.
Cherokee Federal is a government contracting firm that provides specialized cybersecurity, software development, and information assurance services to federal agencies. The company supports critical maritime and defense operations through expertise in system authorization, continuous monitoring, and Salesforce platform implementations for public sector and DoD environments. Cherokee Federal works with agencies like MARAD to strengthen security posture of IT and OT systems while maintaining compliance with federal cybersecurity requirements.
