Senior Data Engineer – Semantic Layer & Analytics Platforms

Senior Data Engineer – Semantic Layer & Analytics Platforms

Hybrid (In office 3 days/week) 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. 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.

What You Bring to Cambia:

Preferred Key Experience:

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.

We strongly prefer candidates with a broad range of experience—such as that gained through consulting roles or cross-functional project work—who can bring fresh perspectives and innovative solutions to our data ecosystem.

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, 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

Skills and Attributes (Not limited to):  

• Technical Expertise: Proven experience building and optimizing data pipelines and semantic layers in complex enterprise environments.

• Semantic Layer Design: Experience designing semantic layers and related database artifacts, including entities, relationships, dimensions, facts, metrics.

• Semantic Layer Engineering Expertise: 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.

• Data Platform Skills: Advanced proficiency in SQL, data modeling, and ELT/ETL design patterns; strong experience with Snowflake and dbt.

• Consulting Mindset: 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.

• Collaboration: Experience collaborating with cross-functional teams (business, product, engineering, governance, quality assurance).

• Orchestration & Automation: Familiarity with orchestration tools (e.g., Airflow) and version-controlled development workflows (CI/CD, DevOps/DataOps).

• Data Governance: Strong understanding of data governance, security, and compliance in large-scale data environments.

• Healthcare Experience: Experience in healthcare or other highly regulated industries is a plus.

• Preferred Additional Experience:

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

What You Will Do at Cambia (Not limited to):   

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

The expected hiring range for The Senior Data Engineer is $115k–$135k/year depending on skills, experience, education, and training; relevant licensure / certifications; performance history; and work location. The bonus target for this position is 15%.  The current full salary range for the this position is $104k - $171K/year.

#LI-Hybrid

About Cambia

Working at Cambia means being part of a purpose-driven, award-winning culture built on trust and innovation anchored in our 100+ year history. Our caring and supportive colleagues are some of the best and brightest in the industry, innovating together toward sustainable, person-focused health care.  Whether we're helping members, lending a hand to a colleague or volunteering in our communities, our compassion, empathy and team spirit always shine through.

Why Join the Cambia Team?

At Cambia, you can:  

• Work alongside diverse teams building cutting-edge solutions to transform health care.  
• Earn a competitive salary and enjoy generous benefits while doing work that changes lives.  
• Grow your career with a company committed to helping you succeed. 
• Give back to your community by participating in Cambia-supported outreach programs.  
• Connect with colleagues who share similar interests and backgrounds through our employee resource groups.  

We believe a career at Cambia is more than just a paycheck – and your compensation should be too. Our compensation package includes competitive base pay as well as a market-leading 401(k) with a significant company match, bonus opportunities and more.  

In exchange for helping members live healthy lives, we offer benefits that empower you to do the same. Just a few highlights include: 

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

Learn more about our benefits. 

We are happy to offer work from home options for most of our roles. To take advantage of this flexible option, we require employees to have a wired internet connection that is not satellite or cellular and internet service with a minimum upload speed of 5Mb and a minimum download speed of 10 Mb.