Product Design Projects

opportunity

Sting for intorudction to ICEN AWARDS

We are producing the ICEN Awards and need an animator to create a 45-second opening sting designed to command attention and bring a live audience to the main stage. The animation opens with the ICEN Awards starburst logo (supplied) accompanied by an explosive impact sound, which you will source. This transitions into a sequence of beat-locked cuts set to Japanese taiko drumming (also to be sourced by the animator), alternating between full-frame typographic words in bright ICEN brand colours and full-bleed images supplied by us. The sequence runs for 12 cuts across approximately 45 seconds, with every image and type change locked precisely to the drum beat. All type is set in Helvetica Neue Bold Condensed, all caps. A storyboard and full production brief are attached. Please review both before quoting.

Photoshop & AI Specialist for Realistic 3D Floor Plans

We're looking for a talented Photoshop and AI image editing specialist to join our team on an ongoing freelance basis. Your role will be to create realistic 3D top-down floor plans for luxury residential properties featured across our YouTube channels, including The Luxury Home Show, The New Build Show and The Interior Design Show. These floor plans are used within our professionally produced long-form property tours and must accurately reflect the layout, furniture, flooring and finishes shown in the original property. For each project, we'll provide: - The original architectural floor plan. - Video walkthroughs of the property. Using these materials, you'll recreate the property as a realistic 3D floor plan before producing a final AI-enhanced render ready for use in our videos. We're looking for someone who: - Has advanced Adobe Photoshop skills. - Has experience with AI image generation and editing tools (such as ChatGPT, Artlist AI or similar). - Has excellent attention to detail and can accurately recreate interiors from reference material. - Can communicate and collaborate during UK business hours (Monday–Friday, approximately 9:00 am–5:00 pm GMT/BST). - Is looking for an ongoing working relationship with regular projects. Please note: A PDF guide is attached outlining our current workflow. We expect applicants to familiarise themselves with this process, as it demonstrates the quality and consistency we're looking for. However, we're not prescriptive about the software or workflow used. If you know of a faster or more efficient method that produces the same (or better) results while maintaining our quality standards, we're happy for you to use your preferred approach. The final output is more important than the process used to achieve it. When applying, please include examples of any relevant work, particularly architectural visualisation, Photoshop compositing, AI image editing or realistic floor plan creation. Applicants with relevant portfolio examples will be prioritised. We look forward to finding someone who can become a long-term part of our creative team.

Office Space Planning Support - Desk Layout & Seating Options

We are looking for someone to help us with office space planning for a small office team of around 8 people. This is not a request for a full interior design project or a 3D walkthrough. What we need is a practical, intelligent desk layout plan that helps us make better use of the space and work out where people should sit. We have the key dimensions of the office, desk sizes, number of screens, printers, floor boxes, plug sockets, air conditioning units, and other fixed points. We can provide a floor plan or rough sketch with measurements, along with photos of the space if helpful. The main requirement is to help us play around with different layout options for desks and seating positions. We would also like to provide some context on each person in the office, including: Their role and who they work closely with Where they currently sit What works and does not work about their current position Any preferences or restrictions around where they should sit Which team members should ideally be close together Any areas we want to keep clear or use more effectively The aim is to end up with a few sensible layout options that show where desks could go and where each person could sit. We are looking for someone who can think practically about workflow, communication, comfort, noise, screens, sockets, printers, and general day-to-day office use. The final output could be a simple 2D plan, annotated layout, or clear desk/seating diagram. It does not need to be overly polished, but it does need to be accurate, easy to understand, and useful for making a decision. Ideally, we would like someone with experience in office space planning, workplace layouts, facilities planning, or practical interior layout design. Please include examples of similar work if you have any.

Build webscraper to collect data from outlet menus

