Planning Analytics Data Modeler

High Cliff Partners Inc.

Global, AB(remote)

JOB DETAILS
SKILLS
Application Programming Interface (API), Applications Security, Budgeting, Business Processes, Cloud Computing, Communication Skills, Data Modeling, Database Extract Transform and Load (ETL), ERP (Enterprise Resource Planning), Finance, Financial Operations, Financial Planning, Financial Planning and Analysis (FP&A), Forecasting, IBM Cognos, Identify Issues, Microsoft FAST, Microsoft Windows Azure, Operational Support, Operations Planning, Oracle, Performance Modeling, Performance Tuning/Optimization, Problem Solving Skills, Process Modeling, Profit & Loss, Python Programming/Scripting Language, REST (Representational State Transfer), Reconciliation, Relational Databases (RDBMS), Reporting Dashboards, Reporting Skills, Requirements Management, SAP, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Security Monitoring, Work From Home
LOCATION
Global, AB
POSTED
30+ 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. 

About the Company

H

High Cliff Partners Inc.