Microsoft Power BI Consultant (Senior)

*Please note: the service contract for this position will not be concluded with Henkel AG & Co. KGaA but with an external party”.

Project Description

The service is requested as part of the project Sales BI. The project has the purpose to provide reporting on daily sales information based upon SAP COPA and manual flat file data for the business units A / B / L worldwide.

The project is working in an agile methodology. Sprint duration is two weeks. Further assigned changes for smaller project integration requests are running in classical waterfall mode. The expertise of the external Consultant is needed for the changes, as internal expertise is not available.

Concretely, detailed task description without personal reference, which reveals the independency of the service provision

The scope of services includes the following tasks, which are independently performed by the external contractor:

The contractor will work on the subcomponents (Features) “Sales Rep Derviation” and “Actual Payments”

Purpose of “Sales rep derivation” is to correctly assign postings and sales to Henkel’s sales partner based upon complex logic. “Actual Payments” are used by controller community to evaluate if accruals set were high enough to cover actual consumption (mainly in the area of year-end-/off-invoice-discounts to customers)

• Functional and technical consulting of business analysis and facilitate documentation of business requirements that will be validated and approved by Henkel.
• Independently implement the needed business functions (as described in the task above) in the application’s business core layer including the related deployment activities.
• Deployment activities are meaning: Insert the developed code into the entire code on the development environment ("merge") as well as transferring it from the development environment to the test and production system.
• Implement the required functionality (according to the above-mentioned business requirements) in Sales BI tabular model. Basis for the sign-off are the overall Definition of Done ( “documentation done”, “functional test passed”, acceptance criteria refined for each underlying item as well as provided test cases).
• Establish and align data quality KPIs for the subcomponents (features) as mentioned above according to the business requirements (mentioned above)
• Perform functional unit testing; in case of business requirements (mentioned above) are not working, fix to be applied, starting at point 1 again.
• Conduct guiding of user testing (business acceptance testing), referring documentation mentioned below, by introducing the new subcomponents.
• Functional consulting of documentation of business logics and procedures that will be validated and approved by Henkel.
• Handover of implementation to internal and external maintenance organizations according to above mentioned documentation.

Used tool stack: Azure Cloud services, team foundation server (Azure Dev Ops), Microsoft Azure DWH, Microsoft Azure Analysis services tabular model

Possible timelines to be kept:

The following timelines are to be adhered to by the contractor during the performance of the service:

All activities are part of the overall application roadmap. The functional component have to be ready to use end of December 2020.