Senior Data Engineer

About the Company

Solera Health is committed to changing lives by guiding people seamlessly to better health solutions, while providing payers and employers the tools to providers and outcomes across conditions. Solera's platform provides a marketplace of curated networks of digital and community point solutions focused on intensive, evidence-based lifestyle, behavioral, and social interventions to impact the most prevalent and costly chronic conditions. Solera strategically matches consumers to their best-fit solution and helps keep them engaged for successful health outcomes.

About the Role

We are seeking a highly skilled and experienced Senior Data Engineer to join our dynamic team. The ideal candidate will have a solid background in data engineering, with expertise in ETL processes, SQL, Python programming, and workflow orchestration using Airflow. You will be responsible for building, maintaining, and evolving a flexible and modular ETL process backed in Python, with a focus on healthcare data models, particularly FHIR and Google BigQuery.

Who You Are

You are intellectually curious and always up for a good challenge. You are flexible and adaptable to change. You work well independently, and with a team, and are comfortable working in a remote environment. You are a self-starter who is excited to provide new ideas and opinions for sustainable solutions. You can consume and transform requirements into efficient and effective solutions that meet the highest quality and performance standards. You believe that unit and integration tests are an integral part of the development process. You are a problem solver.

What You'll Do

• Design, develop, and maintain scalable ETL pipelines in Python to process large volumes of healthcare data.
• Implement and optimize ETL workflows using Airflow.
• Develop complex SQL queries for data extraction, transformation, and loading.
• Collaborate with software engineers, analysts, and other users to understand data needs and deliver high-quality data solutions across a wide variety of data sources.
• Ensure data quality, data integrity and consistency across various sources and destinations.
• Monitor and troubleshoot ETL processes to ensure optimal performance.
• Document ETL processes and workflows for maintainability and scalability.
• Support client FTP setup and ongoing support.
• Mentorship of other data engineers to ensure cross-functional learning and continuous development.
• Stay up-to-date with industry best practices and emerging technologies in data engineering and healthcare data.

What You'll Need

• Education: Bachelor's or Master's degree in Computer Science, Engineering, Math, Analytics, Information Technology or related discipline.
• Data Engineering: 5+ years of professional experience in data engineering, specifically in ETL (Extract, Transform, Load) processes and SQL.
• Automation: Proven experience in building automated ETL flows.
• Programming: Professional experience in Python for data manipulation and automation.
• Data Warehousing: Strong understanding of data warehousing concepts.
• Workflow Orchestration: Proficiency in using Airflow for workflow orchestration

Preferred Qualifications

• Healthcare: Experience with healthcare payor and clinical data would be highly beneficial. Familiarity with healthcare data models, such as FHIR (Fast Healthcare Interoperability Resources), is a plus.
• Big Data Technologies: Experience with other big data technologies and frameworks beyond SQL and Airflow.
• Cloud Platforms: Familiarity with cloud platforms, especially Google Cloud Platform (GCP).
• Database: Experience with Google BigQuery is a strong plus.
• Healthcare Regulations: Understanding of healthcare regulations and compliance, such as HIPAA (Health Insurance Portability and Accountability Act).

Where you are located

• This role is remote and requires availability within North American time zones, with occasional travel to other corporate locations as necessary.

Benefits

• Remote-first work culture
• Competitive salary package
• Flexible paid time off
• Paid pregnancy and parental leave
• Adoption assistance program
• Comprehensive medical, dental and vision insurance
• 13 company holidays
• 401k with company match
• Free FitBit, Sworkit and Headspace (meditation & mindfulness app) accounts
• Casual and fun work environment

Disclaimer

The information contained herein is not intended to be an all-inclusive list of the duties and responsibilities of the job, nor are they intended to be an all-inclusive list of the skills and abilities required to do the job. Management may, at its discretion, assign or reassign duties and responsibilities to this job at any time.

EEO

Solera Health provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Solera Health complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.