VBP Data Analyst 2

PacificSource; Idaho; Hybrid; USD 65,000 - 110,000; Full time

Benefits offered by this job

Flexible telecommute policy

Medical

Vision

Dental insurance

401(k) plan

Tuition reimbursement and training

Life insurance

Job summary

PacificSource in Boise, Idaho is seeking a health analytics professional to support data extraction, cleaning, and reporting for critical analysis and RFP processes. You will develop visualizations with Tableau or Power BI, work with data warehouses and nonstandard sources, and ensure accuracy and timely delivery across employer groups and ASO projects.

Preferred candidates have a Bachelor's degree in a related field and at least three years in health insurance analytics, with knowledge of SAS,

Qualifications

• Three years’ experience in health insurance or related field.
• Healthcare analytics experience is preferred.
• Bachelor's degree in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health or similar research related field.
• General knowledge of statistics/analytical programming tools (R, SAS, SPSS).

Responsibilities

• Provide data support and coordination for analytics and reporting needs.
• Extract data from data warehouse and nonstandard sources to meet project requirements.
• Clean, transform, and pre-process data using t-SQL, SAS, and similar tools.
• Develop data visualizations with Tableau or Power BI for interactive data analysis.
• Develop reports and analytical processes to support RFPs, ASO, and employer groups.
• Assist in cost and utilization analysis related to RFPs and sales requests.

Skills

Data extraction

Data cleaning

Data transformation

T-SQL

SAS

Tableau

Power BI

Reporting

Analytics

R

SPSS

Education

Bachelor's degree in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health or similar research related field

Tools

Tableau

Power BI

SAS

T-SQL

Job description

Essential Responsibilities:

• Provides essential data support and coordination activities for various business critical analysis and reporting needs.
• Perform accurate and complete data extraction from data warehouse as well as nonstandard data sources to meet project requirements as directed.
• This would include cleaning, transformation and pre-processing data using software programs such as t-SQL, SAS, etc.
• Support the development of data visualization solutions that allow customer to interact with the data using data visualization software solutions such as Tableau or Microsoft Power BI.
• Develop reports and analytical solutions and processes to support the RFP process, large employer, ASO as well as various state and federal requests.
• Calculate and analyze value based payment terms including development of reports, running of monthly report processes as well as reporting to support financial reconciliation processes.
• Support presentation of complex data, analysis and findings to teams in a way that is clear and understandable.
• Develop and maintain documentation and training materials including job aids.
• Assist in evaluating impact of business changes on risk reports specifications such as plan, benefit, network, provider configuration and payment and other operational changes.
• Prepare ad hoc analysis related to cost and utilization opportunities related to RFP, employer groups, ASO groups and other Sales/Marketing requests.
• Assists with quality assurance adherence to ensure accuracy, completeness, and reliability of project-related information data resources and reporting initiatives such as participating in data validation projects and providing feedback on development of unit testing, error checks and validation processes.
• Develop general health insurance business content knowledge as well as specific knowledge related to assigned business areas of analytics support.

Supporting Responsibilities:

• Meet department and company performance and attendance expectations.
• Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information.
• Perform other duties as assigned.

Success Profile

Work Experience: Three years’ experience in health insurance or related field. Healthcare analytics experience is preferred.

Education, Certificates, Licenses: Bachelor's degree in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health or similar research related field.

Knowledge: General knowledge of business principles, theories and concepts. Proven ability to manage multiple projects and competing deadlines. Ability to manage workload within a team environment or with minimal direct supervision. Ability to conceptualize solutions to complex problems; readily anticipates problems and identifies solutions. Ability to deal responsibly with confidential information. Ability to develop, document and adhere to department policies and procedures. General knowledge of in at least one statistical/analytical programming tools such as R, SAS, SPSS. General knowledge of other technical applications such as Tableau, Power BI and web-based database tools. Skilled in Microsoft Office: Word, Excel, PowerPoint and Outlook.

Preferred Knowledge: Familiarity with Medicare Five-Star, Oregon Quality Incentive Measures and/or NCQA HEDIS, Health Care Payment Learning & Action Network (LAN) and Alternative Payment Model framework, and Facets claims processing system. Working knowledge of medical costs is desired, while experience with medical coding and terminology. Master’s degree or above in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health or similar research related field preferred.

Competencies: Building Customer Loyalty Building Strategic Work Relationships Contributing to Team Success Planning and Organizing Continuous Improvement Adaptability Building Trust Work Standards

Environment: Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately less than 5% of the time.

Skills: Accountability, Collaboration, Communication (written/verbal), Flexibility, Listening (active), Organizational skills/Planning and Organization, Problem Solving, Teamwork

Compensation Disclaimer

The wage range provided reflects the full range for this position. The maximum amount listed represents the highest possible salary for the role and should not be interpreted as a typical starting wage. Actual compensation will be determined based on factors such as qualifications, experience, education, and internal equity. Please note that the stated range is for informational purposes only and does not constitute a guarantee of any specific salary within that range. Base Range: $64,871.24 - $110,281.11

Our Values

We live and breathe our values. In fact, our culture is driven by these seven core values which guide us in how we do business:

• We are committed to doing the right thing.
• We are one team working toward a common goal.
• We are each responsible for customer service.
• We practice open communication at all levels of the company to foster individual, team and company growth.
• We actively participate in efforts to improve our many communities-internally and externally.
• We actively work to advance social justice, equity, diversity and inclusion in our workplace, the healthcare system and community.
• We encourage creativity, innovation, and the pursuit of excellence.

Physical Requirements

• Stoop and bend.
• Sit and/or stand for extended periods of time while performing core job functions.
• Repetitive motions to include typing, sorting and filing.
• Light lifting and carrying of files and business materials.
• Ability to read and comprehend both written and spoken English.
• Communicate clearly and effectively.

Disclaimer

This job description indicates the general nature and level of work performed by employees within this position and is subject to change. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position. Employment remains AT-WILL at all times. PacificSource is anything but a typical health insurance company. Founded in 1933, we’re an independent, not-for-profit organization that puts our members, and their communities first—across Idaho, Oregon, Montana, and Washington. It's our employees who make it happen: promoting health equity and partnering with providers to deliver better access to optimal, affordable care. So yes, with PacificSource, you get to do great things. In our effort to put members first—more than 525,000 of them—initiative, commitment, and hard work are supported and rewarded with excellent benefits, competitive wages, and opportunities for personal growth and advancement.

Benefits

• Flexible telecommute policy
• Medical
• Vision
• Dental insurance
• Incentive program
• Paid time off and holidays
• 401(k) plan
• Volunteer opportunities
• Tuition reimbursement and training
• Life insuranceOptions such as a flexible spending account

Accolades

• Top Workplace 2026, 2025 and 2024 USA | USA Today
• 2025 Healthcare Top Workplaces | Energage
• Top Workplaces # 6 Healthiest Employer of Oregon 2025 | Portland Business Journal
• Top Workplace 2024, 2023 and 2022 for Oregon and SW Washington | The Oregonian
• Top Workplace 2025, 2024, 2023 and 2022 for the Treasure Valley | Idaho Press
• Certified Age Friendly Employer, 2023 | Age Friendly Institute

PacificSource is an equal opportunity employer. Click here to review our AAP Policy Statement. If you have questions about working at PacificSource or need help with your application, please email [e-mail].