Department:
38590 API Specialty Pharmacy - Retail Pharmacy
Status:
Full time
Benefits Eligible:
Yes
Hours Per Week:
40
Schedule Details/Additional Information:
Experience with Epic Hyperspace/Willow
Experience with Snowflake
Experience coding using the Pandas library
Pharmacy operations knowledge
Remote in IL/WI
May need to report to the site as needed. Menomonee Falls, Greater Milwaukee and Greater Chicagoland area.
Major Responsibilities:
- Develop a variety of pharmacy-related reports, including: Productivity, inventory, and KPI reports. Revenue opportunity and special initiative reporting. Third-party contract compliance reports.
- Validate the accuracy and integrity of generated reports
- Perform data manipulation and analysis using technical languages like Python and/or SQL.
- Build and maintain dashboards in Microsoft Power BI
- Build and maintain reports in Excel
- Build and maintain reports in Snowflake
- Communicate efficiently and effectively to all report stakeholders
- Support organizational merger by aligning and optimizing reporting structures
- Contribute to the design and validation of transitioning pharmacy data to a cloud-based data infrastructure.
Licensure, Registration, and/or Certification Required:
- None Required.
Education Required:
- Bachelor's Degree (or equivalent knowledge) in related field.
Experience Required:
- Typically requires 3 years of experience in business process mapping, analysis, defining business and user requirements, acceptance testing and documentation with experience in the specific function/area supported.
Knowledge, Skills & Abilities Required:
- Advanced computer skills including experience in using Microsoft Office 365 Suite (Power Apps, Power BI, Excel, Access) or similar products, and experience with large scale automated systems.
- Advanced knowledge of data analysis tools and techniques, data structures and algorithms, and working knowledge of programming languages such as Python, R, SQL, Scala, Java.
- Experience with application users, vendors and other technical experts, providing operational support for clinical systems, analyzing business and clinical processes, and providing user training/education.
- Project management experience with ability to use project management software.
- Necessary analytical skills to make sound recommendations based on data analysis, and clinical user needs, assuring maximum productivity, and continuous process improvement.
- Ability to balance multiple tasks, be detail and results oriented, set appropriate priorities and accomplish assignments in a thorough and timely fashion.
- Strong organizational, problem and issue resolution skills. Ability to gather and organize data.
- Strong communication skills.
- Understanding of change management practices and procedures.
Preferred Remote in ILLINOIS and WisconsinNo relocation, No Sponsorship for this position
Physical Requirements and Working Conditions:
- Exposed to normal office environment.
- Job may require travel, therefore, may be exposed to road and weather hazards.
- Must be able to lift up to 40 lbs. occasionally.
- Sits the majority of the workday, but also may lift, reach, and bend throughout the day.
- Operates all equipment necessary to perform the job.
This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.
Pay Range
$30.15 - $45.25
Our Commitment to You:
Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more – so you can live fully at and away from work, including:
Compensation
- Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training
- Premium pay such as shift, on call, and more based on a teammate's job
- Incentive pay for select positions
- Opportunity for annual increases based on performance
Benefits and more
- Paid Time Off programs
- Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
- Flexible Spending Accounts for eligible health care and dependent care expenses
- Family benefits such as adoption assistance and paid parental leave
- Defined contribution retirement plans with employer match and other financial wellness programs
- Educational Assistance Program
About Advocate Health
Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.
Top Skills
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
