Business Process Automation Analyst

National Data and Surveying Services Inc; Eastern Manila District; In loco; PHP 700.000 - 1.100.000; Tempo pieno

Descrizione del lavoro

National Data and Surveying Services Inc is seeking a Business Process Automation Analyst to support data-driven transformation. You will document, clean, and analyze existing processes, develop dashboards, and translate findings into actionable requirements for automation projects.

You will collaborate with SMEs and technical teams, leverage SQL, Excel, Power BI, and Airtable to improve efficiency, ensure data integrity, and contribute to measurable ROI through process optimization and UAT

Competenze

• Bachelor’s degree in a quantitative field.
• Advanced MS Excel (VBA) and SQL for data extraction and manipulation.
• Experience with data cleaning, validation, and preparation techniques.
• Strong analytical and problem-solving skills with attention to detail.
• Familiarity with data visualization tools (Power BI, Tableau).
• Excellent written and verbal communication skills to explain findings to non-technical stakeholders.
• Ability to work in a team and manage multiple tasks.

Mansioni

• Documentation and mapping of current-state processes with SMEs to identify steps, decisions, and bottlenecks.
• Acquire, prepare, and manage datasets; perform data cleaning and validation to ensure data integrity.
• Conduct quantitative and qualitative analysis to identify root causes of inefficiencies and ROI for automation.
• Develop dashboards/reports (Power BI, Tableau) to monitor KPIs and process performance.
• Translate analytical findings into clear business and functional requirements for automation solutions.
• Support continuous improvement by applying Lean/Six Sigma principles to remove waste.
• Participate in user acceptance testing (UAT) to validate automated outputs against design requirements.
• Facilitate cross-functional communication between business units and the automation team.
• Use basic programming (SQL, Python) to extract data and build analytical models.

Conoscenze

Excel (Advanced)

SQL

Data Cleaning

Power BI

Tableau

Airtable Mastery

Communication

Team Collaboration

Formazione

Bachelor’s degree (Business, Math, Stats, CS or related quantitative field)

Strumenti

Power BI

Tableau

SQL

Airtable

Descrizione del lavoro

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