Sr Data Analytics Specialist

7 days ago


Somerset, New Jersey, United States Terumo Full time

Terumo Medical Corporation (TMC) develops, manufactures, and markets a complete, solutions-based portfolio of high-quality medical devices used in a broad range of applications for numerous areas of the healthcare industry. TMC places a premium on providing customers with world-class products, training and education programs that drive clear economic value, better clinical outcomes and improved quality of life for patients. TMC is part of Tokyo-based Terumo Corporation; one of the world's leading medical device manufacturers with $5+ billion in sales, 20,000+ employees worldwide and operations in more than 160 nations. Terumo Medical Corporation is comprised of two strategic business divisions: Terumo Interventional Systems and Terumo Medical Products.

Job Summary

The Senior Data Analytics Specialist will be part of our BI/Analytics Team and will be responsible for designing, developing, and maintaining the Enterprise Data Warehouse (EDW) for Reporting and Analytical needs. As the Data Analytics lead, this position will be responsible for architecting scalable, best-in-class Data Warehouse solutions and processes and play a key role in the Analytics modernization initiative. This role will drive Analytics Literacy and help establish a standardized Data Analytics infrastructure for all TAH entities. This role will work closely with the IT, Sales, Finance, Marketing, Manufacturing, and Operations teams to develop data-informed analyses, ultimately supporting successful business growth, operational efficiency, and sales acceleration.

Job Details/Responsibilities

  • In collaboration with BI/Analytics Manager, IT Leadership and Business Partners, develop and maintain roadmap for the management and governance of Enterprise Data Warehouse, ensuring it reflects the current and future business needs, aligned with industry, best practices and solution roadmap
  • Perform Data Modeling, Data Transformation, ETL, ELT, Automation and Process Improvement
  • Creating and maintaining Fact, Dimension and Aggregate tables to support BI Reporting.
  • Data Ingestion/Data Acquisition from various Enterprise Applications
  • Data Profiling, Data Validations, and ensuring Data Hygiene and Quality
  • Develop processes for monitoring, preserving data integrity and quality on an on-going basis
  • Performance Tuning of Database Tables and views for reporting consumption.
  • Promote the adoption of new technologies and solutions to improve the organization's data processing, analysis, and validation capabilities
  • Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes
  • Develop and maintain guidelines, principles, policies, standards, reference models and best practices for all matters related to Enterprise Data Warehouse related process and data architecture
  • Perform unit testing and ensure satisfaction of the documented requirements
  • Facilitate working sessions to understand the analytical requirements and prioritize them.
  • Automate and develop schedules for KPI metrics, and ensure all deadlines and deliverables are met
  • In collaboration with the BI/Visualization team, develop and promote easy to use 'self-service' data products
  • Assists in developing weekly status reports and communicate status, risks, and issues
  • Define the processes and frameworks allowing the Analytics team to prepare enriched and aggregated data assets for reporting and Advanced Analytics
Job Responsibilities (continued)
  • Work with IT Leaders, SAP COE Leaders, PMO, (external) Consulting Team and (internal) Core Business Team for the successful design, configuration, unit testing, integration testing and user acceptance testing of the Analytics Modernization initiative
  • Advising on optimized architectures for cloud data management, helping develop roadmaps for on-premises to Cloud migration efforts
  • Perform risk assessments of enterprise apps and work closely with project teams on building/configuring applications security.
  • Lead team members on projects involving data migration and implementation of new solutions on cloud Data Warehouse platforms
  • Work with the IT Leaders, SAP COE Leaders, PMO, Project Team and Business stakeholders to proactively and effectively communicate and collaborates with the User Community to address reporting, analytics, and data needs across all operations in the Americas.
  • Support the building of and effectively manage Integration Points between Cloud Data Lake/Data Warehouse and other TAH systems.
  • Create clearly defined Instructions and Structured Documentation to track and control project scope.
  • Adheres to the policies, standards & baselines to ensure consistency
  • Establish processes, methods, and tools for EDW and Data Management.
  • Apply processes and tools to support the SLA(s) established by the BI/Analytics team to the various business units. Monitor and report on the SLA adherence
  • Respond to User Help Desk tickets for disposal of service requests from business users.
