Planning Analytics Data Modeler

High Cliff Partners

  • Alberta
  • Contract
  • Full-time
  • 14 days ago
Our Calgary based client is seeking an experienced Planning Analytics Data Modeler to join their project in May 2026 and will run for 6 months, with possibility of an extension. The ideal candidate should have 8+ years in TM1/Planning Analytics development, including designing dimensions/hierarchies, supporting financial/operational planning, and experience with SAP, Blackline, and Oracle finance solutions. Requires expert knowledge of TM1 Rules, Feeders, TI scripting, SQL, and proficiency in PAW/PAfE. This will be a fully remote work setting with MST work hours.Key responsibilities:
  • Strong financial acumen (P&L, budgeting, forecasting, reconciliation).
  • Excellent problem solving and communication skills for engaging finance stakeholders and senior management.
  • Design, build, and maintain multidimensional cubes, dimensions, hierarchies, and attributes within PAW.
  • Develop complex calculation logic (Rules) and optimize performance through efficient Feeders.
  • Create and maintain TurboIntegrator (TI) processes for importing and transforming data from relational databases, flat files, and ERP systems.
  • Develop reports, dashboards, and templates using Planning Analytics for Excel (PAfE) and PAW.
  • Manage application security, user access, and chore scheduling (automated processes).
  • Work with Finance and FP&A teams to gather requirements, translate business processes into technical models, and troubleshoot issues.
  • Troubleshoot and enhance the performance of existing models to ensure fast reporting and data loading.
Preferred Skills:
  • Experience with Planning Analytics on Cloud, including upgrades and migrations.
  • Familiarity with scripting languages like Python (TM1py) or REST API.
  • Experience with ETL tools (e.g., SSIS, Azure Data Factory).
  • Certified Developer – Cognos TM1 certification.

High Cliff Partners