Business Intelligence Analyst

iPeople Solutions Limited
Ilford, Greater London
£33000 - £43000/annum
08 Jul 2017
07 Aug 2017
Contract Type
Full Time
Our client is a British charity based in Ilford (London) to care for vulnerable children and young people. They are looking for a Business Intelligence Analyst in the Income and Innovation department to implement the migration of Fundraising audiences.


SalesForce has been introduced to the client company as the organisation’s strategic Customer Relationship Management database. While the focus of implementation has been on the migration of Fundraising audiences, and embedding SalesForce within existing business processes across Fundraising and Finance, they are now at the stage where the functionality and impact of the system is ready for significant extension.

The Fundraising Business Intelligence team are responsible for ensuring that the organisation has access to the appropriate data and reports required to respond to the Corporate Strategy’s desire to more than double voluntary net income and to become a digitally agile organisation; driven through a rich, single customer view.


The Fundraising Business Intelligence Analyst position is responsible for understanding business requirements and translating these, using a range of platforms including Salesforce, to surface the required data in the most appropriate format.

This ranges from working with our Data Warehouse to overlaid reporting applications, creating reports natively within Salesforce or working directly with Digital Analytics platforms.

The role is responsible for providing data to support analytical and operational requirements in a variety of formats and using varying visualisation and presentation techniques.


* Assist the Fundraising Business Intelligence Manager, and Head of Insight & CRM, with development and maintenance of a range of reporting applications
* Liaise with other teams about their requirements for reporting and add value by correctly interpreting each teams’ requirements and delivering the best solution
* Working and collaborating as a team; sharing best practice, developing each other’s experience and creating a common development framework.
* Working with other team members ensuring data from all channels (including but not limited to digital channels) is captured and collated as appropriate through our Data Warehouse


* Support the Fundraising Intelligence Manager with the development of the Organisation’s reporting strategy, contributing to priorities for development which meet business objectives.
* To manage the delivery of reports created by third parties to the agreed schedule
* To deliver on user requirements for the development of native Salesforce reporting
* To deliver reporting through various reporting applications such as Google Analytics, FastStats, Tableau, SSRS etc as appropriate
* To ensure that any reporting solution or use of data is developed in line with both the charity’s strategic objectives and compliant with existing data policies.
* To provide regular updates to all relevant stakeholders and audiences, including presenting on new reports and working with Learning and Development colleagues to ensure appropriate training and documentation is in place.
* Work in a collaborative manner that shares best practice within the team, develops the skills of the function as a whole and which works to a common development framework.

This Job Description and Person Specification reflect the duties of the post as they exist at this time and may be subject to changed based on the needs of the Department Programme. The post-holder may be required to undertake other duties commensurate with the salary and competence requirements of this post from time to time as required.

Pre-employment checks will be required for the role.



* Educated to degree level in relevant area (or equivalent)
* SalesForce Certification (Adm) (D)
* Highly computer literate and numerate with an excellent working knowledge of SalesForce, Excel and Access
* Working knowledge of SQL or other similar scripting language
* Knowledge of Customer Relationship Management and its practical application


* Experience of using FastStats or similar tool such as Tableau or SSRS (D)
* Extensive experience of creating reports and dashboards in Salesforce
* Relevant experience in a similar post (ideally in a fundraising or marketing environment)
* Significant experience working as part of a multi-disciplinary project team
* Experience working with external agencies and suppliers in an IT environment (D)
* Some experience working with Data Warehouses as part of an analysis and reporting tool set
* Experience of using online tools (such as Google Analytics) to inform and support digital fundraising/marketing activity


* Excellent ability to use business analysis techniques to capture requirements from users
* Excellent planning, administrative and organisational skills.
* Excellent communication skills including both written and verbal presentation and reporting abilities.
* Excellent interpersonal and communication skills with a proven ability to negotiate and influence business application users.
* Team player – ability to work in a collaborative manner to develop self and others.


Planning and Organising
Professional/business initiative
Striving for Excellence
Team working