Role title: Business Intelligence Developer / Data Analyst

Role title
:


Business Intelligence Developer /
Data Analyst


The Organisation:

Kew Foundation

The Kew Foundation is a
n

ambitious
scientific and
environmental fund raising charity
, supporting the work of RBG Kew. The current
fundraising campaign, entitled B
reathing Planet aims to raise £100 million in the five years to 2015.

Reports to:

IS Manager, Kew Foundation

Role detail:

A detailed
, technical, numeric and analytical
role ensuring
the integrity of
data and
providing a

quality of

analysis and

reporting
in a
dynamic and

multi
-
dimensional
environment
.

Current databases include:

the fundraising database,
ThankQ CRM

(TQ)
,
the accounting
application
Microsoft Dynamics GP 2010

(GP 2010)
,
and

significant other external data interfaces
.

This role provides the op
portunity

for an innovative developer to play a significant role in a world renowned organisation, d
riv
ing

forward
the development and adoption of the Foundation’s BI strategy including sourcing new tools and techniques for information deli
very.

Duties an
d Responsibilities
:



Retrieve data from our in
-
house databases using
internal
or
T
-
SQL

reporting tools
, and turn it into information, especially
form GP 2010 and TQ



Ensuring data
quality
and integrity
across a large and expanding

interactive supporter datab
ase



Providing high quality internal data analysis and management reporting to management using
various

packages,
including
Excel

and
SSRS



Analysing and reviewing m
anagement information and where
appropriate,
with insight into
identified trends and
anomalie
s



Reviewing and further developing the format, delivery and analysis of existing management information reporting



Understanding the multiple sources of business information to enable creation of new
,

and modification of existing
,

reports.



Communicating dir
ectly with internal stakeholders,
(face to face,
email, telephone and at meetings
)

to ensure reporting
requirements delivered

to customer satisfaction



Process efficiency and data import/exp
ort analysis and implementation



Liaison with help desk and technica
l support desks (TQ, GP 2010, Kew IT etc.)



Supporting upgrades and migrations of data systems


Skills and Experience Required


The successful candidate will be able to demonstrate:



C
ompetent in the use of multiple software applications in order to extract
data, analyse it and present the resu
lts with
considered conclusions



Previous data analyst experience

in the commercial or charitable sectors
,

and genuine understanding
of
and enthusiasm
for the power of data analytics



“Can do” attitude, hard working a
nd p
repared to take initiative



Experience of T
-
SQL,

SSRS and SSIS in SQL Server 2008R2 or later



Advanced MS Excel skills

including PowerPivot for Excel 2013 and DAX




Experience of dimensional modelling



Understanding of effective visual communication and visual
isation best practice



Analytical approach to tasks



Excellent organisational
and
communication
skills



Ability to work with
demanding

internal customers and

to interpret
customer

requests


Desirable Skills



Ability to understand

the
bigger picture of the
orga
nisation
, and ideally share some empathy with overall aims and
objectives



SQL Server 2012 (or a willingness to learn)



Experience of developing and supporting ad hoc information delivery solutions



ThankQ CRM
, package specific experience



Microsoft
Dynamics G
reat Plains 2010

package specific experience
, with
Jet Reports



Some financial analysis



Any dba type experience, particularly around
database
performance monitoring and tuning would be beneficial



Data Mining (Ideally using SQL Server)


Salary

C £35k

+ benef
its