Analytics Engineer

Analytics Engineer LocationRemoteEmployment TypeFull timeLocation TypeRemoteDepartmentDataCompensation$140K – $150K • Offers Equity • Offers BonusOur TeamDandelion 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. Meet the rest of our team here.Our DataWe 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)VideoWaveformsContinuous streaming monitoring dataYour RoleYou 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.In this role, you will be responsible for: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 journeysDeveloping 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.You are not afraid to dig into massive, confusing, disorganized new datasets and get them under...