Reporting Business Analyst Non-IT

1268

Reporting to

Finance Manager – Reporting & Analysis

Job Description

  • System User Support of Cognos TM1 by ensuring data in TM1 Finance cubes is accurate and reflects current business needs.
  • Assist with loading and collation of budgets annually & monthly forecast submissions into the TM1 system.
  • Data extraction for Adhoc reporting requests for senior management.

Responsibilities

  • Administer Finance TM1 instance and ensure the structure supports management reporting needs. Includes creating, deleting, and amending Cubes, Dimensions (including various version such as Actual, Forecast, etc.), Processes, and Chores
  • Ensure TM1 Finance cubes reflect the current Merch Hierarchy (lead and be fully accountable for this reclassification process) and current comp reporting set up
  • Maintenance of automated reports generated directly from TM1 Finance
  • Maintenance and development of written scripts i.e. process to pick up data from other systems or flat/CSV. Files, ensuring that the data is pulled into the system correctly from other systems
  • Be a reference point/superuser/subject matter expert for TM1 Finance, including training for finance team members
  • Ensure TM1 system and process documentation is current and of a high quality
  • Support finance team to automate financial reports and eliminate manual processes
  • Granting user login access to the system, ensuring the user only gets access to the relevant cubes needed for their role
  • Load budgets annually into the TM1 system via load templates completed and submitted by the Finance team in Melbourne
  • Load forecasts monthly into the TM1 system via load templates completed and submitted by the Finance team in Melbourne
  • Extracting and collating detailed data for commercial analysis deep dives and ad hoc requests from the finance team

Desired qualification and work experience

  • Training / Certification for Cognos TM1
  • Degree in Finance, Accounting or Computer Sciences
  • 4-5 years experience in supporting Cognos TM1

Technical skills

  • Deep knowledge of Cognos TM1 system
  • Advanced Excel skills
  • Strong problem solving and analytical skills
  • Excellent communication skills
  • Knowledge of Power BI would be an advantage

Traits and abilities

  • Exceptional skills in critical thinking, prioritization, staying organized, problem solving
  • Works with a sound sense of urgency
  • Demonstrates business acumen to manage and meet customer and sponsor needs