Data Warehousing Projects

opportunity

AI OPERATIONS EXPERT

I need an AI operations expert to streamline marketing and operations across Amazon, Etsy, TikTok Shop, website, eBay, Facebook and Instagram. Clone and redeploy unified marketing assets, design automated funnels to convert social followers using chatbots and dynamic offers, monitor and optimize the AI stack (data pipelines, prompt tuning, insights), ensure brand-review compliance, enable end-to-end attribution, deliver dashboards and weekly reports, and document SOPs for junior staff.

Freelance Sales Support Assistant

I'm looking for an experienced Freelance Sales Support Assistant to support the sales team with research, data management, and coordination. What you'll do: • Research and identify potential prospects and key decision-makers • Qualify contacts and ensure they align with the Ideal Customer Profile • Manage and organise follow-up sequences to maintain engagement • Support the sales team with reporting and administrative tasks If you're organised, detail-oriented, and experienced in sales support, send me a proposal!

opportunity

Investment account recnciliation

We are looking for an experienced professional to assist with 5½ years of investment account reconciliation. The work involves reviewing and organizing statements for accounts holding securities, unit trusts, dividends, withdrawals, purchases, and loans. Key Responsibilities: Reconcile all transactions over the past 5½ years Verify and track dividend payments per security, monthly Record and summarize all withdrawals, purchases, and sales of securities Track loan amounts taken and repaid Prepare a clear, easy-to-read spreadsheet summarizing monthly cash flows and balances Identify missing or incorrect payments and inconsistencies in statements Required Experience: Proven experience working with investment accounts, securities, or brokerage statements Strong spreadsheet and accounting skills Attention to detail for long-term data reconciliation

opportunity

Sales Dashboard for 6–8 Sales Reps with Comm Forecast, Analytics

I am looking for a freelancer to build a visual and user-friendly sales dashboard for a team of 6 to 8 sales representatives. The goal is to create an informative dashboard that allows each salesperson to access their own interface and analyze their performance in a clear and practical way. The dashboard should include, at minimum, the following features: • Individual view for each salesperson • Filtering and analysis by month, year, and fiscal year • Fiscal year comparison based on an accounting period from July to June • Year-over-year comparison • Top clients • Top clients by client type • Top-selling products • Department-based organization and reporting • Ability to select a client and view all related orders • Estimated next commission calculation based on formulas already defined • Clear visual presentation with charts and graphs • Maximum readability and usefulness for business decision-making Important notes: • I already have the commission calculation rules and logic • My current data and calculations are managed in Google Sheets, including scripts • I need a freelancer who can either build directly from Google Sheets data or propose the best tech stack compatible with it • The final solution must be reliable, easy to use, and easy to update What I expect from your proposal: • Your recommended technology stack for this project • Whether you would build it directly from Google Sheets, Google Apps Script, Looker Studio, Power BI, or another solution • The estimated delivery timeline • The main project phases • Examples of similar dashboards you have already built • How you would structure user access if each salesperson needs their own view

Set up my CRM

I updated this Project, as 3/4 of the advert did not post properly, all applicants are invited to re-apply! I run a UK-based consultancy working with ~150 news publisher clients (mid-size/small digital publishers). I help them set up and manage syndication agreements with ~10 news aggregation platforms, generating monthly revenue share. I’m looking for an experienced CRM specialist to fully set up and optimise my Pipedrive account from scratch. Current Situation CRM (Pipedrive) purchased but not set up ~150 clients stored across: Microsoft OneDrive (contracts & folders) Microsoft Outlook (all communication) Key business knowledge currently in my head (not systemised) Website contact form not integrated into CRM _______________________________________ What I Need Built 1. CRM Structure & Data Migration • Import all ~150 clients into Pipedrive • Attach relevant metadata: Platforms they are on (e.g. Platform X, Y, Z) Revenue status (earning / not earning) Contract details (from OneDrive) Clean, logical pipeline structure ________________________________________ 2. Tagging & Filtering System I need to be able to easily query: “All clients on Platform X and Y” “Clients NOT on Platform A & B” “Clients not earning revenue yet” 3. Email Integration • Full sync with Outlook • All past and future communications linked to contacts • Ability to track conversations easily 4. Task & Workflow Management • Convert emails into tasks automatically • Ensure no client requests are missed • Follow-up reminders and workflows ________________________________________ 5. Platform Relationship Tracking • Track interactions with platforms as well as clients • Example: If a publisher was pitched to a platform and rejected → logged Avoid re-pitching incorrectly in future 6. Lead Capture Integration Connect to CRM from website form. Automatically create leads in Pipedrive Engagement • 5–10 hours per week initially • Potential for ongoing work Requirements (Must Provide) 1. Evidence of similar work Screenshots, case studies, or portfolio (especially Pipedrive setups) 2. 2-minute video Walk through how you would approach: Structuring the CRM Migrating data Automations 3. Additional value Tell me what I haven’t thought about that could improve: Efficiency Revenue tracking Automation Bonus (Nice to Have) Experience working with: Media companies / publishers SaaS marketplaces or platform ecosystems Ability to redesign website (future project)