I have a list of appr. 50.000 outlets, of which I want to have the menu information scraped cleansed and organised (see FACT DIM below). Assignment is to receive a working and tested code for doing that, perphaps for a smal sample of 100 outlets or so to see that it's working. Lump sum proposal please, needs to be ready asap. Best regards, Sander -------------- CREATE TABLE public.outlet ( outlet_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, naam text NOT NULL, plaats text, website_url text, segment text, status text NOT NULL DEFAULT 'actief'::text CHECK (status = ANY (ARRAY['actief'::text, 'inactief'::text])), created_at timestamp with time zone NOT NULL DEFAULT now(), updated_at timestamp with time zone NOT NULL DEFAULT now(), CONSTRAINT outlet_pkey PRIMARY KEY (outlet_id) ); CREATE TABLE public.menu_source ( source_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, outlet_id bigint NOT NULL, pagina_type text, url text NOT NULL, domain text, bestandstype text CHECK (bestandstype = ANY (ARRAY['html'::text, 'pdf'::text, 'image'::text])), confidence real, is_active boolean NOT NULL DEFAULT true, created_at timestamp with time zone NOT NULL DEFAULT now(), CONSTRAINT menu_source_pkey PRIMARY KEY (source_id), CONSTRAINT menu_source_outlet_id_fkey FOREIGN KEY (outlet_id) REFERENCES public.outlet(outlet_id) ); CREATE TABLE public.crawl_run ( run_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, source_id bigint NOT NULL, crawled_at timestamp with time zone NOT NULL DEFAULT now(), http_status integer, etag text, last_modified text, sha256 text, parse_status text NOT NULL DEFAULT 'pending'::text CHECK (parse_status = ANY (ARRAY['pending'::text, 'ok'::text, 'partial'::text, 'failed'::text, 'not_modified'::text])), parser_version text, raw_ref text, CONSTRAINT crawl_run_pkey PRIMARY KEY (run_id), CONSTRAINT crawl_run_source_id_fkey FOREIGN KEY (source_id) REFERENCES public.menu_source(source_id) ); CREATE TABLE public.menu_item ( menuitem_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, run_id bigint NOT NULL, categorie text, product text NOT NULL, beschrijving text, prijs numeric, valuta text NOT NULL DEFAULT 'EUR'::text, volume text, merk text, merkeigenaar text, positie integer, confidence real, CONSTRAINT menu_item_pkey PRIMARY KEY (menuitem_id), CONSTRAINT menu_item_run_id_fkey FOREIGN KEY (run_id) REFERENCES public.crawl_run(run_id) ); CREATE TABLE public.change_event ( event_id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, outlet_id bigint NOT NULL, source_id bigint, oud_menuitem_id bigint, nieuw_menuitem_id bigint, detectiedatum timestamp with time zone NOT NULL DEFAULT now(), event_type text NOT NULL CHECK (event_type = ANY (ARRAY['product_toegevoegd'::text, 'product_verwijderd'::text, 'prijs_verhoogd'::text, 'prijs_verlaagd'::text, 'brand_switch'::text, 'menu_redesign'::text])), oude_waarde text, nieuwe_waarde text, ai_interpretatie text, impact text CHECK (impact = ANY (ARRAY['hoog'::text, 'midden'::text, 'laag'::text])), opportunity_score integer CHECK (opportunity_score >= 0 AND opportunity_score <= 100), aanbevolen_actie text, bevestigd_runs integer NOT NULL DEFAULT 1, status text NOT NULL DEFAULT 'nieuw'::text CHECK (status = ANY (ARRAY['nieuw'::text, 'bekeken'::text, 'afgehandeld'::text, 'false_positive'::text])), CONSTRAINT change_event_pkey PRIMARY KEY (event_id), CONSTRAINT change_event_outlet_id_fkey FOREIGN KEY (outlet_id) REFERENCES public.outlet(outlet_id), CONSTRAINT change_event_source_id_fkey FOREIGN KEY (source_id) REFERENCES public.menu_source(source_id), CONSTRAINT change_event_oud_menuitem_id_fkey FOREIGN KEY (oud_menuitem_id) REFERENCES public.menu_item(menuitem_id), CONSTRAINT change_event_nieuw_menuitem_id_fkey FOREIGN KEY (nieuw_menuitem_id) REFERENCES public.menu_item(menuitem_id) );

TikTok Video Editor – 150 Short-Form Videos (Bulk/AI Workflow)

TikTok Video Workflow Specialist – 150 Short-Form Videos (Bulk/AI Workflow + 1 Month Account Setup) Job Description: We are an independent small agile AI travel platform launching a global consumer-advocacy campaign to expose predatory rental car damage scams. We have fully developed the scripts, raw materials, and core messaging. We are looking for a system-driven Video Editor & Account Manager with deep experience in bulk-creation tools (CapCut Pro, Canva, HeyGen or specialized AI video infrastructure) to produce our core 150-video asset vault and establish our initial channel presence. This is not a traditional "frame-by-frame" creative editing job. We are optimization-focused; we want to leverage smart workflows, clean master templates, and automated assets to generate a high-volume batch efficiently without sacrificing a clean, high-impact aesthetic. Key Deliverables: 1. The 150-Video Vault (Fixed Price Component A): Edit and export 150 short-form videos based entirely on our provided scripts. 2. Customizable Master Templates: All master templates, graphics, and timeline frameworks must remain editable/transferable so I can make minor text or asset tweaks in the future, alternatively utilizing the original creator. 3. Account Management Trial (Fixed Price Component B): Basic setup and 30 days of standard feed management/scheduling for our initial launch account. Mandatory Submission Requirements: To be considered, your proposal must break down your bid into these distinct lines: • Quote 1: Fixed-price for the complete production of the 150-video vault. • Quote 2: Fixed-price for basic account setup and 1 month of scheduling/management. • Workflow Detail: A 2-sentence summary of the specific batch-processing tools or AI software you plan to use to complete this efficiently. The Selection Process: We will select top candidates for a paid 1-video sample milestone. Upon approval of the template visual design, pacing, and quality, we will release the contract for the full batch of 150 videos immediately. Please ensure pricing is realistic for the project this is about saving me personal time effort and resources by not having to do it myself with the potential for extending future ongoing work to the selected creator. Sincerely

