Purpose of Job

Responsible for the development of all aspects of the organisations (Samaritan’s Purse and The Billy Graham Evangelistic Association) data strategy to enable us to grow our supporter base and income in the future. The role will lead the strategic transformation of the CRM database to enable the optimisation of our supporter communications.

The Data Manager will be responsible for all aspects of our Raiser’s Edge database, and help us meet our aspiration to develop this into an organisation-wide Customer Relationship Management system for all our supporters, whether donors, volunteers or church contacts.

The post will oversee the collection, import, maintenance and analysis of data, seeking out the most efficient and effective methods of recording, organising and utilising data, that fully supports organisational processes and all future innovation strategies and initiatives.

Alongside this, the Data Manager will lead on data selections, data segmentation, marketing analysis and how insights support business. Ensuring more effective and tailored communication with our donors, supporters and local community.

The post will make sure our processes and procedures for data management and storage are robust and in line with GDPR and other quality standards.

SCOPE OF JOB

• Proactively support campaigns with data segmentation, reporting and data insights, working with relevant colleagues across the organisation.
• Implement and manage projects to improve the use of the CRM database, data cleanliness, and import/export procedures.
• Take the lead in the development, maintenance and smooth running of the organisation's databases and associated applications and systems.
• Plan and manage the financial budget for the organisation's databases and related projects, under the supervision of the IT Manager.
• Manage the performance and cost effectiveness of database suppliers and partners.
• Manage processes to ensure the quality and currency of database records and provide training and support for the activity of database users across the organisation.
• Plan and implement systems and processes to ensure best practice and compliance in regard to data regulations, especially GDPR

Key Skills & Experience

• Proven experience in a Data Manager role including extensive experience of operating multi-user database systems, ideally in a fundraising environment and using the Raisers Edge CRM system.
• Have excellent IT skills with a good working knowledge of Microsoft Excel including the use of pivot tables, plus MS Word.
• Have a good understanding and experience of using MS SQL Server.
• An outstanding communicator and influencer, who can translate technical systems requirements into jargon-free, implementable solutions and user training that maximizes CRM functionality and regulation compliance.
• Proactive, resourceful and energetic.
• Flexible and collaborative in your approach while retaining a clear vision of what you want to achieve.
• You should be curious and up-to-date with global technological developments and affecting factors, particularly around Raiser’s Edge, and understand how to apply this knowledge in your role.

The person appointed will ideally with have:

• Experience of using Raisers Edge CRM.
• Experience of utilising SQL to build queries and reports.
• Experience of donor/customer marketing.
• In-depth understanding of GDPR and other regulatory compliance issues that affect data management and utilisation.
• An understanding of the Gift aid scheme and relevant legislation.

There is a requirement for the job holder to be a practicing Christian as functions within this role will require knowledge and personal experience of the Christian faith.

We are working for a world where LGBT+ young people are fully included in society, with equal access to opportunities, living without fear of prejudice, discrimination and harassment. We are a Cambridgeshire based charity with big ambition and a voice and influence that belies our modest size.  We are seeking an exceptional person to lead the team that takes the vision forward into an exciting future.

This is a great time to join a charity with a strong local and national profile, with exciting plans to expand our services to reach more LGBT+ young people across the county, increase our schools and training services and establish ourselves as the lead LGBT+ charity in the East of England. In 2020, we’ll embark on a new 3 year strategy so we’re looking for an experienced leader to facilitate and realise its development and delivery. 

Our staff team, volunteers and trustees are incredibly passionate about The Kite Trust’s work and leading our organisation will be exciting challenging and rewarding.

Our work is guided by the following values.  We are:

Supportive and Guiding.

We support, encourage and care.

Positive and Inclusive.

We nurture confidence, pride and happiness. We understand and support LGBT+ issues.

We provide opportunities to learn and grow.

Safe and Friendly.

We are trustworthy, professional and confidential. We are open, fun and relaxed.

With a strong history of delivery of services, we now need to focus on continuing our core programmes whilst maintaining and growing our profile. We have a strong business development track record and we need to consolidate and develop this.

