Data Engineer

Crossover Health

Crossover Health

This job is no longer accepting applications

See open jobs at Crossover Health.
Software Engineering, Data Science
United States · Remote
Posted on Thursday, December 21, 2023

About Crossover Health

Crossover Health is creating the future of health as it should be. A national, team-based medical group with a focus on wellbeing and prevention that extends beyond traditional sick care, the company delivers an entirely new model of healthcare—Primary Health—built on the foundation of trusted relationships, an interdisciplinary care team approach, and outcomes-based payment. Crossover’s Primary Health model integrates primary care, physical medicine, mental health, health coaching, care navigation and more, and delivers care in surround-sound—in-person, virtually and via asynchronous messaging. Together we are building a community of members that embraces healthcare as a proactive part of their lifestyle.

Job Summary

Crossover’s Sr. Data Engineer is responsible for managing and developing data sources for analytics at scale. This is a critical role for supporting Crossover’s growing analytics team, and serves as the connection between Crossover’s Information Technology team, Data Science team, and data infrastructure vendors. In this role, the successful candidate will build out new data sources within the enterprise data warehouse, guide data modeling efforts for new and existing projects, and manage data ingress and egress between Crossover teams, clients, partners, and vendors. The ideal candidate will have experience with both clinical healthcare data as well as healthcare claims data.

Job Responsibilities

  • Develop and maintain data sources within Crossover’s enterprise data warehouse (inclusive of our current vendor and/or future data infrastructure)

  • Assist with the development of a comprehensive data strategy and roadmap, including recommendations for data architecture, data storage, data integration, data quality, and data models

  • Design and build data models to clean and transform datasets for use by Crossover’s Data Science team

  • Design customized data tests to guarantee quality and repeatability of data model results

  • Manage the creation, maintenance, and processing data ingest and export

  • Assist stakeholders including analytics, design, product, and executive teams with data-related technical issues

  • Assist with ETL, ELT, and reverse-ETL design and development initiatives including data analysis, source-target mapping, data profiling, change data capture, ETL coding, QA testing, and performance tuning

  • Invest in documentation, including all system design, architecture and ongoing changes

  • Design and support production job schedules, including alerting, monitoring, break fixes, and performance tuning

  • Build solutions that are automated, scalable, and sustainable while minimizing defects and technical debt

  • Perform other duties as assigned

Required Qualifications

  • Bachelors in Computer Science, related degree, or equivalent professional experience

  • 6+ years relevant work experience within a complex, dynamic environment, with preference for experience with clinical healthcare data.

  • Strong knowledge of SQL (DML & DDL), Stored Procedures, Indexes, user defined functions, and related data query and management technology .

  • Experience building and operating highly available, distributed systems of extraction, ingestion, and processing of large data sets

  • Experience in business intelligence development across a variety of applications (OLTP, OLAP and DSS)

  • Experience developing, designing and supporting applications and relational databases

  • Experience with enterprise data warehouse design patterns and technology

  • Experience with data migration tools and techniques

  • Experience with data integration tools such as FiveTran, Stitch, Grouperoo or similar ELT/Reverse ETL tools

  • Working knowledge of Git, dbt, or similar collaborative code management software

Preferred Qualifications

  • Masters in Computer Science or related degree

  • Healthcare data acquisition, ingestion, processing, and analytics highly preferred

  • Previous experience with health informatics, taxonomies, terminologies, and code sets.

  • Experience with healthcare claims data, formats, and analysis

  • Experience with Health Catalyst’s data and analytics platform

The base pay range for this position is $133,430.00 to $156,780.00 per year. Pay range may vary depending on work location, applicable knowledge, skills, and experience. This position will be eligible for an annual bonus opportunity and comprehensive benefits package that includes Medical Insurance, Dental Insurance, Vision Insurance, Short- and Long-Term Disability, Life Insurance, Paid Time Off and 401K.

To all recruitment agencies: We do not accept unsolicited agency resumes and are not responsible for any fees related to unsolicited resumes.

#LI-Remote

This job is no longer accepting applications

See open jobs at Crossover Health.