Operations Analyst / Data Reporting Specialist for US Marketing Agency

We are a US-based marketing agency working with 60+ medical clinics across the United States. We are growing fast and need someone to take complete ownership of our data, reporting, and dashboards.
You will be the person who tells leadership exactly what is happening in the business every week. You will pull data from multiple platforms, build clear dashboards, and produce reports that drive every major decision the company makes. Your work will directly determine where we invest our money, who we hire, and how we grow.
This is a high-visibility role reporting directly to the CEO.

What You Will Build and Maintain:
1. Sales Reports

Front-end close rate (by week, by month, by sales rep)
Backend close rate
Cash collected (daily, weekly, monthly)
Sales performance by rep (calls, closes, revenue, commission)
Show rates and no-show rates
Callback performance and conversion
Pipeline health and deal stage movement

2. Marketing Reports

Ad spend across all platforms
Cost per lead (CPL)
Cost per booking (CPB)
Cost per qualified showed appointment (CPQSA)
ROAS by campaign
Lead quality scores
Platform performance (Meta vs Google vs other)
Booking rates and funnel conversion
Creative performance (which ads are working)

3. Client Performance Reports

Which clinics are profitable (full P&L per client)
Which clinics are failing (early warning system)
Which clinics need attention (mid-tier requiring intervention)
Which clinics should pause or stop ad spend
Revenue generated per clinic
Patient acquisition costs per clinic
Cohort tracking (clients grouped by signup month)
Back-end collection rate per cohort

4. Operations Reports

Broken automations (which workflows are failing)
CRM errors (data integrity issues)
Attribution issues (revenue not properly tracked)
Tracking problems (pixel issues, duplicate leads)
Pipeline leaks (where opportunities are getting lost)
Duplicate leads identification
Reporting inaccuracies and data discrepancies


Required Skills:

Advanced Google Sheets / Excel (pivot tables, VLOOKUP, INDEX-MATCH, complex formulas, conditional formatting, data validation)
Experience pulling and analyzing data fro ---------- ta Ads Manager
Experience with GoHighLevel (GHL) CRM (or similar — HubSpot, ActiveCampaign)
Ability to build clear, executive-level dashboards from raw data
Strong attention to detail — accuracy is non-negotiable
Excellent written English communication
Self-directed — you will work independently and own your deliverables
Available during US Eastern or Central business hours for overlap (at least 4 hours of overlap with US 9am-5pm EST/CST)


Bonus Skills (Not Required But Preferred):

Looker Studio / Google Data Studio
Zapier or ---------- automation experience
Basic SQL
Stripe / payment processor reporting
Experience working with US clients
Background in healthcare marketing or agency operations


What Success Looks Like in This Role:
Week 1: Audit all current data sources and deliver the first weekly executive dashboard.
Week 2: Sales and Marketing reports running automated weekly.
Week 4: All four report categories (Sales, Marketing, Client Performance, Operations) running automated weekly. CEO has complete visibility into the business.
Week 8: Predictive insights — you are flagging problems before they become emergencies. You are recommending actions based on the data, not just reporting it.

Hours and Schedule:
40 hours per week. Some flexibility but you must have at least 4 hours of overlap with US Eastern or Central time daily. Weekly reports due every Monday morning US time.

To Apply:
Send a message that includes:

Your full name and location in the Philippines
Years of experience in data analysis or operations reporting
List 2-3 specific dashboards or reports you have built in past roles (briefly describe them)
Your favorite Excel/Sheets formula and why
One example of a time you spotted a data error that others missed
Your monthly salary expectation in USD
When you can start

In the subject line write: "DATA NINJA — [Your Name]"
Applications without "DATA NINJA" in the subject will be ignored. This filters out applicants who do not read job descriptions carefully.
We will respond to qualified candidates within 5 business days. Selected candidates will complete a paid trial project before final hire.

Why You Should Want This Role:
You will work for a US company that pays on time, every time. You will work with a team that respects expertise and gives you autonomy. You will build systems that actually get used by leadership to make real decisions. Your work will directly impact the success of a fast-growing business.
If you are passionate about data, organized to a fault, and want to work with a US company that treats Filipino talent as core tea ---------- mbers rather than outsourced labor — apply now.