About The Position

Take on the challenge of synchronizing efforts across diverse products and interpreting operations data for growth opportunities. Unleash your potential in a role that lets you shape change initiatives and strategize resource allocation. As a Senior Business Transformation Associate on the Revenue Management Data Analytics team, you will be responsible for creating benchmark prices for targeted products for the annual Price Event as well as maintaining the Intranet Deal Model (IDM) Deal Screen (Benchmark & Approval Report). You will also be responsible for supporting the rest of the Data Analytics Team’s reporting responsibilities. The C&IB Revenue Management Data Analytics team focuses on the optimization of revenues across the Account Analysis product suite. The team is responsible for executing the annual Price Event as well as supporting the entire Revenue Managements data and reporting needs.

Requirements

  • Experience with Excel, Access, SQL, or Alteryx
  • Experience with Excel Visual Basic for Applications (VBA)
  • Experience creating and maintaining macros and complex formulas that use numerous functions in Excel (index, xlookup, range, min, max, etc.)
  • Strong analytical and problem-solving skills
  • Ability to adapt to a fast-paced environment and meet time sensitive deadlines
  • Excellent written and verbal communication skills
  • Excellent organizational skills with the ability to multitask and prioritize time sensitive deliverables
  • Strong attention to detail and accuracy
  • Experience with quality assurance processes and documentation

Responsibilities

  • Support the Deal Review Excel model
  • Calculate/maintain/present benchmarking data models
  • Interact with external vendor to obtain data needed for analysis
  • Support annual Price Event including data mining, price change modeling, testing, reporting and implementation. Each stage involves extensive analytical review and presentation of summary results
  • Perform ad hoc analytical projects
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service