Consultant -Data Systems & ETL Development

Description

Project/Consultancy Title: Data Systems & ETL Development ConsultantProject Location: RemoteBackground:
Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, in hardship, in more than 40 countries around the world, we partner to put bold solutions into action — helping people triumph over adversity and build stronger communities from within.
Gaza Sky Geeks is Gaza’s first and only innovation hub and start-up accelerator, run by Mercy Corps. Mercy Corps founded GSG in partnership with Google.org in 2011 with an aim to transform Gaza’s most talented youth into the Middle East’s technology business leaders and to realize Gaza’s potential as a start-up hub. In 2017, Gaza Sky Geeks has grown to include the West Bank
under its wing.

Purpose / Project Description:
Gaza Sky Geeks has multiple components, i.e., individuals, companies, and community. All these components have their own data based on the work they accomplish, and we need help in working on this data with activities such as data cleaning.

Consultant Objectives:
● Extract and translate program log frames and budgets into structured data requirements
● Work closely with a third-party consultant to support the design and implementation of a scalable, integrated database architecture covering all GSG functionalities
● Contribute to discovery sessions, implementation phases, and onboarding to ensure alignment with GSG’s data needs
● Establish a data warehouse and ETL pipelines to support automated and real-time reporting
● Strengthen GSG’s overall data systems to improve analytics, organizational learning, and reporting

Consultant Activities:
The Consultant will:
● Extract data requirements from GSG logframes, budgets, and reporting frameworks
● Conduct comprehensive requirements-gathering sessions with all relevant GSG team members and program leads
● Design a robust database architecture that covers all GSG programs, components, and functionalities
● Develop and document a data warehouse structure to consolidate program, MEL, and operational data
● Create and implement ETL (Extract, Transform, Load) pipelines to support the data warehouse and enable real-time or near real-time data updates
● Ensure data quality, integrity, and consistency across systems
● Build and maintain real-time and automated reports and dashboards to support internal management, partners, and donors
● Work closely with program, MEL, and management teams to identify learning opportunities through advanced data analytics and deep dives
● Support system testing, validation, and refinement based on user feedback

Provide technical documentation, guidance, and knowledge transfer to relevant GSG staff
● Support other related data analysis, system enhancement, and MEL activities as needed
● Provide relevant training, presentations, and manuals as required to the program team to ensure accurate and precise data management protocol
● Support in other related data analysis, quality assurance, and MEL activities as needed

Consultant Deliverables:
The Consultant will:
● A documented extraction of data requirements from GSG logframes and budgets
● A comprehensive database design that supports all GSG programs and functionalities
● A fully defined and documented data warehouse structure
● Functional ETL pipelines to populate and maintain the data warehouse
● Real-time or automated dashboards and reports (e.g., Power BI) reflecting GSG program data
● Technical documentation, including system architecture diagrams and data flow descriptions
● An action plan for future enhancements and sustainability of the GSG data system

Timeframe / Schedule:

Jan 27th, 2026– July 17th, 2026

The Consultant will report to:
Leyan Zahdeh – Tech Unit Officer

The Consultant will work closely with:

Optional – E.g. TSU, Program Desk Officers, Program Manager

GSG Director , GSG Sr.Program Manager , GSG Program Manager, GSG Data and learning Coordinator.

Required Experience & Skills:

● Bachelor's degree in a relevant field such as Data Science, Statistics, Mathematics, Science, or Computer Science

● At least five years of work experience in a relevant field. Experience in MEL or a highly organized role in other fields will be of value

● Proficiency in data management and analysis tools such as Power BI, Microsoft Azure, Microsoft Excel, etc.

●...

Job Description

Title:

Independent Mental Capacity Advocate

Department:  Operations

Reporting to:  Advocacy Manager

 Office Base:  Swansea

This post will be subject to an Enhanced Check, including the Adult / Children
Barred Lists

1

Purpose

1.1

1.2

To  provide  an  Independent  Mental  Capacity  Advocacy  (IMCA)  service
within the ASC area of operation, as required by the Mental Capacity Act
2005.

The  post  holder  will  provide  non-instructed  advocacy  (NIA)  support  to
people who lack capacity and are un-befriended, in relation to decisions
regarding serious medical treatment, long term move of accommodation,
care reviews and adult safeguarding.

