Strategy-Intern, Data and Analytics

Strategy Intern - Data and Analytics

Job Summary:

The intern will be responsible for creating a dashboard to comprehensively track the success of all markets and centers across various dimensions of performance. This report would allow AWH's strategy team to quickly identify areas of opportunity across the enterprise and begin to take immediate action to address them. This report will drill into the primary drivers of financial performance and provide critical information as to why certain markets or centers may be underperforming. The intern will work directly alongside other members of AWH's strategy team to do this work.

This experience is designed to help the intern develop their analytic skills by giving them an opportunity to directly link data from various sources to financial performance and design some of the infrastructure required for an organization such as AWH to act on insights gleaned from data.

Duties/Responsibilities:

• Design and build a PowerBI report which would compare the performance of AWH markets and centers to each other on multiple critical dimensions of financial performance
• Write the SQL queries required to build the data view needed to build this report
• Development of key metrics which may be lacking in pre-existing views of our data and performance

Required Skills/Abilities:

• Ability to understand a P&L and factors that drive it
• Translating financial drivers into quantifiable and actionable metrics for reporting purposes
• Visualizing data in a way that allows end users to quickly and accurately draw insights from data

Minimum Qualifications:

• Bachelor's degree
• Proficient in data analysis and visualization
• Proficient in SQL
• Has experience analyzing data and using it to make recommendations to business stakeholders

• Embodies and serves as a role model of ArchWell Health's Values:
  
  
  
  • Be compassionate
  • Strive for excellence
  • Earn trust
  • Show respect
  • Stay resilient
  • Always do the right thing
  
  
  
  

About ArchWell Health:

At ArchWell Health, we're creating a community of caring designed to help our members stay healthy and engaged. By focusing on a strong provider-patient relationship, routine wellness, and staying active, our members enjoy a higher level of care and better quality of life after the age of 60. Everything we do is for seniors. We believe seniors should be heard, listened to, and given ample time by their physicians to live well later in life.

Our value-based care model is designed to prevent illnesses while keeping members healthy and happy in every aspect of their life. We deliver best-in-class primary care at comfortable, accessible neighborhood centers where older adults can feel at home and become part of a vibrant, wellness-focused community. We're passionate about caring for older adults and united by the belief that caring has the power to change everything for our members.

ArchWell Health is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to their race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected classification.