Data Analyst/Consultant

£Competitive

Cambridge

Closing Date: 30th June

Role Purpose

This is a technical role, working with the deployment teams as a specialist resource where you will be managing the migration and deployment of customer data. You will also be working with customer stakeholders (e.g. managers) to help them get the most out of that data through use of reporting and dashboard tools.


Responsibilities

  • Helping customers understand their legacy and target data models and recommending actions to assist in effective migration

  • Analysis of customer data and production of data quality reports outlining data quality issues and recommending “quick wins” for fix and highlighting issues.

  • Accurate Data mapping between legacy and new schemas

  • Test and final load of data sets into customer environments in such a way as to give confidence in completeness and accuracy, minimising business impact

  • Working with customers to support them in getting the most out of Salesforce.com and 3rd party reporting and dashboarding tools, feeding back to product teams where data model adjustments would be beneficial

  • Managing your own time whilst working within the project constraints

  • Taking part in project planning exercises and ensuring data concerns are given full consideration


What do you need:

  • A deep interest in, and enjoyment of working with data is essential for this role.

  • A good level of experience using your choice of tooling (MS Excel, MS Access, SQL, Jitterbit, Alteryx, Open Refine, Informatica) to extract, transform and load data between systems.

  • You should expect to be working across several projects simultaneously and be comfortable working to customer deadlines.

  • Ability to quickly adapt to new situations, different business practices and challenges of working in the public sector

  • A proven ability to plan, organise, prioritise, manage and track numerous concurrent activities to successful outcomes

  • Business Intelligence & reporting experience - Both the process of developing and displaying performance indicators and tooling e.g. Tableau, Silk, Qlik or the BI tools within AWS such as QuickSight (desirable)

  • Experience with data modelling - A working knowledge (or beyond) of data modelling techniques would be a distinct advantage. For example being able to interpret, write and (to the right audience) explain an ERD would help you hit the ground running in this role. If you can discuss why Salesforce’s minimum record size of 2Kb gets in the way of proper normalisation you may be overqualified but please get in touch to discuss other roles. (desirable)

 
Kate Warboys