Public Relations Projects

Backlink Building Specialist (Freelance / Performance-Based)

Backlink Building Specialist (Freelance / Performance-Based) — GeoRankers Type: Freelance / Ongoing | Location: Remote About GeoRankers We help B2B SaaS companies understand how AI engines like ChatGPT, Gemini, and Perplexity describe their brand to potential buyers and go beyond a visibility score to verify whether a specific fix actually moved the needle. We're an early-stage, fast-moving startup building our SEO and organic presence from the ground up. What we need We're looking for an experienced link builder to run a monthly, quality-first backlink acquisition process for our website. This is not a bulk link-placement gig, we care about a small number of real, relevant, high-quality links over a large number of throwaway ones. If your pitch involves PBNs, link farms, paid link networks, or guaranteed link counts with no quality context, this isn't the right fit. What you'll be doing Identify and secure backlink opportunities from topically relevant sites: SaaS, B2B marketing, martech, startup/founder publications, and adjacent categories Execute via legitimate channels: guest posting, HARO/journalist-style outreach, resource-page outreach, partnerships, and other white-hat methods Vet every prospective site for Domain Rating/Authority, real organic traffic, and topical relevance before pitching or placing Report monthly on referring domains added, DR/DA of each, anchor text used, and placement context (not just a raw link count) Flag any link opportunity that looks borderline (low-quality directory, suspicious exchange, etc.) rather than placing it by default Pay structure Performance-based, paid monthly against verified referring domains that meet our quality bar: Minimum DR/DA of 25 and topical relevance required for a placement to count Target: 4–6 qualifying referring domains per month. Placements at DR 40+ are weighted 1.5–2x toward this target and we'd rather reward fewer, stronger links than a higher count of borderline ones Links must be live and verifiable at time of payment Links that go dead or are removed within 60 days of placement will be deducted from the following month's count, not clawed back retroactively Open to proposals on rate per qualifying referring domain — please include your typical monthly output and quality benchmarks in your pitch. What we're looking for Demonstrated experience in white-hat link building for SaaS, tech, or B2B companies: portfolio or case studies required Working knowledge of Ahrefs, Moz, or Semrush for prospecting and vetting Clear, honest reporting: we'd rather know the real number than a padded one Understanding of what actually moves rankings vs. what just moves a vanity metric Bonus: experience specifically with early-stage/startup SEO, or in the marketing tech / SaaS tools space To apply Share 2–3 examples of backlinks you've placed for a SaaS or B2B client (site, DR at time of placement, and result if known), and your proposed monthly rate structure.

opportunity

Azure Migration Specialist - Full details in attachment.

## Azure specialist to deliver a UK-sovereign production migration (Container Apps · PostgreSQL Flexible Server · Azure OpenAI) The project We run a multi-tenant ready single-tenant B2B SaaS platform (project delivery / PMO software) used in production by enterprise customers. The stack is a TypeScript modular monolith — Fastify API, React SPA, PostgreSQL 17 — currently hosted on Supabase Cloud, Fly.io, and Vercel. An enterprise customer requires **UK sovereign data hosting**, and we are migrating the platform onto Azure in the UK, with sovereignty technically enforced (region-locked policy, private networking, customer-managed keys) rather than promised on paper. **The design work is done.** You will not be starting from a blank page: there is a complete, independently reviewed document set — a High-Level Design, a code-verified Low-Level Design, and a step-by-step migration plan with exit gates, a cutover runbook, and a rollback model. Your job is to **execute and manage the Azure side of that plan**, challenge it where your experience says it's wrong, and get production cut over safely. ### The target architecture (summary) - **Compute**: Azure Container Apps, internal-only environment in a VNet, four containerised services plus a one-off migration Job; Application Gateway WAF_v2 as the single public entry. - **Data**: Azure Database for PostgreSQL Flexible Server (PG17), PITR, customer-managed keys, geo-redundant backup to a second UK region; Blob Storage with user-delegation SAS. - **Identity & secrets**: managed identities end-to-end (goal: no static credentials anywhere in production), Key Vault, GitHub Actions OIDC federation for CI/CD. - **AI**: Azure OpenAI, UK South, regional Standard deployments only (data residency enforced by policy). - **Email**: Azure Communication Services (SMTP relay). - **Observability**: Azure Monitor / Log Analytics with an alerting path into our existing external paging service; always-on audit baseline (Activity Log, Azure Policy, Defender for Cloud). - **Auth**: the platform's existing open-source auth server (Supabase GoTrue) is re-hosted as a container — sessions and passwords survive the migration by design. You don't need prior GoTrue experience, but you do need to be comfortable running a third-party container against Postgres. Full details in attachment

