Data Warehouse Developer w/ SAP BW/HANA


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. Responsibilities:

  • 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

Required Experience:

  • 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.

We're proud to be an equal opportunity employer- and celebrate our employees' differences, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or Veteran status. Different makes us better.

Due to the highly regulated pharmaceutical industry and legal requirements, you may be subject to post employment background checks.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Personal Training - Team Member Development Ma...
Shelby, MI Life Time Fitness
Personal Training - Team Member Development Ma...
Commerce Township, MI Life Time Fitness
Senior J2EE Developer
Dearborn, MI MSX International
Supervisor, Instrumentation Depot and Warehouse
Kalamazoo, MI Thermo Fisher Scientific
Senior Specialty Developer
Taylor, MI MSX International
Data Scientist -Modeling
Dearborn, MI MSX International