Knowledge, Skills and Abilities (KSA)
  • Advanced knowledge of SQL, Scripting, Database, Data Warehouse methodologies, Data Management, Data Modeling and Performance Tuning
  • Knowledge of SAP ERP (S/4 or ECC) with understanding of the processes, Tables and CDS Views would be a great asset.
  • Demonstrated ability in creating DB objects like Stored Procedures, Functions for computing and data transformation.
  • Demonstrated ability in Performance Tuning of large-scale Enterprise Data Warehouses (EDW) to power BI/Reporting
  • designing and building ETL pipelines using SQL or any Data Integration technologies.
  • Migrating on premise workloads to one or more industry leading public cloud(s)
  • Experience with any Data Integration/ETL/ELT technologies like Informatica, Talend etc., and Data Visualization/BI Tools like Tableau, Power BI would be plus
  • Able to work cross-functionally with many teams and multi-task with a sense of urgency.
  • Comfortable working in a fast-paced, dynamic environment and committed to meeting deadlines
  • Strong analytical ability to understand the reporting requirements and the resulting implications for the process teams and BI design
  • Strong desire to stay ahead of the trends and ability to research and apply emerging technologies.
  • Excellent communication skills and able to work with business owners to develop and define key business requirements and to build data sets that answer those questions.
  • Keen sense of maturity, judgment and diligence required to:
  • Secure company's financial interests
  • Avoid exposures to expensive delays and cost overruns
  • Ability to cope with stress and continuously changing demands/priorities
  • Willingness to learn new skills/techniques/processes
Qualifications/ Background Experiences
  • Bachelor's Degree in Computer Science, Information Technology, or related fields.
  • Minimum 10 years of experience designing and implementing Data Warehouse to support BI/Business Analytics Reporting for ERP system and with Microsoft SQL Server or similar RDBMS
  • Minimum 7 years' experience in custom ETL design, implementation, and maintenance
  • Prior experience with SAP is highly preferred but at a minimum must have experience developing Business Analytics/BI System for any ERP system (i.e., JD Edwards, Oracle, etc.).
  • Prior experience with Large and Complex BI Analytics implementation required
  • Prior experience with any Cloud Data platform (Snowflake, Azure Synapse, Redshift, Big Query etc.) required
  • Prior experience in the medical device industry and/or pharmaceutical industry highly preferred
