Business Analyst

ADEC Innovations; Muntinlupa; On-site; PHP 450,000 - 650,000; Full time

Job summary

ADEC Innovations is seeking a Business Analyst to design, test, and implement dashboards under the Analytics & Automation Manager. You will drive data-driven analysis to support decision-making and recommendations across business units.

The role involves planning ETL/dashboard projects, consolidating data, and creating insightful reports. You will train junior analysts, update documentation, and present findings to leadership.

Qualifications

• Bachelors degree in IT or business management (4-year).
• 3 years of experience with BI tools (Power BI/Tableau/Domo).
• Advanced Excel with formulas, Visual Basic, macros, and charting.
• Exposure to BPO or manufacturing is advantageous.
• Basic to average proficiency with ETL/SQL coding (SSIS, SSRS) is advantageous.
• Project management experience is a plus.

Responsibilities

• Plans and manages ETL and dashboard projects.
• Creates, gathers, and consolidates business data into insights for decision-making.
• Aggregates data from multiple sources using ETL and SQL queries as needed.
• Creates dashboards and analyses data using Excel or BI tools.
• Maintains project plans and documentation for Analytics & Automation initiatives.
• Creates training materials and trains new Business Analysts in ETL and dashboard creation.
• Reviews daily reports and trends to support proposals and progress reports.
• Presents findings and recommendations to management and business units.

Skills

Excel formulas

Data analysis

Power BI experience

Education

4-year degree in IT or Business Management

Industrial/Management Engineering advantageous

Tools

Power BI

Tableau

Domo

SSIS

SSRS

Job description

Under the supervision of the Analytics & Automation Manager, this key position is responsible for the creation, design and testing of dashboards. The Business Analyst provides data driven analysis that assists in decision making and recommendations to business units.

Duties & Responsibilities:

PROCESS INTERFERENCE

• Plans and manages ETL and Dashboard Projects.

• Creates, gathers, and consolidates business data and transform them into insight-generating analyses and reports for decision-making that will be used by the shareholders.

• Aggregates raw data from different data sources within the company using ETL (Extract, Transform, Load) Programs/ Tools and SQL queries as needed and as applicable.

• Creates Dashboards and analyses data using Microsoft Excel or Microsoft Power BI and/or any applicable Business Intelligence (BI) Tools.

• Creates project schedule, maintains and updates the project plan as initiated by PMG – Analytics & Automation, for implementation with Production and other cross-functional groups.

• Maintains and updates documentation related to assigned Analytics & Automation processes and Projects to ensure standard compliance of all groups.

• Creates Training Materials and trains new Business Analysts in basic ETL and dashboard creation.

REPORTS AND ADMINISTRATIVE MANAGEMENT

• Reviews and updates daily reports, including trends, to enhance the system to develop and deliver proposals, progress reports, and presentations, and ensure that data is available to every member of the organization.

COMMUNICATIONS

• Works closely with process owners and cross-functional group partners to ensure action plans are monitored through project milestone and gate reviews and recommends process improvements.

• Presents findings, recommendations and best practices to management and business unit leaders across the organization to help the look on the overall effectiveness of the program.

Qualifications:

• Graduate of any 4-year course preferably related to Information Technology and Business Management. Graduate of Industrial Engineering, Management Engineering an advantage.

• 3 years of experience with Business Intelligence (BI) tools (e.g., Microsoft PowerBI, Tableau, Domo, and equivalent), Business Process, Data Analytics, or Operations Management.

• High proficiency level with Microsoft Office, specifically MS Excel. Advanced Excel formulas, Visual Basic, macros, and Charting.

• Exposure in BPO and/or Manufacturing industry is an advantage.

• Basic to Average Proficiency Skill Level with coding programs such as ETL, SQL - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) is an advantage.

• Project Management experience is a plus.

IMPT. NOTE: As this website allows us to collect your information through your resumes, please read our Privacy Notice before proceeding: https://www.adec-innovations.com/privacy-statement/