Business Process Automation Analyst

National Data and Surveying Services Inc; Metro Manila; On-site; PHP 600,000 - 900,000; Full time

Job summary

National Data and Surveying Services Inc is seeking a Business Process Automation Analyst to support digitization efforts. You will document and map current-state processes, ensure clean data, and analyze process data to identify automation opportunities.

You will build dashboards in Power BI/Tableau, translate findings into automation requirements, and assist with Lean/Six Sigma initiatives. You will collaborate with SMEs and technical teams, perform data extraction with SQL and Python, and

Qualifications

• Bachelor’s degree in Business, Mathematics, Statistics, Computer Science, or a related quantitative field.
• Proven proficiency in advanced MS Excel functions (VBA Macro) and SQL for data extraction, manipulation, and querying.
• Demonstrated experience or a deep understanding of data cleaning, validation, and preparation techniques.
• Strong analytical and problem-solving skills, with acute attention to detail.
• Familiarity with data visualization tools (Power BI, Tableau).
• Excellent written and verbal communication skills, with the ability to articulate complex data findings to non-technical stakeholders.
• Ability to work effectively in a team environment and manage multiple tasks simultaneously.

Responsibilities

• Process Documentation & Mapping: Work closely with SMEs to document current-state processes using mapping and flowcharts.
• Data Acquisition & Cleaning: Acquire, prepare and manage data sets; perform cleaning, validation, and scrubbing to ensure data integrity.
• Data Analysis & Metrics: Conduct quantitative and qualitative analysis to identify root causes and ROI for automation opportunities.
• Reporting & Visualization: Develop dashboards/reports (Power BI, Tableau) tracking KPIs and highlighting improvement areas.
• Requirements Gathering: Translate findings into detailed business and functional requirements for automation.
• Continuous Improvement Support: Support Lean/Six Sigma approaches to remove waste.
• Testing & Validation: Participate in UAT and validate output data against design.
• Cross-Functional Communication: Facilitate communication between business units and the automation team.
• Technical Assistance: Use SQL and Python to extract data, manipulate data, and create analytic models.

Skills

Advanced MS Excel (VBA)

SQL

Python

Data cleaning

Data analysis

Power BI

Tableau

Communication

Education

Bachelor’s degree in Business/Math/CS or related field

Tools

Power BI

Tableau

Airtable

BPMN

Python

Job description

Position Summary: The Business Process Automation Analyst is critical in laying the foundation for successful digital transformation by providing in-depth data analysis and process understanding. This role focuses on the initial stages of the automation lifecycle: identifying, documenting, and analyzing existing business processes and the associated data. The analyst ensures that the data used for process analysis and subsequent automation development is clean, reliable, and accurate, directly supporting the Business Process Automation Specialist and other technical teams.

Key Responsibilities:

• Process Documentation & Mapping: Work closely with Subject Matter Experts (SMEs) to thoroughly document current-state ('As-Is') business processes using process mapping and flowcharts to clearly identify steps, decision points, and potential bottlenecks.

• Data Acquisition & Cleaning: Acquire, prepare, and manage data sets relevant to the business processes under review. This includes:

  • Performing data cleaning, validation, and scrubbing to ensure data integrity, consistency, and accuracy before analysis.

  • Identifying and resolving data quality issues, missing values, and inconsistencies.

  • Creating and maintaining standardized data dictionaries and documentation.

• Data Analysis & Metrics: Conduct quantitative and qualitative analysis on process data to identify root causes of inefficiencies, assess the feasibility and potential return on investment (ROI) of automation opportunities, and establish baseline performance metrics.

• Reporting & Visualization: Develop and maintain dashboards and reports (e.g., using Power BI, Tableau) that track process performance and key performance indicators (KPIs), highlighting areas ripe for improvement or automation.

• Requirements Gathering: Assist the Specialist and technical teams by translating analytical findings and documented processes into clear, detailed business and functional requirements for automation solutions (e.g., RPA, workflow tools).

• Continuous Improvement Support: Contribute to process improvement initiatives by supporting the application of methodologies like Lean or Six Sigma principles to eliminate waste and non-value-added activities.

• Testing & Validation: Participate in the user acceptance testing (UAT) phase of new automation deployments, focusing on validating the output data and ensuring the automated process accurately reflects the design requirements.

• Cross-Functional Communication: Facilitate effective communication between business units and the technical automation team, ensuring a shared understanding of process flows, data needs, and project status.

• Technical Assistance: Utilize basic programming skills (SQL, Python) to extract data, perform complex data manipulation, and create analytic models to support process optimization efforts.

Required Qualifications:

• Bachelor’s degree in Business, Mathematics, Statistics, Computer Science, or a related quantitative field.

• Proven proficiency in advanced MS Excel functions (VBA Macro) and SQL for data extraction, manipulation, and querying.

• Demonstrated experience or a deep understanding of data cleaning, validation, and preparation techniques.

• Strong analytical and problem-solving skills, with acute attention to detail.

• Familiarity with data visualization tools (e.g., Power BI, Tableau).

• Excellent written and verbal communication skills, with the ability to articulate complex data findings to non-technical stakeholders.

• Ability to work effectively in a team environment and manage multiple tasks simultaneously.

Preferred Qualifications

• Airtable Mastery (Highly Preferred): Proficiency in building and maintaining Airtable bases, including the use of advanced formulas, Interface Designer, and native automations to track workflows or data.

• A basic understanding of business process modeling notation (BPMN) or similar process mapping techniques.

• Familiarity with AI, machine learning, and automation concepts is highly desirable.