Pricing Data Analyst in Dubai for 6 months

Project status
Project start date
1 Oct 2018
Project posted
17 Sep 2018 12:28
Project duration (approx.)
6 Months
Budget (approx.)
US$640 / day
Level of Experience
Food & Beverages
Area of expertise
Data Analytics

Objectives and Key Deliverables

* Please submit your proposal by 18 September.
** This project is in Dubai, UAE. If you are outside of Dubai, all expenses will be covered for relocation and your time there.

One of the leading catering companies in the MENA region, providing specific type of catering and support services to over 130 companies across the globe is looking

A) To develop a Business Intelligence repository to capture price, all cost types & sales volume movements
B) To develop Interim pricing solution for pricing data modelling, pricing process automation supported through central pricing repository

Pricing department of our Company wants to analyze the trend of price, cost (Current, F, FF) & sales volume across continuous period of the past years and going forward, broken down in months at a SKU/BoM level comprising all the relevant details pertaining this specific sector, Loading scale etc.

For this purpose, it is proposed to maintain above information in Business Intelligence database (OLAP), wherein complete breakdown of Sector wise / Product / BOM wise details of Price, Volume, Cost (Current, F, FF) is maintained.

Below is the high-level scope of work
1) To understand the report & dashboard requirements of Pricing Department
2) Document the requirement & get the same approved from Pricing Department
3) Develop system design document & get it signed off from Pricing Department
4) Develop scripts to extract the required data from JD Edwards
5) Develop data marts to store the data in Oracle Business Intelligence repository
6) Develop reports and dashboards as per user requirements
7) Perform unit testing to confirm new developments are as per business requirements
8) Organize User Acceptance Testing to get sign off on the new developments
9) Deploy the new developments to Business Intelligence Production
10) Create repository of historical data of price, cost & sales volume

Currently all of the Ad-Hoc pricing and regular price requisitions are performed outside of the system as a manual activity. The Methodology incorporated is refined and can be easily automated through simple technology solutions. This immensely supports in reduced Turnaround Time, focus on accuracy and Revenue optimization.

High-level scope of work
1) Centralize all pricing related details in to one single repository (Pricing Data Mart)
2) Future proofing on the price determination strategies and providing tracker on all the activities to support the audit and Financial compliances
3) Automation of data analysis currently carried out manually by pricing team to determine new price for items
4) Create models to summarize and consolidate pricing data recorded in multiple tables
5) To arrive at layouts of reports & dashboards from Business Intelligence


To achieve this we require resources with below skill sets for a period of 6 months

- Pricing Data Analyst – with strong analytic capabilities. This is essentially a data analyst/scientist/modeller who understands data, process and flow. And will perform multiple analysis and create models/dashboards in excel to deliver insights and reports


BUDGET: Flexible for the right candidate

Available actions

You must have an account to be able to apply for projects.

Register as a talent

Already have an account? Log in

Looking for a talent?

Post a project and have talent apply

Post a project

About Talmix

Talmix is an online staffing platform, creating connections to business talent faster and across more data points than any other solution.

Connecting clients instantly to permanent, interim or project-based talent, Talmix makes total talent acquisition simple.

  • 50,000+ talent network
  • 150+ countries
  • 100+ sectors covered
Why Talmix >