Sr. Sales Planning and Insights Lead

Requisition ID:  34405  

At Terumo Blood and Cell Technologies, our 7,000+ global associates proud to come to work each day, knowing that what we do impacts the lives of patients around the world. For Terumo, for Everyone, Everywhere.

We make medical devices and related products that are used to collect, separate, manufacture and process various components of blood and cells. With our innovative technologies and service offerings, we touch a patient’s life every second of every day and are committed to continuing to increase the number of patients we serve. Advancing healthcare with heart.

With some of the best and brightest minds in the industry, an unmatched global footprint, comprehensive benefits and a distinct culture, Terumo Blood and Cell Technologies is a great place to work, grow and be part of a team that is focused on making a difference. Join us and help shape wherever we go next. You create your future and ours.

JOB TITLE: Sr. Sales Planning and Insights Lead

JOB SUMMARY

This position will develop and maintain strong relationships with multiple departments within the Finance function while delivering high quality solutions to our internal customers. This role requires cross-team collaboration and the ability to work independently. Responsible for leading all process aspects of Sales Forecasting, Budgeting and long-range sales planning in full alignment with the Director of Commercial Finance. Responsible for providing high-level, as well as detailed, quantitative, and qualitative analytical support to the finance organization, leveraging the various financial system applications and data sets. In the role you will be responsible for managing the day-to-day functionality of our Planning system and the integration with our systems – SAP, Workday Adaptive, OneStream, PowerBI, BW, etc. This role will proactively support critical business strategies by overseeing the maintenance and enhancements of the system in collaboration with Finance team leaders. In addition, this position needs to deploy analytical skills and problem-solving skills to ensure accurate data, well executed processes, continuous process improvements and improving analytical tools.  This person also needs to have the ability to solve complex problems and generate insights.

ESSENTIAL DUTIES

• Manage data integration into Planning system (Workday Adaptive) from SAP, SAP BW, OneStream and other source systems as appropriate, serve as a primary point of contact for business and IT teams
• Lead and drive cross functional projects to improve sales planning, reporting, and system functionality
• Recommends and implements modifications to existing policies & procedures
• Monitor deployment of additional Planning system functionality/upgrades release, completing and coordinating testing and communication to key stakeholders
• Manage business rules impacting calculations, allocations, and data repositories for the purpose of facilitating the Company’s annual budgeting, forecasting and actual reporting
• Plan, review, and revise configurations and customizations to meet evolving business and operational needs
• Develop, document, and implement policies, procedures, guidelines, and best practices to ensure data integrity and standardized end user processes
• Document and roll out training on reporting and dashboards to customer base
• Troubleshoot intermittent data and/or break/fix issues and system errors
• Maintain user permissions and role access
• Analyze business requirements and translate them into effective & efficient application configuration
• Manage design and support of data visualization and reports
• Implement data visualizations, dashboarding, and reporting solutions that will drive meaningful insights and business decisions for customers
• Create a self-service environment that users can leverage to understand how they are performing toward goals and make data-informed decisions using BI tools such as PowerBI
• Analyzes complex problems and implements solutions to ensure consistency and accuracy of the financial systems
• Create and maintain documentation including requirements, design, and user manuals
• Build ad hoc analysis
• Coach and transfer knowledge to less experienced team members and customers
• Partner with Global and Regional teams to ensure a smooth and accurate budget, planning and reporting process
• Data validation as a point of triangulation to ensure accuracy of source of truth actuals data across multiple systems/sources
• Provide advanced training to TBCT Associates who are required to become “power users” of our systems
• Act as back-up across our key financial systems tasks to ensure business continuity.

MINIMUM QUALIFICATION REQUIREMENTS

Education

Bachelor's Degree in Computer Science, Business, Finance, Accounting, or related fields. Master’s Degree Preferred

Experience

