Writing Projects

Flutter developer

Flutter Developer Needed: Build AC Survey App from Existing Source Code Project Overview I need an experienced Flutter developer to take my complete source code for a mini-split air conditioning site survey app and build it into a working Android APK that I can install on my phone and tablets. Important: The app is already fully coded. I'm not asking you to write it from scratch. I need you to: 1. Review the code for any issues 2. Build it into a working Android app (APK) 3. Test it thoroughly 4. Deliver the installable APK file 5. Optionally help publish it to the Google Play Store What I'll Provide Complete Flutter source code (all screens, models, services, utilities) List of all packages/dependencies used Detailed feature list and workflow description Access to answer any questions about the business logic Prompt feedback during testing What You'll Do 1. Code Review & Setup Download and review all source code files Set up the Flutter development environment Run  flutter pub get  to install dependencies Run  flutter pub run build_runner build  to generate Hive adapters Fix any compilation errors or dependency conflicts 2. Build the Android App Configure Android build settings (min SDK, target SDK, app name, package name) Build a release APK (not debug) Ensure the app runs smoothly on Android 8.0+ devices Optimize APK size where reasonable 3. Testing Install the APK on at least one physical Android device Test the complete workflow: Create a new survey Fill in all fields (property details, electrical assessment, rooms, outdoor unit) Take photos with the camera Save the survey Reopen and edit the saved survey Generate and share the PDF report Verify photos appear in the PDF Test on different screen sizes if possible (phone and tablet) Fix any bugs discovered during testing 4. Deliverables Working APK file ready to install Source code with any fixes you made Brief documentation on how to install the APK List of any changes you made to the original code (Optional) Help publishing to Google Play Store Technical Stack The app uses: Flutter 3.x (latest stable) Dart 3.x Key packages:  hive  and  hive_flutter  for local storage  pdf  and  printing  for PDF generation  image_picker  for camera/photos  image  for photo compression  share_plus  for sharing  path_provider  for file paths  uuid  and  intl  for IDs and dates App Features (For Your Reference) The app is a 4-step survey tool for UK air conditioning installers: Step 1: Property Details Customer name, address, postcode Property type, construction era, wall type, glazing Photo capture (property photos) Step 2: Electrical Assessment Main fuse rating (60A/80A/100A) Consumer unit type Toggles for EV charger, electric shower, heat pump, solar, battery Live calculation of total electrical load Warning if load exceeds 80% of main fuse capacity Photo capture (consumer unit, meter) Step 3: Room Survey Add multiple rooms (repeatable) For each room: dimensions, floor level, orientation, windows, insulation Live BTU calculation per room Recommended unit size (2.5kW, 3.5kW, 5kW, 7kW) Photo capture per room Step 4: Outdoor Unit & Compliance Outdoor location, wall material, line-set length Condensate route, noise notes Compliance checkboxes (F-Gas, Part P, Part F) Photo capture (outdoor location) Summary Screen Review all survey data Generate professional PDF report with all data and photos embedded Share via email, WhatsApp, etc. Survey List Home screen shows all saved surveys Edit or delete existing surveys Persistent local storage using Hive

Developer Wanted – UK Adult Social Care Management Platform

