VBP Data Analyst 2

pacificsource; North Carolina; Hybrid; USD 90,000 - 130,000; Full time

Job summary

PacificSource is seeking an analytics professional to support reinsurance, large employer RFPs, ASO projects and related regulatory reporting in a healthcare setting. The role involves data extraction from data warehouses and nonstandard sources, building reports, and creating visualizations with Tableau or Power BI to inform contract and cost analyses.

You will collaborate with analysts and management across departments to validate data, support financial governance, and drive cost-saving

Qualifications

• Provide essential data support and coordination for critical analysis and reporting.
• Extract data from data warehouse and nonstandard sources; clean and transform data using tools such as t-SQL, SAS.
• Develop data visualization solutions using Tableau or Power BI to enable user interaction with data.
• Develop reports and analytical solutions to support RFPs, large employer, ASO and state/federal requests.
• Analyze value-based payment terms and support monthly reporting and financial reconciliation processes.
• Present complex data, analysis and findings to teams clearly and understandably.
• Develop documentation and training materials including job aids.
• Evaluate impact of business changes on risk reports and provider configurations and payments.
• Prepare ad hoc analyses related to cost and utilization opportunities.

Responsibilities

• Provide essential data support and coordination for critical analyses and reporting.
• Perform accurate data extraction from data warehouse and nonstandard sources, including cleaning and transformation.
• Support the development of data visualizations with Tableau or Power BI.
• Create reports and analytical solutions for RFPs, ASO, large employer projects, and regulatory requests.
• Analyze value-based payment terms and support monthly reporting and reconciliation.
• Present findings clearly to teams and stakeholders.
• Develop and maintain documentation and training materials.
• Assess impact of changes on risk reports and provider configurations.
• Produce ad hoc analyses for cost and utilization opportunities.

Skills

Data extraction

Data analysis

Data visualization

Report development

Financial reconciliation support

Communication of results

Documentation

Cross-functional collaboration

Education

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

Tools

t-SQL

SAS

Tableau

Power BI

Job description

Looking for a way to make an impact and help people?

Join PacificSource and help our members access quality, affordable care!

PacificSource is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, sex, sexual orientation, gender identity, national origin, genetic information or age. PacificSource values the diversity of our community, including those we hire and serve. We are committed to creating and fostering a work environment in which individual differences and diversity are appreciated, respected and responded to in ways that fully develop and utilize each person's talents and strengths.

Primary subject of analytic support related to support of reinsurance, large employer RFP, large employer and ASO, state and/or federally mandated reporting and analyses. Analytical role may vary and involve knowledge of value based payments, provider contract language, healthcare utilization, healthcare benefits and state and federal guidelines. The role will also collaborate with level 3 and 4 analysts and analytics management in coordination of projects with multiple departments in supporting contractually required reporting in a timely, accurate and easy to understand format for external provider audiences. Additional tasks may include assisting with components of validating data used in the VBP settlement and payment processes; initiating documentation and processes; provides financial guidance and support; supports cost savings and process improvement efforts; provides financial governance and oversight.

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.