Semantic Data Engineer

Semantic Data Engineer (Healthcare)

Hybrid within Oregon, Washington, Idaho or Utah.

Join us to create a person-focused and economically sustainable health care system.

Every day, Cambia’s Data & Analytics Engineering Team is living 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. It will focus on implementing and optimizing semantic data models, ensuring seamless integration with AI workflows, and supporting advanced analytics initiatives—all in service of making our members’ health journeys easier.

Qualifications and

Certifications:

• 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 similar cloud data platforms
• Equivalent combination of education and experience

• Implement Enterprise Semantic Models:
  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.
• Data Pipeline Development:
  When necessary, 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’s capabilities.
• Analytics and AI Integration:
  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.
• Performance Tuning:
  Optimize Snowflake queries and data structures (e.g., tables, views, materialized views) to ensure high performance for semantic data access.
• Data Quality and Validation:
  Implement data quality checks and validation processes to ensure the accuracy and reliability of the semantic layer.
• Collaboration:
  
  Work 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.
• Automation and Monitoring:
  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).
• Experience with semantic technologies, including Snowflake semantic views, Microstrategy, AtScale, or Business Objects universes, and familiarity with healthcare ontologies (e.g., SNOMED, LOINC, 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’s 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.

The expected hiring range for the Semantic Data Engineer is $115k–$135k depending on…