I’m looking for a developer to help build a web-based management platform for Registered Managers and owners of adult social care services in the UK. I have over 20 years' experience running a care business, so the concept, industry knowledge and management processes will come from me. I’m looking for someone who can turn those ideas into a simple, intuitive and commercially viable product. ### The concept This isn't intended to be another cold compliance system full of forms, warnings and dashboards. The aim is to create an intelligent **management companion** that helps a care manager run their service, stay on top of their responsibilities and become a better manager. The platform will include: * A personalised home screen showing what genuinely needs the manager's attention. * A short daily wellbeing check-in so the system considers the manager's capacity as well as their workload. * Personal to-do lists alongside automatically generated daily, weekly, monthly and annual management tasks. * Staff, recruitment, service-user and operational oversight. * CQC compliance, quality assurance, audits and improvement actions. * Policies, procedures and organisational documents. * Simple financial and business-performance oversight. * Relevant CQC, Skills for Care and wider UK care-sector updates. * An AI assistant where managers can ask questions about CQC, policies, staff issues, difficult conversations, incidents, management decisions and their own service. * AI-supported people-management guidance that encourages fair, compassionate and proportionate management rather than simply quoting policies. * Alerts, reminders and intelligent follow-up of actions. A major principle of the product is that **complexity should sit in the background**. Rather than presenting a manager with dozens of outstanding tasks, statistics and compliance warnings, the software should understand what is happening across their service, identify what genuinely needs attention and help them work through it. The system should feel less like a piece of compliance software and more like having an experienced, supportive management colleague beside you. ### Where I am now The concept is well developed and I have started designing the key screens and user experience. I'm now interested in speaking to developers about the best technical approach for creating an MVP. AI will be an important part of the product, including conversational assistance, using an organisation's own policies/documents as a knowledge source, interpreting management information and potentially bringing in relevant information from trusted external sources. I would initially like to build an MVP, test it with real care managers and then develop the platform further based on feedback. I'm open to recommendations regarding the technology/platform used. If interested, please send: * Examples of relevant software/SaaS products you've built. * Any experience with AI-powered applications. * Your suggested technical approach. * An approximate timeframe for an MVP. * An indicative cost or cost range. I'm particularly interested in finding someone who wants to understand the problem we're trying to solve and contribute ideas, rather than simply being handed a specification and writing code.

Creative Strategist

Position Overview We’re looking for a talented and performance-driven Creative Strategist to develop high-converting ad concepts for fast-growing DTC and eCommerce brands. This is a fully remote role with flexible working hours. You will own the creative strategy behind paid social campaigns—from researching audiences and competitors to developing ad angles, hooks, scripts, briefs, and testing plans. You’ll work closely with Video Editors, Static Designers, and the wider performance marketing team to turn ideas into scroll-stopping creatives that drive measurable results. Position Details Work Setup: Fully Remote (Work from Anywhere) Schedule: Flexible (8 hours/day) Expected Output: 3–5 new creative concepts or briefs per day, depending on campaign needs Salary: Competitive (based on experience and skill level) Performance Bonus: Available for top-performing strategists Responsibilities Research target audiences, customer pain points, competitors, trends, and winning ad formats. Develop creative angles, hooks, messaging frameworks, scripts, and ad concepts for DTC/eCommerce brands. Create clear creative briefs for Video Editors, Static Designers, and UGC creators. Build and maintain a structured creative testing pipeline. Analyze creative performance data and identify opportunities to improve CTR, CPA, ROAS, CVR, and other key metrics. Turn winning concepts into new variations, iterations, and scalable creative systems. Collaborate with editors and designers to ensure creative direction is executed accurately. Stay updated on paid social trends, platform changes, competitor ads, and emerging creative formats. Present ideas clearly and communicate feedback in a constructive, actionable way. Manage multiple brands, campaigns, and deadlines independently. Requirements — Must Have Proven experience as a Creative Strategist, Performance Creative Strategist, Media Buyer with strong creative experience, or similar role. Strong understanding of DTC/eCommerce advertising and paid social platforms, especially Meta and TikTok. Experience developing direct-response ad concepts that are designed to drive conversions. Strong understanding of customer psychology, buyer objections, awareness levels, hooks, offers, and messaging. Ability to interpret creative performance data and use it to improve future concepts. Excellent written communication skills, including ad copy, hooks, scripts, and creative briefs. Highly organized, self-motivated, and able to manage multiple projects at once. Experience collaborating with Video Editors, Designers, UGC creators, or marketing teams. Stable internet connection and a reliable computer. Portfolio or examples of creative briefs, ad concepts, scripts, campaigns, or performance results. Nice to Have Experience working with scaling eCommerce brands. Experience managing creative testing for Meta Ads or TikTok Ads. Familiarity with tools such as Meta Ad Library, TikTok Creative Center, Motion, Foreplay, Notion, ClickUp, Airtable, or similar platforms. Experience writing landing page copy, email copy, or product messaging. Background in copywriting, media buying, growth marketing, or brand strategy. Experience managing or mentoring creative teams. Hiring Process Portfolio / Case Study Evaluation Strategy Interview Paid Creative Test Trial Period (if applicable) One-Month Performance Evaluation Full-Time Offer Important Notes The creative test is mandatory and must be completed using original work only. Candidates may be asked to review a brand, product, competitor landscape, or existing ad account data and create sample ad concepts, hooks, scripts, or creative briefs. Depending on performance, candidates may either move directly to a full-time offer after the creative test or complete a short trial period before final evaluation. Following the one-month evaluation, successful candidates will receive a full-time offer. Engagements that do not meet expectations will conclude at that stage. If you enjoy turning customer insights into high-performing ad ideas and thrive in a fast-paced, performance-driven environment, we’d love to see your work.

