Share this Job

Sr Business Intelligence Analyst

Apply now »

Date: Nov 23, 2021

Location: Lakewood, CO, US

Company: Terumo BCT, Inc.

Requisition ID:  28373  


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.


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.


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. Consider joining our team and unlock your potential. 


This position will develop and maintain strong relationships with multiple departments within the Finance function while delivering high quality BI solutions to our internal customers. This role requires both tight team collaboration and the ability to work on project components independently.  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 & Consolidation system and the integration with our systems – SAP, 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.



  • Manage data integrations into Planning & Consolidation system from SAP, BW, and other source systems as appropriate, serve as a primary point of contact for business and IT teams.
  • Monitor deployment of additional Planning & Consolidation 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
  • 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
  • Work closely with internal customers to define key metrics
  • 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
  • Analyzes 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 for strategic Operations or Finance initiatives
  • Provide training and guidance to lower level analysts




Bachelor's Degree in Computer Science, Business, Finance, Accounting or related field.


  • Minimum 5 years' experience with CPM system administration with a minimum of 2 years in FP&A experience/exposure preferred
  • 2+ years' experience creating self-service content with an Enterprise BI tool
  • Bachelor's Degree, or equivalent degree in Business, Finance or Accounting or relevant field
  • 3+ years Modern Cloud Based Planning & Consolidation System (*name once selected) experience preferred
  • 2+ years of SQL experience
  • Excellent data analysis skills, using MS tools such as Excel, Access, PowerPivot, Desktop PowerBI, etc.
  • Expert experience with Workday Adaptive system for planning, consolidations and reporting
  • Ability to build and develop effective PowerPoint presentations
  • 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 to customers and internal users on reports and dashboard product offerings
  • Expert level Excel knowledge, including advanced pivot tables, lookups, Visucal Basic coding etc.
  • Experience working in an international organization with multiple currencies preferred
  • Direct experience SAP/ERP system with exposure to master data maintenance
  • Direct experience in data testing and validation of systems and processes


  • Self-directed individual with strong motivation and willingness to take initiative.  Should work independently but accept constructive supervision
  • Team player that embraces change and thrives in a fast-paced environment
  • 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
  • Strong analytical and problem solving skills
  • Demonstrated technical knowledge of accounting standards and practices 
  • Abbility to lead small projects utilizing basic Project Management fundamentals
  • Basic understanding of finance and accounting principles




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:  $92,300.00 to $115,400.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:  10.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. Absent accommodation permitted by applicable law, as a condition of employment with Terumo Blood and Cell Technologies in the United States you must be fully COVID-19 vaccinated and provide valid proof of vaccination to the company.

Nearest Major Market: Denver

Job Segment: Business Intelligence, Medical, Military Intelligence, ERP, SAP, Technology, Healthcare, Government