Analytics Engineer II

Full-time - Entry Level

Boston, MA

About the position

Cohere Health is a fast-growing clinical intelligence company that’s improving lives at scale by promoting the best patient-specific care options, using leading edge AI combined with deep clinical expertise. In only four years our solutions have been adopted by health insurance plans covering over 15 million people, while our revenues and company size have quadrupled. That growth combined with capital raises totaling $106M positions us extremely well for continued success. Our awards include: 2023 and 2024 BuiltIn Best Place to Work, Top 5 LinkedIn™ Startup, TripleTree iAward, multiple KLAS Research Points of Light, along with recognition on Fierce Healthcare's Fierce 15 and CB Insights' Digital Health 150 lists. We are looking for an Analytics Engineer to come join our awesome team. In this role, you will ensure that data in our platform is validated, cleaned, and ready for any reporting and analytics work. You’ll work closely with the analytics, clinical content, product, and engineering teams to understand the data needs, develop ETL data pipelines, validate ETL summary reports, monitor jobs, and troubleshoot issues. The work will be fast-paced and project-based, with evolving needs - requiring scrappiness, flexibility, curiosity, and grace under pressure. At a growing organization, this is a position that offers the ability to make a substantive mark on the company and its partners with exponential growth opportunities. You’ll be part of the data management team and build one Cohere data platform to support our downstream teams to optimize patient care paths. Last but not least: People who succeed here are empathetic teammates who are candid, kind, caring, and embody our core values and principles. We believe that diverse, inclusive teams make the most impactful work. Cohere is deeply invested in ensuring that we have a supportive, growth-oriented environment that works for everyone.

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
• Ensure data quality by monitoring 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

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

Nice-to-haves

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

Benefits

• Health insurance
• 401k
• Bonus