TM1 & Informatica Planning Systems Specialist

SGS Consulting; Sacramento (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

SGS Consulting is seeking an experienced TM1/Planning Analytics professional to design, implement, and optimize enterprise planning models. You will develop TI processes, PAW/PAfE content, and secure data across the planning landscape. Collaboration with Finance, Data Engineering, and business partners is essential to deliver accurate budgets and forecasts.

You will also support system upgrades, data integration, and governance to ensure high-quality planning results across the organization.

Qualifications

• 5+ years in enterprise financial planning systems.
• Hands-on TM1/Planning Analytics development including cubes, rules, and TI.
• Experience with Informatica for data integration and scheduling.
• Strong FP&A understanding and data analysis skills.

Responsibilities

• Design, develop, and maintain TM1 models including cubes, dimensions, hierarchies, rules, and feeders.
• Build and support TI processes for data loading, transformation, validation, and automation.
• Enhance PAW and PAfE content for planning workflows.
• Support budgeting, forecasting, and P&L planning processes.
• Implement and manage TM1 security across cubes and apps.
• Troubleshoot data, reconciliation, and performance issues across TM1 and Informatica.
• Create technical docs, runbooks, and support procedures.
• Participate in system modernization, upgrades, and cloud migrations.

Skills

TM1 Planning Analytics

Informatica PowerCenter

Informatica IICS

FP&A processes

SQL

PAW

PAfE

Data integration

Data analysis

Collaboration

Education

Bachelor's degree +5+ years IT-relevant experience

IT-relevant experience without a Bachelor's degree

Tools

Informatica PowerCenter

Informatica Intelligent Cloud Services (IICS)

Planning Analytics Workspace (PAW)

Planning Analytics for Excel (PAfE)

TM1 security tuning

Job description

SGS Consulting is seeking an experienced TM1/Planning Analytics professional to design, implement, and optimize enterprise planning models. You will develop TI processes, PAW/PAfE content, and secure data across the planning landscape. Collaboration with Finance, Data Engineering, and business partners is essential to deliver accurate budgets and forecasts.

You will also support system upgrades, data integration, and governance to ensure high-quality planning results across the organization.