Data Analyst/Manager (Lead Generation Company)

Company: Capital Leads
Location: Remote
Schedule: Flexible 40 hours/week as long as reports are sent every 12MN Melbourne time; should overlap at least 4 hours of Melbourne time.
- Weekdays: Reports every 12A ---------- lbourne time;
- Weekends: 1-2 hours on weekends to prepare the daily midnight lead allocation report

Compensation: ---------- USD per week ( ---------- USD/month)

About Us
Capital Leads is a lead generation company based in Melbourne, Australia. We deliver high-quality leads daily to multiple clients and we’re hiring a Data Analyst & Data Manager to ensure every lead is tracked, analyzed, and assigned effectively.

Your Role
Own both data analysis and lead management, keeping client sheets accurate, ensuring no leads go to waste, and reporting clear, actionable insights.

Key Responsibilities
- Review and manage multiple client Google Sheets/CRMs to track daily lead delivery.
- Verify accuracy and identify the source campaign for each lead.
- Monitor lead dispositions (contacted, qualified, invalid, sold, etc.).
- Act as Data Manager: ensure unallocated leads are promptly assigned to the correct buyer or internal team.
- Produce a daily midnight lead allocation report showing where unassigned leads should go so the team can process them first thing in the morning. (Includes a 1 to 2-hour weekend task.)
- Prepare a daily performance summary for client sheets, including:
- Total leads sent per client and campaign
- Disposition breakdowns and key insights
- Notable trends, anomalies, and follow-up actions
- Provide data-driven recommendations to improve campaign efficiency and lead utilization.
- Maintain clear documentation and communicate updates to internal teams and management.

Qualifications
- Advanced Google Sheets/Excel (formulas, pivot tables, lookups, data cleansing).
- Proven experience in data analysis, reporting, or lead tracking.
- Exceptional attention to detail and data accuracy.
- Strong organizational and communication skills.
- Self-motivated and dependable; comfortable working with minimal supervision.
- Understanding of lead generation/digital marketing/CRMs is highly desirable.


Nice to Have
- Looker Studio, ---------- or Zapier experience
- Familiarity with GoHighLevel, HubSpot, LeadByte, or similar lead management systems.


How to Apply
If you believe you’re the right fit, please send the following:
- A link to your CV
- A short Loom video introduction - tell us about your experience in data management or analysis, especially any work related to lead generation or CRM systems.

To gauge your data management and analysis skill, please complete this small task and attach the Google sheet link in your reply.
- Duplicate this test sheet and perform the following and attach your version: ----------

1. Identify and highlight duplicate or invalid records.
2. Create a pivot summary of the following:
- Total leads per source/campaign
- Unallocated leads
- Add a brief written summary of your findings and recommendations (3–5 sentences).


We’re looking for someone who’s not just accurate, but someone who can help us with our data and help us scale and grow the business further.

P.S. Please follow instructions carefully.