Data Selections Analyst

An amazing opportunity has just arisen for an experienced Data Selections Analyst to join an award winning children’s charity based in Stratford, London. You will be providing data manipulation to produce effective and accurate selection and segmentation of supporter data for fundraising appeals. The Data Selections Analyst will receive excellent training on FastStats, SQL coding and data modelling techniques to allow them to really progress their career. 

This is a great opportunity for an experienced Data Selections Analyst who wants to move into a role where you will progress your skills further within analysis, learn statistical analysis and data modelling. You will be joining this charity at an exciting time as they have great plans for the future and are in the process of implementing new systems such as Tableau. Working for this exciting charity you will get to utilise their flexi working policy and work from home twice a week.

Skills required for the Data Selections Analyst are:

• Experience of building Data Selections and marketing segmentations
• Strong skills working within a CRM (any CRM is fine)
• Ability to pick up new skills quickly (SQL, FastStats, Data modelling)

Data Selections Analyst / Marketing Segmentation / Insight / FastStats / SQL / Tableau

Location: Stratford, London 

Salary: £35,000 - £40,000 + Excellent benefits

Apply now for immediate consideration regarding this excellent opportunity!

Understanding Recruitment is acting as an employment agency for this vacancy.

Contract Type: Fixed Term (2 years)

Hours: Full time, 35 hours a week

Closing Date: 23:59 on Tuesday 4th February 2020

Are you an experienced data analyst, excited to use data to understand issues affecting social disadvantage and solutions for creating positive social change? Are you motivated by using data to explore organisational effectiveness, inform strategic planning and guide operational decision making? Do you have creative flare for telling stories with data and producing captivating insights for a range of audiences?

The Prince’s Trust is seeking a Data Analyst who will illuminate the stories behind our wealth of management information to produce in depth insights about the young people we support, the work we do and the positive change that result. Alongside external horizon scanning and assessing operational effectiveness, the insight portfolio will provide a constant picture of the ever-changing needs young people in the UK face; informing the direction and guiding the effectiveness of our response.

To learn more about the role please visit our website.

The Prince’s Trust are a youth charity whose mission is to help young people transform their lives by developing the confidence and skills, to live, learn and earn. This year we will support more than 70,000 young people through a range of proven programmes, with three in four achieving a positive outcome!

We have a bold ambition to extend the reach and impact of our work and help one million more young people transform their lives over the next ten years.  Our job is to inspire them, support them and release their potential, so that they can thrive and society can prosper.  We will focus on innovation, to ensure we adapt and remain relevant in a rapidly changing world.  We owe it to ourselves and the young people we serve, to do the best work of our lives and to help give them an increasing stake in our economy and society. They are the key to a positive and prosperous future for all of us.

Indicative salary £24,350 to £27,050 dependent on experience.

The Prince's Trust is committed to safeguarding and promoting the welfare of children and young people and expects all staff and volunteers to share this commitment.

We are committed to equality and believe in building a diverse organisation that is representative of and responsive to the needs of our young people and stakeholders.

A NOTE FOR RECRUITMENT AGENCIES:

We prefer to hire people directly, but we do have a preferred supplier list for when we need a helping hand. We'll be in touch directly if we need you!

As a Business Systems Analyst within our team, you will help Stewardship move forward with products and support the staff using those products by delivering a logical, reasoned, effective service.You will be expected to be part of a team who pray together and seek to define systems which help to deliver our missional goals.

Main responsibilities

Product Specialist:

• Understand how the functionality of our core giving platform is built and used
• Support the staff using those systems with expert knowledge of those systems
• Guide the direction of new functionality for those systems with the project management team

Write specifications for new system functionality based on business requirements and fitting in with an Agile methodology:

• Write specifications for new features in our bespoke software working with our product team to agree fit with user experience designs and our system development agency to align with the development process
• Read and feedback on specifications for new features in our bespoke software

Test new product releases:

• Test each sprint prior to a full release to minimise bugs within the software
• Remaining bugs and errors are identified as part of the test process
• Ensure no major bugs are identified when the software released within Stewardship or to external clients
• Where minor bugs arise, develop and communicate suitable workarounds for the appropriate users

Support the Giving Services, Philanthropy Services, Deposits and Finance teams:

• Provide advice and guidance to enable system users to address problems
• When issues arise deal quickly and effectively with them in conjunction with the IT team

Design, create and maintain system communications to givers and recipients:

• Create and update communications including attachments and statements in StreamServe quickly and without error, meeting business objectives
• Ensure Giving Services and clients understand the communications generated
• Ensure processes are replicable and reliable

Specify, design and develop reports, using SQL, within products and to support the business:

• Occasionally create new reports, ensuring the results are technically accurate
• Ensure any changes are made effectively and communicated internally and where appropriate, to end users
• Occasionally produce reports to meet user expectations and business requirements quickly and effectively

