Analyst II Pharmacy Reporting

Address: USA-NC-Salisbury-2085 Harrison Road
Store Code: Store Support Services (2761783)
Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which includes five leading omnichannel grocery brands - Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Our associates support the brands with a wide range of services, including Finance, Legal, Sustainability, Commercial, Digital and E-commerce, Technology and more.
Responsible for designing, creating/building, analyzing and distributing reports (excess of fifty per week), both operational and financial, that provide analytic information to key stakeholders (Senior Management, Pharmacy Operations, Store Operations and Finance/Accounting) to support all ADUSA Brand's reports and ad hoc requests are generated from a variety of pharmacy reporting tools on a regular cadence as well as on demand requests. Requires analytical and research skills as well as advanced Microsoft Excel skills to mine pharmacy data from reporting tools to analyze, combine and format large datasets into meaningful content for end users.
***Our flexible/ hybrid work schedule includes 3 in-person days at one of our core locations and 2 remote days. Our core office locations include Salisbury, NC, Quincy, MA, Carlisle, PA, Scarborough, ME, Hyattsville, MD
Essential job functions:

• Generate standard and ad hoc reporting from reporting tools on a weekly, period, quarterly and year to date basis.
  • Reports include metrics such as prescription, sales, gross margin, PBM rates, and operational information.
  • Other tools utilized to retrieve financial data include but not limited: SAP/EPM, Data Insights Reporting Tool, McKesson Enterprise Pharmacy Dispensing, Inmar Analytics, Power BI: SAS (Prod), EPM (Enterprise Performance Management) and ACIS/DSS. .
• Utilize strong analytical and research skills.
  • Requires advanced Microsoft Excel skills to mine key pharmacy data from reporting tools to analyze, combine and format large datasets into meaningful content to support key stakeholders for Brand and consolidated views.
  • Research and analyze activity recorded to pharmacy sales, margin and expenses. Work with various accounting teams to understand impact and provide input if needed.
  • Provide feedback to Brands inquiring about pharmacy sales, margin and expense impacts.
• Provide support in identifying, researching and understanding pharmacy trends including marginPBM reimbursement, physical inventory, reclamation, vendor allowances, expense and sales.
• Review data/reports to ensure data accuracy and completeness.
• Support the documentation of business processes, including types of reporting (immunization, controls), systems utilized, and steps needed to retrieve data/reporting.
• Support the identification of appropriate accruals for shrink and rebates as needed.
• Support various areas (procurement, regulatory, pricing, managed care, clinical) within the department.
• Assist and prepare Brand budgeting, forecasts, and latest estimates. Assist in the reconciliation of actual results to budgets/forecasts.
• Additional job duties may be assigned as needed to meet the needs of the business and support our Values.

Qualifications:

• Bachelor's degree in Finance, Accounting, Business Analytics, Data Science, Pharmacy Administration, or a related field or equivalent experience.
• Minimum 2-4 years of experience in financial and operational reporting, data analysis, or a similar analytics-focused role.Advanced Excel skills (pivot tables, VLOOKUP, Power Query, large dataset management).
• Strong analytical and research skills to interpret trends, variances, and complex data.
• Clear communication skills and ability to work cross-functionally with operations, finance, and pharmacy teams.
• High attention to detail, strong organizational skills, and ability to document processes.
• Flexible and adaptable to evolving business needs.
• Applicants must be currently authorized to work in the United States on a full-time basis until the end of their appointment

Preferred Qualifications:

• Experience working in healthcare, pharmacy operations, or a related industry.
• Strong working knowledge of reporting tools and data platforms such as: SAP/EPM, Power BI, SAS (Prod), Data Insights Reporting Tool, McKesson Enterprise Pharmacy Dispensing, Inmar Analytics, or ACIS/DSS.

ME/NC/PA/SC Salary Range: $63,440-$95,160
IL/MA/MD Salary Range: $72,880 - $109,320
#LI-Hybrid
#LI-BB1
At Ahold Delhaize USA, we provide services to one of the largest portfolios of grocery companies in the nation, and we're actively seeking top talent. Our team shares a common motivation to drive change, take ownership and enable our brands to better care for their customers. We thrive on supporting great local grocery brands and their strategies.
We offer an experience where our associates are valued; Diversity, Equity, Inclusion and Belonging are infused in our business and our employees are representative of the communities that we serve. We believe in total wellness, which encompasses a blend of physical, financial and emotional wellness.
We believe in collaboration, curiosity, and continuous learning in all that we think, create and do. While building a culture where personal and professional growth are just as important as business growth, we invest in our people, empowering them to learn, grow and deliver at all levels of the business.
Job Requisition: 438709_external_USA-NC-Salisbury