Job Title Sr. Analyst, Reporting COE * Reports to * Mgr, Reporting COE * Department * HBP Data Reporting & Analytics * Job Location * Providencia,* Guadalajara * Summary As part of the Reporting Center of Excellence (COE) with the Hershey Business Platform team, 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, and final report creation for both, report-writing and complex dashboard requests related to core Delivery Service SLA and KPI reporting initiatives. All data/information that this role comes into contact with must be kept confidential per company guidelines. * 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, Snowflake, 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 and skills* 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) * Education* Business, Mathematics, Computer Science-related bachelor’s degree Required (Economics, Administration, International Business, Operations, Project Management, Statistics, etc.) or equivalent experience. * Experience* 3-5 years of experience