Finantial Tm1 Architect

PepsiCo
Vitoria-Gasteiz, Spain
15 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

Tech stack

Microsoft Excel Agile Methodology Business Analytics Applications Data Analysis Applications Architecture Audit Trail Cloud Computing Data Integration Extract Transform Load (ETL) Data Visualization Relational Databases Oracle (Applications)
+14 more
Performance Tuning Power BI Anaplan SAP (Applications) SAP Business Planning and Consolidation Data Streaming Tableau (Software) Scripting Oracle Hyperion Data Lakes Data Analytics Machine Learning Operations Software Version Control Alteryx

Job description

Overview The Finance Application Architect (TM1) is a key contributor in designing, developing, and maintaining financial planning and analytics solutions using IBM Planning Analytics (TM1) Customization of IBM Planning Analytics (TM1) for Pepsico is known as Mosaic initiative.This role combines technical expertise with a deep understanding of finance processes to create robust, scalable, and efficient systems that enable data-driven decision-making.The focus of this role includes: Mosaic Core Model deployment Architectural design for future Mosaic solutions Enhancing scalability, performance, and integration Additionally, this position plays a vital role in cross-functional collaboration, ensuring seamless integration with Data lake and other systems, optimizing financial workflows, and driving best-in-class architectural practices in financial analytics.Responsibilities1. Solution Architecture & Deployment Co-Lead and support the end-to-end architecture and deployment of Mosaic Core 2.0, ensuring alignment with global guidelines.Design scalable, high-performance financial planning solutions using IBM Planning Analytics (TM1).Define and implement best practices for TM1/Planning Analytics model development and optimization.Ensure architecture meets business needs while maintaining governance, compliance, and performance.2. Finance Application Strategy & Design Collaborate with key finance and business stakeholders to translate business objectives into scalable architectural solutions.Lead the design and advisory for future Mosaic enhancements, ensuring future-proofing and adaptability.Develop technical roadmaps for TM1 and retirement of other financial planning applications (e.G., BPC, Hyperion, Anaplan).3. Performance Optimization & Scalability Implement strategies to enhance system performance and reduce processing time in large-scale TM1 models.Optimize data flows, cube calculations, and model structuring for efficient financial reporting and analysis.4. Data Integration & Automation Manage seamless integration between TM1 and Other systems (Data Lake, Alteryx, etc. ) Automate data loading, transformation, and reconciliation.5. Governance, Compliance & Best Practices Review, align and enforce TM1 development standards, governance policies, and version control.Maintain high data accuracy, reliability, and auditability in financial models.6. Training, Support & UAT Conduct training sessions for finance teams to maximize their use of TM1.Lead User Acceptance Testing (UAT) and provide ongoing advisory support to optimize financial workflows.Qualifications Technical Expertise Advanced experience in finance planning applications: IBM Planning Analytics (TM1) and nice to have in BPC, Hyperion, Anaplan.Proficiency in TM1 model development, TurboIntegrator scripting, rules, feeders, and cube design.Expertise in relational databases, data modeling, and ETL processes.Experience with TM1 add-ins (Planning Analytics for Excel) and integration with visualization tools.Finance Process Knowledge Deep understanding of budgeting, forecasting, consolidation, and financial reporting.Ability to design financial solutions aligned with business priorities and goals.Solution Architecture & Advisory Expertise in finance application architecture design and strategic solution implementation.Ability to architect scalable, reliable, and future-proof solutions.Communication & Leadership Strong stakeholder engagement skills with the ability to explain complex technical concepts to non-technical audiences.Experience working with cross-functional teams to align finance application strategies with business objectives.Preferred Qualifications Experience integrating TM1 with ERP systems (SAP, Oracle) and BI tools (Power BI, Tableau).Exposure to TM1 Cloud and Agile methodologies.Experience leading finance digital transformation projects.This position is ideal for a professional who combines deep technical expertise with strategic vision, ensuring seamless finance application architecture and innovative solutions to drive business success.#J-*****-Ljbffr

Requirements

Qualifications Technical Expertise Advanced experience in finance planning applications: IBM Planning Analytics (TM1) and nice to have in BPC, Hyperion, Anaplan. Proficiency in TM1 model development, TurboIntegrator scripting, rules, feeders, and cube design. Expertise in relational databases, data modeling, and ETL processes. Experience with TM1 add-ins (Planning Analytics for Excel) and integration with visualization tools. Finance Process Knowledge Deep understanding of budgeting, forecasting, consolidation, and financial reporting. Ability to design financial solutions aligned with business priorities and goals. Solution Architecture & Advisory Expertise in finance application architecture design and strategic solution implementation. Ability to architect scalable, reliable, and future-proof solutions. Communication & Leadership Strong stakeholder engagement skills with the ability to explain complex technical concepts to non-technical audiences. Experience working with cross-functional teams to align finance application strategies with business objectives. Preferred Qualifications Experience integrating TM1 with ERP systems (SAP, Oracle) and BI tools (Power BI, Tableau). Exposure to TM1 Cloud and Agile methodologies. Experience leading finance digital transformation projects. This position is ideal for a professional who combines deep technical expertise with strategic vision, ensuring seamless finance application architecture and innovative solutions to drive business success. #J-*****-Ljbffr

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.buscojobs.com.es

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

5:39 min

Transitioning from technical engineering into corporate project leadership

Peter Busch · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:42 min

System architecture for ingesting and processing enterprise data

Sandeep Kusuma Sandeep Kusuma · WWC Europe 2026

3:29 min

Transitioning from talent acquisition to agile talent architecture

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

2:48 min

Daily responsibilities and alignment practices for technical engineering leadership

Edoardo Dusi · LIVE

Videos

See all

Related articles

See all