Perrigo Company plc, a leading global healthcare company, delivers value to its customers and consumers by providing Quality Affordable Healthcare Products. Founded in 1887 as a packager of home remedies, Perrigo has built a unique business model that is best described as the convergence of a fast-moving consumer goods company, a high-quality pharmaceutical manufacturing organization and a world-class supply chain network. Perrigo is the world's largest manufacturer of over-the-counter ("OTC") healthcare products and supplier of infant formulas for the store brand market. The Company also is a leading provider of branded OTC products throughout Europe and the U.S., as well as a leading producer of "extended topical" prescription drugs. Perrigo, headquartered in Ireland, sells its products primarily in North America and Europe, as well as in other markets, including Australia, Israel and China.
The Data Warehouse Developer works closely with Business Analysts and Business Users to develop and maintain and grow Data Warehouse (EDW). The incumbent analyzes data and system requirements and writes, tests and debugs programming and configuration supporting Data Warehouse functionality. This includes new/existing ETL/ELT Flows, DB Schemas /Data models and data sets, as well as supporting existing functionality within the environment. The incumbent maintains all documentation supporting these processes through interaction with business users as well as the Business Analysts.
Accountable for the reliable, accurate, and consistent Data Warehouse /EDW environment
Identification of new opportunities and functionality
Accurate, useful documentation on existing and new systems
Alignment to global Strategic Data Warehousing Initiatives
Qualified candidates must possess a bachelor's degree in a relevant discipline along with a minimum of 5 years prior experience in the development and maintenance of SAP Data Warehouse/HANA, preferably in the pharmaceutical market. Prior work with SAP BW/Hana with functional experience in the areas of SD, FI, CRM and SCM is desired.
Experience with Modeling and Architecting for SAP and Non SAP Data sources.
Provide solutions architecture oversight for new development projects in support of our client's BI program.
1+ Years of hands-on experience in Enterprise HANA Modeling ( good to have ).
Demonstrated experience in building and maintaining data marts, including test and production environments.
Experience working with large datasets from a variety of systems and sources.
Proficiency with source code control and release management.
Strong analytical and critical thinking skills along with excellent research and problem-solving skills.
Ability to communicate the results of analysis in a clear and effective manner.
Ability to prioritize tasks and work independently.
Excellent written and verbal communication and presentation skills.
Extensive experience in interfacing with corporate directors and other key persons.
Ability to fulfill DBA duties such as database configuration and tuning, etc. is a plus.
Knowledge of Dimensional Data Modeling (Kimball Methodology).
Translate business specifications into technical BI specifications.
Knowledge or working with Microsoft SQL Server, SQL Server Analysis Services, and SQL Server Integration Services is plus
Knowledge or working experience with analytical tools like PowerBI, Lumira is plus.
Perrigo Company Corporate