Need help with shopify website

I’d like to improve the overall user experience, visual quality and premium feel of the website. Rather than rebuilding it, I want to refine what we already have and make it feel more polished, modern and intuitive. This is a premium culture magazine website, so the experience should feel editorial rather than like a typical ecommerce store. It should take inspiration from high-end digital publications and luxury brands, with clean layouts, strong typography and immersive imagery. Every page should encourage visitors to discover content naturally before converting into magazine purchases or memberships. Some key improvements I’d like you to make include: * Review the entire website from a UX perspective and identify any friction or unnecessary clicks. * Improve spacing, alignment, typography and visual hierarchy throughout. * Create a more premium editorial aesthetic with consistent layouts across every page. * Refine the homepage to create a stronger first impression and encourage exploration. * Consider a more engaging hero section, potentially using subtle motion or video if it enhances the experience without affecting performance. * Improve the navigation so content is easier to discover. * Enhance article pages to feel more like a premium online publication, with better readability, imagery and related stories. * Simplify the purchase journey by reducing unnecessary clicks between discovering a magazine and checking out. * Improve calls-to-action so they’re more consistent and visually prominent. * Add subtle animations, hover effects and transitions that elevate the experience without becoming distracting. * Optimise the mobile experience so every page feels intentionally designed for smaller screens. * Improve footer layout and overall page structure. * Optimise loading speed, image quality and SEO best practices. Please also use your own design expertise to suggest and implement further improvements where appropriate. I’m looking for a website that feels premium, modern, editorial and culture-led, with attention paid to every small detail. Please review every page individually—not just the homepage—and focus on creating a seamless, high-end experience throughout.

Junior Product Manager

Summary Key responsibilities Provide day-to-day support to government clients and triage their queries Assist with platform implementations for new clients Run product demonstrations and training sessions (initially with senior support, then independently) Maintain user-facing documentation, guides and training materials Gather user feedback and pass insights to the Senior Product Manager Support coordination between clients and internal delivery teams Help track delivery progress and flag risks or blockers Essential experience & skills Strong written and verbal communication skills Confident, professional manner when dealing with clients Well organised, with an ability to manage your own time and tasks Attention to detail and a methodical approach to documentation Willingness to learn quickly and take ownership of your work Eligibility to live and work in the UK Willingness and ability to obtain clearance (BPSS, SC or higher) Desirable experience Some experience in product, project, delivery or customer success (including internships, placements or graduate schemes) Exposure to SaaS, ICT or public-sector environments Awareness of Agile or Scrum delivery frameworks Experience presenting or training non-technical audiences What we offer An accessible entry point into product management with mentoring from a Senior PM Fully remote working from anywhere in the UK Hourly rate via PAYE £18/hour Initial 6-month contract with a clear path to extension Hands-on experience supporting services used across UK government Confirm your Eligibility to live and work in the UK Confirm your Willingness and ability to obtain clearance (BPSS, SC or higher)

Social Talent Sourcing Expert

We are looking for a Social Talent Sourcing Expert who can help us find and collect potential candidates from social platforms such as Facebook, Instagram, LinkedIn, Twitter/X, Reddit, and other online communities. The main task is to search for people who match our target profile. We will provide the full details of the type of people we need after we contact you. Responsibilities: * Search for relevant people on Facebook, Instagram, LinkedIn, and other social platforms * Find profiles based on job title, skills, industry, location, experience, and online activity * Collect candidate information in a clear format, such as name, profile link, current role, location, and contact info if available * Identify active and real profiles, not fake or low-quality accounts * Use keywords, hashtags, groups, communities, and advanced search methods to find strong leads * Organize all sourced leads in Google Sheets or Excel * Provide regular updates on progress and sourcing results Requirements: * Experience with social media sourcing or talent sourcing * Strong research skills across Facebook, Instagram, LinkedIn, and other platforms * Good understanding of how to find people through keywords, groups, hashtags, and public profiles * Ability to judge whether a profile is relevant and high quality * Good attention to detail * Ability to work independently and follow instructions * Experience with recruiting, lead generation, or online research is a plus Preferred Skills: * LinkedIn Boolean search * Facebook group research * Instagram hashtag and profile research * Contact finding tools * Google Sheets or Excel * Talent sourcing for contractors, freelancers, or niche roles What We Provide: We will provide clear details about the target people we need to find, including industry, skills, location, job titles, and other requirements after initial contact. To Apply: Please share your previous experience with social talent sourcing and mention which platforms you are strongest at using.