The successful candidate will lead and manage a small yet dedicated team of staff and volunteers. As Chief Executive you will provide value based, clear and mission-driven strategic leadership to the charity, ensuring financial sustainability and growth. You’ll also act an ambassador for the charity and champion for young LGBT+ people.

We are looking for someone with proven experience of strategic leadership, empowering staff and volunteers, and growing programmes or services to deliver at scale. We expect you to work closely with the governing Board of Trustees to ensure the effective financial, legal and moral governance of The Kite Trust. You will need to be able to oversee programme delivery and bring the best out of the small dedicated team, delivering the strategic aims of The Kite trust in a creative and inspiring way that will engage others. Although not essential, lived experience of LGBT+ identity would be desirable.

This post is subject to a DBS check. The Kite Trust welcomes applications regardless of sex, gender, race, age, sexuality, belief or disability.

Application Information: Application form and 4-page statement with person specification addressed in detail, with examples please

Closing date for applications: 5pm on Friday 11th October 2019

Interviews: Interviews will be held in Cambridge on Monday 21st October between 10am-3pm. Please expect to join us for a full day of recruitment activities and a chance to meet young people and the team.

Do you want to play a key role in an organisation which stands up for children? Join us as Head of Business Architecture and Analysis and lead our business analysis practise and work with the wider Save the Children movement in developing common systems and services.

In our Support Services department, we fight for children every single day. We provide leadership and direction in the business of running an efficient organisation. We ensure our resources are used to maximum effect. We go the extra mile - and we don’t rest until the work is done.

As Head of Business Architecture and Analysis you will lead a team of analysts and architects, playing a pivotal role in the development of business architecture and design of solutions to meet business needs.  You will lead the business analysis practise in SCUK, driving positive, proactive engagement with the wider organisation. You will support the CIO to establish and lead a Technical Design Authority, as well as reviewing project proposals to assess and advise on the broad alignment with business architecture. In addition you will:

• Engage Application Development and Data teams in the conception, design and evolution of systems
• Work with Technology SLT to develop a framework that nurtures innovation

• Report to the CIO, work alongside our Head of Service Delivery, Head of Engineering, and Head of PMO to form an effective and coherent leadership team for our Technology Department

• Promote innovation, and spot opportunities to apply technology in our organisation, including in our programme delivery for children.

To be successful you will be a fantastic communicator with a proven background in leading, managing and motivating others, and driving change. You will have experience of supporting multiple projects at a time with competing priorities and challenges; a working knowledge of project management methodologies (including Agile experience) and experience of delivering project support through structured activities. In addition you will have:

• Proven track record of encouraging the personal and professional development of the team, alongside the ability to work independently under own initiative and make complex decisions of high impact
• Experience in requirements gathering and analysis, process design and improvement and information assurance and data security
• Experience modelling business processes using a variety of tools and techniques
• Excellent negotiation skills with internal and external parties
• Extensive experience planning and deploying both business and IT initiatives.

At Save the Children we are committed to the safeguarding and protection of children in our work. We will do everything possible to ensure that only those who are suitable to work with children are recruited to work for us. This post is subject to a range of vetting checks including a criminal records disclosure.

If you share our belief in the power of children, join the fight. It takes relentless determination, creativity and a real commitment to real change. Because every child should be able to make their mark on their world, and help to build a better future. We look forward to hearing from you.

To apply please visit our website.

Closing date: 23rd September 2019

ActionAid are recruiting for a Supporter Data Manager to provide expertise on ActionAid’s data and processes and supporter database development.

The Supporter Data Manager will provide day-to-day oversight of our two supporter databases, currently Raiser’s Edge and an in-house developed Oracle database. We have just embarked on a new CRM project to integrate our systems, so the post holder will also have an opportunity to contribute their expertise to this project too.

The Supporter Data Manager is responsible for leading on the maintenance and development of FastStats, in order to ensure that it remains fit for purpose to deliver selections, reporting and analysis.

The post holder will be responsible for promoting and supporting the understanding and appropriate use of ActionAid UK’s supporter data and databases through training, support, documentation and workshops.

The Supporter Data Manager will be committed to our ‘Every Supporter Matters’ ethos and will ensure that all supporters’ needs are given the necessary consideration in each and every communication.

