Data Warehouse Developer W/ SAP Bw/Hana

Perrigo Company Corporate Allegan , MI 49010

Posted 5 months ago

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.

upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
SAP Systems Analyst

Perrigo Company Corporate

Posted 2 days ago

VIEW JOBS 1/15/2019 12:00:00 AM 2019-04-15T00:00 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. Perrigo is looking to add a Systems Analyst to their SAP team located at it's North American Headquarters in Allegan, MI. The Systems Analyst will be accountable for configuring, testing, deploying, and maintaining SAP systems to support business requirements for Product Lifecycle Management (PLM) using Materials Management (MM) SAP module and Bills of Material (BOM) concepts. They will also ensure that appropriate testing and documentation is completed for each project, and provide second tier Service Center support for assigned business groups. Responsibilities: * Working with subject matter experts to gather and document business requirements for assigned projects or system enhancements. * Researching solutions which meet business requirements involving the Business Analyst Manager as needed. Present solutions to the business users to obtain consensus and approval. * Developing solutions in coordination with other IT staff, including programmers, Basis, infrastructure, and project managers. * Spearheading the process of moving a change from development to production. Test and deploy customizations, interfaces or enhancements supporting Materials Managementf. Prepare and maintain change control and validation documentation. * Supporting continued use and maintenance of MM module through ticket management, user instructions and identification of root causes of recurring problems or trends. Knowledge & Experience: * Strong analytical and communication skills, and the ability to translate business processes or concepts into technical requirements are essential. * Good understanding of computer systems validation concepts, change control procedures, and MM module of SAP; and familiarity with configuration and customization standards are required. * Sound understanding of SAP master data elements, data mapping and data conversion is necessary, and the ability to read and interpret process flow documentation and translate this into configuration and customization requirements is also required. * Ability to test programming and interfaces is preferred, and the ability to debug programs is also preferred, but not required. * Must work independently on concurrent projects, and in supporting problem tickets by working with end users, subject matter experts, and Business Analyst Manager to gather requirements, present solutions and participate in the selection of the best solutions. * A Bachelor degree in Business Information Systems, Computer Science, or a relevant business discipline, preferably combined with 1 to 3 years' experience as a SAP Business Analyst, or as a subject matter expert in the MM functional areas of SAP. Experience with Production and Packaging BOMs is preferred. * Fundamental skills in MS Word, MS Excel, Power Point, Visio, and Power BI reporting are preferred, and experience in a regulated environment, particularly FDA, is strongly preferred. Perrigo Company Corporate Allegan MI

Data Warehouse Developer W/ SAP Bw/Hana

Perrigo Company Corporate