Apply now »

Sr Analyst Reporting COE

Posted Date:  Sep 22, 2022
Requisition Number:  115953

Position Title: Sr. Analyst, Reporting COE

Job Location:  Hershey, PA


As part of the Reporting Center of Excellence (COE), this position delivers standardized, accurate & actionable data in a timely manner that supports cross-funictional and enterprise-wide teams, allowing them to make business decisions. Specifically, this position will play a key role in data acquisition, data manipulation, automation-techniques, and final report creation for both, report-writing and complex dashboard requests.


All data/information that this role comes into contact with must be kept confidential per company guidelines.

Major Duties/Responsibilities: 

Report Generation

•  Assist in the development and delivery of ADHOC and Project-Driven Reporting requests (e.g. identifying requirements, coordinating set-up, and investigating data sources/data via Data Mining and working with IS support)

•  Have experience and knowledge of Relational Databases to connect to data, merge data, and data mine using (e.g. ODBC, Teradata, DataLake, SAP)

•  Utilize advanced reporting techniques and software knowledge to standardize and automate output (e.g. Alteryx, SQL, Power BI, Power Automate, R)

•  Help QA Logic, Data, and Reporting Output

•  Communicate and disseminate report progress and status to Report Stakeholders.

•  Establish workflow documentation (e.g. Reports catalog, Definitions, Processes, etc.)

Support Enterprise Data & Reporting Strategies

•  Assist in the change management and migration of current Reporting COE business practices to align with our enterprise-wide S4 Reporting and Data Strategy.

•  Assist in working with cross-functional IS teams to optimize and centralize Reporting COE’s best practices.

Report Maintenance

•  Assist in the maintenance of existing reports and dashboards

•  Ensure reports and dashboards are up-to-date and continue to be processed within the Reporting COE’s Service Level Agreements



Minimum knowledge, skills and abilities required to successfully perform major duties/responsibilities:

  • Knowledge/ability to work with SAP, LPR modules & other ERP processes and a basic understanding of Master Data elements
  • Familiar with Relational Databases and Relational Database Management Systems. 
  • Familiar with Microsoft Office 365 Tools and Capabilities.
  • Strong analytical and strategic thinking skills, with the ability to pay attention to detail.
  • Excellent oral and written communication skills.
  • Proficient in SQL (or other Programming Languages including R, DAX, Python)
  • Experience with developing Power BI and/or Tableau Dashboards.
  • Experience in Process Optimization Techniques (Power Automate, Scheduling Systems, and Node Workflows)

Minimum Education and Experience Requirements:


  • Business, Mathematics, Computer Science-related Bachelor’s Degree Required (Economics, Administration, International Business, Operations, Project Management, Statistics, etc.) or equivalent experience


  • 3-5 years of experience




Nearest Major Market: Harrisburg

Apply now »