Next.js Developer Needed – Headless WordPress (Vercel Deploy)

Development: Full Stack / Frontend 1. Project Description We're looking for an experienced developer to build a modern, fast-loading website using a decoupled (headless) architecture. This is not a traditional WordPress theme build we want a custom-coded frontend that pulls content from WordPress as a backend CMS only. 2. Tech stack requirements: The frontend should be built in Next.js using the App Router, with server-side rendering for performance and SEO. Styling should use Tailwind CSS (utility-first, no separate handwritten stylesheets). Fonts should be optimized using Next.js's built-in font system (self-hosted Google Fonts, no external font requests). Images need to run through Next.js's built-in image optimization so files are automatically resized/compressed on delivery. The site should be deployed on Vercel. Error/performance monitoring should be set up via Sentry so we get visibility into production issues. On the content side, we want WordPress set up purely as a headless CMS on a separate subdomain used only to manage content (text, images, blog posts, pages, etc.) through the WordPress dashboard, with no public-facing WordPress theme or frontend. The Next.js app should fetch this content via the WordPress REST API or WPGraphQL. 3. What we need from you: Please share examples of past projects where you've built a Next.js frontend decoupled from a headless WordPress backend. Let us know your experience with Tailwind CSS, Vercel deployment, and Sentry integration. We'd also like to understand your typical process for structuring content models in WordPress so they map cleanly to a custom frontend. 4. Project scope: Build a CMS-managed marketing website from an existing Figma design a standard brochure/lead-gen site (WordPress or equivalent), fully editable by our team afterward. Pages/templates: Home (hero, packs preview, process steps, gallery preview, testimonials, Instagram feed, CTA); Pack template (reusable, CMS-addable, with pricing, specs, gallery, FAQ); About; Examples (portfolio gallery); Project template (reusable case-study CMS post type, with gallery and related projects); Terms template (reusable for legal pages); Contact (enquiry form + map); Send an Enquiry (consultation booking form + map); site-wide responsive navigation. Requirements: All content editable via CMS, no dev needed. Pack and Project templates must be repeatable CMS entries. Both forms submit to email/CRM. Fully responsive, matching Figma exactly. Out of scope: No custom API/booking integrations, no custom backend. 5. Deliverables Fully responsive site matching the above stack, deployed and live on Vercel, with WordPress CMS configured and documented for our team to manage content independently going forward. 6. Budget To be agreed --- ** We do not accept spam you must quote "I WANT THIS JOB" at the top of the application

opportunity

AI-Powered Deal Origination & Opportunity Intelligence Platform