Luxury Brand Content Creator / Storyteller

We're looking for someone who can demonstrate an understanding of luxury brands, craftsmanship, and visual storytelling. Our audience is architects, interior designers, heritage property owners, and affluent private clients. This position is suitable for self-employed / freelancers, newly qualified students or students looking to gain valuable industry experience, build their portfolio, and develop practical marketing skills within a small business environment. We are looking for someone with experience and an interest in marketing, social media, content creation, or digital communications to assist with marketing at our cabinet making business. This would provide practical, hands-on experience working with a real business to help develop and promote our online presence. This would be temporary/freelance in the first instance (on a rolling 2 week position) but could lead to a flexible job offer. We anticipate this is mostly a remote working position but should likely include one occasion per week/bi-weekly of 'site' work (taking photos/gathering information at our workshop) therefore their ability to travel to our site would be essential. Duties Activities would be mainly creating and scheduling social media content: >Photographing and showcasing completed / work-in-progress projects on social media platforms >Developing ideas for marketing campaigns >Assisting with website and online content updates >Researching local marketing opportunities and customer engagement strategies Application is informal - please email me with your CV/experience information and specific visual examples of how you have undertaken similar work (this could include work completed during study). Pay: £15.00-£25.00 per hour Work Location: Hybrid/Remote in Hathersage S32 1EG

Video Editor for 1st Birthday Photo Slideshow

I am looking for an experienced video editor to create a beautiful and emotional 1st birthday retrospective video for my daughter. The video will be a photo slideshow with a specific theme and layout requirements. Project Details: Theme: Under the Sea. Duration: Between 3 to 5 minutes. Format: Photo Slideshow. Total Photos: Approximately 150 photos to be included in the slideshow. Photo Layouts: The slideshow should be dynamic, displaying photos in different grid formats throughout the video. Specifically, I want scenes showing 1, 2, 4, and 8 photos at a time on the screen. Transitions & Effects: Open to the editor's creativity, but they should be smooth and match the "Under the Sea" theme (e.g., fluid movements, soft fades). Audio: I will provide 2 specific songs to be used as the background track. The editor must synchronize the photo transitions with the rhythm of the music. Visual Elements: I will provide a specific color palette and visual elements (such as corals, bubbles, fishes, etc.) to be incorporated into the video design/backgrounds once the job is awarded. Requirements: Proven experience in video editing and creating dynamic photo slideshows. Ability to work with specific color palettes and thematic elements. Good sense of rhythm to sync transitions with the provided music. Please include examples of similar slideshow or event videos you have created in your proposal. Deliverables: Final video in high quality (1080p or 4K, MP4 format). One round of revisions if necessary. I look forward to seeing your proposals and creating a magical memory for my daughter's first birthday!

opportunity

UK Solicitor ONLY: Food app T&Cs, privacy & telemetry

