Position Summary The Junior Reporting Analyst supports several departments by preparing, maintaining, validating, and distributing recurring operational reports. The position also assists with ad-hoc reporting requests, data entry, data extraction, report testing, and documentation.

This is an entry-level position intended for someone who has strong Microsoft Excel skills, careful attention to detail, and an interest in developing a career in reporting and data analytics. Training will be provided on departmental processes, HubSpot, SAP, Amazon Connect, and internal reporting systems.

The analyst will work under the direction of the department manager and collaborate with operational team members to ensure reports are accurate, complete, understandable, and delivered on schedule.

Essential Functions

- Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
- Prepare, validate, and distribute daily, weekly, and monthly operational reports.
- Maintain existing Microsoft Excel reports, templates, formulas, data connections, and supporting documentation.
- Use Excel functions such as XLOOKUP or VLOOKUP, PivotTables, SUMIFS, COUNTIFS, filters, and conditional formatting to organize and analyze data.
- Combine, compare, and reconcile information from multiple worksheets, workbooks, and reporting systems.
- Review reports for missing information, duplicate records, inconsistent values, formula errors,



and other potential data-quality issues.
- Follow established report-validation procedures and maintain a consistently high level of accuracy.
- Assist with extracting data from HubSpot, SAP, Amazon Connect, internal applications, and other approved reporting systems.
- Support ad-hoc reporting and data requests under the direction of the department manager or senior team members.
- Document report procedures, business rules, data sources, validation steps, and recurring reporting schedules.
- Communicate reporting issues, delays, or unclear requirements to management in a timely manner.
- Assist with testing report changes and confirming that updated reports produce the intended results.
- Recommend practical improvements to recurring reports after becoming familiar with the reporting process and departmental needs.
- Organize and prioritize multiple recurring assignments to meet established deadlines.
- Present straightforward findings to department management with guidance when appropriate.
- Protect confidential business, customer, and employee information in accordance with company policies.

Other Duties Please note this is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

📌 Junior Reporting Analyst (Guadalajara)
🏢 ResortCom
📍 Guadalajara