The Hershey Company

Job Title Analyst Reporting COE

Reports to Mgr Reporting COE

Department Enterprise Architecture & Data – Reporting COE

Job Location Providencia, Guadalajara

Summary

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.

Responsibilities:

Report Generation

• Develop 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)
• Build Relational Databases, Query Creation and connect to data, merge data, and data mine using (DataLake, Databricks, Snowflake, Azure)
• Utilize advanced reporting techniques and software knowledge to standardize and automate output (e.g.Power BI, Power Automate, PowerQuery)
• Utilize querying techniques using SQL, Python to transform complex databases into reporting layers
• 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.)

Report Maintenance

• Maintenance of existing reports and dashboards, solutioning break, fixex, bugs and change requests
• Ensure reports and dashboards are up-to-date and continue to be processed within the Reporting COE’s Service Level Agreements

Minimum knowledge and skills

Prior experience with Sarbanes Oxley control compliance requirements preferred

Strong Analytical skills

Knowledge of accounting and policies and procedures

Strong Excel skills and competence with other Microsoft functionality

Strong computer skills – comfortable using various systems

Strong collaboration and teambuilding skills

Excellent interpersonal and communication skills, including ability to effectively communicate with Senior Management and external auditors

Ability to accurately prepare daily, weekly, monthly, quarterly and annual reports

Ability to synthesize massive amounts of data into clear, concise conclusions for management

Experience with SAP and other systems (EDI) a plus

Education

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

Experience

 1-3 years of experience