About the role
We are a PR & Communications agency looking for an experienced and detail-oriented AI-driven Data Analyst or Data Automation Expert to support the structuring, categorizing, and preparing large-scale media contact databases.
We currently manage a database of approximately 60,000 contacts in LaunchMetrics, including press, VIPs, celebrities, digital influencers, and key industry professionals. Our database is organized under a highly detailed category and press beat system (geographic regions + subject typologies such as Business, Law, Society, Travel, Animals, Fashion, Decor, Diplomacy, Finance, etc.).
We want to hire a freelancer who will help us analyze, clean, categorize, and prepare data extracted from the following platforms:
• LaunchMetrics (existing data)
• Muck Rack (data export and online profiles)
• Fashion Monitor (data export)
The goal is to ensure that all contacts are appropriately categorized according to our standards, structured in clean Excel templates, and ready for bulk import into LaunchMetrics.
We want to work on a Project Fee (Fixed Price) basis, structured in clear, deliverable-based phases.
Scope of Work & Project Phases
Phase 1 – Data Structuring Audit & Pilot Batch
• Analyze a test batch of approximately 1,000 contacts from LauncMetrics and MuckRack
• Cross-reference with existing LaunchMetrics data.
• Categorize and structure them under our standard categories and press beats.
• Prepare data in our pre-defined Excel format, which is ready for LaunchMetrics bulk import.
Phase 2 – Full Data Analysis & Categorization
• Conduct full-scale categorization and cleaning of remaining contacts from Muck Rack and Fashion Monitor.
• Review editor bios, job titles, topics most covered, and article terms where available (especially from Muck Rack).
• Assign correct categories and press beats.
• Deliver fully formatted Excel files, divided by phase (country by country, or category by category).
Phase 3 – Data Deduplication & Cross-Platform Mapping
• Cross-reference LaunchMetrics, Muck Rack, and Fashion Monitor data.
• Identify and remove duplicate records.
• Ensure consistency across all platforms and create a master, clean database.
Phase 4 – AI/Automation System Proposal
• Propose anddevelop an AI-based or semi-automated system (Python scripts, Google Sheets automation, AI APIs) to facilitate ongoing categorization and data cleaning internally.
• Provide documentation and user guide.
Ideal Skills
• Proven experience with AI & Data Categorization (Natural Language Processing, Python, Machine Learning, AI APIs).
• Strong knowledge of Excel automation, data handling, and large datasets.
• Experience working with media databases, PR contacts, and editorial data.
• Ability to execute complex categorization with high accuracy and consistency.
• Attention to detail, logical data organization, and ability to work independently.