Finalize Flutter Media App Part-Time Flutter/Node Developer

Global Kirtan App (GKA) is a non-denominational platform for kirtan, sacred sound, and bhakti practice, built for a global audience spanning devotional practitioners, yoga communities, sound healers, and spiritual-but-not-religious users. It's a freemium mobile app combining regular practices, audio/video streaming, a lyrics library with translations, tutorials, event discovery (map + calendar), facilitator and community profiles, and an instrument shop. This isn't a from-scratch build. A working Flutter app already exists with a live backend, and it's been through an independent technical audit — we know its real strengths and its real problems. We're looking for a developer to pick it up from here. The Role This is deliberately not a full-time position, and we can't offer at this time. What we're looking for instead is someone willing to become our standing point of contact for this codebase — available reliably when work comes in, understanding upfront that hours will vary month to month and neither side is committing to fixed employment. If you need guaranteed steady hours, this probably isn't the right fit; if you're comfortable with an ongoing, flexible working relationship and want to be the person who knows this app inside out over time, it might be exactly right. There's no guarantee here — but a developer who proves reliable and becomes a genuine fit for this project would be our first call for full-time or expanded part-time work, once we're actually in a position to offer it. First phase — roughly 20 hours: • Fix the known issues from our existing audit. • Begin work on a new Practice tool — a planned addition to the app's core navigation. Full specification shared once we've agreed terms. After that — ongoing, unpredictable: • Common maintenance tasks • Bug fixes, small feature additions, dependency and security updates, as they come up • Some months will be quiet, others busier — we're looking for someone who can flex with that rather than needing a fixed retainer Compensation Compensation is set at Indian developer market rates. Whether we structure it as hourly or fixed-per-requirement will be decided together based on what makes sense for each piece of work — we're open to either. Confirmed Tech Stack Mobile app (Flutter/Dart): flutter_riverpod (state management), go_router (navigation), dio (networking), just_audio + audio_service (media playback and session handling), youtube_player_iframe (embedded video), flutter_map, flutter_secure_storage (encrypted credential storage). Release builds use R8 obfuscation and are properly signed. Backend (as specified): Node.js + TypeScript modular monolith, PostgreSQL, versioned REST API (/api/v1/), JWT-based authentication. What We Need From You • Real, demonstrable Flutter/Dart experience — ideally including audio or media-heavy apps • Comfort inheriting and working inside an existing codebase, not just building greenfield • Honest communication about your own actual availability — we'd much rather hear "I can only do a few hours some months" upfront than have someone overcommit and go quiet later • A genuine interest in an ongoing relationship with this project, not a single ticket — we're picking a person to grow with the app, not just closing a task • Comfortable working respectfully with devotional and sacred content across multiple traditions • Willingness to sign an NDA and assign IP (Intellectual Property) ownership of delivered work to us How We'll Work • Full Git repository access, normal commit/PR discipline • We'll share our existing independent technical audit with serious applicants (under NDA) so you know exactly what you're inheriting before committing to anything • Payment structure and rate agreed in writing before the first task begins To Apply, Please Share 1. Flutter/mobile projects you've built or maintained, especially anything involving audio/media playback 2. Your honest, realistic read on your own availability over the next 6–12 months 3. Any experience picking up and maintaining someone else's existing codebase (not just building your own)

