Data Warehousing Projects

Need help with Looker Dashboard in Looker Studio

I have a file where I will need help with Looker dashboards. It is related to Phishing data.

Virtual Research Assistant - UK business research

I am looking for a reliable and detail-oriented Virtual Research Assistant to help me identify UK-based businesses that may be suitable for acquisition. Your primary task will be researching companies using Companies House and other public sources, collecting accurate business and contact information, and organising it clearly in spreadsheets. This is ongoing, long-term work for the right person. Key Responsibilities Research UK companies using Companies House Filter companies based on clear criteria (provided) Collect and record: - Company name - SIC code - Years trading / incorporation date - Director name(s) - Website - Email address - Phone number (if available) Enter all data accurately into Google Sheets Follow clear instructions and research processes Required Skills & Experience Strong web research skills Comfortable using spreadsheets (Google Sheets / Excel) Good written English and reading comprehension High attention to detail and accuracy Able to follow step-by-step instructions Reliable internet connection Willingness to learn new tools and processes Nice to have (but not required): Previous experience with Companies House Lead generation or list-building experience CRM or data-entry experience Hours & Pay Part-time to start (5–10 hours per week) Opportunity to increase hours based on performance Competitive hourly rate (based on experience) Long-term opportunity for the right candidate How to Apply (IMPORTANT) Please answer the following questions in your application: Have you done online research or list-building work before? Please describe. Are you familiar with Companies House or similar business databases? How do you ensure accuracy when collecting data? What tools have you used for research and spreadsheets? What does “attention to detail” mean to you in practice? What Success Looks Like - Clean, well-organised spreadsheets - Accurate and complete data - Minimal supervision needed over time - Consistent weekly output

opportunity

Poulry Farm/Farms Management

1. Solution Overview The solution consists of two tightly integrated components: Mobile Application for Field Officers Web Dashboard for Partners & Program Administrators Together, these components ensure reliable field data collection and meaningful insights at the policy and management level. 2. Mobile Application - Field Officers Purpose To enable accurate, verified, and offline-capable data collection during farm visits. Key Features Secure login with role-based access Offline-first functionality (data syncs automatically when online) GPS-based visit verification Timestamped inspection records Cluster and farm selection Poultry data capture: Initial bird count Current bird count Mortality numbers Feed provided and consumed Estimated weight / meat output Optional photo capture for audit support Offline Capability Full functionality without internet access Local device storage with background synchronization Sync logs to ensure data consistency and auditability 3. Web Dashboard - Partners & Administrators Purpose To provide centralized visibility, monitoring, and analytics for stakeholders. Key Features Secure web access for authorized officials Cluster-level and farm-level dashboards Data visualization for: Poultry survival rates Mortality trends Feed-to-meat conversion ratios Field officer activity tracking: GPS-verified visits Visit frequency and compliance Exportable reports (CSV / PDF - optional in MVP) 4. Key Metrics & Insights The system will track and visualize: Survival rate per farm and cluster Mortality trends over time Feed consumption vs meat output efficiency Visit compliance and verification Performance comparison across clusters 5. Data Integrity & Security To ensure transparency and trust, the platform will include: GPS validation for each recorded visit Automatic timestamps on all entries Immutable audit logs Role-based access control Centralized data validation rules 6. MVP Scope (Pilot Phase) Included in MVP Mobile application (React Native - MVP focus) Offline-first architecture GPS-based visit verification Core poultry data capture Web dashboard with visual analytics Support for 10 pilot clusters Out of Scope for MVP Advanced AI or predictive analytics Payment or subsidy disbursement Farmer self-service portal

opportunity

I need a set of illustrations in the biodiversity data space

We are seeking a talented illustrator to create a cohesive set of illustrations centered around biodiversity data, of varying complexity, all adhering to a consistent artistic style. The deadline for completion is around the end of January. Refer to the attached sample from a recent report, particularly the products in the graphic on page 4, as a preliminary guide for the desired illustrations. A detailed brief will be provided.

Quick Python Data Scraping Task (1 Hour)

I need to quickly extract structured data from a public webpage and export it to a CSV file. Scope is intentionally small and limited to a single page. Deliverables: Python script CSV output Brief explanation of approach Budget: €30 Duration: ~1 hour

Field Network Engineer

