Purpose

To provide global support Actuation Technologies Sales and Marketing teams in the creation of various business-related reports, analyses and database management as needed by the business unit.

Duty 1: Metrics, Reporting and Analytics

Data Gathering

Extracts/generates quantitative information from a single or multiple tools Business Intelligence Tools (i.e. Oracle, Tableau, etc.)

Communicates with resource person to get input/raw data needed for report generation

Data Manipulation

Cleans extracted data using pre-defined guidelines or instructions

Formats extracted data based on expected report output (with batching capability)

Calculates data using available fields within the gathered information (basic math)

Formats extracted data based on expected report output. (multiple data formatting requirements)

Categorizes and segments extracted data using tools to convert data to information relevant to the report (excel, macro, database)

Consolidates and standardize data structure from different data sources

Combines extracted data from multiple resources using automated tools (excel, macro, database)

Data Analysis

Gathers and analyzes report requirements from stakeholders. Identify and provide solution to general inquiries

Analyzes gathered information & data using descriptive analytics (basic mathematics & comparative analysis)

Analyzes stakeholder requirements from an existing report and provides improvement and recommendation based on customer request

Reporting

Creates reports based on standard templates

Pricing, Sales & Marketing Analysis Enters Model codes/ Part number in Oracle for validation

Collates prices from system or price book and price lists.

Validates and calculates pricing using offline pricing tools

Adds and updates Oracle price items

Encodes cost template and fiscal year Cost Database

Coordinates with the supplier/factory/other support group to obtain product and service pricing

Escalates commercial inquiries to factory

Escalates pricing issues to appropriate support group

Validates and calculates pricing using system tools

Computes price increase per brand and world area (local currency)

Implements price change by creating new or update existing price book

Analyzes and cleanses Oracle price items

Duty 2: Project Support

Project Initiation

Attends scope reviews to learn what the project request is all about

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

Project Planning

Creates documentation using standard project templates; stores and organizes the documents to the team's repository

Performs research and analysis to validate if the detailed solution is the best fit to meet the requirements

Project Execution

Reports own progress back to the project tracking tool

Participates in cross-functional testing and peer reviews

Project Testing

Sets up UAT (informing participants, scheduling, gathering results)

Creates user manuals using standard templates of the team

Creates test cases to be used during UAT

Duty 3: Training and Development

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 courses

Training Execution

Conducts basic overview and awareness training on processes and/or business tools

Requirements

Education

Bachelor of Science degree in any business-related fields

Job Related Experience

(3) three years' experience in data mining, manipulation, analysis and reporting

Specific Knowledge

Microsoft Office

Data Manipulation & Interpretation

Product datasheets, price lists, manuals & catalogs Skills

Intermediate Microsoft Excel proficiency Level 2 (Worksheet Formulas & Charts)

Oral & written communication skills

Problem solving & analytical skills

Presentation skills