Professional Adobe Premiere Pro editor needed

PROFESSIONAL PREMIERE PRO EDITOR NEEDED FOR THREE ZAMBIA DOCUMENTARY FILMS We are looking for an experienced video editor to turn raw footage filmed in Zambia into three polished, professional films. The footage was captured by a young filmmaker during an extended work-experience placement. We need someone who can review and organise the footage, select the best interviews and B-roll, and help create a strong structure for each film. We can provide the key messages and write the linking scripts. The filmmaker can record any required voiceover once the editor has identified the best interview clips and created an initial structure. THE THREE FILMS 1. FLATDOGS CAMP BRAND DOCUMENTARY Target length: 3–4 minutes; maximum 5 minutes. Flatdogs is a safari lodge next to South Luangwa National Park. The footage includes interviews with several team members, the camp and accommodation, staff, wildlife, safari experiences and surrounding landscapes. We need an attractive, cinematic brand film that captures the people, atmosphere, wildlife and guest experience. It should combine the best interview clips with B-roll, music, natural sound, titles, branding and narration where required. It should feel warm, authentic and aspirational—not like a generic corporate video—and be suitable for the Flatdogs website, YouTube and promotional use. 2. PROJECT LUANGWA DOCUMENTARY Target length: 4–5 minutes; maximum 5 minutes. Project Luangwa is a charity supporting communities in Zambia’s South Luangwa Valley. The footage includes interviews with approximately five people, including representatives of the organisation and people who have benefited from its work. There is also B-roll of its education, community and environmental projects. The finished film should clearly explain what Project Luangwa does, who it supports, the impact of its work and why people should donate, fundraise or become involved. The editor will need to select the strongest interview content and combine it with B-roll, music, titles, branding and narration to create a positive, authentic and emotionally engaging film. 3. AFRICAN WILD-DOG COLLARING FILM Target length: approximately 1½–2½ minutes. This footage shows a wildlife-conservation operation in which an African wild dog was captured and fitted with a tracking collar. We need a short, compelling conservation film showing what happened and briefly explaining why wild dogs are collared and monitored. It should have a strong opening, a clear sequence, natural sound, suitable music, brief explanatory captions or narration and a concise ending. The animal and conservation team must be portrayed respectfully without sensationalising the operation. We would prefer a strong two-minute film to a longer version containing repetitive footage. EDITING REQUIREMENTS All three films must be edited professionally in Adobe Premiere Pro. Please do not apply if you intend to use iMovie, CapCut or another editing program. The work must include: * Review and organisation of the raw footage * Selection of the best interviews and B-roll * Collaborative story development * Professional video and audio editing * Audio clean-up and balancing * Colour correction and grading * Appropriately licensed music * Titles, interviewee names, captions and simple graphics * Subtitles where appropriate * Integration and enhancement of the recorded voiceovers * Two rounds of reasonable revisions per film * Final high-resolution 16:9 exports * Complete, editable Adobe Premiere Pro project files The Premiere Pro files must be clearly organised so the filmmaker can open them, understand how the films were constructed and make future amendments. Please include all graphics and details of any fonts, effects, plug-ins and music licences used. We can supply logos, interviewee names, background information, key messages and scripts. The filmmaker can also talk the editor through the footage. OPTIONAL EXTRAS Please quote separately for: * A 60-second social-media edit of the Flatdogs film * A 60-second edit of the Project Luangwa film * Short vertical edits of 15–30 seconds WHEN APPLYING, PLEASE PROVIDE: * Relevant examples of documentary, wildlife, conservation, travel, charity or hospitality films * A fixed price for each film individually * A discounted fixed price for all three films * Confirmation of what your quotation includes * How much raw footage your price assumes * Your estimated turnaround time * Number of revisions included * Confirmation that licensed music and editable Premiere Pro files are included * Your preferred method for transferring the footage Please do not provide only an hourly rate. We need a clear fixed-price quotation. There may be further work available if the project goes well.

opportunity

Creator & Affiliate Outreach Specialist for Mobile Apps

