EXCEL / POWER QUERY DATA AUTOMATION ASSISTANT

MAA Integrated Waste Solution Corporation; Urdaneta; On-site; PHP 446,000 - 781,000; Full time

Job summary

MAA Integrated Waste Solution Corporation is seeking an Excel-focused data professional to develop, maintain, and automate Excel-based reports and systems using Power Query. You will transform raw operational data into organized, accurate outputs to support day-to-day decisions.

You will collaborate with multiple departments to ensure data integrity, build dashboards, and streamline repetitive tasks with advanced Excel formulas and Power Query transformations.

Qualifications

• Experience building and maintaining Excel-based data systems, reports, and dashboards.
• Ability to troubleshoot data issues and ensure data accuracy.
• Strong collaboration with multiple departments to understand data requirements.
• Comfort with advanced Excel functions and problem solving for operational data.

Responsibilities

• Develop and maintain Excel-based data systems, reports, trackers, and dashboards.
• Use Power Query to import, clean, combine, transform, and organize data from different sources.
• Build and maintain Excel Tables and structured data systems.
• Create and troubleshoot advanced Excel formulas and data-processing solutions.
• Automate repetitive data preparation and reporting tasks whenever possible.
• Connect and consolidate data from multiple Excel files, worksheets, and operational sources.
• Develop automated reports for areas such as inventory, purchasing, sales, operations, warehouse, payroll, or other business data.
• Ensure data accuracy, consistency, completeness, and proper organization.
• Identify and troubleshoot formula errors, data inconsistencies, and Power Query issues.
• Coordinate with different departments to understand their data requirements and reporting needs.

Skills

Microsoft Excel

Attention to detail

Data analysis

Problem-solving

Tools

Power Query

Excel Tables

XLOOKUP

SUMIFS

FILTER

Job description

About the role

We are looking for an Excel-focused and detail-oriented individual who can help develop, maintain, and improve our business data systems using Microsoft Excel and Power Query. This role involves working with operational data and helping transform raw information into organized, connected, accurate, and automated Excel-based business reports and systems. The successful candidate will work closely with different departments to organize data, automate repetitive processes, troubleshoot data issues, and develop reports that can support day-to-day operations and management decision-making.

Key responsibilities

• Develop and maintain Excel-based data systems, reports, trackers, and dashboards.
• Use Power Query to import, clean, combine, transform, and organize data from different sources.
• Build and maintain Excel Tables and structured data systems.
• Create and troubleshoot advanced Excel formulas and data-processing solutions.
• Automate repetitive data preparation and reporting tasks whenever possible.
• Connect and consolidate data from multiple Excel files, worksheets, and operational sources.
• Develop automated reports for areas such as inventory, purchasing, sales, operations, warehouse, payroll, or other business data.
• Ensure data accuracy, consistency, completeness, and proper organization.
• Identify and troubleshoot formula errors, data inconsistencies, and Power Query issues.
• Coordinate with different departments to understand their data requirements and reporting needs.

About you

• Strong knowledge of Microsoft Excel.
• Comfortable working with Excel Tables, structured references, and formulas.
• Good knowledge of functions such as XLOOKUP, SUMIFS, COUNTIFS, FILTER, UNIQUE, IF, INDEX/MATCH, and other advanced Excel functions.
• Working knowledge of Power Query, including importing, cleaning, merging, appending, and transforming data.
• Basic understanding of data organization, table structures, and relationships between datasets.
• Strong attention to detail and commitment to data accuracy.
• Able to troubleshoot Excel formulas and data-processing problems independently.
• Organized and capable of following standardized data procedures.
• Good analytical and problem-solving skills.
• Willing to learn and work with an evolving business information and data automation system.