1.3

The post holder will also provide the required roles under Deprivation of
Liberty Safeguards (DoLS).

1.4

IMCAs are expected to provide a duty advocacy role as part of a rota

2

Core Competencies

2.1

To achieve the objective of this role the IMCA must place the client at the
centre of all actions and decision making and must display the necessary
competencies, skills and attitudes in their day to day work.

2.2

These competencies include: -

2.2.1

being non-judgemental;

Page 1 of 10

2.2.2

promoting anti-discriminatory practice;

2.2.3

maintaining confidentiality;

2.2.4

promoting empowerment and self-determination;

2.2.5

promoting equal opportunities, equality and diversity;

2.2.6

2.2.7

ensuring that clients are treated with dignity and respect as part
of ethical practice;

Detailed knowledge of the Mental Capacity Act 2005, including
its Code of Practice, and Deprivation of Liberty Safeguards

3  Main Duties and Responsibilities

3.1

Advocacy Tasks

3.1.1

3.1.2

3.1.3

3.1.4

3.1.5

3.1.6

To  undertake  the  statutory  IMCA  role  as  set  out  in  the  Act,
regulations, Code of Practice, Local Engagement Protocols and
any  subsequent  directives.    IMCAs  must  have  regard  to  the
Mental Capacity Act Code of Practice.

To  receive  and  respond  to  referrals as  required  by  the  IMCA
Advocacy  Manager  and  in  accordance  with  Engagement
Protocols and Codes of Practice.

To provide clients with the information they need in order to be
involved  in,  express  their  views  of,  or  complain  about  their
treatment and care.

To enable clients to identify and articulate their wishes, feelings
and needs in relation to services and advocating as necessary.

To liaise, communicate and negotiate effectively with a range
of health and social care personnel and managers to promote
multi-disciplinary working, an awareness of the role of the IMCA
and the rights of patients.

To  provide  a  duty  advocacy  role  on  a  rota  basis.    The  Duty
Advocate responds to general enquiries and will take referrals
for all our services including IMHA, IMCA and Community. The

Page 2 of 10

Duty Advocate is the first line of enquiry for any professional or
client who wants information about their rights, what our service
provides.  It  is  therefore  vital  that  the  duty  advocate  is
knowledgeable  about  all  of  our  services  and  procedures.  To
signpost  and  refer  on  people  for  issues  that  fall  outside  the
scope of the IMCA role.

3.1.7

To work within the Advocacy Code of Practice and the Mental
Capacity Act Code of Practice.

3.2

Awareness Raising

3.2.1

3.2.2

3.2.3

To  promote  the  role  of  advocacy  and  services  that  ASC
provides within a variety of settings.

To liaise with other agencies, identify and implement ways of
enabling  closer  communication  between  clients,  carers,
professionals, statutory and voluntary agencies.

Establish and maintain links with community groups, voluntary
sector  providers  and  social  service  authorities  including  BME
and older persons groups and services.

3.2.4

To actively promote a positive image of ASC.

3.3

Advocacy Support in Cymru Ltd tasks

3.3.1

Following  successful  completion  of  the  probationary  period,
IMCAs  are  expected  to  obtain  the  City  &  Guilds  Diploma  in
Independent  Advocacy,  in  particular  the  IMCA  specialisms,
within  12  months  of  employment  after  probation.    This  is  a
condition of our Service Level Agreement and must be adhered
to.    This  may  involve  some  out  of  hours'  time  commitment.
Failure to achieve this qualification within this period is likely to
result in your employment being terminated.

3.3.2

Monitor services by using the required recording systems and
in accordance with the Data Protection Act.

Page 3 of 10

3.3.3

3.3.4

3.3.5

To  contribute  towards  quarterly  and  annual  Commissioners
Reports.

To  assist  the  Advocacy  Manager  in  the  development  and
implementation  of  the  Business  Plan  and  other  related
documents.

To  complete  all  required  service  documentation  and  general
documentation,
reports,
required by  ASC,  ensuring  that there  are accurate  records  of
work pertaining to the post.

including  comprehensive  case

3.3.6

Meet all required deadlines...

