Junior Excel Data Analyst Jobs in Carol Stream, IL

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