We are looking for a hands-on Creator & Affiliate Outreach Specialist to help grow our mobile app portfolio through relevant creators, influencers and affiliate partners. This is not a mass-email or copy-paste outreach role. We want someone who can identify creators who genuinely match the audience of the product, research them properly, find the correct contact method, create personalised outreach and help turn conversations into real partnerships. We have multiple mobile app projects, but we will start with one app and one clearly defined target audience. If the test is successful, there is potential for ongoing work across additional apps. What you would do You will: Research relevant TikTok, Instagram, YouTube and other suitable creators Identify micro, mid-size and larger creators where appropriate Assess whether each creator genuinely fits the app and audience Find verified email/contact information where possible Include creator profile links and key audience/relevance notes Identify creators who may be suitable for: paid collaborations affiliate partnerships commission-based promotion app reviews/demos UGC-style content long-term ambassador relationships Write personalised outreach rather than generic templates Contact selected creators once the approach is approved Handle initial replies and follow-ups Track outreach status and responses Highlight creators showing genuine interest Provide weekly reporting and recommendations What we do NOT want Please do not apply if your approach is based mainly on: mass automated DMs scraped lists with no relevance generic copy-and-paste messages buying influencer databases and simply exporting contacts fake followers or engagement contacting hundreds of random creators to hit volume targets promising creators fees, commission levels or commercial terms without our approval Quality is more important than volume. Paid test We will begin with a small paid test for one mobile app. For the test, we would like approximately 15–20 carefully researched creators. For each creator, please include: Creator name Platform Profile URL Approximate follower/audience size Country Niche/content focus Why they are relevant to the app Contact email or best available contact method Whether they appear better suited to paid collaboration, affiliate, UGC or ambassador outreach A personalised opening line or outreach angle Any useful observations about their content/audience We also want your recommendation on which 5 creators you would contact first and why. Actual outreach may then be included in the test or started immediately after we approve the shortlist. If the quality is strong, the role can become ongoing. When applying, please answer ALL of the following Tell us about your experience finding and contacting creators/influencers for apps, brands or digital products. Please send 2–3 relevant examples of creator or affiliate outreach work you have personally handled. How do you decide whether a creator is genuinely a good match rather than simply having a large following? Which platforms and tools do you normally use to research creators and find verified contact information? Would you personally complete the research and outreach, or would any part be outsourced? Are you comfortable writing individual personalised outreach for selected creators rather than sending the same message to everyone? How do you normally follow up with creators who do not respond? Are you comfortable handling early conversations with interested creators and then bringing serious opportunities back to us for approval? What is your fixed price for the initial 15–20 creator paid test? Does that test price include only research, or also initial outreach? How quickly can you deliver the first test? If we continue, what would you charge for: 50 researched creators 100 researched creators ongoing weekly research + outreach + follow-up Approximately how many high-quality, personalised creator outreaches could you realistically manage per week? Please confirm there will be no additional software/database costs without our approval. Important Please start your proposal with: CREATOR OUTREACH so we know you have read the full brief.

opportunity

Zendesk Help Centre & AI Agent Setup

