Business Intelligence Data Analyst Jobs in Bloomsbury, Greater London
POWER BI ANALYST
Salary: £33,000 - £35,000 per annum
Reporting to: Analytics and Reporting Manager (Product and Operations)
Department: Marketing, Fundraising & Engagement
Contract: 12 month fixed-term contract
Hours: Full time 35 hours per week
Location: Stratford, London Office-based with high flexibility (1-2 days per week in the office)
Closing date: Wednesday 8 May 2024, 23:55 *
* Please note that we will be reviewing candidates on an ongoing basis on this role.
At Cancer Research UK, we exist to beat cancer.
We are professionals with purpose, beating cancer every day. But we need to go much further and much faster. That's why we're looking for someone talented, someone innovative and ambitious, someone like you.
The role of Power BI Analyst will help the team provide expert data analytics, reporting and insight. This role will lead their own projects and contribute to the wider team delivery of analysis projects using internal and external data across digital, marketing, supporter, and operational activity to drive the optimisation and innovation of our fundraising activity and increase contribution.
What will I be doing?
Understanding stakeholder business objectives and gather reporting and analysis requirements and document as per the team's governance model.
Leading projects to develop and provide robust, high quality and insightful KPI reports and analysis for each area of the business and ensure that the business has the most up to date and relevant information available as part of a programme of data analysis projects.
Ensuring that reports and insights are communicated to stakeholders in a way that drives impact and influence.
Ensuring delivery adheres to the established business processes and that all necessary documentation and working procedures are always maintained.
Developing the ability to competently use a broad range of reporting and analysis tools across multiple data sources, building a source agnostic approach.
Investigating and reconcile data inconsistencies, ensuring that Analyst & Reporting team produce consistent results and information.
Identifying opportunities and collaborate with other team members to improve the governance of reporting and analysis, generate more efficient processes, and provide a joined-up view of insight.
Building, developing, and managing relationships and share skills and learning with key stakeholders and networks to ensure the work of the department matches needs and builds capability.
What skills will I need?
Relevant experience of reporting and data analysis techniques and statistics gained in an organisation or agency, ideally with complex marketing and comms landscape.
Relevant experience of using Power BI, familiar with creating advanced data models and DAX language, using outputs to make actionable dashboards and insights.
Advanced knowledge of MS Excel (experience in creating macros advantageous but not essential).
Experience of Google Analytics advantageous but not essential.
Experience of leading and delivering projects with proven impact and demonstrating excellent project management and planning skills with ability to prioritise workload.
Strategic skills (including analysis, structured thinking, and logical reasoning) and strong accuracy and numeracy, with good attention to detail.
Evidence of proactive behaviours, and ability to work independently, challenges own performance, invests in own development and finds innovative solutions to problems.
Excellent communication and presentation skills with ability to convey expertise in a way that engages and builds their knowledge.
Ability to build and maintain strong working relationships with others and work as part of a team.
What will I gain?
Each and every one of our employees contributes to our progress and is supporting our work to beat cancer. We think that's impressive.
In return, we make sure you are supported by a generous benefits package, a wide range of career and personal development opportunities and high-quality tools, policies and processes to enable you to do your job well.
Our benefits package includes a substantial retirement plan, a generous and flexible leave allowance, discounts on anything from travel to technology, gym membership, and much more.
We don't forget people have lives outside of work too and so we actively encourage a flexible working culture.
Our work - from funding cutting-edge research to developing public policy - will change the world. It's exciting to be part of our team.
How do I apply?
We operate an anonymised shortlisting process in our commitment to equality, diversity, and inclusion. CVs are required for all applications; but we won't be able to view them until we invite you for an interview. Instead, we ask you to complete the work history section of the online application form for us to be able to assess you quickly, fairly and objectively.
Please note that, Internally, this role is known as Analyst (P2).
DATA ANALYSIS & RESEARCH MANAGER
Salary: £44,000 per annum
Reports to: Senior Cancer Intelligence Manager (Prevent and Epidemiology)
Department: Policy, Information and Communications
Location: Stratford Office, London, w/ high-flex (1 - 2 days per week in the office). We are open to further discussions around flexible working for the successful candidate.
Employment type: Permanent
Working hours: 35 hours per week. (Compressed Hours or part-time 4 days per week available)
Closing date: Sunday 5 May 2024, 23:55*
* Please note that we may close this role earlier than stated, therefore early application is encouraged to avoid disappointment.
At Cancer Research UK, we exist to beat cancer.
We are professionals with purpose, beating cancer every day. But we need to go much further and much faster. That's why we we're looking for someone talented, someone who shares our vision, someone like you.
We are looking for a Data Analysis & Research Manager to join our Cancer Intelligence team. We need you to manage a team of analysts to deliver prevention projects. You'll work with other managers specialising in general epidemiology, early diagnosis, treatment, and cross-cancer pathway work.
What will I be doing?
- Managing projects undertaken by analysts, by liaising with internal teams and other Data Analysis and Research Managers on project need, delivery timelines and outputs
- Being responsible for general line management and pastoral care of prevention Analysts
- Managing prevention projects including resource planning and stakeholder management
- Building strong relationships with other Data Analysis and Research Managers and the Principal Statistician to ensure that projects have the appropriate support
- Contributing to sign-off on general statistics and press enquiries
- Developing a project prioritisation approach which meets the needs of Analysts, other Data and Research Managers across Cancer Intelligence, and other internal teams, and communicating decisions about project prioritisation to stakeholders.
- Managing multiple concurrent projects and being prepared to flex your own and others' workplans to meet business need.
What skills are you looking for?
- Experience of people management and project management
- Ability to manage own workload and hold self and others accountable for delivery of projects and activity
- Excellent problem-solving skills
- Good understanding of best practice analytical techniques
- Previous experience of delivering analytical projects
- Proven track record of building and nurturing highly effective relationships
- Excellent written and verbal communication skills.
What will I gain?
Each and every one of our employees contributes to our progress and is supporting our work to beat cancer. We think that's impressive.
In return, we make sure you are supported by a generous benefits package, a wide range of career and personal development opportunities and high-quality tools, policies and processes to enable you to do your job well.
Our benefits package includes a substantial retirement plan, a generous and flexible leave allowance, discounts on anything from travel to technology, gym membership, and much more.
We review pay annually and aim to recognise individual performance and achievements.
We don't forget people have lives outside of work too and so we actively encourage a flexible working culture.
Our work - from funding cutting-edge research to developing public policy - will change the world. It's exciting to be part of our team.
How do I apply?
We operate an anonymised shortlisting process in our commitment to equality, diversity and inclusion. CVs are required for all applications; but we won't be able to view them until we invite you for an interview. Instead, we ask you to complete the work history section of the online application form for us to be able to assess you quickly, fairly and objectively.
Actively Interviewing
This organisation is scheduling interviews as the applications come in. Don’t miss your opportunity, apply now!
Job Description – Impact Reporting Officer - Food
Reporting to: Network Analyst
Location: London or Sheffield with regular travel
Contract: Permanent
Hours: Full Time, 35 hours
Salary: £26,138-£27,513 (National) or £28,731-£30,243 (London)
We welcome applications from all backgrounds. We are a Disability Confident Employer that welcome disabled applicants and provide reasonable adjustments.
About FareShare
FareShare is the UK’s national network of charitable food redistributors, made up of 18 independent organisations. Together, we take good quality surplus food from right across the food industry and get it to nearly 8,500 frontline charities and community groups.
The food we redistribute is nutritious and good to eat. It reaches charities across the UK, including school breakfast clubs, older people’s lunch clubs, homeless shelters, and community cafes. Every week we provide enough food to create almost a million meals for vulnerable people.
Every year, more than three million tonnes of food go to waste in the UK, enough for 7 billion meals. Meanwhile, the cost of living crisis is driving millions into food insecurity.
We are fortunate to benefit from the support of major retailers, the media, ambassadors and a groundswell of public engagement. As a result, there has never been a more exciting time to join an organisation at the heart of public consciousness.
FareShare’s Strategy & Vision
Vision: We have the vision of a UK where “No good food goes to waste”.
Mission: To use surplus, fit-for-consumption food to feed those who are vulnerable in the UK by supporting front line charitable organisations that tackle the cause and not just the symptoms of food poverty.
Our Purpose: We are doers. We are a community. We change lives.
Our Values:
Passion – for our cause and the challenge that lies ahead
Ambition – to go the extra mile and drive the change that must happen
Respect – for ourselves, each other, our volunteers, our partners and our beneficiaries
Collaboration – it’s only by working with others that we can be stronger
Focus – on providing the best service possible so that we deliver and achieve the most for our clients/customers.
The Role
As FareShare continues to build broad and successful partnerships with key food suppliers across the UK, the Impact Reporting Officer will play a vital role in managing data and effectively demonstrating our impact to the food industry. This position is central to achieving our mission of saving usable surplus food and feeding communities.
This role is a reporting and systems lead, providing administrative and analytical support to the Food Team with a primary focus on consolidating and managing food volume data. Demonstrating to companies the difference their food makes in an informative and engaging way is a key driver of continued support and motivation for the food industry. We seek a fast learner who can engage across various internal systems, including FareShare’s national WMS, Power BI, and our CRM Salesforce.
Working closely with the Food Team, the role will extract and manipulate data from our systems, presenting it meaningfully in reports and updates for our key food partners. Additionally, this role will collaborate with FareShare’s in-house technology department (The Info Centre) to champion and support the maintenance and accuracy of systems used within the Food Team, ensuring account records are up-to-date, and live reporting is both accurate and beneficial to account managers while adhering to GDPR policies.
This role will champion the further embedded usage of our CRM system (Salesforce) to better manage multifaceted relationships with our partners across the food industry. Having a clear and aligned view of the relationships across the industry is central to our ability to achieve our ambitions in partnership excellence. This role will both support the teams in keeping the CRM accurate and work with the Info Centre in suggesting and implementing builds and developments to the CRM that enhance our ability to successfully track and monitor key relationships.
Alongside the ownership of our impact data, this role will also contribute to cross-departmental data analytics projects and support the Marketing team to gather qualitative impact stories. Across both qualitative and quantitative impact data, this role will look to translate all of this into meaningful insights for companies that highlight FareShare’s work and ultimately help to deliver more food for those that need it.
Main areas of responsibility
Impact Reporting
- Design, build and implement impact reporting activities across the Food Team, ensuring consistency, accuracy, and alignment with key partner joint partnership plans
- Develop and implement best practices for impact reporting to effectively communicate the difference made by partners’ food .
- Support the gathering of qualitative impact stories, working collaboratively with charity partners and individuals to compile compelling narratives.
- Bridge the gap between qualitative and quantitative impact data, translating both into meaningful insights that resonate with key stakeholders.
- Develop content that effectively communicates the broader impact of our initiatives to both corporate and charity partners.
Data Analysis and Insights
- Provide comprehensive reports and analyses on food partner volumes, aiding Commercial Manager presentations and reports to food partners, including Tesco reporting requests.
- Utilise analytical skills to extract meaningful insights from various internal systems, contributing to informed decision-making and strategy formulation (including where possible providing data to marketing team and to support commercial decisions across the procurement team).
- Collaborate with Commercial Managers to support data gathering for monthly reporting and quarterly/annual forecasting and targeting.
- Contribute to cross-departmental projects and discussions as the Food Team data lead
CRM System Enhancement
- Champion the embedded usage of the CRM system (Salesforce) to enhance relationship management with partners in the food industry.
- Collaborate with the Info Centre to suggest and implement CRM builds and developments that improve tracking, monitoring, and reporting capabilities.
- Provide hands-on support to the Food Team in improving the effective use of Salesforce, ensuring all team members are proficient in utilising its features.
- Work collaboratively to identify opportunities for CRM optimisation and efficiency gains in managing partner relationships.
- Support in the ongoing assessment of the Partnership Excellence pillar using our CRM
Food Data Accuracy
- Support the maintenance and accuracy of our food volume data across visualisation tools like Power BI, including full ownership of the food team Power BI report.
- Collaborate with the Info Centre to streamline processes related to live reporting, ensuring accuracy and relevance for account managers.
Troubleshooting, System Support and Training
- Work closely with the Food Team to understand how systems, including CRM and Power BI, are utilised for decision-making, strategic planning, and day-to-day operations.
- Offer troubleshooting support, identifying and resolving issues related to system usage and data management.
- Support in the delivery of training on existing systems with the ambition of building a stronger data culture across the Food Team and wider organisation
Person Specification
As an employer committed to Equal Opportunities, we will assess applications in line with these criteria that we consider either as being essential or desirable in this role.
Experience
Essential
- Experience of data analysis to provide insight and overviews on progress against KPIs.
- Working knowledge of CRM systems and business analytics programmes such as SalesForce and Power BI.
- An ability to comprehend and display often complex data in a simplified and engaging way.
- Experience of working cross-functionally within a busy organisation meeting project deadlines.
- Experience of project reporting for internal or external audiences.
Desirable
- Experience working alongside marketing or brand teams building compelling narratives.
- Experience of using CRM or databases to extract data reports to inform decision-making highlighting any trends.
- Knowledge of, and interest in, FareShare’s mission.
- Interest and understanding of the food industry and/or food waste reduction sector.
- Ability to discuss sensitive case studies with charity partners and produce compelling content for reports and publicity.
- Experience in delivering training on technical systems.
Competencies and behaviours
- Good communication skills, written and verbal
- Ability to think creatively and use data to tell compelling stories
- Proficient IT skills, including all Microsoft office packages; specifically an advanced user of Excel with technical skills to analyse data
- Excellent numeracy skills and excellent attention to detail
- Pro-active, organised and able to work under pressure
- Ability to prioritise effectively and cope with competing demands
- Ability to use own initiative working independently and responsibly
Benefits
- Hybrid / Flexible working, with regular UK travel
- 28 days’ annual leave + 8 bank holidays
- Employers pension contribution
- Employee Assistance Program
- Interest free bicycle purchase loan scheme
- Season ticket loan