How does the opportunity to be the Financial Data expert for a modern, growing and successful organisation sound? Do your data manipulation and data presentation skills belong in an organisation that will act upon your output? Do your Advanced Excel, SQL and Power BI skills stand out as your strongest asset?

My client is a property provider in South London that is going from strength to strength and now has the need for the skills of someone who can manipulate Financial Data in such a way to truly benefit and inform the business in a range of areas, most notably relating to an exciting portfolio of development schemes.

As the Data Analyst, you will work closely with other areas of Finance and the wider business in order to extract relevant data and transform it into meaningful management information that be used to inform strategy decisions. Key systems to use include Power BI and Power Query, SQL, and Advanced level Excel skills.

If you're looking for a role in which you will transform complex data into information that directly influences major projects, this could be the role for you! The benefits package is excellent and there is a flexible working location across South London and Kent - if this role is of interest, please apply to find out more.

To be considered, proven experience in the key areas will be essential. You should demonstrate your systems and database skills from within previous roles. For an informal conversation about the role in more detail, please submit your application for review.

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!

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.

This is a home-based role, with the requirement to attend the head office in Buckhurst Hill once every 2 weeks. Travel expenses for this will be covered.

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.

Age UK are looking to recruit a CRM Data Integration Developer to join our development team. We have complex data streams of both Charitable and Commercial data and the successful candidate will be responsible for the development of our data integration framework to accommodate our data demands.

Working with key stakeholders and alongside the CRM Data Architect you will provide technical expertise in analysis, design, development and deployment of Age UK data integration initiatives.

You will develop our framework to effortlessly load our complex data sets into MS Dynamic, Age UK CRM solution, and develop the established Age UK CRM data warehouse - ISaACC. You will build on the single customer solution and support the Age UK CRM team to deliver insightful marketing campaign selections, business intelligent insight and actionable reporting.

The role requires a highly organised individual with established knowledge and experience of Microsoft T-SQL, SQL Server Integration Services (SSIS) and a willingness to embrace other ETL solutions.

About you

* You will have experience in database data management role and significant experience of software specification, development and testing, including profiling SQL queries and performance tuning.
* You should have advanced T-SQL and extensive ETL experience, supported with your knowledge of software development life cycle.
* You'll have demonstrable experience working with relational databases and the use of SQL, Microsoft SQL Server Integration Services (SSIS) is essential.
* Your knowledge of bulk data manipulation and import procedures and a procedural programming language such as VB, C# or Java will be essential

What we offer in return

In return we can offer an excellent salary of £38,000 to £44,000 per annum and great benefits including 26 days annual leave + bank holidays, excellent pension (we pay in up to 9%), Life Assurance, Healthcare Cashback Plan, Season Ticket Loan, Cycle to work scheme, Shopping Discounts, flexible working and much more.

Additional Information

For a full list of benefits please click here https://www.ageuk.org.uk/about-us/jobs/employee-benefits/

Age UK is an Equal Opportunities employer and positively encourages applications from suitably qualified and eligible candidates, regardless of age, sex, race, disability, sexual orientation, gender reassignment, religion or belief, marital/civil partnership status, or pregnancy and maternity. We guarantee an interview to disabled candidates who meet the minimum criteria. We welcome requests for flexible working.

Age UK is committed to safeguarding adults at risk, and children, from abuse and neglect. We expect everyone who works with us to share this commitment.

Early application is encouraged as we will review applications throughout the advertising period and reserve the right to close the advert at any time.

Age UK politely requests no contact from recruitment agencies or media sales. We do not accept speculative CVs from recruitment agencies nor accept the fees associated with them.

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

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.

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

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.