Title: Staff Engineer/TM1 & Informatica Planning Systems Developer
Contract: 12 Month
Location: San Diego, CA
 
Job Description: 
The TM1 & Informatica Planning Systems Developer is responsible for designing, developing, and supporting enterprise financial planning and forecasting solutions built on IBM Planning Analytics (TM1) and Informatica-based data integrations. This role bridges Financea, FP&A, and Data Engineering teams to ensure accurate, timely, and governed data flows into planning models supporting budgeting, forecasting, and reporting.
 
Key Responsibilities
TM1 / Planning Analytics

• Design, develop, and maintain TM1 models, including cubes, dimensions, hierarchies, rules, and feeders
• Build and support TurboIntegrator (TI) processes for data loading, transformations, validations, and automation
• Develop and enhance Planning Analytics Workspace (PAW) and/or PA for Excel (PAfE) content
• Support planning use cases such as Budget, Forecast, OPEX, Revenue, P&L, Balance Sheet, and Cash Flow
• Implement and manage TM1 security (cube, dimension, element, and application-level)
• Performance tune TM1 models, rules, and feeders to support scalable enterprise workloads
• Informatica / Data Integration
• Support Informatica mappings, workflows, and schedules to feed data into TM1
• Partner with data engineering teams to ensure data quality, completeness, and timeliness
• Support data refresh cycles aligned to financial close and planning timelines
• Cross?Functional & Operational Responsibilities
• Partner with Finance, FP&A, and business users to gather requirements and deliver planning solutions
• Support UAT, production releases, and hypercare for planning system enhancements or upgrades
• Troubleshoot data, reconciliation, and performance issues across TM1 and Informatica layers
• Create and maintain technical documentation, runbooks, and support procedures
• Participate in planning system modernization, upgrades, or cloud migration initiatives
• Ensure solutions align with data governance, controls, and audit requirements

Required Skills:

• 5+ years of experience in enterprise financial planning systems
• Strong hands?on experience with:
• IBM Planning Analytics (TM1) – cubes, rules, feeders, TI processes
• Informatica (PowerCenter and/or IICS) – mappings, workflows, scheduling
• Solid understanding of financial planning and FP&A processes
• Experience integrating planning systems with ERP, EDW, or cloud data platforms
• Strong SQL and data analysis skills
• Ability to work across business and technical teams

Nice to Have:

• Experience in Agile / Scrum delivery environments
• Experience supporting global or multi business unit planning solutions
• Experience with other Planning tools like Anaplan, One Stream, EPM
• Exposure to Databricks, cloud data platforms, or modern analytics stacks
• Knowledge of data governance, certification, or financial controls

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 62.69/daily.