Semantic Architect

Cambia Health Solutions • Medford, OR

158d • $135,000 - $175,000

About The Position

Cambia’s Data & Analytics Engineering Team is living our mission to make health care easier and lives better. We’re seeking a seasoned Data and Analytics Engineer with extensive semantic data architecture experience to design and 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 tools, enabling advanced analytics, predictive modeling, and actionable insights. – all in service of making our members’ health journeys easier. If you're a motivated and experienced Semantic Professional looking to make a difference in the healthcare industry, apply for this exciting opportunity today!

Requirements

• Bachelor’s degree in computer science, Mathematics, Business Administration, Engineering, or a related field.
• 8 years relevant experience in a multi-platform environment, including application development or database development.
• At least 2 years working with Snowflake or similar cloud data platforms.
• Equivalent combination of education and experience.

Nice To Haves

• Experience with FHIR, HL7, or other healthcare data standards.
• Familiarity with tools like Collibra or Informatica for metadata management.
• Expertise in semantic technologies, including Snowflake semantic views, MicroStrategy, AtScale, or Business Objects universes.
• 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.
• Proficiency in dimensional data modeling.
• Proficiency in SQL and experience with Snowflake-specific features.
• Experience using code repositories such as GitLab or GitHub and CI/CD-based deployment.
• Excellent communication skills to bridge technical and business teams.

Responsibilities

• Design, develop, extend, and maintain semantic data models on Snowflake to standardize data definitions, relationships, and ontologies for healthcare data.
• Collaborate with data engineers to integrate structured and unstructured data from internal and external sources into the semantic layer.
• Develop and optimize ETL/ELT pipelines to populate the semantic layer, integrating data from diverse sources using Snowflake’s capabilities.
• Ensure the semantic layer supports analytics, BI, and AI use cases, such as predictive analytics for risk stratification, fraud detection, and member engagement.
• Work closely with the Data Governance organization to develop governance policies, metadata standards, and ontologies.
• Work with business analysts, data modelers, data engineers, and business users to translate business requirements into semantic data models.
• Optimize semantic models for query performance and scalability on Snowflake.
• Document semantic models and provide training to end-users and technical teams.

Benefits

• Medical, dental and vision coverage for employees and their 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.
• Up to 12 weeks of paid parental time off.
• Award-winning wellness programs that reward you for participation.
• Employee Assistance Fund for those in need.
• Commute and parking benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees