Data and analytics - SAP Planning expert (SAC, TM1)

F. Hoffmann-La Roche AG; Madrid; Presencial; EUR 50.000 - 70.000; Jornada completa

Descripción de la vacante

A global healthcare company in Madrid is seeking a Data and Analytics Specialist. You will support financial planning teams by delivering data products and ensuring stakeholder requirements are met. Ideal candidates should have over 5 years of experience in Planning Analytics and familiarity with programming languages like Python and SQL. This role offers a chance to contribute to impactful healthcare solutions.

Formación

• 5+ years as a Planning Analytics/TM1 Architect and Developer.
• Experience with programming languages like VBA, Python, and SQL.
• Experience with Agile methodologies and Agile tools.

Responsabilidades

• Build and maintain relationships with business stakeholders.
• Plan, architect, enhance, and build support processes.
• Document user requirements and create Functional Specification documents.

Conocimientos

Proficiency in setting up cubes

VBA

Python

Java Script / CSS

SQL language

MDX query language

Expert user of Perspectives and PAFE Excel Add-ins

Educación

Bachelor's degree in Computer Science, IT, Business, or related

Descripción del empleo

Data and analytics - SAP Planning expert (SAC, TM1) page is loaded

Data and analytics - SAP Planning expert (SAC, TM1)

Apply locations Madrid time type Full time posted on Posted 30+ Days Ago job requisition id 202505-111208

At Roche you can show up as yourself, embraced for the unique qualities you bring. Our culture encourages personal expression, open dialogue, and genuine connections, where you are valued, accepted and respected for who you are, allowing you to thrive both personally and professionally. This is how we aim to prevent, stop and cure diseases and ensure everyone has access to healthcare today and for generations to come. Join Roche, where every voice matters.

The Position

As a member of Roche Informatics' Data Advisory & Insights team, the Data and Analytics Specialist plays a crucial role in building and maintaining strong relationships with business stakeholders across different functions. This role involves understanding customer and stakeholder needs, problem-solving, contributing to product vision and roadmaps, managing the team backlog, and supporting teams in delivering value through continuous feedback. With a proven track record in understanding the true requirements of business stakeholders, you will collaborate as a team player in delivering data products. Additionally, you are comfortable with ambiguity, able to work independently with minimal oversight.

Overview: The Financial Planning team at Roche supports company-wide budgeting and forecasting processes. We are seeking a Senior TM1/Planning Analytics Engineer to plan, architect, enhance and build support processes to several of our current or future applications.

Responsibilities:

Main Skills and Responsibilities necessary:

• Extensive, proven experience (min. 5 years) as a Planning Analytics/TM1 Architect and Developer:

  • Proficiency in setting up cubes, dimensions

  • Capable of writing complex, dependent Turbo Integrator processes (TIs)

  • Capable of writing complex Rules knowing the rule-engine of TM1

  • Building PAW (Planning Analytics Workspace) workbooks

  • Understanding REST API of TM1, being able to write API calls with complex and parameter driven MDX queries

  • Indepth know-how of TM1 security model and being able to implement complex security set-up within Planning Analytics/TM1

  • Expert user of Perspectives and PAFE Excel Add-ins.

• Extensive, proven experience (min. 5 years) with programming languages at minimum with the following:

  • VBA

  • Python

  • Java Script / CSS.

• Extensive, proven experience (min. 5 years) with relational database systems and primary knowledge with:

  • SQL language

  • MDX query language.

• Expertise in designing, implementing, and testing financial planning applications.

• Serving as a Business Analyst by collaborating closely with customers to understand their processes and requirements.

• Documenting user requirements and creating Functional Specification and Design documents.

• Demonstrated ability to self-organize and take proactive measures.

• Proficiency in English.

If you are ready to take on a challenging role and contribute to a dynamic financial planning team, we would love to hear from you.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Business, or related field.

• understanding of Agile methodologies and experience with Agile tools.

• Excellent communication, collaboration, and interpersonal skills.

• Ability to balance customer-centric thinking with technical feasibility and stakeholder needs.

• Strong analytical and problem-solving skills.

This role demands a dynamic individual who is passionate about delivering customer value through continuous improvement and Agile practices. If you thrive in a fast-paced environment and have a strong customer-centric focus, we would love to hear from you.

Who we are

At Roche, more than 100,000 people across 100 countries are pushing back the frontiers of healthcare. Working together, we’ve become one of the world’s leading research-focused healthcare groups. Our success is built on innovation, curiosity and diversity.

Who we are

A healthier future drives us to innovate. Together, more than 100’000 employees across the globe are dedicated to advance science, ensuring everyone has access to healthcare today and for generations to come. Our efforts result in more than 26 million people treated with our medicines and over 30 billion tests conducted using our Diagnostics products. We empower each other to explore new possibilities, foster creativity, and keep our ambitions high, so we can deliver life-changing healthcare solutions that make a global impact.

Let’s build a healthier future, together.

Roche is an Equal Opportunity Employer.

About Us

We believe it’s urgent to deliver medical solutions right now – even as we develop innovations for the future. We are passionate about transforming patients’ lives. We are courageous in both decision and action. And we believe that good business means a better world.

That is why we come to work each day. We commit ourselves to scientific rigor, unassailable ethics, and access to medical innovations for all. We do this today to build a better tomorrow.

We are proud of who we are, what we do, and how we do it. We are many, working as one across functions, across companies, and across the world.