Analyst Reporting COE

Job Title                               Analyst Reporting COE

Reports to                            Mgr Reporting COE

Pay Band                             1B

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

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

          Experience in Process Optimization Techniques (Power Automate, Scheduling Systems, and Node Workflows)

          Ability to work in a dynamic environment – learning new

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