Data Warehouse Developer W/ SAP Bw/Hana

Perrigo Company Corporate Allegan , MI 49010

Posted 3 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.

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.
Download the
LiveCareer app and find
your dream job anywhere
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
Data Analyst ETL Developer

Perrigo Company Corporate

Posted 2 weeks ago

VIEW JOBS 11/2/2018 12:00:00 AM 2019-01-31T00: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. The Data Analyst is tasked with working with a range of technologies, process and employees to design, build and manage appropriate development objects relating to ETL and Data Quality using Business Objects Data Services, Information Steward and SAP MDG. Other activities include assisting in the development and maintenance of standards and procedures. * Analyze data requirements, map current systems and formats to logical and physical data models, propose harmonization opportunities, propose standard ways for this information to be communicated between systems and stored within corporate databases, and perform architectural alignment. * This role will be directly in contact with projects, working independently, working in a group setting or day to day support activities. Required Experience: * Extensive working experience with Business Objects Data Services and Information Steward are required. Knowledge or experience with SAP MDG is preferred. * Bachelor's degree - Management Information Systems (or related field), including 5 - 7 years of related experience * Self-starter; works independently; takes advantages of all possible venues for continuous learning * Ability to listen to others and incorporate good ideas regardless of source * Professional in all communication and interaction with others * Willing to admit mistakes and make course corrections quickly * Ability to assess / analyze information needs objectively * Ability to drill down and ask the right questions to arrive at root cause * Ability to navigate difficult conversations, remain objective and achieve sound outcomes * Ability to customize communication for any audience using good written and verbal communication skills * Very strong analytical and problem-solving skills. * Strong written skills are needed to provide proper technical documentation to satisfy all corporate guidelines, and Perrigo cGMP standards. Perrigo Company Corporate Allegan MI

Data Warehouse Developer W/ SAP Bw/Hana

Perrigo Company Corporate