Virtual Assistant (Admin & Reporting)

Job Title: Virtual Assistant (Admin & Reporting) Location: Remote Type: Ongoing / Part-Time (PeoplePerHour) Overview We are looking for a reliable and detail-oriented Virtual Assistant to support our business with weekly reporting and general administrative tasks. This is a consistent, long-term role suited to someone who is organised, efficient, and able to work independently. Key Responsibilities Compile and produce weekly reports using provided data Gather information from multiple sources and present it clearly Carry out general, non-specific administrative tasks as required Maintain accurate records and documentation Support the wider team with ad hoc tasks Requirements Strong attention to detail and accuracy Experience creating reports (Google Sheets, Excel or similar) Ability to organise and present data in a clear, structured format Good written English Reliable, proactive, and able to work without close supervision Comfortable handling repetitive and varied admin tasks What We’re Looking For Highly organised and methodical Fast and efficient with admin work Able to follow instructions and also think independently Consistent and dependable How to Apply Please include: Examples of reports you have created (if available) Your experience with admin and data handling Your availability (hours per week) Tools/software you are comfortable using This role is ongoing and will suit someone looking for stable, repeat work with clear expectations.

opportunity

WordPress / WooCommerce Development (SEO-critical + CRM)

We are looking for an experienced WordPress/WooCommerce developer to build a new website on a staging environment, based on an existing website with strong SEO performance. This is not a simple website build. The main challenge is: - preserving SEO rankings - correctly integrating a custom CRM plugin - ensuring a smooth migration and launch ______ Project context The business rents out party and decoration items. ± 2,000 products ± 40 categories Products can belong to multiple categories Clear structure, filtering and scalability are essential ______ Project Scope - Build a new WordPress/WooCommerce website on a staging environment - Use an existing theme (no need to design from scratch) - Integrate a custom-built plugin that connects a CRM with WordPress - Structure products and data based on CRM input - Prepare full migration to live environment ______ Key Functional Requirement (Important) - This is not a traditional webshop. - There is no payment / checkout process - Products are added to a quote request (cart as quotation) - Guests can submit their selected products as an inquiry/request - The “cart” functions as a quotation request system So: - No payment gateways needed - No transactional checkout ____ Key Requirements (Critical) 1. CRM Plugin Integration - Products and data must be automatically retrieved from the custom plugin - Ensure correct mapping between CRM data and WooCommerce products - Products must support multiple category assignments - Stability and performance are crucial 2. SEO Preservation (Highest Priority) This project will fail if SEO rankings drop. You must ensure: - Existing URL structure is preserved (or properly redirected) - All 301 redirects are correctly implemented - Metadata, headings, and internal linking are maintained - XML sitemap and robots.txt are correctly configured - No indexation issues during staging/live transition ______ Process & Collaboration This is a long-term, iterative project: Build → test → feedback → improve (multiple rounds) - Close communication required - You must be comfortable working in structured feedback cycles ______ Launch & Aftercare The freelancer is also responsible for: - Supporting the go-live - Monitoring the website after launch Fixing any issues related to: - SEO drops - Broken links - Plugin/data sync issues - Performance ______ We will only consider serious candidates. Please include: - Your approach - How would you handle SEO-safe migrations? - How do you ensure rankings are preserved? - Experience - Examples of similar projects are a big plus (WordPress + WooCommerce + migrations) - Experience with custom plugins / API / CRM integrations ______ Technical approach - How you handle staging → live deployment - How you test data integrity and SEO Risk management - What are the biggest risks in this project? - How do you prevent them? ______ Important Notes - Budget is fixed. - This is not a quick build: quality and stability matter more than speed! - Communication must be clear and structured - We are looking for a long-term collaboration partner. Also for maintenance in future

Need google ads expert, with knowledge of tag manager

Seeking a seasoned Google Ads specialist proficient in Google Tag Manager, conversion tracking, and analytics implementation. Responsibilities include auditing existing campaigns, configuring tags and triggers, ensuring accurate conversion and event tracking, optimizing campaign structure and bidding, and delivering actionable insights to improve ROI. Must demonstrate strong technical expertise, meticulous attention to data integrity, and experience troubleshooting tracking discrepancies across web and mobile platforms. Clear deliverables and performance-focused improvements expected.