A key focus of this role will be to ensure that all relevant supporter legislation is adhered to, therefore, all applicants must have experience of effectively applying legal and regulatory data requirements.

Line management is a key responsibility within this role, as the post holder will line manager our Supporter Data Specialist, so applicants must have previous, successful line management experience.

In order to succeed within this role, the post holder must have previous experience of large and complex CRM data management, gained within a fundraising context.

If you have this skillset, along with a passion for working within an organisation committed to changing the lives of women and girls living in poverty, please complete an application form.

Please note that this role is being offered as a 12 month Fixed Term Contract.

ActionAid is passionate about supporting flexible working. If you would like to discuss flexible working options, including the possibility of a job share for this role, there will be space to do so during the interview process.

ActionAid is committed to driving improvement through digital channels, tools and ways of working. We will ensure that we provide the technology and the training to enable all staff to perform their roles to the best of their abilities. In return, we ask that all staff are committed to continually improving their digital skills and knowledge within the working environment. Our recruitment processes will evaluate the digital skills of all applicants.  

£31,342 - £33,707 per annum (additional market premium may be applicable for candidates with specific skillsets and extensive experience)

Permanent

Full-time (37.5 hours a week)

Based at Counting House, London Bridge

What the job involves

This is a fantastic opportunity to join our Insight and Experience team at one of the UK’s most progressive and successful charities. Our brief is to support the organisation in raising awareness of prostate cancer and increasing income to fund vital research.

Our aim is to put the individual at the heart of all we do by the delivery and use of data-driven insights. As part of the data team, you will need to understand and challenge data briefs and be responsible for the subsequent data selections; ensuring that data is supplied correctly and on time to your internal clients for marketing or analysis purposes.

You will create queries, exports and reports to support users, as well as document your work by contributing to the projects register, issues log and change control process. Along with other team members, you will be responsible for training new starters across the organisation on how to use Raisers Edge, to record their communications and actions with our supporters and partners.

Where appropriate, you will also support the Data Import Executive in importing data from a variety of different data sources into our database. This will include cleansing, transforming, merging and updating data to ensure its of optimum quality.

What we want from you

You will have proven experience of a similar role and have strong knowledge of Raiser’s Edge user and technical functionality and configuration, to include selections, imports, exports, queries, merges and global changes. You should be an excellent communicator and have excellent time management skills, with the ability to work flexibly, responsively and at speed when required.

You will also have proven experience in manipulating and validating data with strong attention to detail and accuracy, as well as being skilled at running complex queries and selections. You may also have experience with People Stage, FastStats or a similar customer journey tool.

The support we’ll provide

Join our team and you’ll be working at an award-winning charity that will help you learn, develop your skills and expertise, and achieve your highest aspirations. We provide everything you’d expect from a professional organisation – competitive benefits package, contributory pension scheme, life insurance and season ticket loan – but much more besides. Work with us and you’ll see your efforts pay off as we fight for a better future for men.

Closing date: 24 September 2019.

We welcome applications from all sections of the community. Prostate Cancer UK is a registered charity in England and Wales (1005541) and in Scotland (SC039332). Registered company number 2653887.

What the job involves

This is a fantastic opportunity for a hands-on data expert to join our Insight and Experience team. With the brief to support the organisation in raising awareness of prostate cancer and helping raise income to fund vital research into the disease, you will play a key role in delivering our engagement strategy.

Data powers the insight we make decisions by and drives the way we are building long term relationships with all of our different customers – from service users to fundraisers, from campaigners to volunteers. As an organisation, we are adopting a more data driven culture and this role has a big part to play in making that happen.

As a senior member of the team you will be responsible for the management and development of Data Executives, ensuring that the team delivers projects to brief, of high quality and accuracy and to deadline.

You will manage the team responsible for the import, export and quality of our customer data centered around our CRM system and the communication and fundraising tools we use. You will oversee the scheduling of the team, assigning tasks across the team based on capacity and providing support where required. You will be responsible for the quality of the data, working with your team and the rest of the organisation to make sure it is accurate, clean and fit for purpose.

