Title:  Sr 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 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’s 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 Job Description 
•    Able to comply with the company’s safety and quality policies at all times

Physical and Travel Requirements
•    Office environment 
•    10% of travel requirement

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.