Senior Data Engineer – Semantic Layer & Analytics Platforms

Cambia Health Solutions • Medford, OR

2d • Hybrid

About The Position

Every day, Cambia’s Data & Analytics Engineering team is living our mission to make health care easier and lives better. The Data & Analytics Engineering team is seeking a dynamic and experienced Senior Data Engineer with a passion for semantic layer development and analytics enablement. As a technical leader, you will design, build, and optimize scalable data pipelines and advanced semantic models that power analytics, data products, and operational reporting across our organization. If you have hands-on experience with tools such as Snowflake semantic views, AtScale semantics, dbt semantics, Microstrategy Archtect / Semantic Graph, or Business Objects Universes, and thrive on variety and challenge in your work, we encourage you to apply. If you’re a motivated and experienced Senior Data Engineer with a consultant’s mindset and a passion for building semantic layers and analytics platforms, we want to hear from you.

Requirements

• Experienced technical leader with a strong background in building and optimizing data pipelines, excellent SQL skills, and hands‑on expertise with Snowflake, dbt, and modern ELT practices.
• Adept at breaking down work, mentoring Data Engineers, and delivering scalable, high‑quality data solutions in complex enterprise environments.
• Experience developing, implementing, refining, and troubleshooting semantic layers.
• 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
• Proven experience building and optimizing data pipelines and semantic layers in complex enterprise environments.
• Experience designing semantic layers and related database artifacts, including entities, relationships, dimensions, facts, metrics.
• Demonstrated hands-on expertise with at least one of the following: Snowflake semantic views, AtScale semantics, dbt semantics, Microstrategy Architect / Semantic Graph, or Business Objects Universes.
• Advanced proficiency in SQL, data modeling, and ELT/ETL design patterns; strong experience with Snowflake and dbt.
• A track record of delivering high-impact data solutions across a variety of industries or business domains, with the ability to adapt quickly to new environments and requirements.
• Experience collaborating with cross-functional teams (business, product, engineering, governance, quality assurance).
• Familiarity with orchestration tools (e.g., Airflow) and version-controlled development workflows (CI/CD, DevOps/DataOps).
• Strong understanding of data governance, security, and compliance in large-scale data environments.

Nice To Haves

• Ideally, 6+ years of experience in Data Engineering or Data Platform Engineering roles, preferably with senior or lead responsibilities.
• Experience with metadata management, streaming data, and building semantic layers for analytics self-service
• Python development skills, especially for data engineering or automation tasks
• Experience integrating semantic layers with BI and analytics tools (e.g., Tableau, Power BI, Looker)
• Experience in healthcare or other highly regulated industries is a plus.

Responsibilities

• Establish Standards: Drive engineering standards and best practices for semantic layer and data platform development.
• Implement Enterprise Semantic Models: Design, build, optimize, and maintain semantic data models and database layers on Snowflake based on specifications from the Semantic Data Architect and Data Product Owner, using tools such as Snowflake semantic views, Cortex Analyst, stored procedures, and dbt.
• Data Pipeline Development: Design, build, optimize, automate, and maintain scalable ETL/ELT pipelines and data products, ensuring high data quality and platform observability.
• 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.
• Automation and Monitoring: Automate semantic layer maintenance tasks and set up monitoring to ensure system reliability and performance.
• Quality and Governance: Ensure thorough testing, documentation, and adherence to data governance, security, and compliance standards
• Platform Evolution: Assess and adopt new Snowflake features as they are released.

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