SENIOR SOFTWARE ENGINEER - Data Quality

Job description

Key Responsibilities • Design, develop, and maintain scalable data pipelines and ETL processes to transform diverse healthcare data into the Verana common data model. • Conduct deep-dive initial analysis and data profiling on newly integrated EHR and Practice Management (PM) systems to understand their underlying schemas. • Investigate and reverse-engineer clinical workflows to understand exactly how data is captured at the point of care across 3,000+ clinical practices. • Identify, trace, and resolve complex data quality anomalies caused by custom clinic configurations and variations across 20+ different EHR vendors. • Develop highly efficient, advanced SQL queries and Python scripts to perform complex data transformations and normalization. • Apply and map standard healthcare coding terminologies including CPT, ICD, SNOMED, NDC, and LOINC to ensure comprehensive data standardization. • Leverage industry data frameworks like HL7 FHIR to guide and optimize target common data model (CDM) mapping strategies. • Collaborate with cross-functional teams, external EHR vendors, and practice IT administrators to isolate and resolve upstream workflow or data ingestion issues. Mandatory Skills • Expert-level SQL skills for data profiling, complex joins, window functions, and deep-dive data forensics. • Strong hands-on experience with ETL/ELT concepts, data transformation, and source-to-target schema mapping. • Working experience with Python for data engineering, automation, and script writing. • Deep domain experience in healthcare data, specifically analyzing and manipulating native EHR and Practice Management (PM) data structures. • Strong mastery of clinical coding systems and healthcare terminologies, including CPT, ICD-9/10, SNOMED-CT, NDC, and LOINC. • Experience with relational data modeling, schema design, and mapping disparate sources into a unified Common Data Model (CDM). • Proven track record in managing data quality, integrity, and data profiling to catch anomalies before they reach production. • Strong problem-solving skills with a "data detective" mindset to unearth hidden data and reverse-engineer structural workflow variations. • Excellent technical communication skills with the ability to translate complex data discrepancies to non-technical stakeholders and external clinical partners. Desired Skills • Conceptual or working familiarity with HL7 FHIR standards and specification frameworks. • Experience working with large-scale distributed datasets and modern cloud data warehouses (e.g., AWS Snowflake, Redshift, Databricks). • Familiarity with clinical data registries, healthcare informatics, or life sciences data analysis. SQL, Python, AWS Databricks, ETL/ELT