VenoScorp is a UK-based gaming computer manufacturer and retailer (veno-scorp.co.uk), an Asus partner, selling direct to customers across the UK. We use Zendesk for customer support and want to turn years of ticket history into a proper self-serve help centre, then layer an AI agent on top to cut down repetitive tickets for both customers and staff. The problem We have thousands of historic Zendesk tickets and no real knowledge base. Every recurring question (order status, warranty, RMA/returns, build specs, shipping, troubleshooting) currently gets answered from scratch by an agent instead of being deflected by self-serve content or a bot. We want that fixed. Scope of work Phase 1 — Ticket audit & Help Centre build Review our Zendesk ticket history (thousands of tickets) and identify the most common customer and internal questions, complaints, and issues. Group these into clear categories (e.g. orders & shipping, warranty & RMA, technical support/troubleshooting, product & build specs, payments & returns, account issues). Write and structure a proper Zendesk Guide help centre from scratch: sections, categories, and articles in clear, UK-English, customer-friendly language. Cover both customer-facing content and, if useful, an internal-only section for staff (macros/process docs, common resolutions). Recommend whether any content should also live outside Zendesk (e.g. an FAQ page on veno-scorp.co.uk) and set that up if agreed. Phase 2 — Zendesk AI Agent Configure a Zendesk AI Agent (using Zendesk's native AI Agents / Answer Bot tools, or an approved alternative) that: Answers common customer questions automatically using the new help centre content. Helps internal staff quickly find answers/processes for handling tickets. Escalates/hands off to a human agent when it can't resolve something. Set up the triggers, intents, and article linking needed to make this actually deflect tickets, not just sit unused. Provide brief training/handover so our team can maintain and update it going forward. Deliverables A live, organised Zendesk Help Centre covering the top recurring ticket categories. A configured, working Zendesk AI Agent connected to that content. A short written summary of the ticket themes found and what was prioritised. Basic handover notes/documentation so we can update content ourselves after handover. Requirements Proven experience with Zendesk admin, Zendesk Guide (help centre), and Zendesk AI Agents/Answer Bot — please share examples or a portfolio. Strong written English; comfortable turning messy support tickets into clear help articles. Able to work independently, review large volumes of tickets efficiently, and prioritise the highest-impact content first rather than trying to cover everything. Bonus: experience in e-commerce, electronics/PC hardware, or gaming retail support. What to include in your proposal Relevant Zendesk help centre and/or AI agent projects you've delivered (links/screenshots welcome). Your proposed approach for triaging thousands of tickets quickly (tools, process, or scripts you'd use). A realistic timeline against the two phases above, and your fixed price for the full scope. Access We'll grant Zendesk admin/agent access to the successful freelancer for the duration of the project. NDA available on request given this involves customer data.

Senior Full-Stack Developer for Premium Marketplace Platform

We are developing the Pre-Launch MVP of a new digital marketplace for pre-owned and high-value goods and are looking for an experienced, hands-on Senior Full-Stack Developer / Technical Lead to review the existing specification and potentially build the MVP. This is not a standard e-commerce website or simple listings marketplace. The product includes custom buyer/seller workflows, structured buyer demand, seller inventory and supply connectivity, matching, private inventory, progressive item readiness, communications, notifications and administration. The scope is the Pre-Launch MVP — NOT the complete future Commercial Launch platform. The MVP will operate with real users, buyer demand, sellers and real supply to validate the marketplace before commercial transactions are activated. Pre-Launch MVP The MVP will include: • Buyer and seller onboarding • Structured and persistent buyer search/demand workflows • Seller inventory and supply connectivity • Manual and bulk inventory ingestion • Private/hidden inventory • Configurable, category-specific item information • Progressive item-data completion • Demand-to-supply matching • Seller activation/confirmation when relevant demand exists • Buyer-visible relevant opportunities • Item condition information, photos/evidence • Communications and meaningful notifications • Buyer/seller account areas • Admin and operational controls Detailed workflows and business rules are already documented and will be shared with shortlisted candidates. Technical Direction Preferred stack: Next.js / React / TypeScript Supabase / PostgreSQL API-based third-party integrations We need strong experience in complex marketplace/web applications, database architecture, authentication/permissions, Row Level Security, state-driven workflows, matching/inventory systems, asynchronous processes/webhooks, APIs, concurrency/data integrity, admin tooling, security, performance and maintainable architecture. Commercial Launch — Later Stage The complete transactional platform is not part of the immediate MVP build. Live payments/payouts, full transaction execution, independent authentication, high-value logistics, shipment insurance, refunds/disputes and related provider integrations belong to a later Commercial Launch development stage. However, the MVP must be designed modularly so these capabilities can later be added without rebuilding the core marketplace. Premium UI A professional Brand Identity and Design System will be created separately by a specialist designer. The developer is not responsible for creating the Brand Identity, but must implement the supplied Design System across the MVP to a premium production standard, including responsive desktop/tablet/mobile UI, reusable components, polished interactions and performance-conscious front-end development. Please provide examples of premium interfaces you personally implemented. First Step — Technical Review / Gap Analysis Before full MVP development is awarded, the shortlisted developer will review our detailed documentation and: • assess the architecture and requirements; • identify technical gaps, risks and dependencies; • recommend the implementation approach; • distinguish what must be built now from what only needs architectural preparation for later; • propose milestones and timeline; • provide a fixed-price quotation for the Pre-Launch MVP. We are not requesting a quotation for the complete future platform at this stage. We prefer an individual senior developer / hands-on technical lead, not someone providing only high-level advice. Please include: Relevant marketplace/workflow-heavy applications you personally built. Next.js/React/TypeScript experience. Supabase/PostgreSQL experience. Relevant matching, inventory, permissions or API experience. Premium UI examples. Whether you personally develop the project or work through a team/agency. Your approach to the initial technical review. Current availability. Confirmation that initial assessment and communication can be handled in writing through the platform. Detailed documentation will be provided only to shortlisted candidates.

