Looker Studio Automation Expert – Build Nookal ? Google Data Dashboards

GIG SUMMARY:

We’re looking for a Looker Studio, API, and automation specialist who can create automated dashboards by pulling data from Nookal (our practice management system) into Looker Studio using Google Sheets, BigQuery, Apps Script, or a custom API workflow.

If you're a data engineer-type freelancer who loves automation and analytics — this gig is for you.

WHAT WE NEED BUILT:
1. Automated Data Pipeline (Nookal ? Looker Studio)

You must be able to:
- Connect to the Nookal API
- Fetch appointments, revenue, clinician activity, services, invoices, and attendance
- Push the data automatically into Google Sheets or BigQuery
- Keep the data refreshed daily (or more often)

2. Looker Studio Dashboards

We need clean, interactive dashboards for:
• Revenue
• Utilisation & attendance
• EP/Physio/Dietetics KPIs
• SPEC / Retention / UCVA metrics
• Clinician performance summaries
• Pre-Employment Medical analytics
• NPS dashboards
• Finance (Nookal + Xero combined)

3. Automation & Error Checking

• Daily updates
• Alerts if data fails
• Clean formatting
• Smart data transformations
• Easy-to-use structure for future expansion

SKILLS REQUIRED:

- Looker Studio (advanced)
- API connections + documentation reading
- Google Apps Script or Python
- ---------- or Zapier (automation tools)
- Google Sheets (data cleaning & formulas)
- BigQuery experience is a bonus
- Data modelling + dashboard design
- Ability to propose better solutions, not just follow a list

WHAT MAKES THIS PROJECT UNIQUE:

- We don’t want manual exports — we want automation
- You’ll work directly with the CEO
- You’ll be building dashboards that influence clinical decisions
- This is not a basic VA gig — this is a data engineering + analytics project
- Ongoing work available for the right expert

DELIVERABLES:

Automated data pipeline (Nookal ? Sheets/BigQuery ? Looker)
At least 4 main dashboards completed
Documentation of your workflow
Training video for our team on how to maintain it

BUDGET RANGE:

Depending on your expertise:
?20,000–?30,000 PHP

This gig is for an expert, not a beginner.

TO APPLY, SEND:

• 2–3 examples of Looker dashboards you built
• Any API or automation projects you’ve done
• How YOU would connect Nookal ? Looker Studio
• Your quote + timeline
• Your availability for the next 4 weeks