Senior Data Analyst - PBM - REMOTE

Amwins; Chicago (IL); Remote; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Analyst to enhance pharmacy reporting for key pharmacy benefit management initiatives. This role involves building reports, collaborating with various departments, and ensuring the accuracy of data processes. The ideal candidate will possess strong analytical skills and a background in pharmacy claims, with proficiency in SQL and reporting tools. Join a forward-thinking team where your contributions will drive improvements and support critical healthcare initiatives. This is a fantastic opportunity to grow your skills in a dynamic environment focused on innovation and excellence.

Qualifications

• 5+ years in pharmacy benefit management or health insurance.
• Experience with pharmacy or healthcare claims data.

Responsibilities

• Build and maintain pharmacy reporting for PBM initiatives.
• Collaborate with IT and business departments to capture requirements.

Skills

SQL

Analytical Skills

Problem-Solving

Communication Skills

Education

Bachelor’s Degree

Tools

Excel

Power BI

Tableau

SAS

R

Python

Job description

Location: Remote

Job Id: 5753

# of Openings: 1

Job Requirements:

• At least one year of SQL or similar database programming experience
• At least one year of experience with pharmacy or medical claims

Purpose: The Senior Analyst will build and maintain pharmacy reporting for key Amwins Rx pharmacy benefit management (PBM) initiatives. Examples include pharmacy claims pricing validation, rebate reporting, regulatory support, and analytics process improvement. They will collaborate with team members and partner with key stakeholders to ensure accurate and maintained end-to-end processes.

Key Responsibilities:

1. Reporting & Analytics (60%)
   • Build reports and analytics under team leadership guidance.
   • Prepare data files and support team data sources.
   • Collaborate with IT and business departments to capture requirements.
   • Support ad-hoc and recurring work as needed.
2. BI & Reporting Development (30%)
   • Design, build, and maintain BI reporting with team leadership collaboration.
   • Ensure BI environment is maintained and accurate.
3. Personal Development (10%)
   • Enhance technical skills related to reporting tools and coding languages.
   • Maintain knowledge of department practices and data structures.
   • Partner with leadership to develop industry knowledge.

Qualifications:

• Highly creative with the ability to manage multiple projects.
• Effective prioritization and efficiency skills.
• Ability to work independently and in teams.
• Highly organized and deadline-driven.
• Critical thinking and problem-solving skills.
• Professional communication skills, both oral and written.

Knowledge, Experience, and Education:

• Bachelor’s Degree or equivalent experience in a related field.
• 5+ years in pharmacy benefit management, health insurance, or related industry.
• Experience with pharmacy or healthcare claims data.
• Intermediate to advanced Excel skills.
• Intermediate to expert in SQL, SAS, R, Python, or similar languages.
• Intermediate to expert in Power BI, Tableau, or Qlik (preferred).
• Knowledge of health insurance and PBM industry pricing practices (preferred).
• Knowledge of clinical drug information or manufacturer rebates (preferred).

Competencies:

Building Partnerships: Collaborate effectively to meet shared objectives.

Managing Conflict: Handle conflicts professionally with minimal disruption.

Courage: Address difficult issues directly.

Decision Quality: Make timely, effective decisions.

Valuing Differences: Appreciate diverse perspectives and cultures.

Directing Work: Provide clear guidance, delegate, and remove obstacles.