Title:  Solution Architect D&T Power BI

Working at West means having an opportunity to work by the side of our patients and customers, our global team members and the communities in which we operate – which all help contribute to a Healthier World.

At West, we are by the side of patients. The work we do impacts patients’ lives each and every day – our products are a critical part of healthcare delivery and we are proud of the role we play to improve patient health. We work by the side of our team members. We come together as one global team to deliver for our customers and help them address their challenges. We are a diverse, close-knit community of professionals, where everyone has a voice and opportunity to learn and grow through mutual trust and respect. With a 95 year plus history, we have a track record for success, which includes reported sales of $2.14B in 2020. We serve by the side of our community. Giving back is in our DNA—our team members across more than 50 sites globally are involved with hundreds of charities that have special meaning to them through our West Without Borders team member-led giving program.

Job Summary:

The Solution Architect, D&T, Power BI possesses good  knowledge and experience to assist in  overall design, development, and implementation of BI Applications.  The role is involves working in  areas of solution design, development, performance tuning and troubleshooting. 
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:
•    Assist in  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.
•    Support to conduct training programs and knowledge transfer sessions for junior developers as needed
•    Other duties as assigned.

Basic Qualification and Experience:
•    Bachelor’s degree or equivalent experience 
•    3-5 years of relevant experience in the areas specified under Essential Duties and Responsibilities.

Preferred Knowledge, Skills and Abilities:
•    Good experience with and in-depth knowledge of Power BI, M and DAX functions
•    Experience as a Power BI Developer or Data Scientist.
•    Knowledge and experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources
•    Experience in designing dashboards on phones and tablets. 
•    Background in data warehouse design (e.g. dimensional modeling) and SQL databases and SQL statements.
•    Good 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
•    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
•    Able to comply with the company’s safety and quality policies at all times.

Travel Requirements
•    Office environment 
•    10% of travel requirement.

Physical and Mental Requirements:

•    Occasional on-call work required
•    Ability to work in a global and virtual environment and to effectively prioritize and execute tasks in a high-pressure environment.
•    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.
•    Prefer 12pm – 9pm India time. Willingness to work outside of these hours as needed.

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 Apply.Accommodation@westpharma.com.  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 and/or a pre-employment drug screening.