VBP Data Analyst 2

PacificSource•Portland, OR

About The Position

The VBP Data Analyst 2 provides analytical support for reinsurance, large employer RFPs, large employer and ASO business, and state- or federally mandated reporting and analyses. The role may involve value-based payments, provider contract language, healthcare utilization and benefits, and applicable state and federal guidelines. The analyst collaborates with level 3 and 4 analysts and analytics management, as well as multiple departments, to deliver timely, accurate, understandable reporting for external provider audiences. The position may also support validation of data used in VBP settlement and payment processes, documentation and process development, financial guidance, cost savings and process improvement, and financial governance and oversight. The analyst extracts, cleans, transforms, and prepares data from data warehouses and other sources; supports interactive data visualization; develops reports and analytical processes; calculates and analyzes value-based payment terms; and supports monthly reporting and financial reconciliation. The role presents complex findings clearly, maintains documentation and training materials, assesses the effects of business changes on risk-report specifications, and prepares ad hoc cost and utilization analyses. It also supports quality assurance and data validation, builds health insurance and assigned business-area knowledge, and follows company privacy policies and HIPAA requirements. The work is performed in a general office setting with ergonomically configured equipment, with travel required approximately less than 5% of the time.

Requirements

Three years of experience in health insurance or a related field.
Bachelor’s degree in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health, or a similar research-related field.
General knowledge of business principles, theories, and concepts.
Ability to manage multiple projects and competing deadlines.
Ability to manage workload in a team environment or with minimal direct supervision.
Ability to conceptualize solutions to complex problems, anticipate problems, and identify solutions.
Ability to handle confidential information responsibly.
Ability to develop, document, and follow department policies and procedures.
General knowledge of at least one statistical or analytical programming tool, such as R, SAS, or SPSS.
General knowledge of technical applications such as Tableau, Power BI, and web-based database tools.
Proficiency with Microsoft Office, including Word, Excel, PowerPoint, and Outlook.
Skills in accountability, collaboration, written and verbal communication, flexibility, active listening, organization and planning, problem solving, and teamwork.
Ability to read and comprehend written and spoken English, and communicate clearly and effectively.

Nice To Haves

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

Responsibilities

Provide data support and coordination for business-critical analysis and reporting.
Extract data accurately and completely from data warehouses and nonstandard sources; clean, transform, and preprocess data using tools such as T-SQL and SAS.
Support development of interactive data visualizations using tools such as Tableau or Microsoft Power BI.
Develop reports and analytical solutions and processes for RFPs, large employers, ASO groups, and state and federal requests.
Calculate and analyze value-based payment terms; develop reports, run monthly reporting processes, and support financial reconciliation.
Present complex data, analyses, and findings clearly to teams.
Develop and maintain documentation and training materials, including job aids.
Evaluate the impact of business changes on risk-report specifications, including changes to plans, benefits, networks, provider configurations, payments, and other operations.
Prepare ad hoc analyses of cost and utilization opportunities for RFPs, employer groups, ASO groups, and other Sales and Marketing requests.
Support quality assurance and data validation, and provide feedback on unit testing, error checks, and validation processes.
Develop general health insurance business knowledge and specific knowledge of assigned analytics support areas.
Meet department and company performance and attendance expectations.
Follow PacificSource privacy policies and HIPAA requirements for the confidentiality and security of protected health information.
Perform other duties as assigned.