Analytics Engineer

Dandelion Health Inc

35d • $140,000 - $150,000 • Remote

About The Position

Dandelion Health was founded in 2020 by experts in health tech, hospital systems, academia, and clinical AI. We are building the world’s largest AI training and clinical development platform. Today, we pride ourselves on our ability to make data access as easy as possible for AI developers, pharma, and medical devices, while raising the bar for patient safety and data quality. Tomorrow, we will be the place where any healthcare organization can go to build a responsible clinical AI product. Our culture is all about learning from data and improving, so we can help our clients improve health through AI. We partner with health systems to safely and ethically make their de-identified patient data available to AI developers. Currently, the data is acquired from Sharp HealthCare, Sanford Health, and Texas Health Resources – with two additional U.S. health systems joining soon. We have clinical data dating back to July 1, 2016. This data represents over 10 million patients and includes but is not limited to: Structured data (e.g., 100% of the EMR, including some claims), Unstructured text (e.g., clinical notes, radiology reports), Images (e.g., DICOM, pathology), Video, Waveforms, Continuous streaming monitoring data. You are an experienced analytics engineer who knows your way around clinical and electronic health record data. Your primary responsibility is to build, maintain, and optimize the transformation layer of our ELT pipeline, turning raw, messy clinical data into clean, well-modeled, analysis-ready datasets that our clients and internal teams can trust. You will own the full lifecycle of our data models: designing and implementing transformation logic, enforcing data quality and testing standards, optimizing pipeline performance, and documenting data models so they're discoverable and understandable across the organization. You will use your data expertise, programming abilities, and critical thinking skills to support our technical product team in scaling and growing our ability to provide meaningful data. Your team’s ultimate goal is to deliver the highest-quality data possible to our clients, who are building products that improve patient health. You will report to the Data Science Manager, under the Chief Data Officer. You are not afraid to dig into massive, confusing, disorganized new datasets and get them under control. You are excited to learn new environments, languages, and skills. This is a small, early stage company with enormous ambitions and everyone pitches in across the team.

Requirements

• Bachelor’s degree in a quantitative field (ex. Data Science, Biomedical Informatics, Computer Science, Biostatistics)
• 3+ years of experience in analytics or data engineering roles where you are responsible for hands-on cleaning and structuring clinical and electronic health record data
• Strong dbt and SQL proficiency: writing reusable Jinja macros, implementing custom tests, and comfortable with multi-environment deployments (dev/staging/prod)
• 1+ years of experience with extracting, curating, and analyzing data created within the HIT and healthcare delivery ecosystem (e.g., EMR, claims, registry); this may include knowledge of the roles of data exchange and content standards (e.g., FHIR, CDA, CQL) and clinical terminology standards (e.g., ICD, CPT, LOINC, SNOMED-CT, NDC, RxNorm)
• Comfort working in a cloud environment (ideally Snowflake and/or AWS).
• Proficiency with Git and version control workflows
• Is an advocate for bringing software engineering best practices (modularity, unit testing, concise and well-documented code) to a data science team.
• Comfortable with ambiguity and creative problem-solving in a fast-paced, rapidly growing startup environment.
• Excellent communication skills to advocate for the value of robust analytics engineering solutions and translate customer needs into data solutions.
• Passion for improving healthcare and building infrastructure that makes research and clinical AI safer, faster, and more reliable.

Nice To Haves

• Practical experience integrating LLM tools (e.g., Snowflake Cortex, Amazon Bedrock, Azure OpenAI Service) and frameworks (RAG, agent workflows) into data pipelines and product
• Proficiency in Python for data cleaning and model feature engineering.
• Experience working with AI/ML modeling teams and a conceptual grasp of cloud model deployments and evaluation.
• Familiarity with the data aspects of electronic medical records, ex. Epic, Cerner, Allscripts
• Any medical ontology experience
• Any experience working with DICOM or other imaging modalities
• Experience with OMOP common data model
• Comfortable with agile tools such as Jira, Linear.
• Familiarity using dbt cloud

Responsibilities

• Querying complex source systems in a range of health data sources (e.g., EMRs, ECG data, DICOM data) to identify and map data elements in order to create high-quality datasets to support training AI algorithms and conducting in-depth analyses of patient journeys
• Developing and maintaining data transformation pipelines using dbt and Snowflake, ensuring data quality, lineage, and transparency.
• Harmonizing multimodal data from multiple health systems into a unified ontological layer ready for use by data scientists and AI developers, with input from clinical experts across the company.
• Performing complex data extraction, manipulation, and summarization of large databases to create analytical data models;
• Implementing data quality tests, CI/CD and version control best practices for analytics codebases throughout the data modeling pipeline.
• Supporting software engineers in optimizing processes and technical solutions for de-identification and ETL of clinical data from disparate health system cloud environments to Dandelion Health’s data warehouse.
• Working with experts in natural language processing (NLP) to structure and model discrete clinical concepts data that have been abstracted from unstructured and semi-structured text data.
• Collaborating with technical and clinical subject matter experts and Dandelion customers to translate research and model requirements into engineering solutions.

Benefits

• Remote work and flexible hours.
• Complete wellness benefits including healthcare, dental, vision, PTO, sick days and more.
• Professional development days to build your skills
• Collegial work environment
• Academic bent towards inquiry and problem solving but start-up speed and flexibility
• Great balance of focus time to work on projects but easy to access team members to discuss issues and work collaboratively

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level