Data & Analytics Platform Engineer IV

Cambia Health Solutions; Portland (OR); Hybrid; USD 114,000 - 143,000; Full time

Benefits offered by this job

Medical benefits

401(k) with company match

Parental leave

Work from home options

Job summary

Cambia Health Solutions is seeking a Data & Analytics Platform Engineer IV to lead and deliver scalable Snowflake-based frameworks. You will design data pipelines, governance, and RBAC configurations to support analytics and reporting across Cambia.

This hybrid role requires deep Snowflake expertise and strong collaboration with data modeling, product, QA, and engineering teams. Candidates should have 7-8 years in data engineering, a related bachelor’s degree, and experience with ELT/ETL,

Qualifications

• 7-8 years of relevant experience in data platform engineering or data engineering, with senior/lead experience.
• Bachelor’s degree in a related field or equivalent experience.
• Experience with Snowflake, SQL, dbt, and ELT/ETL design patterns.
• Strong Python development and Snowflake SQL skills; experience with REST APIs.

Responsibilities

• Own delivery of technical projects and mentor junior Data Engineers.
• Architect, build, tune, and automate scalable Snowflake-based frameworks for Data and Analytics teams.
• Partner with Data Modeling to design scalable data models and warehouse layers.
• Optimize Snowflake performance, query tuning, and workload isolation.
• Ensure code quality, testing, documentation, and platform observability.

Skills

Snowflake

SQL

Python

dbt

ELT/ETL design

Airflow

REST API

GitLab CI/CD

Snowpark

Education

Bachelor's degree in Computer Science, Mathematics, Business Administration, or related field

Tools

Snowflake

dbt

Airflow

Docker

Kubernetes

Snowpark Container Services

Job description

Data & Analytics Platform Engineer IVHybrid role (3 days/week in office) at our Salt Lake City, Boise, Fargo, Portland, Vancouver, Renton, Medford, Burlington, Lewiston offices.Preference will be given to current employees and candidates who reside within a commutable distance from our Salt Lake City, Boise, Fargo and Lewiston offices or who are willing to relocate.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 Platform Engineering team helps advance our mission to make health care easier and lives better. We are seeking a Senior Data Engineer to join the team as a technical lead, helping shape and deliver scalable platform capabilities that enable data engineering teams across Cambia. In this role, you will design, build, and optimize CI/CD Snowflake framework, Airflow orchestration libraries, database environment cloning capabilities, data masking solutions, and row-level access policy frameworks, and create future accelerators and automation related to data engineering workloads. These platform-wide solutions help teams create data products more efficiently and support conventional analytics, agentic analytics, and operational reporting across the organization. Our technology environment includes Snowflake, dbt, SQL stored procedures, PostgreSQL, Snowflake Streamlit Applications, Snowpark Container Services, Open Flow, REST API Development, Docker, and Airflow.If you're a motivated and experienced Mid/Senior Data Platform Engineer looking to make a difference in the healthcare industry, apply for this exciting opportunity today!What You Bring to Cambi a:Preferred Key Experience:We are looking for an experienced engineer with a strong background in designing and building reusable Snowflake platform frameworks using Python and Snowflake SQL stored procedures. The ideal candidate has experience building data and analytics platform solutions on Snowflake that improve the velocity and productivity of data engineering teams. Experience optimizing data pipelines, applying advanced SQL skills, working with dbt, and using modern ELT practices is also highly desired. This role is well suited for someone who can break down complex work, provide technical guidance to junior data engineers, and deliver scalable, high-quality, reusable, and performant Snowflake platform solutions in complex enterprise environments.Qualifications and Certifications:The Data & Analytics Platform Engineer IV should have at least 7-8 years of relevant experience in data platform engineering or data engineering, including senior or lead-level experience.Bachelor’s degree in Computer Science, Mathematics, Business Administration, or a related field. An equivalent combination of education and relevant experience may be considered in place of a degree.Experience with a business area supported by this position is preferred, such as Provider Network and Contract Management, Digital Solutions, Pricing, Membership, or Claims.Skills and Attributes :Deep expertise with Snowflake, SQL, dbt or other ETL tools, and ELT/ETL design patterns.Expert-level knowledge of developing Python applications and Snowflake Streamlit applications.Experience building CI/CD pipelines using GitLab CI/CD, CircleCI, or similar frameworks.Experience developing stored procedures using SQL or Python, preferably in Snowflake.Experience in building Python based applications on Snowpark Container ServicesDemonstrate experience in calling and building REST API applicationsFamiliarity with Airflow, Snowflake Tasks, or similar orchestration tools.Familiarity with containerization technologies like Docker, Kubernetes, etc.Strong data modeling, pipeline design, and performance optimization skills.Experience migrating from one platform to another and integrating data into new and existing tables in the target platform.Ability to think strategically, understand the full scope of work, and translate big-picture goals into detailed execution plans.Strong data profiling skills, including the ability to identify unique and primary keys and determine cardinality, data type, precision, scale, and skew.Excellent communication skills, with the ability to collaborate within the team and across product, QA, and other partner teams.Understanding of data governance, security, and compliance principles.Nice to Have :Experience in health care or complex enterprise data environments.Experience with semantic layers, metadata management, or streaming data.Experience building AI pipelines using modern large language model frameworks.What You Will Do at Cambia:Own delivery of technical projects and mentor junior Data Engineers; drive engineering standards and best practices.Architect, build, tune, and automate scalable Snowflake-based frameworks for Data and Analytics teams, including data privacy, database object management, data engineering pipeline orchestration, database environment management, and RBAC configuration and management.Partner with the Data Modeling team to design scalable data models and warehouse layers that support analytics and operational workloads.Optimize Snowflake performance, including query tuning, compute sizing, and workload isolation.Partner with analytics, product, data engineering, and business teams to deliver high-quality data & analytics platform solutions.Ensure implementation quality and performant code, thorough testing, extensive documentation, and platform observability. Pay ranges vary based on the candidate's work location. The expected hiring range depends on skills, experience, education, and training; relevant licensure / certifications; and performance history.Oregon, Washington, Utah, and Idaho: The expected hiring range is $114,000 - $143,000, the full salary range is $114,000 - $186,000, and the bonus target is 15%.North Dakota: The expected hiring range is $101,000 - $134,000, and the full salary range is $101,000 - $167,000.About CambiaWorking 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.As part of our security requirements, new hires will need access to a personal mobile device to set up Multi-Factor Authentication (MFA) upon joining the company. MFA is an important layer of protection for accessing Cambia systems and is required for all employees.We are an Equal Opportunity employer dedicated to a drug and tobacco-free workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, age, sex, sexual orientation, gender identity, disability, protected veteran status or any other status protected by law. A background check is required.If you need accommodation for any part of the application process because of a medical condition or disability, please email [e-mail] . Information about how Cambia Health Solutions collects, uses, and discloses information is available in our Privacy Policy .