Associate Solution Architect, D&T, Power BI

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 Associate Solution Architect, D&T, Power BI possesses good knowledge to assist in overall design, development, and implementation of BI Applications.  The role is involves working in areas of solution design, development, and troubleshooting. 
This role must have 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.
•    Help in developing reports, dashboards & KPI scorecards and aggregate data from various sources.
•    With guidance assist the senior to  balance functionality look/feel and performance to ensure an excellent user experience 
•    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.

Basic Qualification and Experience:
•    Bachelor’s degree or equivalent experience 
•    1-3 years of relevant experience 
•    Should have done training on Power BI

Preferred Knowledge, Skills and Abilities:
•    knowledge of Power BI, M and DAX functions
•    Experience as a Power BI Developer.
•    Background in data warehouse design (e.g. dimensional modeling) and SQL databases and SQL statements.
•    Azure is Knowledge is added advantages.
•    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 in a virtual environment in a global organization
•    Able to comply with the company’s safety and quality policies at all times.

Physical and Mental Requirements:

•    Occasional on-call work required
•    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.