BW Architect


Allegan, MI, US, 49010

On Site/Remote: Remote 

Perrigo Company is dedicated to making lives better by bringing Quality, Affordable Self-care products that consumers trust everywhere they are sold.  Help us do it.


Description Overview

Perrigo is looking for a BW Architect to join their growing Analytics and Data Warehousing team.  The Architect must be passionate about  data warehouseing and reporting and enjoy partnering with business users to develop highly effective and impactful, standard, and scalable data models which help analytics solutions.   The right candidate will excel at this job if they can understand and translate people’s needs and are able to apply their level of modeling skills which helps the business to get answers at their finger tips using tools like  PowerBI, SAC, BOBJ.  As an Architect, you are the link between the data and reporting needs helping business partners and Perrigo achieve our mission at "To make lives better by bringing Quality, Affordable Self-Care products that consumers trust everywhere they are sold."

Scope of the Role

  • Independently develop and maintain very complex user-level and technical requirement specifications documentation and issue resolution for SAP HANA/ BW applications
  • Participate in new project development, while supporting projects of high-level complexity
  • Participate in all aspects of SAP Hana/BW-based applications design, development, maintenance, and support; and establish standards and processes which ensure the reliability of Perrigo’s SAP data. Support work and users interation included
  • Maintain project and programming documentation to ensure compliance in Perrigo’s validated cGMP environment
  • Provide guidance and act as a technical expert to the Business Intelligence project team

Experience Required

  • The candidate must possess mature knowledge of data modeling Business Intelligence best practices, Ralph Kimball Methodologies, database structures and connectivity (Primarily SAP ECC, C-fin  and non-SAP related) sources
  • Ability to work with different databases like Hana, SAP BW, SQL
  • Ability to work directly with the business user community to gather requirements, and  build industry standard data models which will help business in self service reporting
  • Very strong analytical, problem-solving, written and verbal communication skills to support HANA models and views in addition to BW functionality, including BW applications, ODS objects and info cube, and the ability to work closely with users and Business Analysts in a validated environment
  • Knowledge of ETL tools like  SAP BusinessObjects Data Services, SLT is a plus
  • Establish thorough testing and provide proper technical documentation to satisfy all corporate guidelines at Perrigo and cGMP standards
  • These skills are normally acquired through completion of a Bachelor’s degree in Business, CIS, Information Technology, or a closely allied field, combined with 6+ years of experience in the development and exposure to modeling and reporting skills with at least one or more domain knowledge like Finance, Sale &Marketing, Customer Service, Planning etc.

We are seeking a diverse applicant pool to ensure the diversity of our team reflects the end consumers we serve through our self-care mission. We are proud to be an equal opportunity employer that celebrates our team’s differences. Individuals of all races, ethnicities, nationalities, ancestries, religious creeds, sexual orientations, genders, gender identities and gender expressions, national origins, ages, mental and physical abilities, familial status,’ veterans status’, military status’ and more are encouraged to apply. TOGETHER, we make lives better. #DIV

Nearest Major Market: Grand Rapids