Healthcare Data Scientist

Cherokee Federal; Washington (District of Columbia); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Generous PTO

Employee incentive program

Continuous learning culture

Recruiting bonuses

3% 401k Safe Harbor

Medical/Dental/Vision

Long & Short-term Disability

Life Insurance

Job summary

ATA, LLC is seeking a Data Scientist to support data pipeline development, validation, and analysis within a cloud-based Health IT data platform. This hands-on role emphasizes building reproducible workflows using SQL, Python (pandas), and PySpark in an Azure Synapse environment.

The role covers the full data lifecycle with healthcare data from EHR systems and HL7 v2/FHIR, requiring strong validation, profiling, and documentation practices to enable analytics and downstream use cases.

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 of healthcare data formats and data lineage concepts.

Responsibilities

• Develop, maintain, and optimize data pipelines using SQL, Python (pandas), and PySpark.
• Execute and manage notebook-based workflows within Azure Synapse, including debugging and documentation.
• Process and transform structured and semi-structured data (CSV, JSON/NDJSON, Parquet).
• Ingest, profile, map, and transform healthcare data from EHR systems and interface feeds while preserving lineage.
• Validate source-to-target mappings and reconcile records across systems during data conversion and migration.
• Collaborate with stakeholders to translate data requirements into usable datasets and metrics.

Skills

SQL

Python (pandas)

PySpark

Azure Synapse

Data pipeline debugging

Tools

Git

Azure Synapse

Job description

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:

• Develop, maintain, and optimize data pipelines using SQL, Python (pandas), and PySpark.
• Execute and manage notebook-based workflows within Azure Synapse, including debugging and documentation.
• Process and transform structured and semi-structured data in formats such as CSV, 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.
• Perform structured data validation, including row counts, null checks, duplicate detection, schema validation, and allowed value enforcement.
• Identify and resolve data quality issues such as schema drift, inconsistencies, and transformation errors across pipeline stages.
• Apply repeatable testing and validation practices, including reproducing issues, verifying fixes, and ensuring data reliability prior to downstream use.
• Validate source-to-target mappings and reconcile records across source and destination systems during data conversion and migration activities.
• Conduct exploratory data analysis to identify patterns, anomalies, and data quality concerns.
• Develop derived datasets to support reporting, analytics, and downstream data use cases.
• Collaborate with stakeholders to translate data requirements into usable datasets and metrics.
• Interpret and work with data schemas, including column definitions, data types, primary and composite keys, and table relationships.
• Manage dataset grain and understand how join strategies (e.g., one-to-one vs. one-to many) impact row counts and outputs.
• 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.
• Collaborate with engineers, analysts, and stakeholders to ensure data usability, integrity, and alignment with requirements.
• Communicate data issues, findings, and workflow updates with technical team members.

ATA, LLC | 752 Walker Road | Suite D | Great Falls, VA 22066 | www.ata-llc.com

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.

• Experience working with structured and semi-structured data formats (CSV, JSON, 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.
• Strong written and verbal communication skills.

Preferred Qualifications:

• Experience working with healthcare interoperability standards and message formats, particularly HL7 v2 and FHIR.
• Familiarity with clinical terminology and code systems such as SNOMED CT, ICD-10, LOINC, RxNorm, or CPT.
• Experience supporting large-scale EHR data conversion or migration efforts, particularly between RPMS and Oracle Health/Cerner-or a comparable legacy-to-modern EHR migration.
• Understanding of clinical data mapping, terminology normalization, provenance, and 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.

About ATA:

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:

• 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
• Life Insurance