You will own the team’s processes and procedures and will work across the organisation to continually optimise these – collaborating to find new ways of building capacity in the team so they can develop new skills and improve the way data is handled.

You will lead on and ensure that the team have an excellent understanding of data protection and GDPR and be part of a cross organisational group to maintain high standards around this.

What we want from you

We’re looking for a self-motivated, hands on Data Delivery leader, who is passionate about making the importing and selections of data as smooth and efficient as possible. You will have an advanced knowledge of Raisers Edge and not-for-profit data from both a user and technical perspective, including code table management, import, exports and global changes. You will also have strong knowledge of products such as FastStats, import tools, automation tools and team workload management tools.  In addition, you will have an excellent practical working knowledge of data protection and GDPR.

It goes without saying you will have exceptional data manipulation and analytical skills as well as strong organisational, time management and problem-solving abilities. You need to be a strong communicator, confident at communicating complex technical information to a non-technical audience face to face or via documentation and have experience at working with stakeholders at all levels of an organisation. You will be able to map out and optimise a process from start to finish and take people with you as you do. You will be a strong people manager, able to motivate your team, be adaptable, collaborative and work well under pressure in a busy, dynamic team in a fast-paced environment.

Why work for us?

We have a simple ambition – to stop men dying from prostate cancer and we know that ignoring prostate cancer won’t beat it.

Through shifting the science over the next 10 years to focus on radical improvements in diagnosis, treatment, prevention and support, we can make prostate cancer a disease the next generation of men need not fear. Be part of a team that will put an end to prostate cancer being a killer.

The support we’ll provide

Join our team and you’ll be working at an award-winning charity that will help you learn, develop your skills and expertise, and achieve your highest aspirations. We provide everything you’d expect from a professional organisation – competitive benefits package, contributory pension scheme, life insurance and season ticket loan – but much more besides. Work with us and you’ll see your efforts pay off as we fight for a better future for men.

Who we are:

Muslim Aid is a British, faith-based international development organisation that provides support to communities around the world affected by disasters, conflict or endemic poverty without regard to their social, religious, or ethnic background.

What you’ll be doing:

The Supporter Experience team is involved in ensuring the supporter experience is at the heart of everything we. We are aiming to increase the depth and value of supporter relationships whilst encouraging repeat giving or multiple interactions. The purpose of this role is to design and implement first class stewardship plans to ensure our amazing supporters have a great experience with Muslim Aid and care about the cause for many years.

The Supporter team plays a pivotal role in making Muslim Aid more data and insight driven in the way we fundraise and communicate with supporters. The team will take a lead in mapping supporter journeys by using a data driven methodology to ensure we are implementing insights to improve the way we engage with our supporters.

As a confident communicator, you will help develop a culture based on understanding and interpreting supporter behaviours and motivations. Using this information, you will lead on mapping journeys and experiences across communications, campaigns and the fundraising portfolio to maximise a supporter’s lifetime value.

Who we are looking for:

The ideal candidate will be IT literate and proficient using Excel to handle data. You will have significant supporter/customer care experience obtained from the commercial or charity sectors. You will understand the importance of a supporter journey and how to map and track that journey to ensure each step is fully understood and engaged with.

You will have experience of working in a busy environment, prioritising activities appropriately and managing multiple, conflicting priorities. You will also have proven experience of developing internal relationships across a complex organisation – working with internal clients to develop and adapt briefs to improve supporter experience.

Why you should apply:

If you are ambitious and self-motivated, with the ability to work with a high degree of autonomy this role is an exciting opportunity. You will be joining a supportive, highly-skilled, passionate organisation as a specialist in your field.

How to apply:

To apply please submit your cover letter (no more than 1 page) and CV to us. 

Muslim Aid’s recruitment and selection procedures reflect our commitment to the safety and protection of children and vulnerable adults in our care/employment. Successful candidates will be expected to undergo a DBS check (Basic, Standard or Enhanced depending on the role). In addition, all successful candidates for finance roles will undergo an Experian Credit Check.

Who are we?

