Data Engineer

About Crossover HealthCrossover 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 SummaryCrossover’s 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 Product and Technology teams, 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 ResponsibilitiesDevelop and maintain data sources within Crossover’s enterprise data warehouse (inclusive of our current vendor and/or future data infrastructure)Assist with recommendations for data architecture, data storage, data integration, data quality, and data modelsContribute to design sessions based on technical requirements, and build data models to clean and transform datasets for use by Crossover’s Data Science and Analytics teamsAssist with ETL, ELT, and reverse-ETL design and development initiatives including data analysis, source-target mapping, data profiling, change data capture, QA testing, and performance tuning to guarantee quality and repeatability of data model resultsCreate and maintain data model standards, including MDM (Master Data Management) and codebase standardizationMigrate Enterprise Workloads to Snowflake using industry standard methodologiesAutomate and deploy as well as build CI/CD pipelines to support cloud based workloadDesign, deliver cloud native, hybrid, and multi-cloud WorkloadsInvest in documentation, including all system design, architecture and ongoing changesDesign and support production job schedules, including alerting, monitoring, break fixes, and performance tuningBuild solutions that are automated, scalable, and sustainable while minimizing defects and technical debtAssist stakeholders including analytics, design, product, and executive teams with data-related technical issuesAbility to work independently with little instruction or direct oversightPerform other duties as assignedMinimum QualificationsBachelors in Computer Science or Data Engineering, related degree, or equivalent professional experience3+ years relevant work experience within a complex, dynamic environment, with preference for experience with clinical healthcare data3+ years architecting, implementing, and supporting data infrastructure and topologiesExperience building and operating highly available, distributed systems of extraction, ingestion, and processing of large data sets across a variety of applications (OLTP, OLAP and DSS)3+ years Experience with Data warehousing, methodologies, modeling techniques, design patterns, and technologies.Experience with data migration tools and deploying cloudbase solutionsExperience in writing advanced SQL (DML & DDL), including Stored Procedures, Indexes, user defined functions, windows functions, correlated subqueries and CTE's, and related data query and management technologyCoding ability in R, Python, and Shell Scripting to build and deploy PipelinesWorking knowledge of Git, or similar collaborative code management softwareExperience with data integration tools such as FiveTran, DBT, Informatica, Matillion, or similar ETL/ELT toolsExperience with Snowflake’s data platformPreferred QualificationsMasters in Computer Science, Data Engineering, or related degreeHealthcare data acquisition, ingestion, processing, and analytics knowledge highly preferredPrevious experience with health informatics, taxonomies, terminologies, and code setsKnowledge and understanding of product features: IAAS, PAAS and SAAS solutionsExperience with healthcare claims data, formats, and analyticsExperience with Health Catalyst’s data and analytics platformExperience with Tableau Cloud administrationExperience with Master Data ManagementUnderstand Cloud EcosystemThe base pay range for this position is $91,428.00 to $105,143.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.Crossover Health is committed to Equal Employment Opportunity regardless of race, color, national origin, gender, sexual orientation, age, religion, veteran status, disability, history of disability or perceived disability. If you need assistance or an accommodation due to a disability, you may email us at careers@crossoverhealth.com.To all recruitment agencies : We do not accept unsolicited agency resumes and are not responsible for any fees related to unsolicited resumes.

#J-18808-Ljbffr