Data Ingestion Projects
Looking for freelance Data Ingestion jobs and project work? PeoplePerHour has you covered.
featured
Implement Automated Lead Nurturing System on Zoho CRM
Company Overview We empower entrepreneurs with the fastest way to get a professional business phone system. Our SaaS platform helps small businesses build stronger customer relationships and grow their sales. We are an early stage startup focused on emerging markets. Project Overview: We need a Marketing Automation Specialist to design and execute a lead nurturing system that maximises conversions on our website. This is a high-impact, time-sensitive project leveraging Zoho CRM to deliver a seamless customer journey from first website visit to closed sale. The ideal outcome is converting website visitors to paying customers within 1-30 days, utilising a multi-channel approach (email, SMS, WhatsApp, and targeted outbound calls). Success will be measured by clear increase in website conversions. Key Deliverables & Success Indicators: - Lead Segmentation & Scoring: A lead scoring model implemented in Zoho CRM that effectively differentiates between low, medium, and high-intent leads. Clear lead segmentation criteria based on demographics, website behaviour, and other relevant factors. - Automated Nurturing Workflows:Design multi-channel campaigns (email, SMS, WhatsApp) with a focus on providing value, addressing objections, and increasing conversions. (Consider a welcome series, educational content, overcoming objections, etc.). SMS and WhatsApp should primarily be used for time-sensitive offers and re-engagement - Integrated SMS and WhatsApp messaging workflows designed to complement email campaigns and boost engagement. - Create compelling email templates and messaging aligned with each lead segment and stage in the customer journey. - Build all necessary automation sequences in Zoho CRM, ensuring seamless lead progression based on engagement. - Telesales Integration: A system to identify high-intent leads who have not converted within 24 hours. Automated process to notify the telesales team and provide them with relevant lead information - Analytics & Optimisation: Zoho CRM dashboards tracking key metrics across all channels (email, SMS, WhatsApp, telesales). Weekly optimisation reports with actionable recommendations to improve campaign performance and conversion rates.workflows. Scope of Work and Timelines Phase 1: Strategy & Setup (Week 1 - 2) - Conduct an audit of existing website analytics and CRM data. - Develop a lead segmentation and scoring model. - Design a comprehensive lead nurturing workflow, including triggers, content themes for each stage, and channel selection. - Outline the telesales integration process. - Create email templates, SMS templates, and automation sequences. Phase 2: Launch & Optimisation (Week 3) - Launch the automated campaigns. - Set up dashboards and reporting in Zoho CRM to track lead progression, conversion rates, and channel performance. - Analyse initial campaign results and suggest optimisations to improve engagement and conversion. If you interested in this Job: - Submit your portfolio highlighting Zoho CRM lead nurturing campaigns. - Include 1-2 case studies showcasing successful automation projects you've implemented. - Briefly describe your approach to segmenting leads and designing a multi-channel campaign that converts.
Help With Finalising NHS Data Security & Protection Assessment
Hello, I am the owner of a small courier brokerage that serves the healthcare sector, including NHS trusts. We are currently in the process of completing an NHS assessment for Data Security and Protection, and I am looking for a specialist who can assist us in finalising the assessment. PROJECT DETAILS Our company has made significant progress in the NHS assessment, but we require expert assistance with the following specific tasks to ensure full compliance: 1. Information Asset Register (IAR) and Record of Processing Activities (ROPA) • We need to create an IAR and ROPA. The IAR should detail where and how personal and sensitive information is held and safeguarded within our organisation. Similarly, the ROPA should provide clear insights into the types of personal data shared externally, including methods and security measures. • Both documents should be in line with current data protection legislation and reflect the latest operational realities of our business. • Templates and guidelines are available below, but professional expertise is required to tailor these to our specific operational context. https://www.digitalcarehub.co.uk/data-security-protecting-my-information/how-to-document-your-data-processing/ 2. Training Needs Analysis for Data Security and Protection • A document relating to our training needs analysis specific to data security, protection, and cyber security is required. This analysis must reflect the current requirements of our staff, including any new roles or changes in data handling processes. • The document should be prepared for annual review and approval by our designated data security officer. • A template is available below. https://www.digitalcarehub.co.uk/resource/training-needs-analysis/ REQUIREMENTS • Proven experience in data security compliance, particularly within the UK and NHS frameworks. • Familiarity with NHS data protection assessments and requirements. • Excellent documentation and communication skills. PROJECT TIMELINE We are looking to complete this project within the next 2 weeks. APPLICATION INSTRUCTIONS If you are interested in this project, please submit a proposal with the following: • A brief outline of your experience with NHS data security and protection requirements. • Your approach to ensuring compliance in a small business setting. Thank you for considering this opportunity. Martin PS: PS: Disregard the budget listed for this project; it was entered merely for placement purposes.
9 days ago14 proposalsRemoteopportunity
Data Extraction and Input
Hi all, I am looking for help to pull some price modelling data from an website and place it into an excel file that replicates how it is shown on the web page. There is a lot of data and I do not think it can be exported, it needs to be done manually. I do not think it is viable to scrape the data. Once we have pulled the data we then need to build charts / data filtering to display the data correctly. My feeling is that the freelancer that does the job will need to be an expert an MS excel. It would be easier to do a Zoom call to show the freelancer the system and explain fully what is required so the price below is a placeholder. Thanks!
22 days ago79 proposalsRemote2DVisualisation Transformations
Seeking a skilled freelancer to create visually stunning 2D visualisations for my project. The ideal candidate should have a strong understanding of design principles, typography, and colour theory, and be able to transform data into engaging and informative graphics. The visualisations should be visually appealing, easy to understand, and tailored to the specific audience. Key responsibilities: * Understand the project requirements and data to be visualised. * Create visually appealing 2D visualisations using appropriate software and tools. * Transform data into engaging and informative graphics. * Meet deadlines and production schedules.
2 days ago10 proposalsRemoteopportunity
Creating a SQL database on Google
We are a marketing agency that has built our own custom software. in the course of the upgrade, we are looking to update the location of the database from zapier tables to Google SQL database. We have 12 tables of information that we would like to be newly formatted on Google SQL. You don't need to help with the transfer of data, this would just be about making sure that the SQL database is properly set up. We need a setup of the Google SQL to be able to properly store the 12 tables worth of information, with each field having formatting rules that they would follow. What's more, we will be having AI read from this, so if the data is not properly formatted we would need a rule to revert the data to something that won't confuse the AI.
4 days ago23 proposalsRemoteopportunity
Excel Data Consolidate&CSV Formatting for Shopify Product Upload
We are looking for a skilled freelancer to assist us in consolidating data from various product ranges stored in separate Excel sheets. The task involves merging Excel sheets when necessary and pulling relevant data, such as prices, to match product codes from different sheets. The ultimate goal is to generate a comprehensive CSV file that adheres to the required template for Shopify product uploads. Some products contain variants, which requires expertise in bulk Shopify uploads to ensure accurate listing of main products alongside their variants. Key Responsibilities: - Consolidate data from multiple Excel sheets into a unified file, accommodating products and their variants. - Match product codes with corresponding prices and other essential information, maintaining consistency throughout. - Ensure accuracy and completeness of data across all product entries, including variants. - Format the final CSV file to meet the specifications of the Shopify platform for hassle-free uploading. - Validate the CSV file to verify compatibility and smooth integration with Shopify's product management system. Requirements: - Proficiency in Excel and CSV file manipulation, with a focus on managing product variants. - Experience with bulk Shopify uploads, particularly in accurately listing main products alongside their variants. - Attention to detail and precision in data entry and manipulation tasks. - Ability to meet project deadlines and deliverables effectively. - Strong communication skills to provide regular updates and address any inquiries promptly. If you possess the requisite skills and are interested in collaborating on this project, please submit your proposal detailing your relevant experience and your approach to completing the task. We welcome any portfolio samples or past projects demonstrating your expertise in data management and bulk Shopify uploads, particularly concerning product variants.
3 days ago38 proposalsRemotePower BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
12 days ago20 proposalsRemoteWeb Scraping
I have a series of projects whereby we would like to take the contact data of travel agents from membership directory websites. An example of this, is this site. https://www.abta.com/abta-member-search/results?search=London Another example is this site. https://www.etoa.org/member-search/?term=&type=&country=United+Kingdom&v_s_m=&d_s=&p_s=&c_r_l=&y_e=&c_a_p_s=&c= We need directory data extracted and ideally we would like the data to be in a spreadsheet with name, email address, telephone number, Company name etc. We have 11 websites we would like the data from. And multiple ofther projects too. Kind regards, Nicola
12 days ago73 proposalsRemoteModelling and simulation with NetLogo
I need a developer or data analyst who is skilled at creating agent-based models with NetLogo. I have an existing model which I would like to analyse and extend for optimised performance.
4 days ago9 proposalsRemoteFull stack dev
I need a good front and back end Dev to integrate 3rd party APIs like address look up and implement a server email system so we collect user data from a website form on our admin email account.
3 days ago54 proposalsRemoteA few really nice looking excle graphs
We are seeking a skilled freelancer to create visually appealing Excel graphs based on a provided dataset. The project requires the creation of 3-4 graphs, preferably stacked bar charts, to effectively present the data. The freelancer should have a strong understanding of Excel and graphic design principles to deliver high-quality graphs that meet our requirements. Attention to detail, ability to work independently, and timely delivery are essential for this project. If you have a passion for data visualization and excel, we would love to hear from you.
2 days ago21 proposalsRemoteI need B2C data for a UK area:
Sussex, population; 250,000. I need consumer/B2C email addresses for this area towards that figure - needs to be homeowners and I just need the name, address, telephone and email addresses nothing else. I will literally accept the cheapest bid...
25 days ago29 proposalsRemoteGoogle BigQuery specialist to handle data migration
Looking for a skilled BigQuery specialist to facilitate the migration of analytical data from Google Analytics into BigQuery. Namely, this involves the transfer of lifetime Google Analytics 3 data as well as the backfilling and ongoing synchronisation of Google Analytics 4 information. The selected candidate will configure BigQuery and design optimised storage schemas to preserve all pertinent metrics and dimensions from GA3 while ensuring comprehensive historical datasets from GA4. Automated scripting must also be set up to upload new GA4 data on a daily basis and implement retention policies addressing privacy regulations. Data integrity and performance are top priorities. You should demonstrate extensive experience architecting similar analytics solutions on BigQuery. The ability to future-proof the platform through an elastic data architecture and support ongoing needs as they evolve is indispensable. Please provide examples of past projects, rates, and anticipated timelines.
17 days ago15 proposalsRemoteGoogle Analytics Sales Conversion Specialist
I'm looking for an experienced Google Analytics specialist who can assist me in creating a detailed and insightful report. This report will primarily focus on our website's online sales conversion rate considering all our products and services. Key Responsibilities: - Analyze and report on website traffic data - Extensive focus on online sales conversion metrics Ideal Candidate: - Expert in Google Analytics and e-commerce - Strong understanding of sales conversion optimization - Experience in compiling and interpreting web analytics data, including user demographics. Your task is to provide the most revealing insights about how we can improve our conversion rates across all product lines and services.
16 hours ago16 proposalsRemoteControl smart relay to pull data and trigger action
Hello, We are looking for a suggestion of a smart relay unit that could be connected to take an input signal from a fire alarm relay box. It can be connected via WiFi or Ethernet. A custom script should then be made. One a signal is received, it should lookup all users from our Microsoft365 AD. It should then send a predefined text message to all the users’ mobile number using an API such as PureSMS.uk Many thanks, James
14 days ago15 proposalsRemoteWoocommerce sign up form.
I need a form on Woocommerce that captures certain information, then charges £35 to the customer and sends us the data. It also needs to not allow under 18's to complete the form.
9 days ago37 proposalsRemoteWordpress expert familiar with API and datadriven templates
We are in search of a web developer for WordPress who is familiar with the WordPress API and the concept of data-driven pages. We need page templates built which will show data from a separate system.
17 days ago90 proposalsRemoteopportunity
Scorecards and Dashboards
Im looking for somone who can create an automated scorecard and dashboard for a client. You'll need to pull data from several systems and create a good looking dashboard which updates a minimum of daily.
8 days ago45 proposalsRemoteTasks for Fundraiser
Need a professional assistant that can handle tasks such as making business related calls with some light data entry work. Outbound calls and data entey work will be for the fundraiser only. Our website is http://vacations2go.club if you want to get more information about our business.
17 days ago22 proposalsRemoteOperational Metrics Dashboard Design
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
18 days ago20 proposalsRemoteSelenium-based data scrape of targeted LI profiles
The creation of a SQL database by scraping data from ~345,000 records from LinkedIn. - Selenium scripts to capture multiple fields from LI profiles (including Summary, Role Descriptions, Dates in Roles) - The storing of the data in an SQL database - Detailed technical documentation about each script
18 days ago28 proposalsRemote