Senior TM1 Developer

Role overview A specialized data and analytics engineering role focused on supporting the migration of TM1 integrations from Amazon Redshift to Snowflake. The position involves assessing existing processes, refactoring TurboIntegrator workflows, and ensuring data integrity throughout a cloud data warehouse transition. The engineer collaborates with data engineers, project teams, and business stakeholders to deliver a reliable, validated outcome.

Responsibilities - Assess existing TM1 TurboIntegrator processes and data integration workflows that source data from Amazon Redshift - Refactor and enhance TM1 TI processes to connect to Snowflake and extract data reliably - Convert embedded SQL queries for Snowflake compatibility, efficiency, and performance - Modify and maintain TM1 data load processes to support accurate cube population and refreshes - Validate TM1 cubes, dimensions, rules, feeders, and calculations after migration - Reconcile Redshift-based and Snowflake-based outputs to confirm data accuracy and integrity - Support UAT by preparing test scenarios, validating results, and addressing business feedback - Troubleshoot and resolve TM1 integration defects and data issues during testing and deployment - Document migration activities, process changes, test results, and operational procedures

Requirements - Hands-on experience with IBM Planning Analytics on Cloud - Strong SQL development and troubleshooting skills - Practical experience developing and maintaining TM1 TurboIntegrator processes - Advanced English proficiency

Nice to have - Experience with Snowflake and Amazon Redshift - Experience supporting data warehouse migrations or cloud-based data integration projects - Experience with TM1 cube, dimension, rule, feeder, and calculation validation