Business Intelligence Data Analyst Jobs in London, Greater London
Actively Interviewing
This organisation is scheduling interviews as the applications come in. Don’t miss your opportunity, apply now!
About
The Open Society Foundations work to build vibrant and inclusive democracies whose governments are accountable to their people. To achieve this mission, we provide thousands of grants every year to groups and individuals across the globe that work on the issues we focus on—promoting tolerance, transparency, and open debate. We also engage in strategic human rights litigation and impact investing, while incubating new ideas and engaging directly with governments and policymakers through advocacy to advance positive change.
The Role
To help us fulfill our mission, we seek Grants Officers, who will oversee complex strategic grantmaking activity, triage, monitoring and compliance, and clearance of conflicts of interest, sanctions, and data privacy. They will also support with managing urgent leadership directed grants where necessary.
Key Responsibilities
As Grants Officer, you will report to the Associate Director, Grants Management and be responsible for:
- Contributing to annual planning for US-based entities, forecasting resource allocation needs throughout the year.
- Leading grant closeout procedures, overseeing the collection of overdue reports for all grants funded by US-based entities, conducting FPR, OSI, OSPC processes. Manage the completion of the Grant Closure Project, identifying obstacles to report collection and establishing standard procedures for closing grants, including those for US-based funded programmatic units.
- Coordinating with Finance, Accounting & Compliance teams for audits of Open Society's US-based entities, as well as the preparation of annual tax filings and financial statements.
- Managing departmental budget, retreat/meeting schedules, and professional development opportunities.
- Conducting pre-award/post-award due diligence to ensure grants align with US-based entities' funding requirements and foundation policies.
- Facilitating internal audits for the Grants Management department.
- Collaborating with opportunities/programs colleagues to ensure timely and efficient proposal compliance review, grant award structuring, issuance of grant letters, payments and amendments, and grant closeout reviews.
- Providing comprehensive education and training on grant award compliance, grantmaking processes, Foundation Connect, GrantSmith, and Analytics Studio within the department and to colleagues across Open Society.
- Serving as a resource for Grants Assistants and other Grants Management colleagues, fostering collaboration and knowledge-sharing.
- Assisting in Grants Management processes related to equivalency determination, expenditure responsibility, OFAC compliance, COI compliance, and data privacy.
- Ensuring data integrity in the grantmaking system and provide reporting and analysis.
- Monitoring grant payment schedules and program budgets, ensuring financial efficiency.
- Liaising with Communications, Finance, GARA, Information Technology, the Office of General Council, outside organizations, and/or affinity groups on matters of mutual interest.
- Developing, documenting, revising, and implementing Grants Management policies, procedures, documents, templates, and multimedia materials.
- Representing Grants Management in cross-departmental staff meetings, workshops, retreats, and working groups.
- Supporting internal Grants Management operations and contribute to special projects as needed.
Key Metrics
Processing grants in accordance with the requirements specified by funding entities.
Key internal relationships
- Director, Opportunity Grants Management
- Associate, Policy, Knowledge & Training
- Associate Director, Grants Management, US Accounting
Experience
The ideal candidate must have a University Degree (BA or Bsc) and have the following experience and competencies:
- Extensive career experience within a large and complex non-profit organization.
- Previous working experience in individual grantmaking.
- Deep understanding and vision of how grantmaking aligns with programmatic strategy complemented by effective grantmaking practices.
Functional Competencies:
- Be diligently compliance-driven to ensure organizational adherence to laws and regulations, particularly within grant-making processes.
- Possess strong analytical skills for using data and information to conduct assessments and make well-informed decisions.
- Demonstrate proven project management and organizational capabilities.
Personal Competencies:
- Exhibit excellent communication and interpersonal abilities.
- Display a high level of emotional intelligence, with the ability to build and maintain strong, trusting relationships internally and externally,
- across cultures and geographies, to advance unit objectives.
- Be committed to Open Society’s core values of humility, commitment, collaboration, respect, inclusivity, and integrity.
- Be dedicated to continuous learning and development in areas such as diversity, equity, inclusion, anti-racism, and social justice.
- Listen and collaborate with humility, fostering respectful interactions with all individuals and supporting an inclusive environment that values diverse perspectives.
Languages:
- Possess an excellent command of English.
- Being proficient in additional languages would be an asset.
What we offer:
- Exceptional opportunities to learn and grow, from annual professional development allowances to onsite training and learning conversations with visiting experts.
- Top-notch benefits and perks to promote well-being and a healthy work-life balance. Including generous time off, flexible work arrangements, employer-paid health insurance, retirement savings plan, progressive paid parental leave, reproductive and family planning support, and much more. (Benefits vary by location.)
- A commitment to nurturing a diverse and inclusive workplace so you can bring your whole self to work and make a positive impact.
We aim to build an inclusive workforce that is reflective of the communities we serve, and actively seek applications from those who are marginalized and underrepresented. We provide reasonable accommodations to applicants and colleagues with disabilities.
Competitive rates of pay apply.
Open Society Foundations is committed to advancing diversity, equity and inclusion, and to building a diverse staff that reflects the movements, issues and communities that our mission serves. Candidates from all underrepresented backgrounds, identities and communities are encouraged to apply.
We are committed to providing reasonable accommodations to applicants and colleagues with disabilities.
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: Sunday 31 March 2024, 23:55 *
* Please note that we may close this role earlier than initially 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'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).
Business Intelligence Developer
Position type: Full time, permanent, 37.5 hours per week
Responsible to: IT Business Analysis Manager
Direct reports: None
Location: Truro, Cornwall (hybrid – mixture of office and home working) or remote working (UK only) may be considered (with regular travel to Truro at least 4x per year).
About the Role
As a Business Intelligence (BI) Developer, you will collaborate with our Business Analyst (BA) Manager to design, develop, implement, document, and maintain robust data modelling and reporting solutions. Your role will involve hands-on work, including prototyping solutions, testing ideas, and collaborating with organisational colleagues. Working closely with our Data Manager and Data Technician, you will also contribute to our data warehousing solution and the development of data pipelines and be responsible for data preparation, modelling, and utilising DAX. You will also work closely with our fundraising Insight team, creating analytic solutions to support our fundraising efforts.
Who are we looking for?
We are seeking an individual who is passionate about data and analytics and possesses meticulous attention to detail. You should be driven to produce high-quality solutions. Excellent written and verbal communication skills and the ability to prioritise tasks and efficiently manage multiple responsibilities are essential. Furthermore, you should have experience with the following technologies and a solid understanding of querying, query optimisation, dimensional modelling design, and data visualisation techniques:
- BigQuery
- SQL
- Power BI
- DAX
- Google Analytics
What you will be doing in the role:
- Working with people across the organisation to understand their analytical requirements.
- Developing, testing, and implementing analytical solutions and data visualisations that empower teams to gain valuable insights from their data.
- Taking ownership of new and existing data models.
- Managing the lifecycle of data models and reporting solutions.
- Working with the BA Manager to define best practices and facilitate knowledge sharing for Power BI development, governance, and deployment across the organisation.
- Ensuring that development aligns with the overall BI strategy and adheres to best practices.
- Responding to incidents and change requests related to existing solutions via our AutoTask helpdesk solution.
- Updating and managing tickets appropriately and timely as the Service Desk Manager sets out, ensuring good communication and customer satisfaction.
- Composing technical and team documentation as required.
- Collaborating and demonstrating analytical solutions to the broader team before roll-out.
- Offering input and advice on processes and practices to improve the team's efficiency and effectiveness.
- Assisting with implementing new solutions, as necessary, with the Business Systems Transformation project.
- To undertake any other duties as requested by the IT management team per the scope and responsibilities of the role.
The client requests no contact from agencies or media sales.
Title: Fundraising Data Analyst
Salary: £34,500 to £38,300 per annum plus £3,500 London allowance if applicable
Hours/Contract: 35 hours per week, Fixed term
Based: Embassy Gardens / Hybrid
Closing date: 31st March 2024
Interview date: On a rolling basis
The role of the Data Analyst is a key member of the Fundraising Analysis, Insight & Selections team who supports the Senior Data Analyst with providing analysis and reporting to the Innovation, Income and Engagement Directorate.
Data and Insight is a vital element in guiding decision making across Marie Curie.
A key theme of the Data Analyst role is to:
- Maintain & develop existing reporting
- Maintain & develop existing data processes
- Ad hoc Analysis & Insight Support
- Communicate and interpret insights to fundraising colleagues
- Use visualisations to communicate key findings
Marie Curie Benefits Package:
- Season ticket loan -for travelling to and from work
- Defined contribution schemes for Pension
- Marie Curie Group Personal Pension Scheme
- Loan schemes for bikes; computers and satellite navigation systems
- Introduce a friend scheme
- Help with childcare cost (TC apply)
- Entitled under Marie Curie Blue Light Card
- Entitled to Benefit-Hub Discount Scheme
- Life assurance - for all employees
- Eye care - (under Display Screen Equipment (DSE) regulations, Marie Curie will pay towards sight tests if you use computer screens and other displays as part of your job)
What's in it for you:
- Annual leave allowance:
- England and Wales = 25 days plus 8 public holidays (pro rata)
- Competitive Policy for parental/sick leave
- Continuous Professional Development - (Marie Curie supports and encourages personal and professional development)
- Industry leading training programmes
- Flexible Working
- Free DBS
What we are looking for:
- Previous analytical experience
- Advanced Excel skills
- Previous experience of using Power BI & SQL skills or a demonstratable ability and desire to learn these
- You'll want to improve current processes and want to build on current reports to deliver improved insight to Fundraisers to make decisions on
- You'll have an investigative outlook, so you want to find the reasons why from the data
You'll work with teams across Marie Curie to maintain and develop Power BI reports that allow teams to self-serve. You'll translate requirements into action through these reports and look to continue to develop the insight available. A key part is insight projects to help answer questions on our supporters and develop our understanding. You'll interrogate the data, use your curiosity to understand the reasons why and ensure there are clear recommendations and actionable insights / next steps. You'll use your visualisations skills to help communicate these outputs.
To view the job description please
To apply, please send us your most recent CV and a cover letter detailing your experience, how you meet the person specification and why you would like to work for Marie Curie
Equity, Diversity, Inclusion & Wellbeing
We believe that diversity makes us stronger. Join Marie Curie and be part of an inclusive and equitable workplace where everyone's unique perspectives and experiences are valued. We welcome candidates from all backgrounds and walks of life. Apply today to bring your talents to our diverse and inclusive charity.
This role will be subject to receiving a satisfactory disclosure check.
We reserve the right to close this vacancy early. Agencies need not apply.
About us:
Every day of your life matters - from the first to the last. When you work for Marie Curie, you understand that better than ever. We're a passionate, committed and diverse team of more than 4,400 staff and 12,000 volunteers, here for people living with any terminal illness, and their families. We offer expert care, guidance and support, to help them get the most from the time they have left.
Everyone knows our daffodil, but it's our warmth, creativity and care that touch lives. Here, we take the time to really get to know the people we care for and those who love them. And we do whatever it takes to give them the final days and hours they deserve.
We are working with a wonderful animal welfare charity to recruit their Data Analyst, working in a collaborative team you will take the lead on reporting and analysis across fundraising and communications, using BI and other analysis tools. You will be the first point of contact for all reporting queries, you should have strong SQL and PowerBI experience.
Main duties for the Data Analyst:
Develop and create new BI dashboards for the organisation
Migration of CRM reports into SQL using data warehousing
Stakeholder meetings and management to procure and capture reporting and analysis requirements
Skills required:
Excellent SQL skills
Up to date GDPR knowledge
Strong communication skills
If you would like to have an informal discussion, please call Chloe or email your interest along with your CV to Ashby Jenkins Recruitment.
Ashby Jenkins Recruitment are a specialist charity recruitment agency, we use our extensive sector knowledge and experience to match candidates to the most suitable roles. We take a relationship-led approach to recruitment, working ethically, supporting people to find their perfect role within the not-for-profit sector.
We are passionate about improving equality across the sector, you can read more about our commitment to diversity on our website.
If enough applications are received the charity reserve the right to end the application period sooner.
Full time (flexible working options available)
Closing Date: 31 March 2024
Ref 6680
We're looking for a Technical Project Manager to support our Salesforce CRM Implementation and Data Migration as part of our dedicated CRM Programme team.
This position is for an 8-month Fixed Term Contract in line with the project timelines, with potential to extend.
About us
Save the Children UK believes every child deserves a future. In the UK and around the world, we work every day to give children a healthy start in life, the opportunity to learn and protection from harm. When crisis strikes, and children are most vulnerable, we are always among the first to respond and the last to leave. We ensure children's unique needs are met and their voices are heard. We deliver lasting results for millions of children, including those hardest to reach.
Technology holds the potential to fundamentally transform the way we work. Technology can deepen our engagement with stakeholders and the wider public, it can deliver new programmatic opportunities and strengthen the impact of our existing work. Technology can improve our effectiveness right across the organisation, and enable SCUK to better achieve our strategic goals.
About the role
As Technology Project Manager you will take on a busy and varied role as part of the CRM Programme, project managing the implementation of a new Salesforce platform and data migration, as part of the wider CRM programme.
As part of a team dedicated to the CRM Programme formed of a number of workstreams split across business and technology teams, you will own the full project lifecycle for the Salesforce Implementation and Data Migration projects, owning the time, budget, scope and quality of these projects.
The role will also include working closely with business representatives with solution delivery prioritisation and helping interpret how our Technology strategy is converted into tangible deliverables.
As Technology Project Manager, you will:
- Shape, scope and manage the implementation of the Salesforce Implementation and Data Migration projects from initial framing of the work through to completion
- Ensure that agreed milestones for project delivery are aligned with the overall Programme timelines and met
- Be accountable for the management and motivation of multi-disciplinary resources who will be working with you to ensure optimum project delivery (Business Analysts, Developers, Testers etc)
- Be accountable for managing supplier dependencies and for managing issues and taking corrective action to keep the project(s) on-track
- Be accountable for ensuring that all risks are adequately addressed, and mitigation strategies are put in-place for each risk.
About you
We're looking for a creative problem-solver with the ability to predict challenges and seek to proactively head-off obstacles.
Bringing proven experience working with Salesforce / Data Migration projects, you'll demonstrate the ability to facilitate discussion and drive decisions on appropriate solutions, and be someone who shares knowledge and experience on project management ways of working across the organisation.
You'll demonstrate:
- A strong track record of successfully project managing CRM implementation, preferably Salesforce,and Data Migration projects to time, budget and quality within a technically complex and dynamic environment
- Hands-on experience of managing projects/programmes that include data manipulation, integration, ETL processes and CRM tools
- Good hands-on knowledge of high-level technical architecture
- High level understanding of one of the following: Microsoft Azure, Azure Data Factory, Synapse and Power BI
- Strong track of record of working with supporting infrastructures (e.g. databases, middleware and communications technologies required for web-enabled business applications)
- Practical experience of software development lifecycles and project methodologies (Waterfall, Agile, Prototyping etc.) and associated documentation
- Practical experience of Agile Principles, processes and techniques (iterative development, backlog tracking, burndown charts, task definition, sprint planning, retrospectives and velocity, daily stand-ups, Kanban boards)
- An industry recognised qualification in Project Management or similar technical field.
Please note: To avoid disappointment, you are advised to submit your application as soon as possible as we reserve the right to close the vacancy early if a high volume of applications are received and will be reviewing applications on a rolling basis.
Ways of Working:
The majority of our roles can be performed remotely in the UK, but there are likely to be times when you will be required to come to your contracted office (up to 2-4 days per month or 6-8 days per quarter). This will be agreed with your Line Manager and team and is intended to be time spent on collaborating with colleagues and relationship building.
Please note: travel costs to your contracted office will be at your own expense.
Flexible Working - We are happy to discuss flexible working options at interview.
Commitment to Diversity & Inclusion:
Save the Children UK believes in a world that is fair, inclusive and equitable where all children have the opportunity to change their world. We apply this to our workforce and we are committed to developing and supporting a diverse, equitable, and inclusive organisation where all employees have a sense of belonging and feel that they can be "Free to Be Me". We are not looking for just one type of person - we want to recruit people who can add fresh perspectives, innovative ideas or challenge that disrupts the risk of group think.
We are especially interested in people whose childhood experiences - of life on a low income, of migration, of being in a racialised community, of the care system, of being LGBT+ or in an LGBT+ family or living with (or with someone with) a disability - help us to see things we might otherwise miss. Whatever your story is we want to hear it because we know that different voices, ideas, perspectives and knowledge, working together will enable us to better the lives of children around the world. This is the reason why we are all here.