Undertake ad hoc analysis, using SQL, to provide insight and understanding:

• Occasionally respond to internal and external requests for data analysis to meet business needs
• New tools and applications are learnt and skills acquired to increase capability

Data Architect

An exciting opportunity has arisen for two Senior Data Architects to join our clients Knowledge Data Architecture team to help lead the development of CRM and Information Governance programs from their Fundraising customer database systems that help maximise the value of customer data.

These roles can be based in either London or Peterborough.

Data Architect Responsibilities:

The successful candidate will be required to undertake maintenance administration and development activities within the appropriate stages of the project life-cycle. They will be responsible for capturing and analysing organisational and operational processes plus data and information requirements for Fundraising CRM system and business change projects with the aim to improve organisational efficiency and customer experience. In addition, they will be responsible for identifying improvements in efficiency and opportunities for automation in order to identify cost-savings.

Data Architect Requirements:

Candidates should have proven track record of data project activity as well as a good working knowledge of data manipulation tools like SQL and Excel. Strong planning and organising and problem solving skills are also essential for this role, as well as the ability to develop effective and supportive relationships with colleagues at all levels of the organisation.

About Our Client:

They're here for everyone affected by sight loss. Working for them means working for one of the UK’s biggest charities, supporting almost two million people living with sight loss in the UK.

Our client is committed to being led by their customers (blind and partially sighted people), and one of the ways they do this is through active involvement and engagement in many of our work activities, including the recruitment of new members of staff.

Please be aware that blind and partially sighted volunteers may be involved in the recruitment and selection process for this vacancy; including reviewing job applications and CV’s, shortlisting and interviews and selection tests.

Our client is committed to being an Equal Opportunities organisation and we welcome applications from people with sight loss.

Location: London or Peterborough

Job type: Full Time, Permanent, 36 hours per week

Salary: £33,000 to £45,000 (including London Weighting)

Benefits: In exchange we offer a competitive salary, a stimulating and supportive working environment and a benefits package including: 26 days holiday per year (plus bank holidays), which increase with service. Excellent pension schemes.

You may have experience of the following: Data Architect, Lead Data Analyst, Senior Data Analyst, Solution Architect, Information Architect, Data Engineer, BI Developer, BI Lead, Data Modeller, Data Analyst, Data Specialist, BI Consultant, etc.

Ref: 91112

Cause: Health

Role: Data Selections Officer

Location: Farringdon

Employment Type: 3 Months to start ASAP

Salary/rate: £30,000 pro rata

Working hours: 35 Hours a week

Ref: J73041

Short description of role:

Our client, a Health Charity are looking for a Data Selections Officer to start ASAP for 3 months. The role is busy with clear deadlines. Our client are looking for someone who will work with colleagues to understand their requirements and be able to problem solve and deliver high quality data selections and analysis as requested. You must have experience of using SQL to produce data selections queries and reports. ideally you will have 2 years' experience working with Data Selections and you must have experience working with CRM systems. You must also have an understanding of GDPR and data protection protocols.

Main responsibilities

Work closely with the Senior Database Officer to manage the data selections calendar

Ensure adequate resource is allocated to support the charity's reporting and selection requirements

Create and document SQL scripts for data selections, including views and stored procedures

Identify areas for selection process improvement and support the wider team to deliver high quality selections

Build imports and exports from scratch and compile mailing lists to assist in targeted supporter activities

Develop the database team's reporting and analysis capacity

Deliver analysis and reporting as requested and work with colleagues to ensure they are asking the right questions and that they are getting the most from the analysis they have requested

If you are interested in applying, please email your CV quoting the reference number in the subject line.

If you know someone who is interested in this role please ask them to contact me directly. Please make sure they mention your referral, as we reward recommendations with a if we find them a permanent job.

We look forward to hearing from you.

Paul Hamlyn Foundation (PHF) is one of the largest independent grant-making organisations in the UK. PHF helps people overcome disadvantage and lack of opportunity, so that they can realise their potential and enjoy fulfilling and creative lives. They have a particular interest in supporting young people and a strong belief in the importance of the arts.

We are currently looking to appoint a new position into the organisation of Business Analyst to overview the grants systems and processes to ensure that they are designed and delivered in the best manner to support our grant-making.This post will be a blend of technical experience, people skills and leadership on continuous improvement. This role will be pivotal in making sure grant-making systems are fit for the organisation and staff and will play a main part in introducing new systems.

This essential role will work closely with the COO, in the planning and implementation of the Foundation's system and process design for grant-making and in the selection of a new CRM database. As this role will be working with very closely with a range of stakeholders in the organisation, you need to be able to work with colleagues to support the implementation of systems and processes and deal with any technical queries that might arise.