• Our Vision & Story
• Our Vision & Values
• Our Story
• Contact
• Our Community
• Our Community
• Our Grounding
• Our Rule
• Our Strategic Objectives
• Our Leadership
• Our Staff Team
• Vacancies
• Volunteer
• Memberships
• Community Regions
• Scotland
• England & Wales
• Ireland/Mainland Europe
• Iona Global
• United States
• News & Stories
• News
• Key Documents
• Transforming Lives document
• Iona Community flyer
• Strategic Plan 2024-2029
• Consolidated Accounts

VACANCIES

Wish you were working here?

We’re often seeking passionate, dedicated, and talented individuals who share our vision and values. Find out more about our current opportunity.

Iona Resident Post

Abbey Musician

Are you a musician who is seeking to combine your skills, faith and creativity in a unique and beautiful setting? We might just have the job for you.

The Iona Community is seeking a gifted and collaborative Musician to join our Abbey team on the Isle of Iona for the 2026 season. You’ll help shape and coordinate the music and singing for our twice-daily worship in the iconic Iona Abbey. You’ll also help to lead ‘Wee Sing’ sessions for guests from around the world and provide other support for our weekly Abbey guest programme.

Working in collaboration with the Iona Community’s Wild Goose Resource Group, you’ll represent and contribute to the musical culture that the Iona Community is known for across the world.

The Iona Community is an international, ecumenical Christian movement working for peace and justice, the rebuilding of community and the renewal of worship. Living and working on Iona is more than a job; it’s a shared way of life rooted in hope, faith and hospitality.

This post contains an element of regulated work and as such is exempt from the Rehabilitation of Offenders Act and the post-holder will need to be or to become a member of Scotland’s Protection of Vulnerable Groups Scheme.

Key Responsibilities

• Providing high quality musical input to worship services, and guest programme sessions
• Encouraging and enabling guest and staff to participate in the Abbey service.
• Maintain the musical resources
• Ensure compliance with copyright laws, by accurate recording and reporting
• Fully participate in the life of the Iona Community on Iona

Why Join Us?

• Living and working at Iona is not just employment, but a profound commitment to a shared common life that involves work, worship, and recreation.
• The opportunity to help lead and shape worship in the place where St Columba brought Christianity to Scotland.
• Generous holiday allowance — 37 days pro-rata, including public holidays.
• Option to join contributory pension scheme.

Further information

Closing time and date for applications: Sunday 8 February 23:59 (GMT)
Interviews: These will be held during the week commencing 23rd February on Iona or in our Fairfield office in Glasgow.
Start date: 8^th April 2026 (some flexibility on start date).

Find out more and apply using the application documents below.

Volunteer opportunities

We’re also on the look-out for energetic, fun-loving community volunteers. 

Head over to the volunteer page to find out more.

Recovery Coordinator (Lambeth)

• locations
• More Time - The Harbour

• time type
• Full time

• posted on
• Posted Today

• job requisition id
• JR011062

Recovery Coordinator (Lambeth)

Location: The Harbour, LambethWorking Hours: Full-timeContract Type: PermanentSalary: £28,690 - £34,730

Make a real difference in your community

Are you passionate about helping others live safer, healthier and more independent lives?

Join Waythrough, one of the UK’s leading mental health and social support charities, and make a lasting impact every day.

We support over 125,000 people each year through our 200 services, empowering individuals to overcome challenges around mental health, housing, and substance use.

About the Role
We are currently looking to appoint a Recovery Worker to join our dynamic, multi-agency team at The Harbour. This role involves providing holistic, person-centred support to adult service users entering the service and coordinating their treatment journey.

As a Recovery Worker, you will play a key role in assessment, care coordination, delivery of psychosocial structured interventions (PSI), and multi-agency working, supporting individuals to achieve meaningful and sustainable recovery outcomes.

Working under the direction of the Team Leader, you will be an integral part of a collaborative team developing and delivering high-quality drug and alcohol services across Lambeth.

What You’ll Do

• Manage a caseload of service users, regularly reviewing ongoing care and treatment

• Liaise closely with a full range of specialist workers within the multi-agency team, including family members and significant others where appropriate

• Work in partnership and undertake joint key working to support progression from semi-structured to structured psychosocial interventions

• Support service users to access resources and services that increase recovery capital and help them achieve their recovery goals