It is Terumo's policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As a Company, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment.

  • Somerset, New Jersey, United States Johnson & Johnson Full time

    Job Description Johnson & Johnson is recruiting for our Sr. Director, Deliver Emerging Capabilities (Risk, Network, Digital & Data, and NPI) located in either Beerse, Belgium, Zug, Switzerland, Tokyo, Japan, Raritan, NJ, Titusville, NJ, or Somerset, NJ. At Johnson & Johnson, we believe health is everything. Our strength in healthcare innovation empowers us...


  • Somerset, New Jersey, United States Legend Biotech US Full time

    Company Information Legend Biotech is a global biotechnology company dedicated to treating, and one day curing, life-threatening diseases. Headquartered in Somerset, New Jersey, we are developing advanced cell therapies across a diverse array of technology platforms, including autologous and allogenic chimeric antigen receptor T-cell and natural killer (NK)...


  • Somerset, New Jersey, United States SHI International Full time

    Job Summary: The Sr. ITAM Customer Success Manager (SR. CSM) is responsible for managing, expanding and renewing contracts with SHIs customers. The SR. CSM will help existing customers to maximize their investment in our ITAM programs. The position reports to the Manager ITAM Customer Success and ultimately to the Director of ITAM Customer Success. The SR....


  • Somerset, New Jersey, United States Terumo Medical Corporation Full time

    The Quality Systems Training Specialist is responsible for tracking, monitoring, and ensuring the learning management system runs smoothly and efficiently. The Quality Systems Training Specialist assists the Sr. Manager Quality Systems in ensuring al Systems, Training, Training Specialist, Quality, Manager, Project Management, Manufacturing, Technology


  • Somerset, New Jersey, United States Pharmscript Full time

    Overview: PharmScript is one of the nations leading pharmacies, partnering with long-term and post- acute care facilities to supply medications to thousands of residents and patients. When you join the PharmScript family, you join the ranks of more than 2,000 dedicated people across the country who help to get safe, accurate, and timely medication to those...

  • Contract Specialist

    7 days ago


    Somerset, New Jersey, United States iBuy LLC Full time

    About iBuy iBuy is a fast-growing retail and wholesale distributor that focuses on consumer electronics, kitchenware, apparel, and more. We are always exploring new categories and expanding our market reach. Welcome to our Workplace At iBuy, we foster a culture of success by encouraging open communication and collaboration in our open office layout. We...


  • Somerset, New Jersey, United States Church & Dwight Full time

    A collective energy and ambition. A place where you can make a real difference. We're a company that genuinely cares about our people, our products, our consumers and the environment. Our unique, informal culture champions courage, determination and collaboration. Knowing we have an open and supportive team means each of us has the freedom to take...


  • Somerset, New Jersey, United States Dungarvin Full time

    Company DescriptionA LITTLE ABOUT US: At Dungarvin, we're not just a national company; we're a family of caring, passionate, and dedicated team members working together nationwide to offer top-notch, community-based support. Our mission is simple: We're here to provide exceptional assistance to individuals with intellectual and developmental disabilities,...


  • Somerset, New Jersey, United States Demant Full time

    Overview: When you become part of the Demant family, you also become part of our quest to make a life-changing difference for over 500 million people all over the world who suffer from hearing loss. Working with us, you will be part of a world-leading hearing healthcare group that develops, manufactures, and sells highly advanced, market-leading hearing...

  • SAP Spec Fin

    7 days ago


    Somerset, New Jersey, United States Terumo Full time

    Terumo Medical Corporation (TMC) develops, manufactures, and markets a complete, solutions-based portfolio of high-quality medical devices used in a broad range of applications for numerous areas of the healthcare industry. TMC places a premium on providing customers with world-class products, training and education programs that drive clear economic value,...

  • Metrologist

    1 week ago


    Somerset, New Jersey, United States Lupin Pharmaceuticals Full time

    Overview: Lupin is comprised of a fast growing, innovative and robust team of manufacturing, Research and Development and commercial divisions. Together these entities make up the generic and branded U.S. business. Lupin has a significant generic pipeline, and a branded focus on womens health. Our first Research and Development facility in the US is located...


  • Somerset, New Jersey, United States RWJBarnabas Health Full time

    Registered Behavior Technician (RBT) - Part Time - Somerset, NJReq #:45629Category:Behavioral and Mental HealthStatus:Part-TimeShift:DayFacility:Childrens Specialized HospDepartment:Childrens Specialized HospLocation:Intensive Pediatric Feeding Disorders Program, 888 Easton Avenue, Somerset, NJ 08873Job Overview:Registered behavior technicians (RBTs) provide...


  • Somerset, New Jersey, United States Surgical Care Affiliates Full time

    Overview Today, SCA Health has grown to 11,000 teammates who care for 1 million patients each year and support physician specialists holistically in many aspects of patient care.Together, our teammates create value in specialty care by aligning physicians, health plans and health systems around a common goal: delivering on the quadruple aim of high-quality...


  • Somerset, New Jersey, United States Church & Dwight Full time

    A collective energy and ambition. A place where you can make a real difference. We're a company that genuinely cares about our people, our products, our consumers and the environment. Our unique, informal culture champions courage, determination and collaboration. Knowing we have an open and supportive team means each of us has the freedom to take...

  • Director, Access

    7 days ago


    Somerset, New Jersey, United States Lupin Pharmaceuticals Full time

    Overview: Lupin is comprised of a fast growing, innovative and robust team of manufacturing, Research and Development and commercial divisions. Together these entities make up the generic and branded U.S. business. Lupin has a significant generic pipeline, and a branded focus on womens health. Our first Research and Development facility in the US is located...


  • Somerset, United States Demant Full time

    Overview The Customer Data Specialist’s responsibility is to analyze, collect, file, update and maintain customer data. Validate and set up new accounts. Set up and maintain accurate account pricing, warranties, and preferences for Demant wholesale and network companies. Through proactive phone and email contact, the Customer Data Specialist works with the...


  • Somerset, United States Terumo Medical Corporation Full time

    Sr IT Support Specialist Date: May 20, 2024 Req ID: 3305 Location: Somerset, NJ, US, 08873 Company: Terumo Medical Corporation Department: TMC Information Technology Job Summary The Sr. IT Support Specialist is responsible for administering and supporting the enterprise user community. This will involve working on the phone, in person and within the helpdesk...


  • Somerset, United States Terumo Medical Corporation Full time

    Sr. Power BI Specialist Date: Jun 10, 2024 Req ID: 2186 Location: Somerset, NJ, US, 08873 Company: Terumo Americas Holding, Inc. Department: IT3_Enterprise Business Apps Terumo Medical Corporation (TMC) develops, manufactures, and markets a complete, solutions-based portfolio of high-quality medical devices used in a broad range of applications for numerous...


  • Somerset, United States Terumo Full time

    Job Summary The Sr. IT Support Specialist is responsible for administering and supporting the enterprise user community. This will involve working on the phone, in person and within the helpdesk system to process support requests, document solutions and communicate status to the end users and IT management. Additionally, this role is responsible for the...


  • Somerset, United States Terumo Full time

    Terumo Medical Corporation (TMC) develops, manufactures, and markets a complete, solutions-based portfolio of high-quality medical devices used in a broad range of applications for numerous areas of the healthcare industry. TMC places a premium on providing customers with world-class products, training and education programs that drive clear economic value,...


  • Somerset, United States Terumo Medical Corporation Full time

    This is a highly visible position one which offers a tremendous opportunity to learn and grow with Terumo Medical Corp.! The incumbent will have the opportunity to collaborate across multiple company departments and functions as well as play an integral part of charting the course for the company's future successes! Job Summary: Sr. Manager Compensation...


  • Somerset, United States Terumo Medical Corporation Full time

    This is a highly visible position one which offers a tremendous opportunity to learn and grow with Terumo Medical Corp.! The incumbent will have the opportunity to collaborate across multiple company departments and functions as well as play an integral part of charting the course for the company's future successes!Job Summary: Sr. Manager Compensation will...


  • Somerset, United States Terumo Medical Corporation Full time

    This is a highly visible position one which offers a tremendous opportunity to learn and grow with Terumo Medical Corp.! The incumbent will have the opportunity to collaborate across multiple company departments and functions as well as play an integral part of charting the course for the company's future successes!Job Summary: Sr. Manager Compensation will...


  • Somerset, United States Terumo Medical Corporation Full time

    This is a highly visible position one which offers a tremendous opportunity to learn and grow with Terumo Medical Corp.! The incumbent will have the opportunity to collaborate across multiple company departments and functions as well as play an integral part of charting the course for the companys future successes! Job Summary: Sr. Manager Compensation...


  • Somerset, United States Terumo Medical Corporation Full time

    This is a highly visible position one which offers a tremendous opportunity to learn and grow with Terumo Medical Corp.! The incumbent will have the opportunity to collaborate across multiple company departments and functions as well as play an integral part of charting the course for the company's future successes! Job Summary: Sr. Manager Compensation...

  • Contracts Specialist

    4 weeks ago


    Somerset, United States SHI International Corp. Full time

    Job Summary: The Contracts Specialist, working with the SHI Salesforce and Management, negotiates and administers contracts for the resale of software, hardware, cloud solutions, and related IT services with our Customers and Partners/Vendors. The Contracts Specialist administers requests for contractual forms, documents, and customer contracts in accordance...


  • Somerset, United States SHI International Corp. Full time

    Job Summary: The Contracts Specialist, working with the SHI Salesforce and Management, negotiates and administers contracts for the resale of software, hardware, cloud solutions, and related IT services with our Customers and Partners/Vendors. The Contracts Specialist administers requests for contractual forms, documents, and customer contracts in accordance...

  • Analytical Chemist

    6 days ago


    Somerset, United States L'Oreal Full time

    **Analytical Chemist** **Location: Somerset, NJ** **Division: Operations** **Reports to: Manager, Laboratories** **Who We Are** At the heart of our company lies a dedication to innovation and progress. In all markets where we operate, we're committed to fostering excellence, empowering talented individuals, and leading the way in various...


  • Somerset, United States Legend Biotech US Full time

    Company Information Legend Biotech is a global biotechnology company dedicated to treating, and one day curing, life-threatening diseases. Headquartered in Somerset, New Jersey, we are developing advanced cell therapies across a diverse array of technology platforms, including autologous and allogenic chimeric antigen receptor T-cell and natural killer (NK)...


  • Somerset, United States Terumo Medical Corporation Full time

    Job Summary: The Senior Power BI Specialist will be part of our BI/Analytics Team and will be responsible for designing, developing, and maintaining our Power BI platform. As the Power BI lead, this position will be responsible for architecting scalable, best-in-class Business Intelligence/Reporting solutions and processes. With a focus on driving...


  • Somerset, United States Terumo Medical Corporation Full time

    Job Summary: The Senior Power BI Specialist will be part of our BI/Analytics Team and will be responsible for designing, developing, and maintaining our Power BI platform. As the Power BI lead, this position will be responsible for architecting scalable, best-in-class Business Intelligence/Reporting solutions and processes. With a focus on driving...


  • Somerset, United States Terumo Medical Corporation Full time

    Job Summary: The Senior Power BI Specialist will be part of our BI/Analytics Team and will be responsible for designing, developing, and maintaining our Power BI platform. As the Power BI lead, this position will be responsible for architecting scalable, best-in-class Business Intelligence/Reporting solutions and processes. With a focus on driving...


  • Somerset, United States Vortalsoft inc. Full time

    **Job description - Role -Data Center technician ( Customer engineer)** **Location - Somerset, NJ** We are looking for a self-motivated, dedicated individual who is ready to put their technical skills to work in a fast-paced, customer-focused environment. Utilizing their technical knowledge, they will have the responsibility of responding to customer calls...


  • Somerset, United States Legend Biotech Corp Full time

    Company Information Legend Biotech is a global biotechnology company dedicated to treating, and one day curing, life-threatening diseases. Headquartered in Somerset, New Jersey, we are developing advanced cell therapies across a diverse array of technology platforms, including autologous and allogenic chimeric antigen receptor T-cell and natural killer (NK)...


  • Somerset, United States Legend Biotech Corp Full time

    Company Information Legend Biotech is a global biotechnology company dedicated to treating, and one day curing, life-threatening diseases. Headquartered in Somerset, New Jersey, we are developing advanced cell therapies across a diverse array of technology platforms, including autologous and allogenic chimeric antigen receptor T-cell and natural killer (NK)...