I am launching a consumer mobile app in the food and recipe space, helping people reduce food waste and discover recipes. I need comprehensive legal documentation and data protection advice before going live. Full technical details will be shared once engaged. ------------------------------------------------- 1. PRIVACY POLICY, TERMS & CONDITIONS, AND TERMS OF USE Full, production-ready documents suitable for App Store (Apple) and Google Play submission, covering a global user base. Must address: - Data collected, purpose, and retention - Lawful basis for processing across all major jurisdictions (UK, EEA, US, and a framework for the rest of the world) - User rights (access, erasure, portability, objection) - Third-party processors and data sharing - Cookie/tracking equivalents in a mobile context - Minimum age requirements across jurisdictions ------------------------------------------------- 2. TELEMETRY AND DATA COLLECTION ADVICE The app collects behavioural telemetry linked to a pseudonymous per-install identifier (no name or email stored). I need written advice covering: - What I can legally collect, and on what lawful basis, across different regulatory regimes (UK GDPR, EU GDPR, CCPA/CPRA, and any other material jurisdictions) - Legitimate interest vs. consent, when each applies and how to document it - Anonymisation thresholds, what level of aggregation (e.g. on-device aggregation, k-anonymity, category-level bucketing) takes data outside scope entirely, and the equivalent thresholds under CCPA and other regimes - Commercial data licensing, whether and how anonymised or aggregated data can be sold or licensed to third parties without consent obligations, and what conditions must be met per jurisdiction - Children's data obligations by jurisdiction (COPPA, Article 8 UK/EU GDPR, etc.) - Proportionate and defensible retention periods ------------------------------------------------- 3. DPIA REVIEW Review and sign off a completed draft DPIA for the telemetry feature. Full document provided once engaged. ------------------------------------------------- WHAT I AM NOT LOOKING FOR - Generic template documents - Advice limited to UK/EU only, global coverage is a requirement - Junior associate work without senior oversight ------------------------------------------------- DELIVERABLES - Production-ready Privacy Policy (global scope) - Production-ready Terms & Conditions and Terms of Use - Written advice note on telemetry, anonymisation thresholds, and commercial data licensing by jurisdiction - DPIA sign-off or marked-up revisions ------------------------------------------------- BEFORE I ENGAGE, PLEASE PROVIDE Proof of qualification - SRA number or equivalent with current practising certificate Relevant experience - examples of privacy policies or data protection advice delivered for consumer mobile or digital products (anonymised references or case studies are fine) Data protection specialism - confirmation this is a primary part of your practice, not an occasional add-on; CIPP/E or BCS Practitioner Certificate in Data Protection preferred Global coverage - confirm you can advise substantively on UK GDPR, EU GDPR, and US (CCPA/CPRA) at minimum, and state clearly which other jurisdictions (Canada, Australia, Brazil etc.) you can or cannot cover Turnaround - this is blocking a production release, please state realistic timelines upfront

opportunity

VBA Developer Needed to Reconcile Inventory

We are looking for an experienced VBA / Database Developer to help us resolve a technical misalignment in our inventory management system's go-live data. The system utilizes a FIFO engine where IngredientBatches controls batch availability, and a movement-led IngredientStock ledger calculates live stock based on receipt/consumption transactions. Currently, a gap in our opening balance setup has caused our live stock dashboard to display negative figures. The strategy and a core fix module (mod_OpeningStockReceipts.bas) have already been outlined. We need an expert to run diagnostics, align the columns, execute the fix safely, and ensure full system reconciliation without disrupting existing consumption history. Scope of Work Module Integration: Import and test a provided VBA module (mod_OpeningStockReceipts.bas) designed to generate missing opening receipt entries in the movement ledger from existing batch data. Column & Data Alignment: Run data validation checks (via a provided macro) to identify and correct misaligned data columns (specifically Status and RemainingQty in the IngredientBatches table). Data Reconciliation: Ensure that: IngredientStock reconciles perfectly with positive opening balances. FIFO batches remain completely unchanged. Existing ConsumptionLedger records stay intact. No duplicate stock movements are created. System Validation: Rebuild and validate the live stock dashboard formulas to ensure future "End of Day" automated runs function reliably. Thank you

Partner Network (Remote Business Development Role)

Build the FrontGlow Founding Partner Network (Remote Business Development Role) Overview FrontGlow Media is building a nationwide premium network of professionals across the UK in luxury residential, commercial AV, smart home technology and digital display solutions. We are looking for a proactive Business Development & Partnership Recruitment Manager to help build our Founding Partner Network. This is not a generic VA position. Your focus is identifying, engaging and qualifying professionals who would be a great fit for the FrontGlow Partner Network. Initial 60-Day Targets Recruit approximately 45 founding partners: 10 Interior Designers / Architects 10 Creative Media Professionals 10 Referral / Business Development Partners 5 Commercial Sales Partners 5 Technology Partners 5 Installation Partners Responsibilities Research suitable professionals. Conduct personalised outreach. Introduce FrontGlow and answer initial questions. Encourage suitable candidates to complete our Partner Application. Maintain our recruitment CRM. Schedule qualification calls where appropriate. Produce a weekly progress report. Research Sources LinkedIn PeoplePerHour Upwork Fiverr Pro Houzz Checkatrade MyBuilder RIBA BIID Local industry directories Professional communities Ideal Candidate We’re looking for someone with experience in: Business Development Recruitment Partnership Development LinkedIn Outreach CRM Management Relationship Building Experience in architecture, construction, AV, smart home, luxury residential or commercial sectors is a bonus. Success Metrics Your performance will be measured by results: Qualified professionals contacted Response rate Applications submitted Approved partners Accuracy of CRM records Weekly reporting Contract Initial 60-day contract 10–20 hours per week Opportunity for an ongoing role as FrontGlow expands To Apply Please include: A short introduction. Examples of outreach or recruitment campaigns you’ve managed. Your experience using LinkedIn or freelance platforms for business development. How you would approach recruiting high-quality professionals for a premium partner network. Your availability and hourly rate. We’re looking for someone who enjoys building relationships and can help establish a high-quality nationwide partner network.

