Data Reporting Analyst or Senior, DOE

Cambia Health Solutions; Salt Lake City (UT); Hybrid; USD 71,000 - 95,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

HSA contribution

Paid time off

Work-from-home options

Parental leave

Job summary

Cambia Health Solutions, Inc. is seeking a Data Reporting Analyst (or Senior, DOE) to support sales and broker performance by mining data, building analytical models, and delivering dashboards. This role is hybrid with offices in multiple locations and relocation considerations.

You will join the Commercial Reporting and Analytics team, forecasting outcomes and informing strategic decisions while advancing governance and reporting standards across health plan operations.

Qualifications

• Bachelor’s degree in mathematics, actuarial science, statistics, computer science or related field.
• 3 years of related experience (Analyst) or 7 years (Senior) or equivalent mix of education/experience.
• Experience documenting business requirements and translating needs into reporting solutions.
• Strong communication skills and ability to work with multiple stakeholders.

Responsibilities

• Provide analytical support to sales and broker performance by mining data and interpreting results.
• Develop methodologies and analytical models, and design dashboards/reports.
• Identify issues, propose resolutions, and participate in quality improvement efforts.
• Document business requirements and maintain data structures for reporting.

Skills

Analytical skills

Problem solving

Documentation of requirements

Oral and written communication

Health plan operations knowledge

Data mining (SAS, OLAP)

Analytic programming (SAS, SQL, OLAP,,

Dashboard development

Finance/business acumen

Education

Bachelor’s degree in mathematics/actuarial science/statistics/computer science or related field

Tools

SAS

OLAP

SPSS

Minitab

Tableau

SQL

Business Objects

Crystal Reports

Job description

Data Reporting Analyst or Senior, DOE Hybrid role (3 days/week in office) at our Salt Lake City, Boise, Fargo, Portland, Vancouver, Renton, Medford, Burlington, Lewiston, Little Rock, and Springdale offices. Preference will be given to current employees and candidates who reside within a commutable distance from our Salt Lake City, Boise, Fargo, Lewiston, Little Rock, and Springdale 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 Data Analysts is living our mission to make health care easier and lives better. As a member of the Commercial Reporting and Analytics team, our Data Reporting Analysts acts as a data and analytics consultant for business areas, collecting and analyzing operational and financial data to identify key trends. They present these findings and support business leaders with forecasting to enable evidence-based decision making- all in service of making our members' health journeys easier.

Do you have a passion for serving others and learning new things? Do you thrive as part of a collaborative, caring team? Are you energized by turning data into insights that drive meaningful decisions? Then this role may be the perfect fit.

Qualifications

Data Reporting Analyst would have a bachelor's degree in mathematics, actuarial science, statistics, computer science or related field and 3 years of related experience or equivalent combination of education and experience. Data Reporting Analyst Senior would have a bachelor's degree in mathematics, actuarial science, statistics, computer science or related field and 7 years of related experience or equivalent combination of education and experience.

Skills and Attributes

• Data Reporting Analyst Keen analytical and problem-solving skills, with proven ability to perform difficult analytical tasks with minimal supervision.
• Proven ability to document business requirements.
• Solid to advanced oral and written communication skills.
• Advanced knowledge of health plan operations, data sources, and data structures within the business area.
• Knowledge of data mining tools and methods (SAS, OLAP) including server reporting services (SPSS, Minitab, Tableau).
• Knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business Objects, Crystal).
• Proven ability to design and develop reporting tools and dashboards.
• Business sense in areas such as finance, accounting, economics, risk management, public health economics, social service research, or epidemiology.
• Ability to organize, plan, and prioritize assignments across multiple projects; demonstrated project management success; able to work with minimal direction and remain flexible coordinating complex activities subject to rapid or extensive change.
• Experience with AI tools and technologies to enhance productivity and decision-making in professional settings (highly desired).

Data Reporting Analyst Senior Attributes

