SENIOR DEMAND ANALYST

QUALIFICATIONS:

College degree in Engineering, Supply Chain Management, Finance, Business, or related field4 years’ experience in data manipulation, analysis and reportingDatabase management experience requiredSolid understanding of database concept, theories, and applicationsKnowledgeable in computer database programs and in ERP system such as Oracle/SAP/ Business Intelligence other database structuresProficient in MS Excel (including pivot tables, lookups, macros), and knowledgeable in MS PowerPoint and another MS Office applicationKnowledgeable in Domo/ Tableau/Power BI is a plusStrong English verbal and written communication skills – able to communicate clearly and effectivelyStrong analytical skills, both in written and verbal form. Ability to interpret data, identify trends, or anomalies, as well as root cause, and suggest viable solutionsTraining skillsFlexible, can work using own initiative, can deal with multiple projects at one time, can work under pressure and tight deadlines, and can prioritize tasks accordinglyArticulate, confident, innovative, and a team playerHas excellent customer service and interpersonal skillsDisplays professionalism towards work and colleaguesHas very good presentation skillsWilling to work on shifts, as the need arisesWork location: SM Cyberwest (across SM North Edsa)Work setup:Hybrid (2x/week onsite)Work schedule: Midshift

DUTIES AND RESPONSIBILITIES

Report Scoping and Planning

Gathers and analyzes stakeholder requirements and provides improvement and recommendation based on customer request

Data Gathering

Generates quantitative information from global raw dataCommunicates with resource person to get input/raw data needed for report generationCoordinates with the factory/other support group to obtain product information, bookings, backlog, and sales dataConducts research to gather qualitative information (competitive product information, industry trends, and check product specifications) from internal & external sources that will be used for analysis

Data Manipulation

Cleans extracted data using pre-defined guidelines or instructionsFormats extracted data based on expected report output.Categorizes and segments extracted data using tools to convert data to information relevant to the report (Excel, Macro, database)Combines and consolidates extracted data from multiple sources using automated tools (Excel, Macro, database), and standardize data structure from different data sourcesCalculates data using available fields within the gathered information (basic math and statistics)

Global SIOP Data Analysis

Analyzes gathered information & data using descriptive and diagnostic analytics (basic mathematics & comparative analysis)Identify and provide solution to general inquiriesValidates and calculates sales using offline and system toolsCommunicates issues/concerns to POC regarding results of AnalysisResearches product information, industry trends, technical specifications and gathers various data to be used by Sales, Marketing & Finance teams (ei. B2B, Production Report, Line Business Report, Global Sales Trend, Global Backlog Trend, Inventory, PBOM, Forecasting)Identifies and resolves SIOP data related issues with WA leaders and manufacturing sitesPerforms data integrity check by comparing past reports to determine any internal changes in database. Validates correctness and applicability of all world area raw data reports provided/recommended by world area data ownersDevelops and recommends Global Project Pursuit related reports and presentation to executive meetings.Analyzes reports for Executive and Functional Review.Generates, monitors Lead Time and on time delivery.

Reporting

Creates reports based on standard templatesCreates and tests dynamic reports/dashboards based on the designed formatDesign reports as requestedGenerates and submits Global Actual Sales Report and Global Backlog ReportGenerates and submits weekly backlog analysis

Project Initiation

Assists project owner in gathering, analyzing and clarifying customer requirements; uses technical knowledge to gauge complexity of the request

Project Planning

Performs research and analysis to validate if the detailed solution is the best fit to meet the requirementsReduces complexity by breaking down large tasks to smaller deliverables ready to be assigned to the project team members.Performs research and analysis to validate if the detailed solution is the best fit to meet the requirementsLeads project milestone and gate reviewsCreates project scope and timeline for small applicationsIn case of differences, negotiate with clients for small applications

Project Execution

Reports own progress back to the project tracking toolParticipates in cross-functional testing and peer reviews

Project Testing

Creates test cases to be used during UATIntroduces and tests proposed solutions to continuously improve the process/tools of the teamImplements the necessary fix or improvement for basic functionalities based on the UAT results

Continuous Process & Innovation

Identifies continuous project ideasRecords and reviews/assesses the improvement / innovation raised by the business unitMaps processes as part of the documentation

Training Material Development

Updates/revises training syllabi, course outlines, lesson plans, and content of existing materials (e.g. presentations, evaluation tools, etc.) for all training coursesAdapts training syllabi, course outlines, lesson plans and content of existing materials (e.g. presentations, evaluation tools, etc.) for all training courses for specific audience/scenarioCreates/Authors content of training materials (e.g. presentations, evaluation tools, etc.) for new courses/programs

Training Execution

Conducts basic overview and awareness training on products, processes and/or business toolsConducts intermediate and comprehensive training on products, processes and business toolsCreates/Authors content of training materials (e.g. presentations, evaluation tools, etc.) for new courses/programs (with batching capability and multiple data formatting requirements)