Analyst 2, Pricing and Data
Emerson
Quezon City, National Capital Region, Philippines
5d ago

Job Posting Date

Mar 27, 2019, 6 : 07 : 12 AM 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
  • 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.
  • 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
  • Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form