Professional health and wellness blogs

I’m looking for a versatile blog writer who can craft polished, evidence-based articles focused on health and wellness. The tone must stay strictly professional—think clear, authoritative, and backed by credible sources—while still being engaging enough to hold a reader’s attention online. You’ll receive working titles or keywords from me; your role is to research, write, and lightly optimise each piece for on-page SEO. I expect clean formatting with logical headings, concise paragraphs, and a short meta description so I can publish with minimal edits. Deliverables • One completed blog post per brief (approx. 1,000 words unless specified otherwise) • Source list or inline citations for any data or studies referenced • SEO title, meta description, and suggested slug When you reply, please include: 1. Two samples of previous health or wellness posts written in a professional style 2. Your typical turnaround time for a 1,000-word article 3. Any questions that will help you produce the best possible content I’m ready to assign an initial article right away and hope to build a long-term collaboration if the first piece meets expectations.

opportunity

Facebook Ads & Pixel Setup Specialist

We are looking for an experienced Facebook Ads specialist to set up our Facebook Ads account, install and configure the Facebook Pixel, and create and launch one high-performing ad campaign. This role focuses on getting everything set up correctly and delivering a strong, conversion-focused campaign. We need someone who can begin quickly and have the project completed within 7 to 10 days ideally. Scope of Work: Set up and configure Facebook Ads account (if not already active) Install and correctly configure Facebook Pixel on our website/Kajabi Set up standard and/or custom events (e.g. page views, leads, purchases) Verify tracking and ensure accurate data collection Create and launch one Facebook/Instagram ad campaign Build relevant audiences (custom, lookalike, or interest-based) Advise on ad creatives, copy, and campaign structure Ensure the campaign is fully set up for optimal performance from launch Test and troubleshoot any setup or tracking issues Requirements: Proven experience with Facebook Ads setup and campaign creation Strong understanding of Facebook Pixel and conversion tracking Experience launching successful ad campaigns Ability to set up campaigns with clear structure and targeting Good communication and ability to explain setup and strategy Experience working with Kajabi or similar platforms Knowledge of funnels and lead generation strategies Familiarity with GDPR/privacy compliance for tracking and ads

Seeking Friendly Virtual Assistant for Long Term Online Support

I’m looking for a reliable, responsible, and easy-to-work-with virtual assistant to help with basic online tasks for my small business. This is stable, long-term part-time work with clear instructions and consistent hours. I’m easy to communicate with and will guide you through everything step by step. What you’ll do: - Basic online shop support - Simple administrative tasks - Data entry & light organization - Following daily instructions accurately - Consistent, reliable support What I need from you: - Fluent in English - Reliable internet & computer - Good communication - Able to work consistently long term - Positive & responsible attitude This is not complicated work. I’m looking for someone I can trust and build a long-term working relationship with. If you’re looking for stable, gentle, consistent part-time work, please send me a short proposal.

Google Merchant Manager

Seeking an experienced Google Merchant Center manager to optimize and maintain our product feed, troubleshoot disapprovals, implement best practices for feed quality, and enhance product visibility across Google Shopping. Responsibilities include feed mapping and optimization, structured data validation, policy compliance, performance monitoring, and conversion-focused recommendations. Ideal candidate will demonstrate proven Merchant Center experience, strong analytical skills, and a track record of improving ROAS and feed health. Ongoing collaboration with our marketing team is required.

MSA for Manchester MSP: UK Contract Law Specialist Required

We are a newly established Managed Service Provider (MSP) based in Manchester. As we launch our operations, we require a professional, legally-sound Master Service Agreement (MSA) to serve as our foundational contract for all future client engagements. Scope of Work: Because we are a new entity, we need a comprehensive "from-scratch" agreement governed by the laws of England & Wales. It must cover: Framework: How we will attach future Statements of Work (SOWs). Liability: Robust protection regarding cybersecurity, data loss, and professional indemnity. Compliance: Full UK GDPR alignment. Future-Proofing: Non-solicitation of staff and RPI-linked price increase clauses. Budget & Bids: Our listed budget is £200, but this is a placeholder. We are looking for quality and protection above all else. We will review all bids case-by-case—please bid what you feel is fair for a bespoke, high-quality document. Requirements: Strictly UK-based freelancers only. Experience with IT/MSP contracts is mandatory.

Social Media Manager

