Health Plan Data Analyst II (SQL required)
About The Position
The Health Plan Data Analyst II is responsible for extracting, analyzing, reporting, tracking and monitoring provider data across business functions, systems and interfaces. This role involves supporting existing provider data operations and new market implementations, performing disruption analysis, and assimilating large or complicated data into meaningful formats. The analyst will also serve as a Project Manager for select initiatives, develop performance improvement plans, and coordinate activities related to provider network data management and reporting. Additionally, the role involves developing database structures and reports, creating queries for data retrieval and validation, and reviewing provider organizations and systems to support contract negotiation and recruitment. Collaboration with internal and external partners for provider network reporting and analysis, tracking State files and recruitment information, and preparing NCQA documentation are also key responsibilities. The Health Plan Data Analyst II will act as a Subject Matter Expert for provider data and its impact on downstream processes.
Requirements
- Bachelor’s degree or equivalent years of relevant work experience is required
- Minimum of three (3) years of data analysis or experience in a health care setting is required
- Experience with Cognizant Facets Provider application is required
- Proficient in data analysis and use of analytics / reporting tools such as Power BI
- Demonstrates analytical and supporting technical skills to include SQL capabilities
- Excellent written and verbal communication skills
- Ability to meet tight deadlines
- Extreme flexibility as projects and priorities shift
Nice To Haves
- Managed care experience is preferred
- Project management experience is preferred
- Advanced Microsoft Excel, Access, and Word skills
- Knowledge and understanding of Facets data model
- Experience with Visio and PowerPoint preferred
- Working knowledge of provider data repositories and directories preferred
- Ability to work independently and within a team environment
Responsibilities
- Participate as a member of Health Partner Lifecycle (HPLC) team to support existing provider data operations and new market implementations
- Perform disruption analysis activities for assigned markets
- Assimilate large quantities and/or complicated data into meaningful formats for tracking and status requirements
- Serve as Project Manager for select HPLC initiatives
- Develop Performance Improvement initiatives/corrective action plans to improve quality of provider data and network development
- Coordinate activities with regard to provider network data management and reporting
- Develop database structures and reports as needed
- Develop queries to aid in information retrieval, validation and updating of provider databases
- Review provider organizations and systems for development of analyses that support contract negotiation and provider recruitment processes
- Work with both internal and external partners to gain information for provider network reporting and analyses
- Coordinate and track all State files, hospital, physician and ancillary recruitment information
- Prepare NCQA documentation for assigned markets as appropriate
- Act as Subject Matter Expert for provider data and impacts to downstream processes
- Perform any other job duties as requested
Benefits
- Substantial and comprehensive total rewards package
- May qualify for a bonus tied to company and individual performance
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
