Semantic Data Engineer

Cambia Health Solutions • Portland, OR

50d • Hybrid

About The Position

SEMANTIC DATA ENGINEER (HEALTHCARE) Hybrid - within Oregon, Washington, Idaho or Utah Build a career with purpose. Join our Cause to create a person-focused and economically sustainable health care system. Who We Are Looking For: 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. This role 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. If you're a motivated and experienced Semantic Engineer 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
• 3+ years relevant experience in a multi-platform environment, including, but not limited to application development or database development
• At least 1 year working with Snowflake or similar cloud data platforms
• Equivalent combination of education and experience
• Proficiency in SQL, Python, or other scripting languages for data processing and pipeline development.
• Experience using code repositories such as GitLab or GitHub and CI/CD-based deployment.
• Experience with semantic technologies, including Snowflake semantic views, MicroStrategy, 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 OpenFlow, Airflow).
• Knowledge of healthcare regulations (e.g., HIPAA) and data security best practices.

Nice To Haves

• 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.

Responsibilities

• 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.

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, with a potential discretionary contribution based on company performance (no vesting period).
• Up to 12 weeks of paid parental time off (eligibility requires 12 months of continuous service with Cambia immediately preceding leave).
• 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: Mid Level
• Number of Employees: 5,001-10,000 employees