Recently named Third Sector Charity of the Year 2018, we are a rapidly growing charity seeking to accelerate change for those affected by brain tumours, which kill more children and adults under 40 in the UK than any other cancer. Our five-year strategy is ambitious and sets out plans to double survival from brain tumours and halve the harm they cause to quality of life.

Our exciting job role!

We are looking for a new business professional who can bring insight, momentum and tons of energy to hit the ground running.  You will be joining a small, fun and dedicated team who are passionate about defeating brain tumours!

This role is full time - 37.5 hours and will be based in our Farnborough office, with some out‑of‑hours working.  However, flexible location will be considered for exceptional applications.

What we'd like from you:

It's simple - all you need to succeed in this role is talent, ambition and energy. You must completely embrace our values, offer a great cultural fit, inspire us every day and deliver amazing results in a fast paced environment.

According to the job description you should have a track record in building and securing partnerships.  You should also be an innovative, proactive and driven individual with excellent new business development skills.  If this is for you, we’d love to hear from you!

What we'd like to give you:

- Salary c.£30,000 (dependent on experience)

- 25 days holiday plus bank holidays – pro rata for part-time contracts (we also close at Christmas as a ‘thank you’ for volunteering your time at some of our events throughout the year*) 

- Generous pension contribution*

- Life assurance cover*

- Employee Assistance Programme

- Loads of other great benefits, plus an amazing culture to work in, a great team and lots of fun (and cake!)

How to apply to join our amazing team:

Please apply online attaching your CV and a supporting statement explaining why you want the role, what you would bring to the team and how your skillset and experience will enable us to make a real impact for those affected by brain tumours.

Advert close date: Tuesday, 24th September 2019

First interview date and location: Monday, 16th September OR Tuesday, 17th September 2019 via Skype

Second interview date and location: Tuesday, 24th September 2019 our Farnborough Office

More about us:

Don’t forget to check out our short video (you can find it on our You Tube channel) to find out more about our culture and what it is like to work at The Brain Tumour Charity. 

Did you know we have won a variety of awards for our HeadSmart campaign including the NHS Innovation Award, Third Sector Excellence Awards and Charity Times Awards and have been ranked a top global organisation by renowned management consultants McKinsey?

For more information, please visit our website.

We reserve the right to close the advert early in the event of receiving a sufficient number of applications and may extend the advert if we don't find our perfect team mate!

We process your data in accordance with the Data Protection Act 2018 and the General Data Protection Regulation. For full details, please read our privacy policy for job applicants.

*subject to qualifying criteria

We are looking for an outstanding, values driven and passionate Chief Executive to help realise our vision of a world where everybody with a spinal cord injury can reach their full potential.

In May 2020, we’ll embark on a new five-year strategy so we’re looking for an exceptional leader to play a role in its development and delivery. This is an exciting time to join a growing charity, with ambitious plans to evolve our services to reach more people affected by spinal cord injury.

About Back Up

Back Up is a national charity that inspires people affected by spinal cord injury to get the most out of life. We offer wheelchair skills training, an accredited mentoring service, proactive telephone support, life skills and activity courses, and support returning to work or education. 

What does the role involve?

As Back Up’s CEO, you’ll provide clear and mission-driven strategic leadership to the charity, ensuring financial sustainability and growth. You’ll be responsible for the operational delivery of the strategic plan, as well as staff leadership, management and administration of the organisation. You’ll also act an ambassador for the charity and champion for people affected by spinal cord injury. Our staff team, volunteers and trustees are incredibly passionate about Back Up’s work and leading our organisation will be an exciting, challenging and very rewarding experience.

Who should apply?

The successful candidate will have proven experience of strategic leadership, empowering staff and volunteers, and growing programmes or services to deliver at scale. Critical to your success will be your outstanding interpersonal skills, ability to develop a high performing senior leadership team, ambitious and entrepreneurial approach and fit with our core values and culture.  Although not essential, a lived experience of disability or spinal cord injury would be desirable.

What is the timetable for the recruitment process?

Deadline for applications: 30 September 2019

1st stage interviews with Back Up: w/c 28 October 2019

2nd stage interviews: w/c 11 November 2019

Target to appoint: w/c 29 November 2019

