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-functional 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 interacts with, must be kept confidential per company guidelines.
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.
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
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
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)
The Hershey Company is an Equal Opportunity Employer. The policy of The Hershey Company is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual's race, color, gender, age, national origin, religion, citizenship status, marital status, sexual orientation, gender identity, transgender status, physical or mental disability, protected veteran status, genetic information, pregnancy, or any other categories protected by applicable federal, state or local laws.
The Hershey Company is an Equal Opportunity Employer - Minority/Female/Disabled/Protected Veterans
The Hershey Company