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
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Σχόλια 0
Συνδεθείτε για να κοινοποιήσετε σχόλιο