Excel Data Analyst

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 w #J-18808-Ljbffr