• Promote family, carer and service user involvement throughout treatment and recovery planning

• Use excellent communication and therapeutic skills when working with service users, carers and partner agencies

• Work collaboratively with internal and external multi-disciplinary teams, providing advice and guidance through meetings, reviews, group supervision and telephone support

• Coordinate individual recovery plans effectively

• Improve outcomes for children of service users by reducing the impact of drug- and alcohol-related harm on family life and promoting positive family involvement in treatment

To Succeed in This Role, You’ll Need to be:

• Passionate about supporting people affected by drug and alcohol use through a recovery-focused, person-centred approach

• Experience working with adults with complex needs and an understanding of substance misuse and psychosocial interventions

• Confident managing a caseload and coordinating care within a multi-agency or multidisciplinary environment

• Strong communication and engagement skills, with the ability to build positive, trusting relationships

• Able to work both independently and collaboratively as part of a team

• Committed to reducing harm and improving outcomes for service users, families and children

• Motivated, adaptable and keen to contribute to a supportive and inclusive team culture

Please note: The salary listed reflects the full earning potential for this role. Starting salaries depend on experience and progression within the band. 

About Waythrough 

Waythrough was formed in 2024 following the merger of Humankind and Richmond Fellowship. Together, we’ve created one of the largest mental health and social support charities in England.

Every year, we support around 125,000 people through nearly 200 services – and it’s all made possible by our 3,500 brilliant staff and volunteers.

Make a real difference in your community 

Are you passionate about helping others live safer, healthier, more independent lives? Join our team at Waythrough and support people facing challenges around mental health, substance use, housing or domestic abuse. This is more than just a job – it’s a chance to build meaningful relationships and create lasting change.

What We Offer

We value the people who make a difference every day. Alongside meaningful work, yo...

Youth Development Lead - Delivery Partnerships (Liverpool)

Contract Type: Fixed Term for 12 months

Hours: Full Time, 35 hours per week

Closing Date: 23:59 on 02/02/2026

Salary: £23,672.00 to £28,783.00 dependent on your skills, knowledge and experience

Location: Liverpool

Interviews: 13th of February in-person in Liverpool

Are you ready to join The King's Trust and step into a vibrant role where you'll build meaningful connections and nurture relationships with our extraordinary external delivery partners and volunteers, all in the pursuit of connecting with the young hearts and minds we're devoted to supporting? If the answer is yes, read on!

Take the lead in welcoming, training, and expertly managing a group of delivery partners and volunteers. Your mission will be to ensure that our young people have an exceptional experience and achieve those positive outcomes that change lives. You will also be kept engaged as you’ll be required to travel within your local area to support the delivery of programmes as well as programme visits.

Assist and support our delivery partners and volunteers in bringing The Trust's programmes to life. They'll rely on you for access to training, resources, qualifications, and guidance in adhering to our top-notch quality standards. You’ll also be our compliance hero, ensuring that our delivery partners and volunteers are up to speed with all the necessary policies that keep things running smoothly. You'll be our go-to person, ready to tackle any minor concerns or issues that come our way.

Your knack for precision will shine through as you meticulously record information and data on young people, volunteers, or partners. It's all about ensuring that each step of their journey is accurately documented in our systems and aligns perfectly with the requirements of our funding contracts and is at the forefront of championing Equality, Diversity, and Inclusion. Your sheer enthusiasm and commitment will ignite some transformative action, sparking real change as we put those local plans into play and excel in achieving our EDI goals!

Do you have the creativity to facilitate best practice sharing, energise networking sessions, and throw sensational end-of-programme parties? Are you ready to step up and lead sessions with young people when the moment calls? Having a background in education or an understanding of the education system could be an advantage when joining some of our teams, it's like having an ace up your sleeve, whether you're familiar with the intricacies of the school year or you've walked in the shoes of a teacher.

If you are a strong communicator with sharp problem-solving skills and can transform ordinary moments into unforgettable events, you could be just the person we are looking for.

Expect the unexpected and embrace it. Come and be a part of our mission!

For the full job description, click here. (This will open in a new window) 

What happens next?  

Please submit a CV, and Cover Letter that includes your experience, transferrable skills and motivation to work for The King's Trust! The Team will be in touch about the next steps shortly after the closing date.