Overview Build an MVP AI-powered deal origination and opportunity intelligence platform to identify UK private company acquisition, succession, refinancing and distressed opportunities. The platform should analyse public company data, identify high-probability opportunities, enrich decision-maker information, generate AI reports and support targeted outreach. This is an MVP validation project requiring a fast, practical build with scalable foundations, not an enterprise solution. Core Objectives The platform must: • Collect company/director data • Analyse and score opportunities • Identify decision makers • Enrich contacts • Generate AI intelligence reports • Create outreach recommendations • Store opportunities in CRM • Maintain continuously updated pipelines Data Sources Required: • Companies House API • Gazette Insolvency Feed • Company websites • Public web research Preferred: • LinkedIn enrichment • Contact providers • News feeds • Business directories Future: Planning data, Land Registry/property ownership, email automation, workflows, dashboards, additional providers and AI agents. Functional Requirements 1. Company Intelligence Engine Retrieve, store and update: • Company name, number, address and SIC codes • Filing history, accounts and charges/mortgages • Directors and shareholders where available • Insolvency notices and Gazette events • Website and content summaries Maintain structured profiles for each company. 2. Opportunity Scoring Engine Core IP component. Must be configurable, AI-independent and adjustable without code changes. Required: • Weighted and rule-based scoring • Score explanations • Confidence ratings Scores: Acquisition: revenue, EBITDA/profitability, growth, recurring income, sector attractiveness, leverage. Succession: director age, ownership length, ownership concentration, management depth, succession indicators. Refinancing: lender charges, debt profile, leverage, property ownership, maturity indicators. Distress: insolvency notices, winding-up petitions, director resignations, overdue filings, negative trends. Probability of Sale: founder age, ownership duration, succession indicators, growth plateau, market conditions. Example: Sale Score: 86/100 Reasons: • Founder age estimated 67 • Sole shareholder • 24 years ownership • Stable profitability • No succession structure identified AI explains scores; scoring remains framework-driven. 3. Contact Enrichment Identify/store: • Founder, CEO, Managing Director, shareholders • Email, telephone, website, LinkedIn • Decision-maker information Supports future outreach and relationship development. 4. AI Intelligence Briefs Generate for high-ranking opportunities: Company Summary: Business description, financial overview, strengths. Opportunity Summary: Selection rationale, engagement potential, strategic rationale. Engagement Angle: Succession planning, growth capital, partnership, acquisition or refinancing 5. CRM MVP CRM must support: • Opportunity storage • Search/filtering • Notes and comments • Status tracking • Outreach tracking • Score history Workflow: Identified → Qualified → Contacted → Conversation Started → Active → Mandated → Closed 6. Outreach Intelligence Generate/store: • Personalised emails • LinkedIn messages • Telephone briefs No automated sending required AI Architecture Use model-agnostic architecture that remains operational if providers change Support: OpenAI, Anthropic Claude, Google Gemini, Meta Llama, DeepSeek, Qwen and future providers Admin controls: • Select AI provider • Change providers without code changes • Configure API keys • Add models Scoring must remain independent of AI Technology Backend: Python, FastAPI Database: PostgreSQL, Supabase Frontend: React, Next.js Infrastructure: AWS, Vercel, Supabase AI: Provider-agnostic APIs with future agent support Scalability Support future: • Multi-agent workflows • AI orchestration/MCP • Additional APIs • Email and workflow automation • Large-scale analysis • Advanced reporting Future integrations: CRM systems, enrichment providers, email systems, Land Registry, planning/property/commercial intelligence sources Dashboard Provide a simple user-friendly dashboard for non-technical sales/outreach users with navigation, opportunity views, filtering, pipeline management and AI insight access Deliverables • Working MVP • Source code • Deployment instructions • Technical documentation • Configurable scoring engine • CRM • Company intelligence engine • Contact enrichment • AI opportunity reports • Outreach generation • User administration • Large-scale UK company analysis capability Proposal Requirements Include: • Relevant examples • Architecture • Technology stack • Cost estimate • Delivery timeframe • Support options • MVP improvements Budget Open to proposals. Preference for developers experienced in AI intelligence platforms, CRM systems, API integrations and scalable MVP delivery rather than enterprise builds

opportunity

Excel automate, Power Query, data mapping, dashboard development