The successful candidate will be an approachable and engaged Business Analyst with previous experience of working to develop business processes and technical systems.You will have experience with system administration of a database and the ability to be able to pick up new systems with ease. It is essential that this person is a high level communicator with the ability to engage with a range of non-technical stakeholders and deliver workshops and training sessions. The ideal candidate will have experience of designing and managing systems and processes, running workshops and training sessions and the ability to lead in a collaborative manner.Just as important as your high-level technical skills is your ability to listen and build relationships with non-technical colleagues.

This is an excellent opportunity to join our team and help us better deliver our grants programme.

In your role you will be responsible for the design and/or modification of business processes, producing process metrics to evaluate effectiveness.  You will have discussions with relevant stakeholders and other significant parties in order to understand the problems and the required outcomes. You will be required to gather information, document processes and analyse business needs in order to present the requirements to all required parties. You will then ensure that any relevant technical specifications meet those requirements. This role may also include performance or user acceptance testing.

main responsibilities

• Evaluating and documenting business processes, anticipating requirements, defining process metrics, uncovering areas for improvement, defining solutions, and managing their implementation.
• Ensuring solutions meet business process needs and requirements
• Leading ongoing reviews of business processes
• Liaising with relevant stakeholders; working closely with clients, managers and the release team
• Conducting meetings and presentations to share ideas and findings
• Gathering critical information from meetings with various stakeholders and producing reports
• Performing requirements analysis for allocated projects
• Monitoring deliverables and communicating the results
• Performing user acceptance testing

We are looking for a Data Analysis Manager to join us at Amnesty International UK (AIUK). This role is based in the Data and Insight Team.

About the role

Reporting to the Head of Data and Insight, this role is responsible for managing the Data Analysis Team and providing the analysis, reporting and data selections necessary to support Amnesty International UK’s campaigning, fundraising and communication objectives.  You will work with colleagues throughout the organisation, proactively identifying areas in which the Data Analysis Team can support their work and championing the role of data analysis in driving decision making and informing strategy.

You will oversee the range of analysis projects undertaken by the Data Analysis team, prioritise their workload and ensure analysis projects and data selections are delivered on time and to agreed specifications.  You will manage the development of reports to effectively monitor key performance indicators across the organisation, and the development of forecasting models to inform operational planning and budgeting.

You will ensure the team communicates analytic findings and recommendations to stakeholders in a way that is engaging and leads to recommendations being actioned. You will provide leadership, direction and guidance to enable the team to fulfil its potential, developing their technical skills and encouraging cross-team working and innovation.

About you

You will have experience managing teams or individuals responsible for delivering data analysis and the ability to motivate them to achieve shared objectives. You will have substantive experience of undertaking analysis and reporting of direct marketing campaigns, as well as statistical analysis within a marketing environment. Experience with relational databases, digital marketing platforms and a range of data analysis tools and techniques is a must.

You will be able to think strategically about the role of data analysis and lead on the implementation of data analysis projects. You will be highly numerate with excellent communication skills, enabling you to translate statistical or technical findings in an easy-to-understand manner to stakeholders in the organisation. You will have experience with data visualisation tools, such as Power BI. You will be an advanced user of MS SQL and MS Excel and have considerable experience with statistical/data analysis tools such as R, Python or similar.  You will have a strong understanding of Data Protection legislation, Equal Opportunities, and a commitment to the aims and objectives of Amnesty International UK.

For full details of the role, please see the job description below.

About us

Our aim is simple: an end to human rights abuses. Independent, international and influential, we campaign for justice, fairness, freedom and truth wherever they’re denied.  Already our global network of seven million members and supporters is making a difference in 150 countries.  Whether we’re applying pressure through powerful research or direct lobbying, mass demonstrations or online campaigning, we’re all inspired by hope for a better world.  One where human rights are respected and protected by everyone, everywhere.

Apply for this role

For further details about the role please click the 'apply' button. To apply, please complete an application form by 30 January 2020. Interviews will take place in our Shoreditch office on 10 February 2020.

Amnesty International values diversity and welcomes applications from all sections of the community. Applications for flexible working will be considered. Please note that to be considered for this role, the successful candidate must be able to provide proof of their eligibility to work in the UK.

The Role

An exciting opportunity for a candidate with charity experience to develop new systems and processes using best of class CRM, automation and email systems.  Within a team of three, the CRM Manager is responsible for supporting more complex system issues, system development and data selections.

About you

You will be a CRM Manager with at least two years' experience in this area, having managed a CRM across multiple functions in a charity.  You'll have excellent organisational and time management skills and have a calm and flexible approach to work in a busy environment.  You'll be a solution focussed problem solver who is happy to work as part of a small team, with the ability to quickly build excellent relationships across all levels.