Why do we need Youth Development Leads? 

Last year, we helped more than 40,000 Young People, with every three in four moving into a positive outcome for either work, education or training. Youth Development Leads play a crucial role in supporting young people, no matter the young person's background or current circumstances, to fulfil their full potential. We want to continue having a positive impact on young people’s lives and we couldn’t do this without the important work of Youth Development Leads!

Perks for working at The Trust! 

• Great holiday package!30 days annual leave entitlement, plus bank holidays. Office closure on the days between Christmas and New Year
• Flexible working!Unless the location of the role is remote, the Youth Development Lead role requires a combination of office days and working from home.
• You can volunteer for and/or attend events– The King's Trust Awards, Pride, active events etc.
• In-house learning platform!Develop your skills for your career and your role
• Benefits platform!...

Crisis Recovery Worker - Waking nights

• locations
• Oak House
• Willow House

• time type
• Full time

• posted on
• Posted Today

• job requisition id
• JR011173

Crisis Recovery Worker – Lancashire Oak House

Location: Oak House, 383 Padiham road, Burnley, BB12 0HU

(Work from Willow house also required if staff shortage).

Working Hours: 37 hours per week (shifts will equate to 37 hours per week over the year)Contract Type: PermanentSalary: £24,243 - £28,930 per annum

Please note: The salary listed reflects the full earning potential for this role. Starting salaries depend on experience and progression within the band. 

About Waythrough 

Waythrough was formed in 2024 following the merger of Humankind and Richmond Fellowship. Together, we’ve created one of the largest mental health and social support charities in England.

Every year, we support around 125,000 people through nearly 200 services – and it’s all made possible by our 3,500 brilliant staff and volunteers.

Make a real difference in your community 

Are you passionate about helping others live safer, healthier, more independent lives? Join our team at Waythrough and support people facing challenges around mental health, substance use, housing or domestic abuse. This is more than just a job – it’s a chance to build meaningful relationships and create lasting change.

About the service:

Oak house is a mental health crisis recovery house. We offer support for those in crisis from a range of 3-7 days. We are a five bedroom facility, with 24 hour staffing. Waking night staff shifts are a mix of 9:00pm - 07:00am and 10:30pm - 08:30am.

The people we support are central to everything we do. Each person who uses our services is a unique individual and they all deserve to be treated as such. As such, the responsibilities may vary from day to day.

About the role:

Assist people using our services to:

• Manage and improve their own physical and mental well-being
• Develop life-skills and coping tools to better manage their own mental health, through group and 1:1 interventions.
• Live more fulfilling lives and develop new meanings and purposes
• Take control over their life, through their own choices and decisions

Ensure the safe running of the service:

• Assess resident wellbeing and welfare on an ongoing basis
• Keep our service compliant with legal regulations
• Provide a safe, respectful environment

Keywork:

• Oversee the wellbeing of those in service and complete appropriate sessions.
• Concentrate on the person and their individual needs, choices and aspirations, rather than on diagnostic categories or labels
• Work with individuals to develop agreed, meaningful and achievable person centred plans with positive outcomes that meet the individual’s aspirations
• Complete a range of activities during and around sessions
• Ensure positive risk assessments are created and implemented in line with our policies and procedures
• Signpost people we support to other services for additional support
• Maintain the health and safety of the building
• Support the team with the daily planning and running of our service.

Manage your own workload:

• Plan and carry out your core areas of responsibility
• Complete accurate and timely computerised records via our database
• Liaise with external agencies - such as community mental health teams, multi-disciplinary teams and carers - building relationships and projecting a positive image of the service
• Effectively monitoring and managing your own wellbeing through debriefing and discussions with your manager and colleagues
• Keep up to date with organisational developments

To Succeed in This Role, You’ll Need:

• Ability to communicate effectively at all levels

• Ability to respond compassionately to sensitive and complex issues

• Able to motivate, support and advocate for people using services

• Able to work effectively unsupervised and as part of a team

• Able to keep good and accurate records

• Ability to plan and prioritise workload

• Good interpersonal and listening skills

• Able to keep good and accurate records

• Ability to plan and prioritise workload

• Able to demonstrate a commitment to self-development & training

• Able to demonstrate personal & professional integrity

• Ability to work under pressure