YouTube Shorts Editor (Hoodie Guy Style | 2.5D Animation)

Experience Level: Entry We’re launching a new YouTube Shorts channel based on the viral “Hoodie Guy / Pins Guy” format, and we’re looking for a highly skilled editor who can replicate this style precisely. This is not basic editing. You must understand: Fast-paced, retention-driven cuts (every 1.5–2.5 seconds) 2.5D animation (layered backgrounds + subject + host) Cartoon face overlays (like the competitor channels) Sound design (whooshes, risers, impact hits, ambient layers) Story pacing synced to script escalation If you’ve never created this exact style before, this role is NOT for you. Your Responsibilities: Edit YouTube Shorts (45–60 sec) Create 2.5D scenes using layered assets Maintain high visual stimulation (no static scenes) Sync cuts to voiceover and sound effects Add captions as final layer (not during editing) Style Reference: Channels similar to: YT: Hoodie Guy YT: Pins Guy (You should already be familiar with this format) “Start your proposal with the word ‘FRAME-BY-FRAME’ so I know you read everything.” What We’re Looking For: Proven experience with high-retention Shorts. Strong understanding of viral pacing and storytelling. Ability to follow a structured editing system (we provide a full blueprint). We provide Script and Voice Over. Skilled in CapCut, Premiere Pro, After Effects, or DaVinci Strong attention to detail (timing, motion, sound). Important (Read Carefully): When applying, you MUST include: 2–3 examples of similar edits (Shorts format preferred) Confirmation that you understand 2.5D animation Your workflow (tools + process) Applications without relevant examples will be ignored. Bonus Skills (Preferred but not required): Scriptwriting for Shorts (Hook → Escalation → Climax format) Experience with viral content strategy Project Details: 3–4 videos per week Long-term opportunity if quality is strong Pay: Negotiable $30 per Short (based on skill level) “If your work matches the reference quality, I’m willing to increase the rate quickly.” Final Note: We are building a serious channel, not testing casually. If you can match or exceed the reference style, this can turn into a long-term, high-volume role.

Looking for English native B2B Telemarketer / Lead Generator

Business Development Executive / Lead Generator (Contract) Remote | Contract Role | Basic Salary + Uncapped Commission Incentives We are looking for a confident, driven and motivated Business Development Executive / Lead Generator to join our growing team. You will be responsible for contacting UK businesses from company-provided spreadsheets and databases, identifying opportunities and introducing our range of business services to potential clients. Working primarily from supplied data, you will speak with business owners and decision-makers, understand their current arrangements and identify opportunities where our services can save them money, improve efficiencies or generate additional revenue. The services you will be promoting include Business Energy, Business Water, Waste Management, Telecommunications, Card Machines and EPOS Systems, Business Insurance, Business Funding, Commercial Solar Solutions and Commercial EV Charging Solutions. The successful candidate will be confident on the phone, possess excellent communication skills and be comfortable speaking with business owners and senior decision-makers. Previous experience in telemarketing, telesales, lead generation or business development would be advantageous but is not essential for the right candidate. You must be fluent in English with a professional and friendly telephone manner, be self-motivated and target-driven, and have the ability to work independently while managing your own workload effectively. We provide the data, training and support — you provide the enthusiasm, professionalism and determination to generate opportunities and help turn conversations into completed business. This role offers a lower basic salary than a traditional sales position as it has been designed to reward performance through generous commission incentives. In addition to your salary, you will receive a percentage of the commission generated on every deal that successfully completes from your leads. The more opportunities you create and the more deals that get over the line, the more money you earn. There is no cap on earnings, making this an excellent opportunity for ambitious individuals who are motivated by performance and enjoy being rewarded for results. This position is initially offered on a contract basis, however there is potential for a permanent role in the future for the right candidate should the relationship prove successful for both parties. If you are confident on the phone, enjoy speaking with business owners and are looking for an opportunity with genuine earning potential, we would love to hear from you.

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

THE UNCOMMON – EMAIL MARKETING BRIEF

