Data Analyst — BigQuery & Looker Studio (Project-Based, Then On-Call)

Job Title: Data Analyst — BigQuery & Looker Studio (Project-Based, Then On-Call)
Type: Contract — project to start, on-call retainer after
Pay: Open to proposals — tell us your project rate and your hourly rate for ongoing changes
Location: Remote, Philippines preferred

About Us
We are a professional land surveying firm in Ottawa, Canada. We are building a reporting system so our partners can see job profitability, utilization, work-in-progress, and pipeline in real time. We have a tea ---------- mber who handles ---------- and the automated data pipeline into BigQuery. We need someone to own the analytics layer on top of it.

What We Need
This is a two-part engagement.
Part 1 — Build it
Our data is already flowing into Google BigQuery. Your job is to design the data model, write the SQL views, and build the Looker Studio dashboards our partners use daily. Core reports include job profitability with drill-down by person and phase, work-in-progress, staff utilization, AR aging, and quote pipeline.
We will work with you closely at the start to make sure you understand the business and what each report needs to show. After that we expect you to work independently and deliver.
Part 2 — Hand it over
Before this engagement closes, you must deliver a written maintenance guide — plain English, no jargon — that explains how the system works, how to update it when something changes, and how to troubleshoot common problems. This is a hard deliverable. No guide, no final payment.
After that — on-call
Once the system is live and handed over, we will contact you when we need something changed — a new dashboard, a new filter, a schema update. You quote us for the change, we approve, you do it. No retainer, no commitment on either side. We just want a reliable person we can call who already knows our system.

You Must Have

Real BigQuery experience — table design, SQL views, star schema or similar
Real Looker Studio experience — multi-page reports, calculated fields, drill-downs, blended sources
Ability to write documentation that a non-technical person can follow
Strong written English

Working hours: 8am-4pm Eastern Time (Ottawa, ON)


How to Apply

Email ---------- with your project rate, your hourly rate for ongoing work, and two or three examples of BigQuery or Looker Studio work you have done — what the data was, what the reports showed, and what your role was.
Read the whole post before applying. The first line of your application must name the Google product we use as our data warehouse. Applications that do not start with this will not be read.