Terumo BCT
Business Intelligence Visualization and Reporting Analyst (PBI)
Terumo BCT, Lakewood, Colorado, United States,
Requisition ID:
32335At 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.JOB TITLE:
Business Intelligence Visualization and Reporting Analyst (PBI)JOB SUMMARYThis position will develop and maintain strong relationships with multiple departments within the Global Finance function while delivering high quality BI Analytical 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 reporting and analysis tools. This role is responsible for the data modeling, visualization and analytics of the Power BI reports maintained by the Financial Systems Team. This role will proactively support critical business strategies by overseeing the maintenance and enhancements of key dashboards, reports and analysis based primarily in PowerBI along with other reporting and analytics tools..ESSENTIAL DUTIESManage data integrations into
Power BI Desktop system
from SAP, BW, Workday Adaptive, OneStream, EveryAngle, Azure DataLake and other source systems as appropriate, serve as a primary point of contact for business and IT teams.Implement data visualizations, dashboarding, and reporting solutions that will drive meaningful insights and business decisions for customers in partnership with key Finance stakeholders.Monitor deployment of additional reporting and analysis systems/tools functionality/upgrades release, completing and coordinating testing and communication to key stakeholdersPlan, review, and revise configurations and customizations to meet evolving business and operational needsDevelop, document, and implement policies, procedures, guidelines, and best practices to ensure data integrity and standardized end user processes for dashboards, reporting and analysisDocument and roll out training on reporting and dashboards to customer baseMaintain user permissions and role access, ensuring alignment across dashboards, tools and systems.Support, Maintain and enhance existing Power BI reportingAnalyze business requirements and translate them into effective & efficient application configurationManage design and support of new data visualizations and reportsWork closely with internal customers to define key metrics and performance indicatorsDevelop, maintain and enforce "branding" and "look/feel" of dashboards and reports to ensure consistency.Analyzes problems and implements solutions to ensure accuracy of the financial information reflected in dashboards, reports and analysis.Troubleshoot intermittent data and/or break/fix issues.Create and maintain documentation including requirements, design, authorization rules and user manualsAct as back-up across our key financial systems tasks to ensure business continuity
MINIMUM QUALIFICATION REQUIREMENTSEducationBachelor's Degree in Computer Science, Business, Finance, Accounting or related field.ExperienceMinimum 3-5 years' experience with developing enterprise reporting and analytics2+ years' experience creating reports, dashboards and analytics with Microsoft Power Bi .Experience with modern cloud based Planning & Consolidation Systems (such as Workday Adaptive, Anaplan, SAP Analytics Cloud, BPC, etc.)Experiences data integrating tools such as SQL, system API's, etc.Excellent data analysis skills, using Microsoft ToolsDAX and M-Code experienceExpertise in using different Power BI functionalities and Power BI DAX queries
Dashboard development with a keen eye for consistent design and data organizationAbility to train and communicate to customers and internal users on reports and dashboard product offeringsExperience working in an international organization with multiple currencies preferredDirect experience SAP/ERP system with exposure to master data maintenanceDirect experience in data testing and validation of systems and processesExperience custom visualization tools such as Python
SkillsSelf-directed individual with strong motivation and willingness to take initiative. Should work independently but accept constructive supervisionExpert level Excel knowledge, including advanced pivot tables, lookups, Visual Basic coding etc.Team player that embraces change and thrives in a fast-paced environmentAble to understand business requirements and develop data modelsAn analytical, creative thinker who can focus on the details without losing sight of the big pictureStrong attention to detailAbility to work cooperatively and collaboratively with all levels of associates and managementSuperior communication skills and the ability to collaborate with all levels of an organizationStrong analytical and problem solving skillsAbility to lead small projects utilizing basic Project Management fundamentalsBasic understanding of finance and accounting principles
PHYSICAL REQUIREMENTSTypical 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 accommodation may be made to enable individuals with disabilities to perform their essential duties.Target Pay Range: $88,600.00to$110,800.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 othersIntegrity - Guided by our missionCare - Empathetic to patientsQuality - Committed to excellenceCreativity - 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.
32335At 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.JOB TITLE:
Business Intelligence Visualization and Reporting Analyst (PBI)JOB SUMMARYThis position will develop and maintain strong relationships with multiple departments within the Global Finance function while delivering high quality BI Analytical 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 reporting and analysis tools. This role is responsible for the data modeling, visualization and analytics of the Power BI reports maintained by the Financial Systems Team. This role will proactively support critical business strategies by overseeing the maintenance and enhancements of key dashboards, reports and analysis based primarily in PowerBI along with other reporting and analytics tools..ESSENTIAL DUTIESManage data integrations into
Power BI Desktop system
from SAP, BW, Workday Adaptive, OneStream, EveryAngle, Azure DataLake and other source systems as appropriate, serve as a primary point of contact for business and IT teams.Implement data visualizations, dashboarding, and reporting solutions that will drive meaningful insights and business decisions for customers in partnership with key Finance stakeholders.Monitor deployment of additional reporting and analysis systems/tools functionality/upgrades release, completing and coordinating testing and communication to key stakeholdersPlan, review, and revise configurations and customizations to meet evolving business and operational needsDevelop, document, and implement policies, procedures, guidelines, and best practices to ensure data integrity and standardized end user processes for dashboards, reporting and analysisDocument and roll out training on reporting and dashboards to customer baseMaintain user permissions and role access, ensuring alignment across dashboards, tools and systems.Support, Maintain and enhance existing Power BI reportingAnalyze business requirements and translate them into effective & efficient application configurationManage design and support of new data visualizations and reportsWork closely with internal customers to define key metrics and performance indicatorsDevelop, maintain and enforce "branding" and "look/feel" of dashboards and reports to ensure consistency.Analyzes problems and implements solutions to ensure accuracy of the financial information reflected in dashboards, reports and analysis.Troubleshoot intermittent data and/or break/fix issues.Create and maintain documentation including requirements, design, authorization rules and user manualsAct as back-up across our key financial systems tasks to ensure business continuity
MINIMUM QUALIFICATION REQUIREMENTSEducationBachelor's Degree in Computer Science, Business, Finance, Accounting or related field.ExperienceMinimum 3-5 years' experience with developing enterprise reporting and analytics2+ years' experience creating reports, dashboards and analytics with Microsoft Power Bi .Experience with modern cloud based Planning & Consolidation Systems (such as Workday Adaptive, Anaplan, SAP Analytics Cloud, BPC, etc.)Experiences data integrating tools such as SQL, system API's, etc.Excellent data analysis skills, using Microsoft ToolsDAX and M-Code experienceExpertise in using different Power BI functionalities and Power BI DAX queries
Dashboard development with a keen eye for consistent design and data organizationAbility to train and communicate to customers and internal users on reports and dashboard product offeringsExperience working in an international organization with multiple currencies preferredDirect experience SAP/ERP system with exposure to master data maintenanceDirect experience in data testing and validation of systems and processesExperience custom visualization tools such as Python
SkillsSelf-directed individual with strong motivation and willingness to take initiative. Should work independently but accept constructive supervisionExpert level Excel knowledge, including advanced pivot tables, lookups, Visual Basic coding etc.Team player that embraces change and thrives in a fast-paced environmentAble to understand business requirements and develop data modelsAn analytical, creative thinker who can focus on the details without losing sight of the big pictureStrong attention to detailAbility to work cooperatively and collaboratively with all levels of associates and managementSuperior communication skills and the ability to collaborate with all levels of an organizationStrong analytical and problem solving skillsAbility to lead small projects utilizing basic Project Management fundamentalsBasic understanding of finance and accounting principles
PHYSICAL REQUIREMENTSTypical 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 accommodation may be made to enable individuals with disabilities to perform their essential duties.Target Pay Range: $88,600.00to$110,800.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 othersIntegrity - Guided by our missionCare - Empathetic to patientsQuality - Committed to excellenceCreativity - 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.