Install and uninstall network, server, and storage equipment in data center racks following standard procedures. Understand and apply rack unit (RU/U) specifications, including proper placement, spacing, airflow, and weight distribution. Identify and work with different types of fiber optic cables (single-mode, multi-mode; LC, SC, MPO connectors). Identify and work with different types of Ethernet cables (Cat5e, Cat6, Cat6a). Perform proper cable routing, dressing, and securing as per data center standards. Verify the integrity of fiber and Ethernet connections using appropriate testing and validation methods. Troubleshoot basic connectivity issues at cable, port, or device level. Execute port mapping accurately during installation and changes. Label racks, devices, ports, and cables according to documentation standards. Use console cables and tools such as PuTTY for device access and basic validation. Follow a step-by-step decommissioning process, including shutdown, disconnection, removal, and asset handling. Update installation, port mapping, and decommissioning documentation after completion of work.

Bookkeeper and Data Assistant needed for our Chicago office

We are seeking a meticulous Bookkeeper and Data Assistant to join our Chicago office. The ideal candidate will possess strong organizational skills and a keen eye for detail, ensuring accurate financial record-keeping and data management. Responsibilities include maintaining financial records, processing transactions, reconciling accounts, and assisting with data entry tasks. Proficiency in accounting software and Microsoft Excel is essential. If you are proactive, detail-oriented, and eager to contribute to a dynamic team, we invite you to submit your proposal for this exciting opportunity.

Build Automated Stock Data Pipeline (API + Sheets)

I need a solution to automate stock market data using Finnhub API. The project involves fetching real-time or scheduled stock price data through API integration, processing it using an automation workflow (such as n8n), and storing the results in Google Sheets or Excel. The workflow should be reliable, easy to maintain, and scalable for multiple stock symbols. Clean data formatting and basic validation are required. This project is suitable for a developer with experience in API integration, automation workflows, and data handling.

Project Title Zoho integration expert needed

We need an experienced Zoho systems specialist to properly configure and stabilise the integration between Zoho CRM and Zoho Inventory. The systems are not syncing as expected, and we need someone who understands Zoho architecture and how external ecommerce platforms interact with it. Shopify is part of the wider system, so the specialist must also understand how Shopify data (orders, customers, products) typically flows into Zoho environments. This issue is affecting day-to-day operations, so we are looking for a systems integration expert, not a general developer. Systems Involved Zoho CRM Zoho Inventory Shopify Additional Context Shopify is connected to Zoho, and a developer has created a custom/private Shopify app to handle certain data updates. We do not yet know whether this is affecting the Zoho CRM and Zoho Inventory sync, but it may be relevant. The priority for this project is to stabilise and correctly configure the integration between Zoho CRM and Zoho Inventory. The Shopify setup only needs reviewing if it is directly impacting this sync. What We Need Done The specialist will: 1. Review the existing connection between Zoho CRM and Zoho Inventory 2. Confirm both systems are connected to the correct Zoho organisation 3. Configure or repair the integration so that core data syncs properly 4. Check and resolve issues with: Contacts and Customers Products and Items Sales Orders and Invoices (as relevant) 5. Review field mappings and custom fields 6. Check for validation rules or workflows that could block syncing 7. Check for API or third-party app interference if relevant 8. Validate how Shopify data is flowing into Zoho and whether this is affecting the sync 9. Test the sync with live test records 10. Provide a short explanation of: What was wrong What was fixed Any configuration risks going forward We also need this done tomorrow

Mobile App Developer

ABOUT THE ROLE We are building a mobile app that merges private asset portfolio management with exclusive, automated community features. We have a functioning prototype in Lovable, but need to make it a mobile app and will need ongoing development here. We need a Moblie developer with experience using AI-tools (Cursor, etc) to take our current technical foundation and turn it into a world-class consumer experience. This starts as a contract role with a clear path to becoming a core member of the engineering team as we scale. THE PROJECT You’ll be working directly with our founding engineer to stabilize our backend, implement complex data integrations, and polish the mobile UX for an upcoming launch. - Portfolio Management: A utility where users track real-time asset values, 5-year forecasts, and ownership cost curves. - Automated Communities: A subscription-based social layer that auto-places users into niche groups based on their portfolio data and location. TECH STACK - Framework: Flutter or React Native (open for suggestions) - Backend/Data: Supabase - Tools: AI-assisted development (Cursor, etc.) for rapid iteration WHAT WE’RE LOOKING FOR - Required: - Experience shipping high-quality apps. - Ability to work with data-heavy interfaces (charts, trends, forecasts). - Experience with AI-assisted development (Cursor, etc.) to move fast and maintain high output. - High ownership: you can handle ambiguity and ship reliable code independently. - Nice to Have: - Previous experience building social features (feeds, real-time updates). WHAT WE OFFER - Starting Out: - Hourly rate based on experience. - Flexible, fully remote hours. - Direct collaboration with the founding team. - Growth Path: - The opportunity to join as a core early engineer post-raise. - Potential for equity as the team scales. - Ownership over a platform with a roadmap to hundreds of thousands of users. HOW TO APPLY Send us: - Portfolio and links to relevant Mobile App work. - Your experience with AI coding tools. - Hourly rate expectation - When you can start - Weekly availability for the next 1–2 months. - Bonus: A link to a GitHub profile or live mobile projects you’ve contributed to.

