Role title: Business Intelligence Developer / Data Analyst

fantasicgilamonsterΔιαχείριση Δεδομένων

20 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

176 εμφανίσεις

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