I am looking for an experienced Excel and Power Query specialist to complete a multi-level governance and assurance system for a health and social care organisation. The organisation has five service divisions. The workbooks, registers and overall structure have already been designed; I am not looking for someone to start again. I need someone who can review the existing files, improve the formulas and functionality, make the registers smarter and create reliable connections across the system. The required reporting flow is: Service/Practice Observation → Regional Governance → Divisional Governance → Group Governance/Master Dashboard Each division requires its own governance workbook and dashboard. Service and regional information must feed into the relevant divisional workbook, with key information from all five divisions feeding into one Group-level Master Dashboard. Smart governance registers The project includes a suite of existing registers covering areas such as: Risk Safeguarding Incidents and serious incidents Complaints and compliments GDPR and data breaches Restrictive practice Governance actions Service user feedback Audits and improvement Regulatory actions Training and workforce compliance The exact number of files will be confirmed with the successful freelancer following an initial review. The registers need to become functional, consistent and easy to use, rather than simply formatted spreadsheets. Depending on the register, this may include: Unique reference numbers Automated status calculations Open, closed and overdue indicators Due-date and review alerts Automated risk ratings and RAG indicators Dropdown lists and controlled data entry Conditional formatting Automated totals and summary metrics Monthly, quarterly and annual reporting Filtering by service, region, division, category, status and reporting period Identification of themes, recurring issues and required escalations Formula protection without restricting data entry Summary pages or dashboards Connections to the appropriate regional, divisional and Group dashboards The registers will remain the source of truth for individual records. Only relevant totals, themes, trends, risk ratings and outstanding actions should feed into higher-level dashboards. Main requirements The successful freelancer will be required to: Review and inventory the existing workbooks and registers Produce a clear data map showing how information should move through the system Make the registers smarter, more automated and easier to maintain Add, correct and protect formulas across multiple files and tabs Standardise dropdowns, identifiers, categories and reporting periods where required Create calculated metrics, alerts and RAG indicators Link Practice Observation data to Regional Governance workbooks Link Regional Governance workbooks to the relevant Divisional Governance workbook Complete dashboards for each of the five divisions Link all five Divisional Governance workbooks to the Group Master Dashboard Link relevant register data to the correct reporting level Use Power Query or another reliable Excel-based method where appropriate Ensure files work reliably within Microsoft 365/SharePoint Reduce the risk of broken links when files are moved, updated or refreshed Test the complete data flow from source registers through to the Master Dashboard Ensure the system is straightforward for managers with varying levels of Excel experience Deliverables Smart, functioning governance registers Functional Practice Observation templates Regional Governance and Assurance workbooks Five Divisional Governance workbooks and dashboards One Group Governance workbook and Master Dashboard Reliable connections between all relevant files Working formulas, validation, dropdowns, alerts and RAG ratings A complete data map/data dictionary Testing of the full reporting flow Simple refresh and maintenance instructions Final handover and correction of any errors identified during testing Confidentiality The work relates to confidential organisational systems. A Non-Disclosure Agreement must be signed before any files are shared. Anonymised or test data will be used wherever possible. Please include in your proposal: Your experience of creating smart Excel registers and trackers Your experience of linking Excel files stored within SharePoint/Microsoft 365 Your Power Query experience How you would minimise broken connections How you would approach mapping and testing this system Examples of comparable work What you can deliver within the approximate £1,000 budget

Build a Secure Live AI Research Data Processing Prototype

Rapid Low-Code AI Document-Parsing Web Prototype (Secure Cloud Tenant) in Microsoft Copilot Studio / Azure OpenAI Project Overview: I need a highly concise, working prototype of a secure web application interface. The sole purpose of this app is to demonstrate a secure, live text-processing pipeline during a brief stakeholder review. It must ingest a raw text document/dataset, simulate a structured evaluation process against a pre-set compliance rubric, and dynamically display an optimization analytics page. Key Requirements to Implement: 1. Secure File Upload Interface A minimal, clean user interface with a file drop zone labeled: "Secure Sandbox: Upload Manuscript / Dataset Draft (PDF, DOCX, or CSV)". A secondary text field labeled: "Alternative Manual Input: Paste Methodology / Text Details". A dropdown parameter selector: [Parameter Group A / Baseline Metrics Checklist]. 2. Localized Governance Engine Setup Connect this frontend interface securely to an LLM endpoint (via Microsoft Copilot Studio, Azure OpenAI Studio template, or a standard private API pipeline). Define system prompts to parse the document's sections (checking for structural clarity, data mapping consistency, and alignment with baseline formatting rules). 3. Dynamic Output & Accountability Dashboard Upon document submission, the UI must refresh dynamically to show: Maturity / Verification Score: A clean progress gauge (e.g., Ecosystem Readiness Level: 84%). Compliance Rules Checklist: Visual indicators displaying: [Passed] Citation & Data Anonymization Check [Passed] Methodological Parameter Scope [Warning] Formatting Ambiguity Detected in Section 3 Actionable Next Steps: A generated text box detailing exactly what parameters need optimization. Technical Constraints: Must be deployed on a functional, live preview web URL so I can interact with it live during the meeting. Data privacy configuration must be explicitly set to ensure no data processed is utilized for public model training datasets. Important Fail-Safe: Hardcode a single specific fallback template path into the interface so that if the live internet connection fluctuates during the review, the target upload file will immediately trigger the exact correct completed dashboard layout cleanly.