Senior Analytics Engineer

San Diego, CA, United States

Who We Are:

At the intersection of health plans and providers, Apixio is creating a leading Connected Care platform to minimize reimbursement inaccuracies and high-quality patient care so they can thrive as the industry moves toward value-based reimbursement models.

The combination brings together healthcare expertise, AI/machine learning technology and data-driven analytics solutions to deliver innovative solutions and value to our customers and the healthcare ecosystem. We aim to accelerate the shift toward alternative payment models, while enhancing efficiency and supporting better patient outcomes.

About the role

Apixio is looking for a Senior Analytics Engineer to join our analytics team. This role will primarily be responsible for building out our analytics platform on Databricks, using dbt and Python for data transformations. The duties of the Senior Analytics Engineer will comprise data discovery, data modeling, data engineering, and data governance, thus serving as a full-stack analytics engineer leveraging the modern data stack. This is a foundational role within a small, talented team with the opportunity to make a huge impact in a growing organization.

Who you are

Data Discovery and Data Modeling

Conduct thorough data discovery to identify and understand the organization's data sources, adhering to data quality and data governance policies.

Collaborate with stakeholders across Apixio (Ops, Product, Marketing, G&A) and within the team to understand business requirements and translate them into data models that effectively capture data and transform them into metrics.

Design and implement data models using Databricks Delta Lake, ensuring data integrity, consistency, and scalability.

Document data models and data governance processes to maintain knowledge transfer and ensure data quality standards.

Data Engineering and Transformation

Develop and implement data pipelines using Databricks and dbt to collect, process, and transform data from various sources.

Utilize dbt to automate and streamline ELT processes, ensuring data quality and consistency.

Implement data quality checks and data cleansing techniques to ensure data accuracy and consistency.

Optimize data pipelines for performance and scalability to handle large volumes of data.

Data Visualization and Insights

Develop and maintain data visualizations and dashboards using tools like Looker.

Create interactive dashboards that provide business users with self-service access to data insights.

Communicate data insights effectively to stakeholders, translating technical concepts into clear and actionable recommendations.

What you bring to the table

5+ years Data Engineering experience including

3+ years hands-on experience working with large, structured/unstructured datasets using partitioned cloud storage architecture using query engines such as Spark, Delta Lake.

3+ years experience designing, developing, deploying and testing in Databricks.

3+ years of hands-on experience in Python/Pyspark/SparkSQL.

2+ years experience on Big data pipelines/DAG tools like Airflow, dbt is required.

2+ years of SQL experience, specifically to write complex, highly optimized queries across large volumes of data.

Experience in the AWS computing environment and storage services such as s3/glacier is required.

Experience with conceptual, logical and/or physical database designs is required.

Good knowledge in Linux and shell scripting is highly desired.

Past experience in healthcare data extraction, transformation and normalization is highly desired.

Hands-on experience with Kafka or other live streaming technology is highly desired.

Experience with Data Visualization tools like Looker / Tableau is desired.

Ability to lead and complete projects independently once given objective and direction.

Ability to independently look for resourceful solutions and enhancements; and communicate any issues timely if they arise, and present solutions to the problems.

Strong communication skills to partner with data integration, engineering, DevOps, customer success, and product teams and collect technical and business requirements.

High agency, integrity, ownership, and curiosity.

What success looks like

In 1 month: you have understood the various data sources across Apixio

In 3 months: you have built data pipelines to bring more data into the analytics platform

In 6 months: you have led 2-3 projects working with stakeholders end-to-end, going from requirements to KPI / dashboard delivery

The salary range below is for Base Salary.  Total compensation also includes benefits and variable compensation.  Compensation will be determined based on several factors including, but not limited to, skill set, years of experience, and the employee’s geographic location. Base Compensation $90,000—$144,000 USD We recognize that people come with experience and talent beyond just the technical requirements of a job. If your experience is close to what you see listed here, please consider applying. Diversity of experience and skills combined with passion is a key to innovation and excellence. Therefore, we encourage people from all backgrounds to apply to our positions. Your skills and background may be more translatable to this role than you initially thought.  Allow us the opportunity to get to know you.  Please let us know if you require accommodations during the interview process.

What Apixio can offer you:

Meaningful work to advance healthcare

Competitive compensation

Exceptional benefits, including medical, dental and vision, FSA

401k with company matching up to 4%

Generous vacation policy

Remote-first & hybrid work philosophies

A hybrid work schedule (2 days in office & 3 days work from home) ( Note: If the position is designated as REMOTE it will stay REMOTE )

Modern open office in beautiful San Mateo, CA; Los Angeles, CA; San Diego, CA; Austin, TX and Dallas, TX

Subsidized gym membership

Catered, free lunches

Parties, picnics, and wine-downs

Free parking

We take your privacy very seriously. Please review our privacy policy to see exactly how we protect your information here

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

Notice to Recruiters/Staffing Agencies

Recruiters and staffing agencies should not contact Apixio through this page. All recruitment vendors (search firms, recruitment agencies, and staffing companies) are prohibited from contacting our hiring manager(s), executive team members, or employees

We require that all recruiters and staffing agencies have a fully executed, formal written agreement on file

Apixio receipt or acceptance of an unsolicited resume submitted by a vendor organization to this website or employee does not constitute an actual or implied contract between Apixio and such organization and will be considered unsolicited and Apixio will not be responsible for related fees

LI-RB1