Seeking an experienced Social Media Manager with a strong editorial sensibility aligned with high-fashion and luxury branding. This role is responsible for developing and executing sophisticated content strategies, curating visually compelling assets, and managing Pinterest, Instagram, and Facebook with a consistent, elevated brand voice. The ideal candidate demonstrates proven expertise in audience growth, engagement optimization, trend-aware curation, and performance analytics. This role requires both creative direction and data-driven decision-making to strengthen brand positioning, expand reach, and drive meaningful engagement across all platforms.

Prospect Intelligence Analyst | Research Assistant

ROLE OVERVIEW Our firm helps small service businesses in the US and UK identify and fix operational revenue leaks — the gaps that cause them to lose enquiries and bookings without realizing it. You sit at the front of our Prospect Machine. Each week you research small businesses, identify their primary revenue leak, score them, enrich decision maker contacts, and populate our structured prospecting tracker. Your output feeds directly to our Cold Caller and Business Systems Consultants. This is not a data entry role. It requires pattern recognition, fast decision-making from limited information, and the discipline to work at consistent pace to a fixed weekly deadline. CORE RESPONSIBILITIES • Source 150–200 raw businesses per week using scraping tools provided by company • Filter to 120–150 qualified SMBs • Review each business's online digital presence — website, booking system, social pages, and online reputation — and conduct test calls outside office hours to assess missed call risk and after-hours responsiveness. Identify the primary operational revenue leak based on what the evidence shows • Find and verify the decision maker via enrichment tools provided by company • Score each lead, flag Priority Leads, and escalate leads immediately • Populate the B2B Prospecting Tracker • Submit all deliverables via agreed upon platform and time. Onboarding Ramp Week 1— 50–60 leads, research and tracker only. Full SOP and training provided. Quality standards apply from day one. Week 2 onwards — Cold call script prep for top 20 Priority Leads added. Week 3 onwards — Industry community and directory identification added. REQUIREMENTS • Experience in B2B lead research, business intelligence, or structured data research • Able to make fast, confident decisions from publicly available data • Strong attention to detail — accurate entries matter more than perfect ones • Comfortable following a structured SOP independently, without frequent check-ins • Clear written and spoken English, with prompt communication COMPENSATION & STRUCTURE • $17.00/hr · 15 hrs/week · ~$255/week • Performance review at 45 days — rate increase available for strong performers HOW TO APPLY Begin your application with the word SIGNAL — applications that don't will not be reviewed. Then answer these two questions: 1. Describe a research or data project where you worked to a consistent weekly output target. What tools did you use and what was your weekly volume? 2. You're researching a dental practice. Their website has no online booking system — new patients are instructed to call during office hours only. There is no contact form and no alternative way to enquire outside of calling. In two to three sentences: identify the primary revenue leak, explain why it matters commercially, and give this lead a score out of 10 with a one-sentence justification. Note Question 2 has a clear correct answer. We are looking for specific, evidenced reasoning — not a general description of the problem.

I need an admin assistant who specialize in HR and payroll

Seeking an administrative assistant who specializes in professional HR and payroll to support an ongoing project. This role is critical for maintaining accurate employee records, ensuring compliance, and streamlining our internal processes. Key Responsibilities: Payroll Support: Assist with the preparation and verification of timesheets, payroll data entry, and reconciliation to ensure accuracy before processing. HR Administration: Maintain and update employee files (digital), manage onboarding documentation, and assist with offboarding checklists. Compliance: Help track mandatory training, certifications, and leave balances to ensure company compliance. Reporting: Generate routine HR and payroll reports as needed. Ideal Candidate: Proven experience with payroll software (e.g., QuickBooks, Gusto, ADP) and HRIS systems. Reliable communicator available for ongoing, consistent support.

opportunity

Touch controlled fiber optic lighting system

ouch sensor array → AI translation layer → fiber optic light control system. I've got the concept mapped out and will handle all materials procurement. Need someone who can turn this into working hardware in person. Technical requirements: • Pressure/capacitive touch sensor integration • Arduino/microcontroller programming for sensor data processing • Machine learning model deployment (edge computing preferred) • Fiber optic LED driver circuits • Real-time response optimization The system needs to translate touch patterns and pressure variations into corresponding fiber optic light behaviors. Think responsive surface that learns user interaction patterns over time. I'll provide: - All hardware components and materials - Technical specifications and design requirements - Project timeline and testing protocols Looking for: - Arduino/embedded systems expertise - Experience with sensor arrays and LED control - Ability to work in Canary Wharf area - Interest in human-computer interaction projects This is part of ongoing research into bio-responsive interfaces. Good opportunity for someone who wants to work on cutting-edge HCI applications.

opportunity

EU Biocide Registration Consultant

