REQUIRED SKILLS

• Understanding of pharmacy claims and the PBM industry.
• Strong command of Tableau, Excel and SQL.
• Understanding of TSQL.
• Experience with SQL 2008 or above.

Provide analytical support through communication with internal staff and external customers/partners to create a variety of reports using key business data and troubleshoot reporting discrepancies.

• Retrieve, consolidate, analyze and summarize prescription and PBM data.
• Detailed analysis of healthcare and member data to look for discrepancies and provide information back to staff.
• Work with customers, internal business, clinical and technical staff to create, interpret and validate data.
• Collaborating with internal and external teams to design meaningful reports.
• Compiling and organizing data to produce on-going and ad-hoc reports requested by the business.
• QA data to ensure quality and accuracy.
• Utilize data analysis tools such as Excel, Transact SQL.
• Abide by all obligations under HIPAA related to Protected Health Information (PHI).
• If a HIPAA violation is discovered, whether individually or by another, you must report the violation to the Compliance Officer and/or Human Resources.
• Attend, complete, and demonstrate competency in all required HIPAA Training offered by the company.
• Flexibility to understand, appreciate and embrace that this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice

Provide analytical support through communication with internal staff and external customers/partners to create a variety of reports using key business data and troubleshoot reporting discrepancies.

• Retrieve, consolidate, analyze and summarize prescription and PBM data.
• Detailed analysis of healthcare and member data to look for discrepancies and provide information back to staff.
• Work with customers, internal business, clinical and technical staff to create, interpret and validate data.
• Collaborating with internal and external teams to design meaningful reports.
• Compiling and organizing data to produce on-going and ad-hoc reports requested by the business.
• QA data to ensure quality and accuracy.
• Utilize data analysis tools such as Excel, Transact SQL.
• Abide by all obligations under HIPAA related to Protected Health Information (PHI).
• If a HIPAA violation is discovered, whether individually or by another, you must report the violation to the Compliance Officer and/or Human Resources.
• Attend, complete, and demonstrate competency in all required HIPAA Training offered by the company.
• Flexibility to understand, appreciate and embrace that this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.