Business Intelligence & Process Analyst

Location: West Kensington, London

Salary: £30,000 to £35,000 per annum

Bonus: Up to £5,000 (subject to achieving targets and objectives)

Contract: Full time, Permanent


This role sits within the Global Sales Operations team whom are responsible for the business systems and reporting for the Kaplan International Languages business.


The BI and Process Analyst is responsible for enabling everyone up to and including the C-Suite to make efficient and effective data driven decisions across our international teams.


Key responsibilities


  • Managing, developing, integrating, automating and maintaining the database that is used for a variety of end points including our BI tool (Tableau)
  • Tableau business visionary, developer, trainer and onboarding
  • Project managing and gathering requirements on new projects that incorporate data driven decision making
  • Quality assurance, user acceptance testing, solution delivery and change management
  • Drive continuous improvement through identifying opportunities and implementation of best practice standards
  • Database management and architecture
  • Query building (MySQL) and data iteration
  • Management, Sales, Customer Care and forecasting reporting
  • Maintenance and development of VBA scripts utilising custom functions and reporting automation
  • Supporting Salesforce data management and configuration


Experience


  • Advanced Excel and Word – custom functions, VBA, pivot tables, formulas, charts and diagrams
  • Database administration – MySQL, maintaining a rational database, query building, data iteration and data accuracy.
  • Gathering end user requirements from all internal stakeholders
  • Creation of management information reporting, including automation


Desired experience


  • PHP scripts
  • Google Sheets and Apps Scipt
  • Tableau creation and administration
  • Workbook
  • Data aggregation
  • Formulas
  • Permission and user management
  • Salesforce experience
  • ETL experience


Application Process:

Please apply with your CV and cover letter.


Closing date:

Friday 20th December 2019


Apply for position now

Data Privacy Statement