Job Description

Requisition ID: 64084



Date: Nov 28, 2023



Location: Bengaluru, Karnataka, IN



Department: Digtl & Transfrmtion



Description:
At West, we\xe2\x80\x99re 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\xe2\x80\x99s indelible mark on the healthcare industry has just begun. A name started our story. How will yours help write our future?
There\xe2\x80\x99s 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 Power BI possesses in-depth knowledge and experience to work autonomously and have responsibility for the overall design, development, and implementation of BI Applications. The role is proficient in the areas of solution design, development, performance tuning and troubleshooting. Working in a global environment, this role has a hands-on approach capable of working across teams and time zones. This role must have hands-on experience in Power BI, M, DAX functions, data warehouse design, SQL databases and SQL statements.

Essential Duties and Responsibilities:

• Leads, designs, implements, and supports the enterprise BI dashboards and reports.
• Develops reports, dashboards & KPI scorecards and aggregate data from various sources.
• Balance functionality look/feel and performance to ensure an excellent user experience which is a strong focus of the role.
• Work with other teams to gather and document reporting requirements and to use the underlying data sources/data warehouses to meet business requirements.
• Liaise with the SAP Data Warehouse team to design the data model.
• Conduct training programs and knowledge transfer sessions for junior developers as needed
• Conform with and abide by all regulations, policies, work procedures, instruction, and all safety rules.
• Exhibit regular, reliable, punctual, and predictable attendance
• Other duties as assigned

Education and Experience:

• Bachelor\xe2\x80\x99s degree or equivalent experience
• 5+ years of relevant experience in the areas specified under Essential Duties and Responsibilities.

Knowledge, Skills and Abilities:

• Solid experience with and in-depth knowledge of Power BI, M and DAX functions
• Strong experience as a Power BI Developer or Data Scientist.
• Strong expertise and proven experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources
• Advanced expertise in designing dashboards on phones and tablets.
• Background in data warehouse design (e.g. dimensional modeling) and SQL databases and SQL statements.
• Hands-on experience in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse

• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude
• Ability to work autonomously in a fast-paced & complex environment with a self-motivated work ethic; utilize sound judgment with an ability to manage multiple priorities with a sense of urgency
• Ability to work in a virtual environment in a global organization
• Proficient English language skills
• Willingness to global travel
• Able to be aware of all relevant SOPs as per Company policy as they are related to the position covered by this
• Able to comply with the company\xe2\x80\x99s safety and quality policies at all times

Physical and Travel Requirements

• Office environment
• 10% of travel requirement

West embraces diversity and equality of opportunity. We foster an environment where all individuals are safe, treated fairly, valued and respected. We do not discriminate on the basis of race, religion, color, national origin, gender, sex, gender identity, sexual orientation, age, marital status, veteran status, disability status or other applicable legally protected characteristics. Where permitted by law, employment with West Pharmaceutical Services, Inc. or any of its subsidiary or affiliate companies, is contingent upon the satisfactory completion of post-offer background screening and/or drug screening.