Excel Data Analyst Job at AAAHC, Deerfield, IL

cFFFSGVvMWh0cTFtNDBuTzlYbTFpNlEvR3c9PQ==
  • AAAHC
  • Deerfield, IL

Job Description

Join Our Mission to Elevate Ambulatory Health Care

At AAAHC, we are more than just a team; we are at the forefront of improving health care quality through accreditation. Our employees are the heartbeat of our mission-based culture, dedicated to applying their diverse skill sets—technical, research, clinical, analytical, and data-driven—to improve health care quality through accreditation. As we celebrate over four decades of excellence, we invite you to become part of our story. Here, your work is not just a job; it's a journey filled with opportunities to learn, grow, and contribute to a higher purpose. Embrace the chance to be part of a community that values quality every day and strives for excellence in ambulatory health care.

What do we offer?

We prioritize our employees' wellbeing by providing a comprehensive benefits package that includes:

  • Compensation: Receive annual merit increase consideration and an annual discretionary bonus
  • Work-Life Balance: Enjoy generous paid holidays, increasing paid time off with tenure, and potential hybrid schedule eligibility
  • Health & Wellness: Take advantage of our medical, dental, and vision plans including company contributions to HSA as well as our wellness reimbursement benefit
  • Retirement Plan: Invest in your future with our robust 401(k) plan that includes a company contribution and match
  • Professional Development: Advance your career with ongoing training and educational opportunities along with a tuition reimbursement program
  • Life & Disability Insurance: Experience peace of mind with company-paid short/long-term disability, life, & AD&D insurance
  • Employee Assistance Program: Access support services for personal needs
Position Description

Reporting to the Director, Project Management Office/Business Intelligence (PBI), the Data Analyst's primary responsibilities are to conduct data research, analyze internal/external data for market trends, demand information, client performance, and other insights, and design and generate reports using expert skills in Excel. The Analyst will translate data, identify trends, and make recommendations to guide strategy improvement/refinement and outcomes. To accomplish this desired outcome, this position will collect and analyze AAAHC and external source data to drive data-driven decision capabilities & initiatives. This role will also provide support for a variety of other projects requiring flexibility and ability to multitask as the projects are varied and dependent on the needs of the organization at any given time.

  • Ensure timely, accurate organization data collection/extraction and integration for designing and generation of routine and ad hoc reports. Analyze data using Excel and Power BI tool with input from team members across organization to determine trends and necessary information to guide strategy improvement/refinement and to gain business insights.
  • Create PBI, MBD, Leadership and other functional area reports related to standard and ad hoc reports and dashboards, identify and investigate variances and trends, and collaborate with business areas to understand results and determine actionable recommendations. Includes AAAHC Functional dashboard that incorporates new/lost/retained business, volume and financial implications, by market segment.
  • Research and analyze client behavioral data (e.g., transactions), demographics, segmentation, campaign response, and market basket data and transform it into meaningful insights used to drive strategy and tactics or evaluate their effectiveness. Prepare and present results to various groups within the organization in audience-relevant language including conclusions, recommendations and an orientation toward actionable results and efficient decision-making.
  • Collaborate with AAAHC Internal Team, gather and interpret data requirements, conduct analysis, and ensure data flows are efficiently managed.
  • Develop ad hoc, weekly, monthly, quarterly reports and statistics using Excel. Quarterly reports and custom data analysis as per AAAHC's functional business needs.
Minimum Qualifications and Job-specific Competencies Required
  • Bachelor's degree in Management Information Systems (MIS), Business Administration or work equivalent in roles that demonstrate business analytic abilities
  • At least one year of work experience with demonstrated ability to manage projects, complete assignments on time, and multitask
  • Strategic, critical and creative thinker, with a good business sense and excellent analytic skills; strong problem-solving skills
  • Ability to understand highly complex specialty products/services
  • Ability to work independently and receptive to supervision; effective team player
  • Excellent Communicator (verbal, written, presentation)
  • Proven command of analytical tools, relational databases and data modeling techniques
  • Microsoft Office advanced proficiency (i.e., Word, Excel, PowerPoint)
Preferred Qualifications
  • Experience developing business strategies resulting from quantitative sales and marketing analytics/data mining and presenting those results to the client/business partner
  • Experience in health care; knowledge of health care accreditation and the regulatory environment
  • Prior experience in SQL development and Power BI development a plus
Working Conditions & Travel Expectations
  • Estimated travel: <10%
  • Ability to commute to work at least 3 days per week

Physical Requirements

Sedentary work: Exerting up to 10 lbs of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Salary varies based on experience, location, and qualifications

Job Tags

Temporary work, Work experience placement, Work at office, 3 days per week

Similar Jobs

GardaWorld

Security Officer - Driver Job at GardaWorld

 ...GardaWorld Security Services is Now Hiring a Surveillance Security Officer! Ready to suit up as a Surveillance Security Guard?...  ...process) You are at least 21 years of age. Must have a valid driver's license Strong report writing skills Sharp visual activity... 

Best Practice Medicine LLC

Travel Paramedic Job at Best Practice Medicine LLC

 ...Job Description Job Description Description: About you and the role As a Travel Paramedic, you will respond to emergency medical calls and provide pre-hospital care to victims in response to 911 emergency calls. You will coordinate with law enforcement agencies... 

WMCHealth

PATIENT CARE TECHNICIAN Job at WMCHealth

 ...Job Summary The Patient Care Technician has the basic knowledge of patient care needs and skills to safely and competently carry out assigned basic patient care tasks and in compliance with Mid-Hudson Valley Staffco, LLC policies and procedures. The Patient Care Technician... 

The Greater Nebraska Schools Hiring Consortium

ESL teacher Job at The Greater Nebraska Schools Hiring Consortium

 ...Closing Date: UNTIL FILLED District: Schuyler Community Schools Schuyler Community Schools is hiring for a Middle School ESL teacher for the 2026-2027 school year. We offer District-paid full family insurance, flexible PTO, and a base salary starting at $40,700.... 

AIL

Online Customer Service No Experience Job at AIL

 ...programs. What Youll Do: Onboard New Clients: Guide new members through a seamless enrollment process. Deliver Exceptional Service: Address client needs with professionalism and care. Develop Tailored Solutions: Create and evaluate plans that align with...