Survey Data Analysis, Reporting & Dashboard Development

I am looking for a skilled Data Analyst / Monitoring & Evaluation (M&E) specialist to support the analysis and reporting of survey data collected for an NGO-style project. The scope of work includes cleaning and validating datasets collected through tools such as KoboToolbox, performing statistical analysis, and producing clear, well-structured reports to support evidence-based decision-making. Key responsibilities include: Cleaning and validating raw survey data (Excel / CSV format) Conducting descriptive and basic inferential statistical analysis Producing summary tables, charts, and visualizations Developing an Excel or Power BI dashboard to track key indicators Writing a concise analytical report (Word/PDF) with findings and recommendations Deliverables: Cleaned and well-documented dataset Analytical report (5–10 pages) Dashboard (Excel or Power BI) Summary of key insights and recommendations Tools preferred: Excel, R or Python, Power BI, KoboToolbox The project is suitable for a freelancer with experience in data analysis, survey research, and M&E reporting. Clear communication, attention to detail, and adherence to deadlines are essential.

Help us build a excel app for a small family investment firm

Small family investment firm wants to build a tracker with reporting for managing Investments across several accounts. The work will be based in Excel, likely to need functions like the VLook-up, macros and possibly some VB plus report generation. It’s not likely to be a big piece of work - feels like a day of work really, paid hourly because it’s unclear. We have some of the tables mocked up with sample data in. Most of the work is about consolidating data from transaction logs into different views.

Grandstream IP PBX

I am seeking an experienced professional to assist with the migration of settings from a Grandstream 6104 IP PBX to a Grandstream 6304. The task involves performing a backup of the configuration from the old device and subsequently uploading this data to the new unit. Attention to detail is essential to ensure a seamless transition without loss of settings or functionality. Familiarity with Grandstream devices and their configuration processes is required. Please provide your expertise in executing this migration efficiently and effectively.

opportunity

Customise Moodle theme - New Learning (Premium Moodle Theme)

We are looking for an experienced Moodle developer to customise the “New Learning” premium Moodle theme. Prior experience working with this theme is required, as the work will involve theme-level customisation rather than basic configuration. The project will use Moodle version 5, starting with an empty database, and test data will be used during development and validation. Branding guidelines will be provided and must be followed closely. The scope includes modifying the Dashboard and Courses pages, which will require strong coding skills, as well as developing and customising pages for non-logged-in users. PLEASE DO NOT APPLY IF YOU HAVE NO WORK EXPERIENCE Moodle 'New Learning' THEME.

opportunity

Extend Existing Scraper to Extract Emails from UK Property Sites

I’m looking for a developer to extend an existing web scraper to work with UK property listing websites in the vacation rental and group accommodation space. The current scraper already: visits websites follows contact pages extracts emails What’s needed is to: 1. Crawl property listing pages 2. Collect property website URLs 3. Reuse the existing email extraction logic on those sites This is an extension of an existing codebase, not a new scraper from scratch. --- Required Skills Python web scraping experience Ability to work with an existing codebase Browser automation for JS-heavy pages Clean, repeatable scraping logic --- Data to Extract Property name or listing title Website URL Email address Phone number (optional) Location (optional) --- Target Niches Holiday lets Vacation houses Group accommodation Large holiday homes --- Expected Notes Not all properties will list emails Some sites use contact forms Output varies by website --- Deliverables Extended scraper using existing code Instructions to run it Clean output (Google Sheets or CSV) --- Notes Repository will be shared after scope is agreed No form submissions No private or gated data

Phone sales

We are seeking a skilled telemarketer to conduct phone sales and promote our electrical contracting services. The role involves utilizing our existing data, as well as sourcing additional leads independently, to effectively reach potential clients. Your primary objective will be to establish and cultivate a robust sales pipeline, fostering relationships and generating interest in our offerings. If you possess excellent communication skills, a persuasive demeanor, and a proactive approach to lead generation, we invite you to bid on this project and contribute to our growth.