THE UNCOMMON – EMAIL MARKETING BRIEF About The Uncommon The Uncommon is a restaurant, cocktail bar and listening room located within Harbour House, North Shields. We combine great food, cocktails, music and atmosphere to create memorable experiences. Our brand is stylish, creative, independent and community-led. Objective Increase table bookings, walk-ins, repeat visits and customer loyalty through consistent email marketing. Scope of Work Email Marketing Create, design, write and schedule 2 marketing emails per week. Emails should be planned around: Seasons and weather Paydays Bank Holidays Sporting events DJs and live music Sunday Service roasts New menu items Cocktail features Local events Special offers and experiences The aim is to drive: Food bookings Drinks bookings Event attendance Repeat visits Campaign Planning Prepare a monthly content calendar in advance so marketing is aligned with upcoming events, seasonal opportunities and booking trends. Customer Segmentation Manage and improve customer lists including: Previous diners Sunday roast customers Event attendees Drinks customers Regular customers New subscribers Automation Setup & Management Create and manage automated email journeys including: Welcome email series Birthday emails Post-visit follow-up emails Re-engagement campaigns Event reminder emails Booking reminder emails where possible Reporting Provide a monthly report including: Open rates Click-through rates Subscriber growth Booking performance Campaign recommendations Platforms Mailchimp OpenTable Zapier (if required) Brand Personality The Uncommon is: Stylish Creative Friendly Premium but approachable Community focused Key themes: Great food Cocktails Music Atmosphere Experiences "Where Vibes Meet Flavours" Success Targets Increase table bookings Increase repeat customer visits Grow email database Improve customer retention Generate measurable revenue from email marketing Please Include In Your Proposal Hospitality marketing experience Examples of previous restaurant/bar campaigns Experience with Mailchimp automations Monthly management fee Setup fee (if applicable) Estimated time required each month

opportunity

HealthTech Market Validation & Pilot Recruitment Specialist

# Freelance Market Research & Pilot Recruitment Specialist (HealthTech) ## Overview We are looking for an experienced freelance researcher to help validate a new AI-powered health technology product aimed at private healthcare clinics. The goal is not to sell a product. The goal is to conduct structured customer discovery interviews and identify potential pilot partners. This is a short-term project focused on learning, validation and pilot recruitment. ## About the Product We are building an AI-powered health intelligence platform that helps clinicians review and explain blood test results more efficiently. The platform generates patient-friendly reports, highlights longitudinal trends, and supports clinician review before reports are shared with patients. Target customers include: * Longevity clinics * Functional medicine clinics * Thyroid and hormone clinics * Menopause clinics * Private GP practices ## Project Objectives The successful freelancer will: ### 1. Build a Target List Identify and create a database of: * UK longevity clinics * Functional medicine clinics * Thyroid/hormone clinics * Menopause clinics * Relevant private GP practices For each clinic provide: * Clinic name * Website * Contact details * Key decision makers * LinkedIn profiles (where available) ### 2. Conduct Discovery Outreach Reach out to clinics via: * Email * LinkedIn * Phone (where appropriate) The objective is to secure discovery conversations. No hard selling required. ### 3. Conduct Structured Interviews Interview clinicians and clinic owners to understand: * Current blood test interpretation workflows * Time spent reviewing results * Current reporting process * Pain points * Existing software used * Attitude towards AI-assisted reporting * Willingness to participate in pilots ### 4. Produce Research Findings Summarise: * Key themes * Common pain points * Feature requests * Objections * Buying signals * Recommended target segment ### 5. Recruit Pilot Clinics Goal: Secure interest from 3–5 clinics willing to evaluate a pilot programme. ## Deliverables ### Deliverable 1 Target clinic database Minimum: * 100 clinics ### Deliverable 2 Interview findings report Including: * Key insights * Market feedback * Adoption risks * Recommendations ### Deliverable 3 Pilot recruitment report Including: * Interested clinics * Contact details * Next steps * Level of interest ## Ideal Candidate Experience in one or more of: * HealthTech * Digital health * Healthcare consulting * Healthcare market research * B2B SaaS customer discovery * Pilot programme recruitment Experience speaking directly with clinicians is highly desirable. ## Success Criteria Success will be measured by: * Number of clinician conversations completed * Quality of insights gathered * Identification of common workflow pain points * Number of clinics expressing pilot interest ## Proposal Requirements Please include: 1. Relevant experience 2. Examples of similar projects 3. Proposed approach 4. Estimated timeline 5. Fixed-price quote This project is focused on learning and validation. We are looking for someone who can uncover genuine market insights rather than simply generate leads.

Urgent Requirement–Drainage / Wastewater Assessment (N.IRELAND)