Our client, one of London's leading international exam boards and independent education charities is currently looking to recruit a Business Development Assistant to provide administrative support to the marketing and communications team.

As the organisation's Business Development Assistant, you will provide support to the wider team assisting in the progression and delivery of all marketing campaigns and business development work for the organisation's testing centres. You will have responsibility for diary management, travel arrangements and events management as well as assisting the centres with any marketing materials/collateral requests and movement of resources. You will also ensure the marketing directory is kept up to date along with collating data for a range of key monthly reports.

The successful candidate will have previous professional administration experience in a similar role along with exceptional IT skills. You will have an enthusiastic approach to working with the ability to be proactive and act with initiative. You will also have the confidence to communicate with a variety of people across the board, prioritise competing deadlines and comprehend complex situations quickly together with great communication and organisation skills.

If you are interested in finding out more information about this new opportunity, please register your interest below and submit your CV by clicking 'apply now' below.

Come and join the Carers' Hub team to get involved in an exciting new project and help make a real difference to carers in Lambeth.

Your role

• Promoting the Carers Passport via extensive community outreach and by forging strong partnerships with local stakeholders across health, social care, voluntary sectors and wider community to raise awareness and secure sign-ups from carers to meet project targets

• Supporting the development and maintenance of a package of up-to-date information for carers including signposting information to local services, peer support groups, training, emergency planning and social activities 

• Providing first class customer service to carers throughout the sign-up process and encouraging their involvement in workshops to shape project delivery

• Project administration to support the smooth delivery of the project including collecting and collating data and case studies to support monitoring and evaluation and coordinating meetings 

This will be a high profile, brand new project and as such, you will have the opportunity to put your stamp on it, test out and implement new ideas. 

Background info:

What is a Carers Passport?

The Carers Passport scheme seeks to:

• Raise awareness of carers and their vital contribution in our community 

• Connect carers to local support and information to help their caring role, reduce isolation, combat the financial strain of caring and improve carer health and wellbeing

• Reach carers who are currently coping without access to help and support

Who is the Carers Passport for?

The Carers Passport will be open to unpaid carers living in, or caring for someone in the borough of Lambeth. On registering, carers will receive: 

• A carers discount card providing access to discounts from participating local businesses 

• A package of information to support their caring role,  including signposting to local services, peer support groups, training,  social activities, as well as engagement and co-production opportunities. 

Closing date: Thursday 26th September 

Interview date: Thursday 3rd October

I am delighted to have partnered with a leading housing provider; Silva Homes to assist them in recruiting a new Head of Business Partnering into their finance team.

Silva Homes are a highly successful, ambitious and award-winning association based in Bracknell; they provide services to over 7,500 homes.

This is an exciting opportunity for an ambitious and progressive Head of Business Partnering to play an integral role in Silva Homes ongoing growth/ You will lead the Finance Partnering division and report directly into the Finance Director.

As the new Head of Business Partnering, you will;

• Lead the continuous improvement of the finance function through the design and implementation of strategic delivery projects
• Ensure the finance partners work effectively with rest of the business to deliver the Silva Homes strategic plan
• Co-ordinate the production of monthly management accounts, budgets and annual statutory accounts, including liaising with the external auditors
• Support production of the long-term financial plan
• Co-ordinate the compilation of data for benchmarking and VFM reporting, including identification and measurement of targets
• Lead the continuous improvement of the finance function through the design and implementation of strategic delivery projects

The successful applicant will;

• Have experience of leading and developing teams
• Have experience of preparing financial plans, reports and analysis
• Have experience of reporting to executive level within organisations
• Experience of working in social housing or businesses with one of more similarities (e.g. physical asset-based, property development, property maintenance, regulated, charitable etc)
• Strong digital skills, including experience of specialist finance systems and MS Office
• Have high levels of attention to detail and possess excellent problem-solving skills
• Be CCAB qualified accountant

This is an excellent opportunity to join a prestigious organisation that holds a strong social purpose in an exciting time of development and change.

Finance Business Partner (ref: SUS2748)

£35,388 per annum

37.5 hours per week - based in Edinburgh