Danish Image Collection (Hourly Project)

We are looking for freelancers based in Denmark to support an AI data collection project by capturing real-world images containing Danish text. This is a straightforward, guideline-based task.

opportunity

Connect recruitment admin system to Orchid-hosted website

We have a recruitment website built on the Orchid AI platform and a separate admin system hosted on Vercel. At present, job listings created or updated in the admin panel do not sync to the live website. We need a developer to connect the two systems so job data updates appear on the Orchid frontend in near real time. This can be done either by linking the admin system to the same database Orchid uses, or by building an API that the Orchid site can consume. Requirements Frontend must remain on Orchid Job listings must sync reliably and quickly Solution must be scalable and easy to maintain Skills needed Orchid AI platform experience API development and integration Vercel deployments Database synchronisation Please include relevant experience and your recommended technical approach when applying.

Hire 2 Customer Service Analysts

I want to hire two Customer Service Analysts for a remote engagement to analyze customer satisfaction data, feedback, and support metrics. The selected individuals will identify trends and insights aimed at enhancing service quality and customer experience. Key responsibilities include analyzing customer feedback, surveys, and support tickets using Excel or spreadsheets, creating comprehensive reports and dashboards that illustrate satisfaction scores and common issues, tracking essential support metrics, and identifying recurring problems while recommending actionable improvements. Weekly and monthly summary reports must be prepared, showcasing clear insights and visualized findings using basic data tools, preferably Excel charts or Google Data Studio. Ideal candidates will possess strong Excel/Google Sheets skills, experience in customer service data analysis, and a solid understanding of customer support metrics such as CSAT and NPS. The ability to discern patterns and communicate insights effectively is crucial, alongside excellent written English for report preparation. Reliable internet access and the capability to work independently are essential. This is a part-time remote freelance position, requiring 10-20 hours per week from each analyst, with ongoing contracts and monthly reviews. Compensation will be based on hourly rates or a fixed monthly price, contingent upon experience. To apply, please detail your experience with customer service analysis, outline your Excel/data analysis skills and tools utilized, provide an anonymized sample report or dashboard, and indicate your time zone and weekly availability.

Cold Email Campaign Manager – Lead Generation

Summary Cold Email Campaign Manager – Lead Generation Remote | Contract | Mid–Senior+ Compensation: Competitive (depending on level/experience) If you think most cold email fails because it’s lazy, underpowered, and terrified of complexity — we agree. We’re looking for a full-stack Cold Email Manager who can own outbound end-to-end: strategy, data, automation, deliverability, copy, and results. This is not a “write some sequences and hope” role. This is a “systems work” with measurable outcomes. What you’ll actually own: Designing and running outbound systems from scratch Building smart enrichment workflows using Clay Launching and managing campaigns in Instantly (or equivalent) Setting up and protecting deliverability (domains, inboxes, SPF/DKIM/DMARC) Automating workflows with n8n / Zapier and Slack notifications Writing cold emails that feel human — not templated Using hyper-personalisation (e.g. where someone travels for birthdays, interests, brand behaviour, context that actually matters) Tracking what counts: replies, booked calls, qualified opportunities — not vanity metrics You’ll be expected to suggest better data, better signals, and better budgets when needed. If a campaign needs higher-quality data or deeper enrichment to work properly, you won’t shy away from saying so. This is for you if: You’ve run outbound systems yourself — not just parts of them You’re fluent in Clay, enrichment logic, and data hygiene You understand deliverability well enough to fix problems, not just avoid them You’re comfortable wiring tools together (Instantly + Clay + n8n/Zapier + Slack) You enjoy testing sophisticated angles for high-value leads You’re happy pushing back when marketing is half-arsed and underpowered Bonus points if you get buyer psychology and hate “spray and pray” with a passion. Non-negotiable: Proven experience running outbound campaigns across international markets Comfortable targeting and messaging across different regions, cultures, and buyer expectations Understands that what works in one market often fails badly in another In your application response, right at the beginning, please include "reply magnet". If you’ve only ever sent outbound in a single market, this role isn’t a fit. This is not for you if: You only want to write copy You’ve never touched domain setup or inbox health You rely on generic personalisation tokens You’re uncomfortable suggesting better data, tooling, or budget when required Practical details Contract role (scope to expand) ~50–75 hours/month to start Flexible schedule, some CET overlap Competitive pay based on experience and ownership Time tracking required (clean, transparent, non-invasive)