Programmer Analyst II

Cambia Health Solutions, Inc.; Salt Lake City, Northern (UT, KY); Hybrid; USD 93,000 - 125,000; Full time

Benefits offered by this job

Work from home options

Job summary

Cambia Health Solutions, Inc. in Salt Lake City seeks a Programmer Analyst II to design, develop, and maintain data-driven applications and reports for the Operations Business Intelligence team.

The role is hybrid with three days in the office and involves mentoring others and translating business needs into technical solutions. The successful candidate will have a Bachelor's degree in a related field and 7+ years of experience, including healthcare processes, with strong SQL/ETL and reporting

Qualifications

• Bachelor's degree in Mathematics, Operational Technology Management, Computer Science, Operations Research, or an equivalent related field, plus 7+ years of job-related work experience, including 2+ years in healthcare and healthcare business processes - or an equivalent combination of education and related work experience.

Responsibilities

• Design, develop, and maintain reports, programs, and analytical models that meet the needs of business partners across Cambia Health Solutions.
• Write clean, well-documented code and configuration using approved technologies to implement business requirements.
• Develop and execute tests to validate accurate implementation of business requirements.
• Actively manage a Local Analytic Workspace (LAW) or Collaborative Workspace (CLAW) to support Health Plan Operations' analytic and reporting needs.
• Proactively identify issues, communicate concerns to management, and apply knowledge of cross-departmental operations to drive effective solutions.
• Participate in peer review processes and contribute to a culture of quality and continuous improvement.
• Mentor and assist team members and internal business partners to build collective capability.

Skills

SQL

ETL Tools

Tableau

Sigma

Snowflake

DBeaver

Toad

Relational DBs

Education

Bachelor's degree in Mathematics, Operational Technology Management, Computer Science, Operations Research, or related field

Tools

Toad

DBeaver

Snowflake

Talend

DBT

Job description

Programmer Analyst II Hybrid 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 dedicated team of Programmer Analysts is living our mission to make health care easier and lives better. As a member of the Operations Business Intelligence team, our Programmer Analyst II designs, develops, and delivers data-driven programming solutions that power smarter decisions across the organization - all in service of creating an economically sustainable health care system.

Do you thrive on solving complex analytical problems with creativity and curiosity? Are you energized by translating business needs into elegant technical solutions and mentoring others along the way? Then this role may be the perfect fit.

Qualifications:

• Bachelor's degree in Mathematics, Operational Technology Management, Computer Science, Operations Research, or an equivalent related field, plus 7+ years of job-related work experience, including 2+ years in healthcare and healthcare business processes - or an equivalent combination of education and related work experience.

Skills and Attributes:

• Demonstrated proficiency in SQL coding (Toad, DBeaver, Snowflake, etc.), ETL tools (Talend, DBT, etc.), and reporting tools (Tableau, Sigma, etc.)
• Familiarity with relational databases and client-server concepts.
• Proven ability to perform complex analytical tasks with minimal supervision and manage large-risk, complex projects independently.
• Strong understanding of software testing principles and the full development lifecycle, including coding, testing, and debugging.
• Ability to interpret business requirements and translate them into clear design specifications and technical documentation.
• Skill in negotiating solutions and building consensus among stakeholders with competing Business Intelligence needs.
• Advanced knowledge of program evaluation concepts, including effectiveness analysis, measurement, and reporting.
• Experience with AI tools and technologies to enhance productivity and decision-making in professional settings highly desired.
• Solid oral and written communication skills, including presentation and technical writing.
• Knowledge of healthcare and healthcare business processes a plus.

What You Will Do at Cambia:

• Design, develop, and maintain reports, programs, and analytical models that meet the needs of business partners across Cambia Health Solutions.
• Write clean, well-documented code and configuration using approved technologies to implement business requirements.
• Develop and execute tests to validate accurate implementation of business requirements.
• Actively manage a Local Analytic Workspace (LAW) or Collaborative Workspace (CLAW) to support Health Plan Operations' analytic and reporting needs.
• Proactively identify issues, communicate concerns to management, and apply knowledge of cross-departmental operations to drive effective solutions.
• Participate in peer review processes and contribute to a culture of quality and continuous improvement.
• Mentor and assist team members and internal business partners to build collective capability.

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 $92,650-125,350, the full salary range is $87,000-142,000 and the bonus target is 15%.
• North Dakota: The full salary range is $90,435-149,219.

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?

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

Interested in driving accessibility, affordability and quality health care for real people?

Everyone is a health care consumer deserving of a simpler, more personalized experience.

Cambia is transforming the health care system to revolve around people.

For over 100 years we've designed people-first health solutions rooted in the nation's first health plan, a loggers' wage pool established in the Pacific Northwest.

Today that pioneering spirit aligns our family of over 20 companies, including 4 not-for-profit BlueCross and BlueShield licensed health plans serving over 3 million Americans.

Cambia blends data science with a compassionate human perspective to anticipate people’s needs, and empower them to make smarter health care choices.