Sr. Solution Architect, D&T, SAP BW

Description At West, we’re a dedicated team that is connected by a purpose to improve patient lives that has been at the center of our Company for more than a century. Our story began when Herman O. West solved the problem of supplying penicillin in mass quantities to the US Government during World War 2. Through our work to deliver thousands of life-saving and life-enhancing injectable medicines to millions of patients daily, West’s indelible mark on the healthcare industry has just begun. A name started our story. How will yours help write our future?

There’s no better place to join an inclusive community of professionals with opportunities for lifelong learning, growth and development. Supported by benefit programs, we empower the physical, mental, emotional and financial health of our team members and their families.

We believe in giving back to help those in need in the communities where we live and work. And are equally committed to creating a healthier environment and planet through our sustainability efforts.

Job Summary The Sr. Solution Architect, D&T, SAP BW possesses in-depth knowledge and experience to work autonomously. The position is responsible for the SAP BW -Development, enhancements, with expertise in Production support. Have experience in Modeling, Extraction, reporting pertaining to SAP BW 7.5 on HANA .

This role requires hands-on experience in SAP BW, HANA CDS Views, data warehouse design, Extraction & Reporting.

Essential Duties And Responsibilities Act as an expert in leading, designing, implementing and supporting the enterprise BI dashboards and reports.

• Work experience in Enhancements and supporting the enterprise BW , expertise in HANA-BW data modelling using Eclipse Tool.
• Work with Users and Functional teams to gather & document reporting requirements and to use the underlying data sources/data warehouses to meet business requirements.
• Act as an expert in Daily Production support activities pertaining to SAP BW , CDS Views
• Worked on Production support data load issues , bugs , tickets from Business and enhancements.
• Expertise in setup table fill concept, extraction from source systems like S4 Hana, ECC, APO
• Worked extensively on extraction from source system like S4 , APO, HR , Flat file etc . Expertise in LO Cockpit Extractions, Flat File Extractions and Generic Extractions. Having knowledge on using SAP delivered information structures, User defined information Structures for extracting data from different Logistic Information system (LIS).
• Liaise with the SAP Functional Teams to work on solutioning on all Gaps/Enhancements or bug fixes.
• Expertise in SAP BI/BW Data-ware house & Development of BW Objects, which includes Prototyping & Technical Specifications.
• Conduct training programs and knowledge transfer sessions for junior developers as needed.
• Other duties as assigned

Additional Responsibilities

• Bridging the gap between business necessities and technical considerations, negotiating solutions, and encouraging creativity when feasible
• Demonstrating keen attention to detail and a commitment to documenting processes for future reference and benefit
• Ensure best practice is used and solutions are standardized and transferrable

Education

• Bachelor's Degree Data analytics, digitalisation or similar discipline preferred

Work Experience

• 8 Years of Relevant experience

Preferred Knowledge, Skills And Abilities Expertise in SAP BI/BW Data-ware house.

• Development of BI/BW Objects, which includes Proto Typing & Technical Specifications.
• Modeling of Custom Info objects, Info object maintenance, Data Sources, Info Sources, DTP’s, Info packages, PSA, Advanced DSO objects, DSO Objects, Info cubes, Data Marts, Info Providers, Multi Providers, Aggregates, APD's,
• Worked extensively on LO Cockpit Extractions, Flat File Extractions and Generic Extractions. Having knowledge on using SAP delivered information structures, User defined information Structures for extracting data from different Logistic Information system (LIS).
• Expertise in BW Advanced data modelling using Eclipse Tool.
• Knowledge on SAP HANA Attribute views, Analytic views, and Calculation views etc.
• Knowledge/Understanding on Reporting tools Power BI.
• Good expertise on Advanced BW Modeling, CDS Views, ABAP coding
• Exposure/Knowledge on Odata service/binding the service etc.
• Worked extensively on Finance Extractors, HR Head count, Flat File Extractions and Generic Extractions. Having knowledge on using SAP delivered information structures, User defined information Structures for extracting data from different Logistic Information system (LIS).
• Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, Restricted Key figures, Structures & Cells, Variables, Exceptions and Conditions, RRI, Web Items and Web Templates & Reports, Input Ready Queries/Planning Templates.
• Data load Management, Event processing and reporting Optimizations.

Travel Requirements 5%: Up to 13 business days per year

Physical Requirements Sedentary-Exerting up to 10lbs/4kgs of force occasionally, and/or negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time.

West is an equal opportunity employer and we value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sex, gender identity, sexual orientation, age, marital status, veteran status, or disability status. If you have a special need that requires accommodation in order to apply to West, please send an email to [email protected] . Where permitted by law, an offer of employment with West Pharmaceutical Services, or any of its subsidiary or affiliate companies, is contingent upon the satisfactory completion of background screening.