Sr TM1 Systems Analyst, APAC
Corporate Segment
Kuala Lumpur - Wilayah Persekutuan Kuala Lumpur - Malaysia
We are growing our team to expand business support across all segments and regions of CBRE. The ideal candidate will have strong experience designing, developing, and supporting financial budgeting and forecasting models using multidimensional OLAP models (preferably using TM1/IBM Planning Analytics). The candidate must also have strong communication skills to periodically work directly with finance leaders and finance users to gather requirements, conduct testing, solve issues, and provide training.

Primary Responsibilities: 
  • Develop and maintain IBM Cognos TM1/IBM Planning Analytics models, Planning Analytics Workspace (PAW) workbooks and TM1 websheets and reports.   
  • Troubleshoot application issues and support questions from global finance users.   
  • Actively participate in the development of project plans.  Analyze business requirements, document, and build planning/forecast models in IBM Cognos TM1/Planning Analytics.   
  • Work side by side with other members of the Financial Systems Team to carry out the forecast and budget cycles.  
  • Perform validations of data loads and provide ad-hoc analysis. 
  • Understand complex business requirements and translate into TM1 model updates.  Also, challenge user requests by finding alternative and creative solutions.   
  • Evaluate existing processes, identify areas of improvement, and lead/own the implementation process.  
  • Advise on impact of system related changes.  
  • Maintain system process documentation including diagrams and flowcharts. 
  • Interact with IT Department to resolve system related issues. 
  • 8+ years of experience developing OLAP models in IBM Cognos TM1 or another OLAP tool, such as IBM Cognos Planning, Hyperion Planning / Essbase or Anaplan. 
  • Understanding and experience in TM1 cubes / Rules / TI processes /Active Forms /Websheets /PAW Workbooks/Planning Analytic for Excel (PAX)
  • Knowledge of finance and accounting principles required to provide analytical support.  
  • Knowledge of TM1/Planning Analytics architecture and best practices for TM1 development.  
  • Strong communications and stakeholders management skills 
  • Mathematical Skills – Ability to work with and apply mathematical concepts. 
  • Computer Skills – Very strong or advanced knowledge of Excel.  Possess general relational database concepts.  
  • High level understanding of financial systems.