Data Analyst

Job ID:
R150525

Shift:
1st

Full/Part Time:
Full_time

Pay Range:
$30.15 – $45.25

Location:

Menomonee Falls, WI – N93W14575 Whittaker Way
Menomonee Falls, WI 53051

2025 Windsor Dr
Oak Brook, IL 60523

Benefits Eligible:
Yes

Hours Per Week:
40

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 within the position’s 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

Schedule Details/Additional Information:
Experience with Epic Hyperspace/WillowExperience with SnowflakeExperience coding using the Pandas libraryPharmacy operations knowledgeRemote in IL/WIMay 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 Wisconsin

No 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.

Aurora Health Care is the largest health system in Wisconsin and a national leader in clinical innovation, health outcomes, consumer experience and value-based care. The state’s largest private employer, the system serves patients across 17 hospitals, more than 70 pharmacies and more than 150 sites of care. Aurora Health Care, in addition to Advocate Health Care in Illinois and Atrium Health in the Carolinas, Georgia and Alabama, is now part of Advocate Health, the third-largest nonprofit, integrated health system in the United States. Committed to providing equitable care for all, Advocate Health provides nearly $5 billion in annual community benefits.