Pipeline Intelligence Analyst @ The Fedcap Group

Mission

To create opportunities for people by designing and delivering innovative, sustainable solutions and creating measurable changes for those who are socially disadvantaged.

Fedcap Employment and Fedcap Employment Scotland delivers employability solutions across the UK to build communities through a blend of local frontline professional teams and like-minded supply chain partners, using innovative and tested ideas developed both locally and internationally.

Our service is designed to give each individual the best opportunity according to his/her abilities and needs. Our programs provide targeted employment supports to a range of underserved groups, including single parents, people who were previously incarcerated and individuals with health, mental health and/or substance use conditions.

Fedcap Employment and Fedcap Employment Scotland joined The Fedcap Group in 2018.

Website:

http://www.fedcapemployment.org/

Job title: Pipeline Intelligence Analyst

Function: Business Development

Reports to: Director of Strategic Intelligence and Pipeline

Company

The Fedcap Group is a mission-led international not-for-profit organization focused on improving economic mobility and quality of life by unlocking opportunities for individuals and communities. Operating across multiple countries and jurisdictions, the Group delivers a diverse portfolio spanning education, health, employability and economic development. We combine global scale and shared capability with strong regional and local leadership, embedding social value, innovation and measurable impact in how we work, partner and deliver.

The Role

Reporting to the Director of Strategic Intelligence and Pipeline, the Pipeline Intelligence Analyst is responsible for maintaining a trusted enterprise pipeline and producing the analysis required to manage growth performance, opportunity priorities and portfolio risk.

The postholder will drive CRM discipline, data quality, reporting and dashboarding, while providing insight on conversion, must-win priorities, recompete exposure, concentration and pipeline risk. The role will turn pipeline data into clear management information that supports governance, financial alignment and action.

Key Accountabilities

• 1. Pipeline Data Quality & CRM Discipline

Maintain a complete, accurate and trusted enterprise pipeline by applying agreed data, stage and governance standards. Work directly with opportunity owners to resolve gaps and ensure records reflect the current position.

• Monitor Salesforce and associated pipeline records for completeness, accuracy, currency and consistency.
• Validate opportunity value, stage, timing, probability, ownership, next steps and supporting evidence.
• Follow up missing or overdue updates with opportunity owners and track resolution of data-quality issues.
• Apply agreed pipeline definitions, entry and exit criteria and mandatory data standards.
• Produce data-quality reports and identify recurring control or adoption issues.
• 2. Pipeline Reporting & Dashboards

Produce clear, reliable management information that gives leaders visibility of pipeline value, maturity, movement and risk. Maintain dashboards and reporting packs that support action and decision-making.

• Prepare regular pipeline dashboards, KPI reports, review packs and executive summaries.
• Report pipeline value by stage, geography, service line, customer, owner and expected decision date.
• Highlight material movements, stalled opportunities, overdue actions and changes in assumptions.
• Maintain consistent reporting logic, definitions and reconciliations across reports.
• Improve reporting efficiency through appropriate dashboarding, automation and standard templates.
• 3. Pipeline Reviews & Governance Support

Coordinate the information and analysis required for effective pipeline governance. Ensure review forums have accurate records, clear actions and timely follow-through.

• Prepare agendas, analysis and opportunity information for pipeline and portfolio reviews.
• Identify records that do not meet qualification, evidence or stage-gate requirements.
• Capture decisions, actions, owners and deadlines arising from governance reviews.
• Monitor agreed actions and escalate unresolved data or process issues to the Director.
• Maintain the governance calendar and supporting documentation.
• 4. Prioritization & Portfolio Analysis

Provide analysis that supports evidence-based opportunity prioritization and must-win management. Help leaders understand pipeline balance, resource implications and alignment with growth strategy.

• Maintain prioritization scores, must-win reporting and portfolio views using agreed criteria.
• Analyze pipeline balance across sectors, commissioners, territories, service lines and maturity stages.
• Identify concentration, diversification and coverage trends within the opportunity portfolio.
• Prepare analytical inputs for resource allocation and investment discussions.
• Track whether priority opportunities continue to meet the evidence required for their status.
• 5. Conversion, Win/Loss & Performance Insight

Track how opportunities progress through the lifecycle and identify where conversion is improving or weakening. Convert performance data into practical insight for governance and continuous improvement.

• Calculate and monitor stage conversion, win rates, pipeline velocity and ageing using agreed definitions.
• Analyse bottlenecks, stalled opportunities and patterns in progression or attrition.
• Support win/loss reviews by preparing data, trends and opportunity histories.
• Compare performance across relevant portfolio dimensions without overstating conclusions.
• Produce concise recommendations and follow-up measures arising from analysis.
• 6. Recompete, Concentration & Pipeline Risk Insight

Maintain visibility of contract expiry, recompete exposure, concentration and other risks that may affect future growth. Provide early warning of coverage gaps and changes that require management action.

• Maintain the recompete and contract-expiry view and reconcile it with the active pipeline.
• Monitor pipeline maturity, probability, timing, dependencies and key risk indicators.
• Analyze exposure by commissioner, funder, contract, market, geography and service line.
• Identify future revenue gaps, weak pipeline coverage and material changes in portfolio risk.
• Support scenario and mitigation analysis with Finance, Growth and Opportunity Management.
• 7. Forecast Reconciliation & Continuous Improvement

Support alignment between pipeline information and financial planning while improving the quality and efficiency of pipeline processes. Provide transparent analysis of differences, assumptions and changes.

• Support regular reconciliation of pipeline assumptions with FP&A forecasts and planning data.
• Maintain clear records of timing, probability and value assumptions used in reporting.
• Investigate material differences between CRM records, governance reports and financial views.
• Support scenario analysis and long-range growth planning with accurate pipeline data.
• Identify and implement improvements to data standards, reports, controls and user guidance.

Person Specification

Experience and Qualifications - Essential

• Experience in business intelligence, sales or growth operations, commercial reporting, CRM analysis or pipeline management.
• Strong data-analysis capability with advanced Microsoft Excel skills.
• Experience maintaining data quality and producing dashboards, KPIs and management information.
• Experience working with CRM systems and applying consistent data definitions or governance controls.
• Ability to identify trends, exceptions and risks and explain them clearly to non-technical stakeholders.
• Strong attention to detail, organization and follow-through.

Desirable

• Experience using Salesforce and Power BI or comparable CRM and visualization tools.
• Experience within business development, growth, commercial or finance function.
• Understanding of opportunity lifecycles, pipeline governance and forecasting.
• Experience supporting portfolio reviews, win/loss analysis or recompete reporting.
• Knowledge of commissioned, procurement-led or regulated markets.

Key Performance Indicators

• Pipeline data completeness, accuracy, currency and governance compliance.
• Accuracy and timeliness of dashboards, KPI reports and review packs.
• Quality of prioritization, conversion, portfolio and risk analysis.
• Visibility and accuracy of recompete, contract-expiry and concentration reporting.
• Reconciliation of pipeline assumptions with FP&A and governance reporting.
• Reduction in unresolved data-quality issues and overdue pipeline actions.
• Stakeholder confidence in pipeline reporting and insight.