We are seeking assistance from a suitably qualified Civil Engineer, Drainage Engineer or Water Engineer to prepare a short technical note in support of a live planning application in Northern Ireland. Background The planning application relates to an existing public house and adjoining retail unit. As part of the proposal, an existing hot food deli operation is being removed and the retail floorspace is being incorporated into the public house. A key issue has arisen regarding wastewater generation and the potential impact on the NI Water network. We require an independent professional assessment of whether the removal of the existing deli operation is likely to offset, or potentially exceed, any increase in wastewater generation associated with the proposed use. Scope The successful consultant would be required to: • Review photographs and information relating to the existing deli operation. • Assess the likely wastewater generation associated with the existing deli use. • Consider the proposed arrangement and likely wastewater generation following removal of the deli. • Provide an opinion on whether overall wastewater generation is likely to remain similar, reduce, or increase. • Prepare a short technical note on company headed paper suitable for submission to NI Water and the Planning Authority. Requirements • Relevant qualification in Civil Engineering, Drainage Engineering, Water Engineering or similar. • Experience of drainage design, wastewater assessments or NI Water applications. • Ability to provide a professional opinion on company headed paper. • Quick turnaround essential. Timescales This is an urgent commission and we would ideally require a draft note within 24–48 hours. Please contact Ryan Milligan at Planning Experts if interested

Seeking eCommerce Beta Testers

Beta Tester - Optagen Portal & Integrations What you’re testing The Optagen portal lets you manage multiple stores by bringing together data from your commerce, analytics, accounting, inventory, and CRM systems. It creates a single ranked action list, with each recommendation labeled for trust and checked against real results. We need beta testers to use the portal with real store data and identify what breaks, what’s slow, what’s missing, and what doesn’t match reality. Integration coverage required You will test syncing and data accuracy across these integrations: Commerce platforms: Shopify, BigCommerce, WooCommerce, Etsy Analytics: Google Analytics 4, Search Console Shipping/3PL: ShipBob, ShipStation, Easyship Inventory systems: Cin7, Katana Accounting: QuickBooks, Xero Marketing/CRM: Klaviyo You don’t need to use every integration—just test the ones you already use. We’re aiming for each tester to cover at least 3 or 4 integrations from different categories. What we’re asking 1. Sync completeness: Check if all the expected fields from each integration show up in the portal. Are SKU, pricing, margin, sales, traffic, inventory, and competitor data there? 2. Refresh latency: See how long it takes for changes in your source system (like a price update in Shopify or a GA4 event) to show up in the ranked plan. 3. Data accuracy: Choose 5 to 10 data points you can check in both your source system and Optagen. Do they match? 4. Signal read accuracy: The portal calculates metrics such as AI visibility, SKU margins, demand signals, returns concentration, pricing elasticity, and competitor share of voice. Check these against your store. Do they make sense? Can you find the data sources if you look for them? 5. Ranked plan stability: Run the same store scan twice in one week. Does the ranked plan update based on new data, or does it stay the same? Are the revenue-impact numbers realistic? What we’re not asking * Testing the governed execution agent (scheduled to ship later; currently in development) * Load testing or scale testing * Security testing or pen testing * UX/design feedback (we’ll gather that separately) Timeline and access * Beta runs from [DATE] to [DATE] * You’ll get portal access for your own stores, using your real data—not test data. * We’ll keep an eye on logs and collect diagnostics if something fails. Please report any issues as they happen via a feedback button. * We’ll have a weekly sync call to talk about any blockers or patterns you notice. Who should apply * You run 1-5 stores across 2+ of these platforms. * You can verify data accuracy (you know your actual margins, traffic, and sales numbers) * You’re willing to spend 2-4 hours per week auditing sync health and data correctness. * You’re okay with bugs and incomplete features since this is a beta test. When you apply, please indicate: * Which platforms you currently use (Shopify, BigCommerce, WooCommerce, Etsy etc.) * Rough store size (monthly revenue or annual, average order value, SKU count) * Any specific data quality concerns you have with your current setup

Faceless YouTube channel