You will be confident in managing an enterprise platform CRM system and experience of Dynamics 365 would be highly desirable.  You'll be a results driven individual with previous experience of processing direct debits and Gift Aid, as well as data analysis and marketing data selection.  Strong experience of delivering "queries" and "selections" for non-technical users is essential due to the recent implimentation of our CRM system, as is your technology competency level to enable effective management and manipulation of data. 

If this sounds interesting we would love to hear from you.

Key Responsibilities

Technical product ownership for business systems.

• Dynamics 365 :
  • Maintain functionality as business grows and develops, including development of new fields, functions and forms.
  • Translate user requirements to technical specifications.
  • Provide training and user support as needed.
  • Oversee the calendar for marketing selections
  • Oversee the calendar for data cleanse
  • Ensure new users are set up with correct access to perform their role.
• Microsoft Flow (Power Automate) – create and build flows to automate business processes and integrations.
• SQL servers for Dynamics reporting, exporting and storage.
• DotDigital technical lead and support for Digital team automations and marketing lists.
• Supporting integration of business systems i.e. Donation/Direct Debit website pages, Sage 200c, JustGiving, VirginMoney Giving, Realbuzz, Give Panel and Facebook Fundraising.
• Microsoft Admin Portal – maintaining Dynamics licences for new users.
• CRM Portal – Supporting volunteers’ usage and research grant applications, ensuring technical functionality meets requirements.
• Technical contact for M-hance support.
• Power BI – creating business reports across the charity.
• Across all of the above applications, maintain up-to-date knowledge of current-and-upcoming features.

​​​Maintaining and developing the CRM at Crohns & Colitis UK

• Support the Operations Manager to develop business systems that meet business objectives.
• Serve as the escalation point for system issues that the Database Officer cannot resolve.
• Contribute as a senior voice to the governance groups for the CRM, currently including the Data Governance Group and the CRM Power Users’ Group.
• Lead the maintenance and development of the charity’s business applications.
• Lead on ensuring that the chariy’s business systems are appropriately accurate. 
• Use the database to generate analytical and strategic reports across the charity against agreed KPI’s.
• Support the generation of all data needed to deliver external communications activities including direct marketing, membership and volunteering activities. 
• Responsibility for ensuring all database users are using the system correctly and efficiently in accordance with agreed policies and procedures.
• Maintain issues in shared Service Desk system to the team’s agreed service level standards. I.e. all issues are recorded, reported and actioned in a timely manner.
• The post holder will be a technical contact point for business system providers where necessary.  (The Operations Manager is the commercial contact point.)
• Responsibility for identifying and documenting learning opportunities and process improvements.
• Ensure that applications are run in compliance with relevant data protection and information sharing policies, legislation and best practice.
• Identification and recommendation of any training needed to ensure the above is possible.
• Responsible for developing routines and processes to ensure income data is accurately recorded in the accounting system, and for exploring means of simplifying, and ultimately automating this interface.
• Advise on system choice and integration where new software solutions are to be purchased by the charity.
• Planning, executing, testing and documenting larger system changes and upgrades.

CRM Integration

• Work to ensure the integration of all data processes across the charity (e.g. payment portal, Supporter database and finance database) minimising duplication of activity and risk to data integrity and compliance.
• Support, monitor and maintain the existing Business systems, databases and applications. Respond and prioritise support based on support requests and feedback from the various Directorates.

Staff Supervision

• Supervise and provide technical support to the Database Officer and any volunteers that support this team.

EPG is looking for a highly motivated and capable candidate to join its small but growing team. The successful candidate will play a critical role in the conceptualization, design, and management of EPG’s projects alongside locally based team members, including: identifying new opportunities; formulating and overseeing education sector analyses and policy development in countries; developing and managing relationships with government partners; designing and implementing programmes; building in monitoring, feedback, and evaluation mechanisms; preparing and managing budgets; liaising with funding partners; and ensuring effective programme oversight.

you will work directly with governments – mainly Ministries of Education and their development partners – as well as EPG’s locally based team members to design and implementation of policy-related projects to improve the quality of educational services.

The right candidate will find EPG an exciting and entrepreneurial environment and see this role as an opportunity to have a positive impact on improving children’s learning in developing countries. This role is based in Ark’s London office, and includes significant international travel (indicatively 35% time).  

About you:

• Considerable professional experience in international development or international consulting, including experience in leading the design and delivery of policy-related projects.
• A track record in project management and stakeholder management in low- or middle-income countries;
• Experience in research and evaluation design and an ability to analyse and interpret data.
• Knowledge and/or experience in the role of non-state actors in the provision of basic services
• Experience working on programmes aimed at strengthening accountability in school systems;
• French language capabilities.
• Formal training in microeconomics.