Pharmacy Data Analyst (214531-043): MedAssets, Inc.

Career Level (Internal Use Only): PYLW2

Company Overview:

Aspen Healthcare Metrics is a national, clinical service line consulting firm that has been providing management consulting and benchmarking services to hospitals since 1994. Aspen has worked with hundreds of hospital programs to reduce clinical costs, improve physician-hospital relationships, and provide benchmarking and performance analysis. Located in Centennial, CO, Aspen Healthcare Metrics is a subsidiary of MedAssets, a margin and cash flow improvement company providing innovative solutions for healthcare providers

Job Purpose:

Under general supervision, retrieves, reviews, and analyzes pharmacy, utilization and cost data from clients according to consultants’ specifications. Participates in the analysis and interpretation of data including but not limited to identifying cost and clinical opportunities, preparing statistical and other reports, and drafting presentations. May assist in the development and implementation of new processes and data reports.

Essential Duties & Responsibilities:

1. Review pharmacy purchase and utilization data, create/modify data spreadsheets as necessary.

2. Prepare standard pharmacy utilization analysis and quarterly tracking reports.

3. Identify opportunities based on client data, proprietary comparison data, and national/regional benchmarks.

4. Build a preliminary opportunities report/presentation for consultants.

5. Initiate follow-up with clients when necessary, as requested by consultants.

6. Generate final reports for participating clients that identify and track actual cost savings to date and areas of non-compliance.

7. Maintains accountability to the consultants for the timeliness and quality of client data analysis and reports.

8. Keep a master schedule of Aspen and MedAssets Pharmacy Projects Plans and Work in Process.

9. Attend the pharmacy analyst weekly meeting regarding data processing needs and timelines.

10. Assist the pharmacy business analyst with miscellaneous projects and analysis.

Internal Responsibilities:

• Adheres to all company policies and procedures including, but not limited to those identified within the Standards of Business Conduct and the Employee Handbook, as may be amended from time to time. Adheres to all applicable laws and regulations and the company's governance/compliance program.
• Responsible for reporting violations of the company's policies and procedures, Standards of Business Conduct, governance program, laws and regulations through the company's Help Line or other mechanism that may be available at the time of the violation. Assists with internal control failure remediation efforts.
• Becomes knowledgeable of internal control responsibilities through training and instruction. Responsible and accountable for internal control performance within their area of responsibility. Participates in the internal controls self-assessment process.
• Ensures concerns with internal control design or performance and process changes that impact internal control execution are communicated to management.

Minimum Knowledge, Competencies & Qualifications:

1. Two to four years of experience directly related to the duties and responsibilities specified. Bachelor’s degree in related field or equivalent combination of relevant education and/or experience required.

2. Is highly skilled in the use of personal computers and related software applications, including but not limited to intermediate knowledge of the following Microsoft products: Word, Excel, PowerPoint, Access and Outlook.

3. Working knowledge of standard clinical and operating procedures in an acute care setting helpful but not required.

4. Knowledge of medical terminology, pharmaceuticals, ICD9 codes, CPT codes, and DRG codes helpful but not required.

5. Demonstrates strong analytical and problem-solving skills, is detail-oriented.

6. Able to communicate professionally, effectively and courteously, both orally and in writing.

7. Able to prioritize workload and work effectively with minimal supervision.

Travel: Travel is not required.

Physical Demands:

The physical demands and work environment characteristics described here are representative of those that an employee must meet to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. The employee must occasionally lift and/or move up to 15 pounds.
• Mental Demands: the employee must be able to follow directions, to get along with others, and handle stress;
• Work environment: The noise level in the work environment is usually minimal.

MedAssets is an Equal Opportunity Employer and ensures its employment decisions comply with principles embodied in Title VII, the Age Discrimination in Employment Act, the Rehabilitation Act of 1973, the Vietnam Veterans Readjustment Assistance Act of 1974, Executive Order 11246, Revised Order Number 4, and applicable state regulations.