Data Platform Engineer III

DATA PLATFORM ENGINEER III (HEALTHCARE)
Hybrid (Office 3 days/wk – Onsite-Flex) 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/Software Engineering Team is living our mission to make health care easier and lives better. We are the Data and Analytics Solutions division within Cambia that builds and delivers data analytics products driven by value and focuses on our members health care journey. We provide enterprise data technology services by crafting data solutions that enable Analytics and AI capabilities. Our engineers specialize in a variety of technology stack like Snowpark, DBT, Apache Airflow, Stream Lit and integration with tools like Collibra, Sigma, Tableau, DBT Cloud, Alteryx and AWS Glue over Snowflake Cloud Platform.

The Senior Data Platform engineer will have extensive data product development experience specializing in database design and system testing in a cloud platform.
We are looking for a seasoned engineer who can work with Product to build our software and data products with a good technical vision – all in service of making our members’ health journeys easier.  

If you're a motivated and experienced Data Platform Engineer looking to make a difference in the healthcare industry, apply for this exciting opportunity today!
What You Bring to Cambia: 

Qualifications and Certifications:  

• Bachelor's degree in Computer Science, Engineering, or related field
• 6-8+ years of relevant experience in application and database development
• 6+ years of launching, maintaining and testing data products and 3+ years of experience in data modeling, design and architecture
• 6+ years of demonstrated proficiency writing complex, efficient SQL scripts, including complex joins, aggregations, and use of analytics/windowing functions.
• 4+ years of experience in cloud platforms such as Snowflake and AWS
• Equivalent combination of education and experience

Skills and Attributes (Not limited to):  

• Experience in building and maintaining batch data pipelines using technologies like Airflow, Spark, EMR, S3, etc
• Strong dedication to code quality, automation and operational excellence including CI/CD pipelines, unit/integration tests.
• Value SQL as a flexible and extensible tool and are comfortable with modern SQL data orchestration tools like DBT, Mode, or Airflow.
• Experience working with different performant warehouses and data lakes like Snowflake or equivalent.
• Maintain data privacy and integrity, and always act in the best interest of consumers
• Experience integrating data from multiple sources into one or more targets.
• After initial training, able to maintain awareness, monitor, and manage direct computing costs, such as Snowflake credits.
• Intermediate knowledge around object oriented languages like Java would be desirable but not required.
• Proficient with defensive programming.
• Adhere to Cambia Coding Standards and guidelines and contribute to improving our technology and coding standards.
• Able to adapt to changing technologies and methodologies and apply them to technological and/or business needs of limited scope

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

Note that these responsibilities are representative but not exhaustive. Higher-level roles involve successively stronger degrees of initiative taking and innovation beyond the core responsibilities listed here.

• Design, Build and Maintain scalable data pipelines using ETL and ELT on cloud platforms

• Develop Data Integration Solutions to connect various data sources to a single unified data source while ensuring data architecture that supports a single source of truth

• Develop efficient, effective, and maintainable program and system solutions to solve complex business problems

• Develop automated workflows for data ingestion, transformation, and applications integration

• Writes efficient code in languages such as SQL and Python.

• Responsible for supporting our Product and Business partners by researching, identifying and resolving highly technical programming problems

• Meets established deadlines while maintaining a high level of quality of work

• Determines program design and prepares work estimates for development or changes for assigned work

• Performs testing and documents the results

• Expected to be proficient in using version control software like GitHub, GitLab

• Expected deliverables include but are not limited to requirement analysis, system analysis, system design, data models, program design, source code development, test case development, testing, and documentation

• Adheres to policies, procedures, and standards in place within IT/Engineering as well as all corporate policies, procedures and standards established by Cambia.  Those include, but are not limited to, technical and architecture standards, production implementation standards, regular status reporting, regular participation in team, regular one on one meetings with Lead or Manager, and providing work estimates and regular time tracking

• May be responsible for on-call duties as defined by management.

The expected hiring range for The Data Platform Engineer III is $120k–$145k, 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 this position is $104k Low/ $169k MRP

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.