Healthcare Data Scientist

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

• Develop, maintain, and optimize data pipelines using SQL, Python (pandas), and

PySpark.

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

Advanced Technology Applications

• 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

Data Quality and Validation

• 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.

Data Analysis and Dataset Development

• 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.

Data Modeling and Structure Awareness

• 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.

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.

• Collaborate with engineers, analysts, and stakeholders to ensure data usability,

integrity, and alignment with requirements.

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

Advanced Technology Applications

• Communicate data issues, findings, and workflow updates with technical team

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.

-