Analyst Reporting COE

Job Title                                                    Data Reporting Analyst

Reports to                                                Data Reporting

Department                                     HBP – Reporting COE

Job Location                                  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 and 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

• Change management and migration of current Reporting COE business practices to align with our enterprise-wide SAP S4-Hana Reporting and Data Strategy.

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

Report Maintenance

• 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.

▪ Possess strong communication & interpersonal skills in Spanish and English (both written & verbal) and work as a collaborative team member ▪ Experience 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) ▪ Ability to work in a dynamic environment – learning new skills & solving new problems

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