BI Developer (CPM Campaign)

Competitive | Leeds | Contract
Posted 2 months ago

I have a fantastic BI Developer opportunity for my Leeds City Centre based client on a 4-6 week Contract on a full time Monday - Friday but have the flexibility to work remotely 3 days per week.

Objective
Create an automated system which combines recent marketing campaign sales results and previous campaign sales performance data to calculate an expected sales increase for each field colleague delivering the campaign. This expected sales impact will then be compared to the actual sales increase to give a performance result for each colleague. This can then be compared to other individuals and for each person across the various campaigns they work on.
The system also needs to incorporate other performance data which comes from a CRM system (salesforce) and field territory manager feedback.
The system need to be sufficiently automated to allow results to be generated and shared on a weekly basis.

Objective can be broken in to 3
• Create a database and queries for retrieval of historical campaign sales data and adding weekly results on going
• Create a process for combining historical results, previous week’s results to produce a sales performance vs expectation. This also then needs to pull in additional colleague performance data to create a result per colleague
• Set up an overall weekly performance dashboard and an individual monthly 1-2-1 document


Outputs required are;
• Contracted Colleague incremental sales target – this is to be sent out prior to the campaign taking place (1-2 weeks) in order to give the colleague a target to work towards
• Weekly contracted colleague total performance dashboard – this is to include results from activity in the previous week and running totals e.g. month-to-date, year date or month-on-month.
• Contracted colleague 1-2-1 documents – delivered monthly, 1 per colleague to be sent to Field managers
• Tactical colleague priority scores – produced quarterly (?)


If this is of interest to yourself or someone you may know, please email over your updated CV to dominic.firth@itqtech.com or alternatively call Dominic direct on 01423 878 672

For more information about this role, please contact:

Dominic Firth

dominic.firth@itqerp.com
01423 878655

See Dominic Firth's jobs
Related Jobs

Java Developer

Competitive | LEEDS | Permanent

Java Developer – Leeds Are you an experienced Developer? Do you have extensive experience with Java? Would you like to join one of the UK’s organically growing Management Consultancies? Well, look...


Blue Prism RPA Developer

£50,000 | Dublin | Permanent

Blue Prism Robotic Process Automation Developer - Permanent - Dublin, Ireland We need an experienced Blue Prism Robotic Process Automation (RPA) Developer to develop and deliver automated business processes through robotic...


.NET Developer

Competitive | Wondelgem | Permanent

Do you want a role in which you can be seen to be helping others? To enrich the lives of those around you? Well… For a new client based in the...