• Highly advanced analytical and problem-solving skills, with a proven ability to perform and manage difficult analytical tasks with minimal supervision.
• Advanced oral and written communication skills, including the proven ability to document business requirements.
• Advanced knowledge of health plan operations, data sources, and data structures within the business area.
• Advanced knowledge of data mining tools and methods (SAS, OLAP) and server reporting services (SPSS, Minitab, Tableau).
• Advanced knowledge of analytic programming tools and methods (SAS, SQL, OLAP, Business Objects, Crystal).
• Proven ability to design and develop reporting tools and dashboards.
• Well-developed business sense (finance, accounting, economics, risk management, public health economics, social service research, or epidemiology).
• Ability to organize, plan, and prioritize assignments across multiple projects, working with minimal direction and remaining flexible amid rapid or extensive changes.
• Demonstrated success with project management and progressively responsible work experience in leadership roles, with the ability to represent the division as a visible leadership presence in internal meetings.
• Experience with AI tools and technologies to enhance productivity and decision-making in professional settings highly desired.

What You Will Do at Cambia

Data Reporting Analyst Provides analytical support to sales and broker performance by mining data, conducting analysis, and interpreting results related to business needs; reviews data related to health plan operations to assist with developing cost containment strategies. Develops methodologies and approaches to new tasks and projects through the design and development of analytical models and reports. Proactively identifies issues, problems, or needed changes, recommends resolution, and participates in quality improvement efforts. Develops knowledge of health plan operations, data sources and structures, and cost containment strategies. Identifies needed reporting, assembles or directs the assembly of reports, and distributes such information; performs acceptance testing of new reports, programs, and models. Documents business requirements and methods used to generate work output. Drives analytic innovation and best practices within Cambia; actively identifies and eliminates inefficient or ineffective use of resources and recommends process improvements. Serves as a resource on analytic programming tools and methods; may supervise the gathering and analysis of information and assist in training other team members.

Data Reporting Analyst Senior Provides analytical support with a focus on sales and broker performance Architects and oversees the development of sophisticated analytical models and enterprise-level reporting solutions, developing methodologies and approaches for new tasks and projects. Develops and implements advanced analytical methodologies that become team standards, driving analytic innovation and best practices within Cambia. Establishes and maintains data governance standards and best practices within the analytics team. Develops knowledge of health plan operations, data sources and structures, and cost containment strategies. Proactively identifies issues, problems, or needed changes, recommends resolutions, and participates in quality improvement efforts. Identifies needed reporting, assembles or directs the assembly of reports, and distributes such information. Designs, develops, and directs the performance of acceptance testing of new reports, programs, and models. Documents business requirements and the methods used to generate work output. Actively identifies and eliminates inefficient or ineffective use of resources and provides recommendations on process improvements. Oversees and directs analysts on a project basis and assists in the training of staff related to these projects. Leads meetings with internal and external constituents.

Pay Ranges

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.

Data Reporting Analyst: National pay structure - applies to the Boise, Portland, Salem, Seattle/Renton/Tacoma, Burlington, Vancouver, Lewiston, and Salt Lake City metro areas: The expected offer range is $71,000 - $95,000 and the full salary range is $66,000 - $108,000 and the bonus target is 8%.

Regional pay structure - applies to North Dakota and to Arkansas, Idaho, Oregon, Washington, and Utah locations outside the metro areas listed above: The expected offer range is $63,500 - 85,900 and the full salary range is $59,000 - $98,000 and the bonus target is 8%.

Data Reporting Analyst Senior: National pay structure - applies to the Boise, Portland, Salem, Seattle/Renton/Tacoma, Burlington, Vancouver, Lewiston, and Salt Lake City metro areas: The expected offer range is $93,000 - $126,000 and the full salary range is $88,000 - $143,000 and the bonus target is 10%.

Regional pay structure - applies to North Dakota and to Arkansas, Idaho, Oregon, Washington, and Utah locations outside the metro areas listed above: The expected offer range is $85,000 - $114,000 and the full salary range is $79,000 - $129,000 and the bonus target is 10%.

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.

Benefits Highlights

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

Equal Opportunity Statement

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.

Company Overview

Cambia Health Solutions is a family of companies headquartered in Portland, Oregon, working to make healthcare simpler, more affordable and more person-focused. Through our regional health insurance plans, innovative technologies and strategic investments, we are delivering consumer-centric solutions that:

• Help people achieve better health and well-being
• Make healthcare more available, affordable, and personalized
• Are easily understood by everyone

We put people at the heart of everything we do. Our company reaches more than 70 million Americans nationwide, including more than 6 million people enrolled in our regional health plans. Cambia blends data science with a compassionate human perspective to anticipate people's needs, and empower them to make smarter health care choices.