opportunity

Financial Analyst / Modeler - Dynamic Forecasting Model

We are seeking an experienced Financial Analyst / Financial Modeler to build a comprehensive, dynamic 3-statement Excel forecasting model for our business including a full revenue generation forecast model. Our operations combine recurring compliance maintenance renewals, service upselling, technical file fees, and multiple construction/installation project pipelines (e.g., Height Safety, Abseil Projects, Height Access, and Direct Product Sales). We need a clean, flexible, and fully integrated financial model that connects lead conversion metrics, operational capacity, granular revenue schedules, debt servicing, and full 3-statement financial outputs. Key Responsibilities & Deliverables Multi-Stream Revenue Engine (10+ Revenue Lines) Build dynamic operational drivers for 10+ distinct revenue streams divided into two main categories: Compliance & Recurring Services: Renewal streams (e.g., Project 26, Year-1 renewals), End-of-Service-Life cycles, Technical Files, and attach/upsell logic (e.g., rust treatments, tensioners). Project & Construction Pipelines: Multi-tier project pipelines (Abseil, Height Safety, Height Access, Blinds, Consultancy, and Internal/External Product Sales). Incorporate conversion conversion rates (lead-to-opportunity, quote-to-order), sales cycle lag (days quote-to-order), and WIP (Work In Progress) revenue realization timing. Operations & Capacity Planning Model headcount requirements, qualifier/identifier ratios, and operational effort required to deliver on projected sales volumes. Full 3-Statement Model Integration Link revenue and expense drivers into a dynamic Income Statement (P&L), Balance Sheet, and Cash Flow Statement (CFS). Model working capital dynamics (Debtors/Creditors days, inventory/WIP timing). Debt & Capital Structure Schedules Build dynamic schedules for existing/new debt (principal, interest, amortization schedules) and account for specific capital transactions (e.g., intercompany loan write-downs). Best-Practice Financial Modeling Standards Adhere strictly to industry standard financial modeling conventions (e.g., FAST modeling standards: blue font for hardcoded inputs, black font for formulas, standard grid formatting). Build dynamic scenario toggles (Base, Upside, Downside) and sensitivity tables for key conversion rates and sales velocity. Required Skills & Qualifications Expert-Level Excel & Financial Modeling: Proven track record of building dynamic, multi-tab financial models from scratch for mid-market or growth businesses. Complex Revenue Modeling Experience: Expertise in modeling hybrid business models combining SaaS/recurring revenue logic with construction/contract WIP pipelines. 3-Statement Mastery: Deep understanding of accounting principles to ensure flawless balance sheet balancing and cash flow linking. Standardized Formatting: Strict adherence to clean formatting guidelines (color coding, clean tab layout, auditability, avoiding circular references). Clear Communication: Ability to translate messy operational inputs and historical data into clear logical model assumptions. How to Apply When submitting your proposal, please provide: Relevant Portfolio / Examples: 1–2 anonymized examples or screenshots of complex Excel models you have built (specifically 3-statement models, WIP pipeline drivers, or multi-stream revenue engines). Approach & Estimated Hours: A brief description of how you would structure this project and an estimated timeframe/cost to complete. Question Response: In 2 sentences, explain how you handle quote-to-order lag and WIP revenue recognition in Excel without creating circular references.