About the company We are a small UK retailer of swimming pool water treatment chemicals. We are expanding our European operations and require a specialist consultant to manage the biocide registration process for our chlorine-based products across four EU member states. The role We are looking for an experienced EU biocide regulatory consultant to manage and submit national marketing authorisation applications for three swimming pool disinfectant products across Belgium, Poland, Spain, and the Netherlands. You will take full ownership of each country application, from dossier preparation through to submission and authority liaison, working directly with our internal team. Products SDIC Granules — Sodium Dichloroisocyanurate Dihydrate (UN3077, PT2) Multifunctional Tablets — TCCA + copper sulphate pentahydrate + boric acid (UN3077, PT2) Stabilised Chlorine Tablets — Trichloroisocyanuric Acid / TCCA (UN1479, PT2) All active substances are included in the EU BPR Review Programme (IIAHC notifications). Our active substance supplier is confirmed on the ECHA Article 95 list. Scope of work Belgium Registration via Gestautor system. French and Dutch bilingual label. Restricted or full evaluation depending on authority assessment. Poland Formal application to URPL. Polish-language label and SDS required. Efficacy data and sworn translations needed. Spain Full BPR national authorisation via Ministerio de Sanidad. ES/MR number required. ENAC-accredited efficacy data required. Netherlands Full dossier submission to Ctgb under transitional law. Full risk assessment required. Dutch-language WG/GA and label. IIAHC Letter of Access may be available. Responsibilities 01 Review existing documentation (SDS, labels, IIAHC letter, Article 95 confirmation) and identify any data gaps per country 02 Prepare complete application dossiers for each country in compliance with applicable national and BPR requirements 03 Submit applications to Gestautor (Belgium), URPL (Poland), Ministerio de Sanidad (Spain), and Ctgb (Netherlands) 04 Liaise with competent authorities on any requests for additional information and manage the application through to decision 05 Advise on efficacy testing requirements and coordinate with our manufacturer to obtain or commission required EN-standard test certificates 06 Provide regular progress updates to our internal team throughout the process Essential requirements +Demonstrated experience submitting biocidal product applications under BPR Regulation (EU) 528/2012 in at least two of the four target countries +Strong working knowledge of EU national transitional procedures under Article 89 BPR +Familiarity with PT2 disinfectant products and associated efficacy testing requirements (EN 1276, EN 13623 etc.) +Experience working with Gestautor (Belgium) and/or Ctgb submissions (Netherlands) +Ability to prepare or coordinate multilingual label and SDS requirements +Excellent written English; additional languages (French, Dutch, Polish, Spanish) are an advantage Desirable -Background in pool, water treatment, or chlorine chemistry -Knowledge of IIAHC dossiers for chlorinated isocyanurates and Letter of Access procedures -Experience resolving Amazon EU marketplace biocide compliance issues -Understanding of mutual recognition procedures for extending authorisations to additional EU markets What we will provide -Completed translated labels for all four countries -English-language SDS for all three products and translations if required -Article 95 Letter of Supply from manufacturer -Any available efficacy test certificates from manufacturer -Payment of all government application fees on top of your consultancy fee Contract details Type Contract / freelance Location Fully remote Duration Project-based, 6-12 months Rate Competitive, based on experience How to apply Please apply with a brief covering note outlining your experience with biocide registrations in the relevant countries, examples of similar projects you have completed, and your day rate or project fee estimate. Applications without relevant EU biocide registration experience will not be considered.

BrandDiscovery&Strategy

Market research (industry trends,customer needs), competitoranalysis (positioning, pricing,strengths), SWOT analysis(internal/external factors),positioning statementdevelopment, brand storycreation, messaging framework (3-5 key messages per audience), toneof voice guidelines(formal/technical/innovativetraits) As this is a Mechanical enginering industry of manufacturing | trading of Aerospace | Hydraulic | general engineering components. Market local : Bangalore, India ambition on global market as well. If you are having the mechanical engineering experience show case sample refereces attach in your proposal. Data reliability and clarity of our presentation. Post submission support details as well.

Hubspot Experts to setup one time

HubSpot Mastery: Own the Marketing Hub. You’ll build automated workflows, manage lead segmentation, and ensure our CRM data stays clean and actionable. The Weekly Newsletter: Lead the end-to-end production of our flagship weekly newsletter. This includes curation, copywriting, layout design, and A/B testing subject lines for maximum open rates. Content Calendar Management: Develop and maintain a rolling Content Calendar. You’ll coordinate topics across blog, social, and email to ensure we never miss a beat and our messaging stays consistent. Campaign Automation: Build "set-and-forget" nurture sequences that turn new subscribers into warm leads without manual intervention. Configure country specific engagement