Semantic Data Engineer

SEMANTIC DATA ENGINEER (HEALTHCARE)

Hybrid – Oregon, Washington, Idaho, or Utah

Our mission is to create a person‑focused and economically sustainable health care system.

Every day, the Cambia Data & Analytics Engineering Team lives our mission to make health care easier and lives better. We’re seeking a skilled Data and Analytics Engineer with significant experience engineering semantic layers to design, implement, expand, and enhance our existing semantic layer within our Snowflake data platform to support AI‑driven semantic intelligence and BI for our health insurance payer organization.

The role will focus on creating a robust, scalable semantic framework that enhances data discoverability, interoperability, and usability for AI and BI tools, enabling advanced analytics, predictive modeling, and actionable insights. All of this is in service of making our members’ health journeys easier.

• Bachelor's degree in Computer Science, Mathematics, Business Administration, Engineering, or a related field
• 3+ years relevant experience in a multi‑platform environment, including application development or database development
• At least 1 year working with Snowflake or a similar cloud data platform
• Equivalent combination of education and experience

• Build and maintain semantic data models on Snowflake based on specifications from the Semantic Data Architect and Data Product Owner, ensuring alignment with business, analysis, and AI requirements.
• Develop and optimize ETL/ELT pipelines to populate the semantic layer, integrating data from diverse sources (e.g., claims, member data, third‑party feeds) using Snowflake capabilities.
• Enable analytics and AI workflows by preparing and transforming data in the semantic layer for use in predictive models, natural language processing, and other analytics and AI applications.
• Optimize Snowflake queries and data structures (e.g., tables, views, materialized views) to ensure high performance for semantic data access.
• Implement data quality checks and validation processes to ensure the accuracy and reliability of the semantic layer.
• Collaborate with data product owners, business analysts, the semantic data architect, data modelers, and data engineers to create and refine data models and troubleshoot issues in production environments.
• Automate semantic layer maintenance tasks and set up monitoring to ensure system reliability and performance.

• Proficiency in SQL, Python, or other scripting languages for data processing and pipeline development.
• Experience using code repositories such as Git Lab or Git Hub and CI/CD‑based deployment.
• Experience with semantic technologies, including Snowflake semantic views, Micro Strategy, AtScale, or Business Objects universes and healthcare data standards (e.g., FHIR, HL7, ICD‑10).
• Strong understanding of analytics workflows and their data requirements.
• Experience with data governance, metadata management, and compliance in healthcare.
• Strong problem‑solving skills and experience with data pipeline tools (e.g., dbt, Snowflake Open Flow, Airflow).
• Knowledge of healthcare regulations (e.g., HIPAA) and data security best practices.
• Preferred:
  Experience with Snowflake features like Streams, Tasks, or data sharing; familiarity with cloud platforms (AWS, Azure, or GCP).
• Experience in dimensional data modeling.
• Excellent communication skills to bridge technical and business teams.

Expected hiring range: $115k – $135k depending on skills, experience, education, and training; relevant licensure/certifications; performance history; and work location. Bonus target: 15%.

• Medical, dental and vision coverage for employees and eligible family members, including mental health benefits.
• Annual employer contribution to a health savings account.
• Generous paid time off varying by role and tenure in addition to 10 company‑paid holidays.
• Market‑leading retirement plan including a company match on employee 401(k) contributions, with a potential discretionary contribution based on company performance (no vesting period).
• U…