PURPOSE

This position assists the Manager of Business & Healthcare Analytics and other departments with their data information needs by analyzing medical and pharmacy claims, eligibility data, and external data. This includes understanding business needs, defining and communicating deliverables, as well as performing any necessary data manipulation and aggregation. This individual will be a primary user of the Fund’s data warehouse as well as various internal information systems.

The senior analyst will also mentor other analysts in defining methodologies and coding to improve efficiency and accuracy.

ESSENTIAL JOB FUNCTIONS AND DUTIES

• Collects, compiles, and analyzes data to measure and report on provider and program performance
• Responds to requests for data by determining users’ needs, collecting, organizing, and analyzing data, and providing accurate and complete reports
• Works with other analysts to perform financial analysis of hospital, physician, and ancillary cost and utilization
• Works with other analysts to perform a variety of ad-hoc analysis and reports as requested
• Produces standard periodic reports to meet users’ needs
• Identifies, develops, and implements methods for improving reporting efficiency
• Performs checks and audits of various data sources to ensure data is accurate and complete
• Maintains and applies knowledge of current trends, practices, and developments in health care
• Mentors and trains other analysts
• Sets goals and achieves measurable results
• Contributes ideas to setting and achieving department goals
• Demonstrates the Fund’s Diversity and Inclusion (D&I) principles in their conduct at work and contributes to a safe inclusive culture with equitable opportunities for success and career growth
• Exemplifies the Fund’s BETTER Values in contributing to a respectful, trusting, and engaged culture of diversity and inclusion
• Performs other duties as assigned within the scope of responsibilities and requirements of the job
• Performs Essential Job Functions and Duties with or without reasonable accommodation

ESSENTIAL QUALIFICATIONS

Must be fully vaccinated for COVID- 19

Years of Experience and Knowledge

• Minimum of 5-years’ experience in data analytics; healthcare and claims data analysis preferred
• Minimum of 5-years’ experience with SQL programming; additional experience with SAS preferred
• Minimum of 2-years’ experience with Power BI including visualizations, dataset building, and report authoring
• Working knowledge and experience in industry coding (revenue codes, ICD 9 &10 classifications, CPT codes, etc.)
• High-level understanding of analytical methodologies

Education, Licenses, and Certifications

• Bachelor's degree in Statistics, Economics, Mathematics, Informatics, Computer Science or related field or equivalent work experience required
• Preferred: Master’s degree in Statistics, Economics, Mathematics, Informatics, Computer Science, or related field

Skills and Abilities

• Advanced level Microsoft Office skills (PowerPoint, Word, Outlook)
• Advanced level Microsoft Excel skills
• 10% ~ 15% travel
• Advanced SQL programming skills
• Advanced SAS skills preferred
• Advanced Power BI skills
• Strong attention to detail
• Ability to:
  • Write and communicate effectively
  • Work well independently or as part of a team
  • Manage and lead complicated projects and analysis
  • Be open to pursuing additional training/education as required to meet emerging requirements
  • Manage competing deadlines and multiple projects in a fast-paced environment
  • Perform the essential functions of this job with or without reasonable accommodation