Project Title Faceless Kids YouTube Channel Creator (Long-Term Partnership) Project Description I’m looking for an experienced YouTube content creator or small creative team to help build a brand-new faceless children’s YouTube channel from the ground up. This is a long-term project with weekly work available for the right person. What I Need I’m creating a fun, educational, and entertaining animated channel for children ages 3–8 featuring original characters, positive life lessons, humor, adventure, and catchy storytelling. I need someone who can help create high-quality videos that keep children engaged while maintaining a consistent visual style across every episode. Responsibilities * Create engaging 8–10 minute YouTube episodes * Produce colorful, child-friendly animations * Edit videos with sound effects, music, and pacing that holds children’s attention * Generate AI visuals when needed while keeping all characters consistent * Add subtitles and polished transitions * Deliver videos ready for YouTube upload * Create eye-catching thumbnails * Maintain a consistent look and feel throughout the series Style I’m Looking For * Bright, colorful animation * Pixar/DreamWorks-inspired quality (using AI tools where appropriate) * Fast-paced storytelling * Educational without feeling like a classroom * Positive messages about kindness, friendship, teamwork, confidence, and problem-solving * Original content only (no copyrighted characters) Skills Preferred * YouTube content creation * Children’s animation * AI video workflows (Higgsfield, Veo, Runway, Kling, Pika, Sora, or similar) * Adobe Premiere Pro, After Effects, DaVinci Resolve, or equivalent * Motion graphics * Storytelling * Sound design * Thumbnail design Deliverables * Fully edited YouTube video (8–10 minutes) * Thumbnail * Intro and outro * Background music and sound effects * Editable project files (if applicable) * Final video in 4K or 1080p When Applying Please include: * Examples of children’s content you’ve created * Links to YouTube channels you’ve worked on * Your animation workflow * AI tools you use * Estimated turnaround time per episode * Your price per episode This is intended to become an ongoing weekly collaboration for someone who can consistently deliver engaging, high-quality content. I’m looking for creativity, strong communication, reliability, and a genuine passion for making entertaining educational videos for kids.

opportunity

Add functionality to app - Dart / Flutter app

Project Brief – App Development Overview This project involves adding new functionality across two existing checklist/reporting applications. Both apps allow users to complete food safety checklists which are then stored and generated into reports. Several features already exist in one application and now need to be duplicated into the other, alongside new functionality. Application 1 – GS App 1. Live Temperature Sensor Updates Implement live updating temperature readings from connected sensors. 2. Manual Label Printing Add a "Print Manual Label" screen. Users should be able to generate and print labels without selecting an existing food item. 3. Amazon Label Reordering Add an Order Labels button. When pressed: Customer's saved Stripe payment method is charged. Amazon Multi-Channel Fulfilment (MCF) automatically ships a new roll of labels to the customer's registered address. No manual intervention required. 4. Delivery Comments Add a comments field to Delivery records. Comments should also appear on generated reports. 5. Report History At the bottom of the Reports screen display the last 5 reports generated. Users should be able to download/view these reports again. 6. Compliance Improvements Add two new compliance sections: Pest Control Agreement Oil Disposal Agreement The documents will be uploaded through the dashboard and viewable from the mobile app. 7. Copy Compliance Allow compliance checklists to be copied/imported from the second application. Application 2 – SF 1. Duplicate Label Printing System Copy the complete label printing functionality already built into the GS App, including: Manual Label Printing screen Existing label printer functionality 2. Amazon Label Reordering Add an Order Labels button. When selected: Customer's Stripe payment method is charged. Amazon MCF automatically dispatches label rolls. Printer purchases remain available within the Owner Account section. 3. Delivery Comments Add comments to delivery records. Include these comments on generated reports. 4. Report History Display the last 5 generated reports at the bottom of the Reports screen with download capability. 5. Compliance Documents Add two new compliance sections: Pest Control Agreement Oil Disposal Agreement Documents are uploaded through the dashboard and viewable within the mobile application. SFBB Pro – Subscription & Multi-Site Upgrade Subscription Changes Remove the existing: Normal Plan Premium Plan Replace with: Standard Subscription Current application functionality. Label Printing Subscription Includes label printing functionality. Multiple Site Subscription Additional charge: £12.95 per additional location Multi-Site Management Create owner-level multi-site functionality. The account owner should be able to: Add new locations. Remove locations. View all locations from a dashboard. Be charged for each additional location. Assign a Location Administrator for each site. Each Location Administrator should: Only access their assigned location. Complete daily checklists. Manage staff for their location. View reports for their location only. The Owner should have visibility and reporting across every location. General Requirements The developer should: Reuse existing functionality wherever possible rather than rebuilding it. Maintain the current design style. Ensure all new features are fully integrated into reporting. Test all new functionality before completion. Deliverables GS App Live sensor updates Manual label printing Amazon MCF label ordering Delivery comments Report history Compliance document upload/view Compliance copy feature SFBB Pro Duplicate label printing system Amazon MCF label ordering Delivery comments Report history Compliance document upload/view Subscription restructuring Multi-site management Owner dashboard Location administrator functionality Agreement Please review the above scope carefully. If you are happy with everything listed, please confirm that you agree this represents the full scope of work before development begins.

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