Analytics Engineer II

Summary

Join Cohere Health, a fast-growing clinical intelligence company, as an Analytics Engineer. You will play a crucial role in ensuring data quality and readiness for reporting and analytics. This involves building ETL data pipelines, validating data, and collaborating with cross-functional teams. The position demands a fast-paced, project-based approach, requiring flexibility and problem-solving skills. You will contribute significantly to improving patient care and have opportunities for professional growth within a supportive and inclusive environment. The role offers a competitive salary and benefits package.

Requirements

• Bachelor’s or Master’s degree in STEM, computer science, software engineering, economics, finance or public health related field
• 1-3 years data experience at company where health outcomes were critical to the mission, preferably a healthcare analytics company or population health organization
• Passionate about improving the U.S. healthcare system and helping ensure every patient receives the best care possible
• Self-starter, able to work independently, able to succeed in a fast-paced, high intensity start-up environment
• Hands-on experience with common software development practices such as version control, unit testing, and CI/CD
• Strong interest and understanding of EMR, Claims and SDOH data
• Expertise in ETL tool and languages like Spark, PySpark, Python, DBT and SQL
• Knowledge in data modeling and storage design using different database technologies
• Excellent interpersonal skills to work with stakeholders to enable data governance and quality standards

Responsibilities

• Quickly understand Cohere’s products, services and clinical programs and how Cohere’s x-functional collaboration and workflow support healthcare providers’ workflow and patients’ care journey
• Build required ETL jobs for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies
• Ingest, standardize, transform, validate and load various data from external clients, public sources and Cohere internal application data
• Work with stakeholders including analytics, data science, reporting and product teams and assist them with data-related technical issues
• Monitor daily refresh data jobs from payer to our Cohere platform and from Cohere platform to our data platform
• Perform and review quality checks on incoming, outgoing and aggregated data in order to identify data anomalies
• Map and specify target data requirements and associated data transformations and validations

Preferred Qualifications

Knowledge of STARs, HEDIS and other clinical / financial metrics in healthcare

Benefits

• Health insurance
• 401k
• Bonus