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

Kitchen Tune-Up

Cabinet Installer Job at Kitchen Tune-Up

 ...Full-Time Cabinet And Cabinet Refacing Installer Kitchen Tune-Up Lake Mary is growing and seeking a skilled, dependable full-time cabinet and cabinet refacing installer to join our team. This role is ideal for experienced remodelers or trim carpenters who take pride... 

SC2, Supply Chain Services & Solutions

CDL Day Cab Driver Job at SC2, Supply Chain Services & Solutions

 ...sharing Referral program Safety equipment provided Vision insurance Trucking driver type: ~ Company driver Trucking home time: ~ Home daily Trucking route: Local Regional Experience: ~ Driving: 1 year (Preferred) License/... 

Intermountain Health

Medical Oncologist and Hematologist Job at Intermountain Health

 ...deliver care, but also in how we care for you. As a Physician in Medical Oncology, you'll collaborate with a team of 9 medical oncologists to provide top-notch care and patient experience. Throughout the day, you will collaborate with and have support from APPs,... 

BD&J Injury Lawyers

Remote SEO & Directory Strategy Specialist Job at BD&J Injury Lawyers

BD&J Injury Lawyers is seeking a detail-oriented SEO Specialist to support its digital marketing in Los Angeles. This remote position emphasizes directory management, off-page SEO strategies, and involves extensive ownership of directory verification processes. Successful... 

UVA Health

Medical Director - Pediatrics and Specialty Care - UVA Physicians Group Job at UVA Health

 ...The Medical Director provides clinical oversight and physician and advanced practice provider leadership for outpatient ambulatory clinics...  ...needs. Improves or sustains key clinical quality, patient safety, and population health outcomes through data informed decision...