As a senior member of Sustrans’ finance team, this role ensures that finance and the way we use and think about our money is front and centre of the transformation agenda for the charity, as we move into a new strategic plan period. This role will also work as part of Sustrans’ senior leadership team in Scotland, leading the financial and accountancy support for the c£60m government-funded Scottish active travel programme.  

Sustrans Business Partners provide a comprehensive professional accountancy and general financial advisory service to leaders, managers and staff within the areas of the organisation for which they are responsible. Finance is brought out of the back office and an active partnership between finance and operations is created. This includes providing 'real time' financial support and analysis, being a trusted adviser, providing information which enables effective decision making and informing the development of strategic and operational plans.

Educated to degree level or equivalent and part-qualified in Chartered accountancy – ICAEW, CIMA, CIPFA, ACCA – you will have substantial experience in a related position and proven experience of providing finance advice and support to budget holders.  You will also have experience of the preparation of budgets and management accounts and in the interpretation of accounts.  You will be accurate, organised and methodical, be able to prioritise your workload to meet deadlines whilst using your excellent communications and interpersonal skills to build effective working relationships.  A knowledge of accounting for charities and a commitment to the promotion of sustainable transport would be an advantage.

Please quote reference number. Closing date for the receipt of completed applications is 9am Monday 23 September 2019.  Interviews will take place in Edinburgh on Wednesday 16 October 2019.

Sustrans is committed to reducing inequality, valuing diversity and enabling inclusion.

 We welcome applications from people with the appropriate skills from all parts of the

community.

Job title: Data and Application Support Analyst

Salary: £35,405 per annum

Location: London, E1

Hours/Contract: Full time 35 hours per week, Permanent

Closing date: 27 September 2019, 5pm

Key Tasks

The role has three main functions: Support; Development & Projects; and Administration.

Support

1. Provide user support for application and their related database systems across the organisation.  Prioritising and responding to user requests to proactively assessing support needs as required and deliver solutions to enquiries.
2. Provide user support to teams in the use of the Licensing system, and provide support cover for the core business applications when required.
3. Ensuring data imports are received and uploaded as necessary.
4. Provide face-to-face customer service to our teams.

Development & Projects

1. Investigate, develop and implement updates/ improvements for in-house application and database systems and Business Intelligence systems.
2. To work with the Data & Information Manager to deliver application and data related projects, participate in the application and data related aspects of projects as required.
3. Work with teams to understand their reporting requirements and translate this into the production of tailored ad-hoc, automated reports using SQL queries, and stored procedures in SSRS & Power BI.
4. To manage and deliver own projects finding appropriate solutions and making recommendations.
5. To ensure existing and change control documents are maintained and updated.

Administration

To have an in-depth understanding of data and information management systems in order to manage:

1. The backup process.
2. Database integrity checks / data reconciliation.
3. Database system capacity & performance monitoring.
4. Supporting teams to ensure accurate data (e.g. data cleansing and reconciliation).
5. The operation of stored procedures and automated reports.
6. The database replication processes via Log Shipping.

General

1. Such other duties as department management may from time to time reasonably require
2. Comply with all in-house and statutory Health & Safety procedures

Person Specification

Education / Training

• MCTS SQL Server 2005 / 2008 or equivalent, or qualified through experience (E)

Experience

• Of working with SQL Server databases, including creating & modifying T-SQL scripts, Stored Procedures & Triggers, and writing ad-hoc queries (E)
• Of Power BI reports and SQL Server Reporting Services (SSRS) (E)
• Of working closely with non-technical staff, demonstrating an ability to translate and 'negotiate' non-technical requirements into a detailed technical specification (E)
• Of setting-up database Log-Shipping processes (E)
• Of writing VB script

Knowledge / Technical Skills

• Of Internet Information Services (IIS) administration (D)
• Good interpersonal, verbal, and written communication skills with a proven ability to explain complex technical ideas and problems clearly to non-experts (E)
• Excellent organisational and time management skills with the ability to manage projects / work streams (E)
• Self-motivated, enthusiastic, and strong problem solving skills (E)
• Logical approach to understanding data structures, processes, and systems with an excellent attention to detail (E)
• Understanding of database design and best practices (E)
• Commitment to Fairtrade and development issues (D)