• Minimum 7 years' experience with EPM, Planning or Consolidation systems utilization and administration.  In addition, requires minimum of 5 years in FP&A or Accounting experience/exposure
• Experience creating self-service content with an Enterprise BI tool
• Workday Adaptive Planning (strongly preferred), OneStream or other Cloud-Based Planning & Consolidation System Experience
• Hands-on experience using MS tools such as Excel, , Desktop PowerBI, Azure, Power Automate, etc. 
• Strong in understanding and writing coding and complex formulas in MS Tools
• Ability to build and develop in Workday Adaptive Sheets, complex coding, design integrations, pipelines, and complex reporting. Strong dashboard development skills with attention to design and data organization
• Experience working in an international organization with multiple currencies preferred
• SAP S4 Hana/ERP system with exposure to master data maintenance.
• Data testing and validation of systems and processes

Skills

• Advanced proficiency in configuring and administering Workday Adaptive Planning, including model structure, versioning, and user roles
• Proven ability to lead cross-functional projects from initiation through execution leveraging project management skills
• Self-directed individual with strong motivation and willingness to take initiative and work independently

• Ability to build and develop effective PowerPoint presentations
• Data analysis skills, strong in using MS tools such as Excel, PowerBI, Power Automate, etc.
• Ability to communicate technical concepts clearly and concisely to both technical and non-technical audiences
• Dashboard development with a keen eye for design and data organization
• Ability to interact with customers, gathering requirements and turning them into meaningful reports
• Ability to train and communicate with customers and internal users on reports and dashboard product offerings
• An analytical, creative thinker who can focus on the details without losing sight of the big picture
• Strong attention to detail

• Ability to work cooperatively and collaboratively with all levels of associates and management

• Superior communication skills and the ability to collaborate with all levels of an organization

• Demonstrated technical knowledge of accounting standards and practices 
• Ability to lead project prioritization and road mapping discussion and utilize basic Project Management fundamentals to execute projects.

PHYSICAL REQUIREMENTS

Typical Office Environment requirements include: reading, speaking, hearing, close vision, walking, bending, sitting, and occasional lifting up to 20 pounds.

The physical demands described here are representative of those that must be met by an associate to successfully perform the essential duties of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

Target Pay Range:  $121,300.00 to $151,700.00  -  Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data
Target Bonus on Base:  7.0%

At Terumo Blood and Cell Technologies, we provide competitive total reward offerings that consist of compensation, benefits, recognition, along with a wealth of other well-being, work-life and recognition programs which support in unlocking the potential for you and your family. Included in our expansive list of benefits offerings are multiple group medical, dental and vision plans, a robust wellness program, life insurance and disability coverages, also a variety of voluntary programs such as group accident, hospital indemnity, critical illness, pet insurance and much more. To help you save for retirement, we offer a 401(k) plan with a matching contribution and for work-life balance we have vacation and sick time programs for associates. For us, it’s about protecting the personal welfare of our associates and their families, helping to achieve personal goals and offering those extra touches for convenience, security and overall peace of mind.

• Terumo Blood and Cell Technologies is part of Terumo Group, founded in 1921 and headquartered in Tokyo, Japan.
• In 2019, Terumo Blood and Cell Technologies reached $1 billion in revenue.
• We employ nearly 7,000 associates globally, with global headquarters in Lakewood, CO, U.S., and regional headquarters in Brussels, Buenos Aires, Singapore and Tokyo.
• We manufacture devices, disposable sets and solutions at our facilities in Belgium, India, Japan, Northern Ireland, the U.S. and Vietnam. Our global presence enables us to serve customers in more than 130 countries.
• Our core values help set our direction, guide our actions and keep us true to our corporate mission of contributing to society through healthcare.
  • Respect – Appreciative of others
  • Integrity – Guided by our mission
  • Care – Empathetic to patients
  • Quality – Committed to excellence
  • Creativity – Striving for innovation
• We contribute to the Leukemia and Lymphoma Society (LLS), raising $1.3 million USD since 2007.

We are proud to be an Equal Opportunity Affirmative Action Employer.  All applicants will be afforded equal opportunity without discrimination because of race, color, religion, sex, gender identity or expression, sexual orientation, marital status, order of protection status, national origin or ancestry, citizenship status, age, physical or mental disability unrelated to ability, military status or an unfavorable discharge from military service.

Terumo Blood and Cell Technologies is committed to providing a safe, healthy and secure working environment. Our Colorado campus locations are tobacco-free workplaces, and we maintain a drug-free workplace and perform pre-employment substance abuse testing and detailed background verification.