Description
Position Summary:
We are seeking an analytical, organized, and detail-oriented Administrative Assistant to consolidate, cleanse, and analyze operational information, generating reports and key performance indicators (KPIs).
Key Highlights:
1. Support the consolidation, cleansing, and analysis of operational information.
2. Create pivot tables, charts, reports, and automate processes using macros.
3. Identify opportunities for improvement in information handling and analysis.
**We Are Hiring an Administrative Assistant!**
Do you enjoy working with data, Excel, and identifying discrepancies or inconsistencies in information?
We seek an analytical, organized, and detail-oriented individual to support the consolidation, cleansing, and analysis of operational information, contributing to the generation of reports and KPIs for our clients.
Main Responsibilities
* Consolidate databases from various sources, such as **Excel and client systems**.
* Normalize and standardize fields to ensure data quality and consistency.
* Perform data cleansing: removal of duplicates, correction of inconsistencies, and validation of formats.
* Validate information such as **phone numbers, addresses, serial numbers, and other relevant fields**.
* Cross-reference information across different databases to identify matches, discrepancies, and pending items.
* Develop **pivot tables, charts, and operational tracking reports**.
* Support the creation and updating of control dashboards.
* Automate repetitive tasks using **macros and VBA**.
* Prepare executive presentations for client-facing reports.
* Support the generation and monitoring of **management indicators (KPIs)**, such as effectiveness, coverage, and operational progress.
* Identify opportunities for improvement in information handling and analysis processes.
We Are Looking For
* Analytical thinking and attention to detail.
* Organizational skills and time management ability.
* Commitment to delivering outputs on schedule and meeting deadlines.
* Proactivity in detecting errors, inconsistencies, or anomalies in data.
* Ability to work under pressure, especially during month-end closings and client deliveries.
* Proficiency in handling information from diverse sources and large volumes of data.
Desirable Knowledge
* **Intermediate/Advanced Excel**.
* Pivot tables, lookup functions, logical functions, and database management.
* Knowledge of **macros/VBA**.
* Chart and dashboard development.
* Familiarity with **Power BI** is a plus.
**Are You Interested in Joining Our Team?**
If you are analytical, organized, and passionate about working with information, **we want to meet you!**
Send your CV to: 938 985 977 and become part of our team.
Salary: S/.856\.88 \- S/.3,075\.55 per month
Work Location: On-site employment