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.
