VBP Data Analyst 2

PacificSource is hiring a VBP Data Analyst 2 to provide data support and analytical reporting for value-based payments, reinsurance, employer and ASO business, and mandated reporting. The role extracts and analyzes data, develops reports and visualizations, supports financial reconciliation and quality assurance, and communicates findings to internal teams and external provider audiences.

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

Requirements:

• Three years' experience in health insurance or related field
• Bachelor's degree in Mathematics, Computer Science, Statistics, Engineering, Health and Medical Economics, Public Health or similar research related field
• 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
• Accountability
• Collaboration
• Communication (written/verbal)
• Flexibility
• Listening (active)
• Organizational skills/Planning and Organization
• Problem Solving
• Teamwork
• Ability to read and comprehend both written and spoken English
• Communicate clearly and effectively
• Healthcare analytics experience
• 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
• 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