Holtrex B.V.

Senior Analytics Engineer / Data Engineer for E-commerce BI Project (BigQuery / dbt / Airbyte)

Please login or register as jobseeker to apply for this job.

: TYPE OF WORK

Part Time

: SALARY

$6.00 - 10.00 /hr

: HOURS PER WEEK

TBD

: DATE UPDATED

Mar 30, 2026

JOB OVERVIEW

Hi there!

I run a growing e-commerce business where around 90% of revenue and day-to-day operations are Amazon-focused. I also sell on eBay and via our own brand website, but Amazon is the core engine.

I am looking for an Analytics Engineer / Data Engineer to take over an existing BI project for my e-commerce business. My current BI freelancer has been absent for an extended period due to illness, so I am now looking for someone who can step in, understand the current setup, and complete the project.

This is not a project starting from zero. A large part of the foundation is already built. This is a hands-on build role for someone who can combine technical execution with practical business thinking. After the initial project is completed, there will be ongoing work, maintenance, and new projects. The intention is for the right person to become an embedded part of my company, not just a temporary freelancer.

CURRENT PROJECT STATUS

Milestone 1 is approximately 80% complete already.

What is already done:
• Amazon APIs are connected through Airbyte
• We use dbt on my local TrueNAS system
• Historical Amazon data has been cleaned and imported into BigQuery
• The warehouse foundation is largely in place

What still needs to be done first:
• Import the remaining Amazon ads data
• Finish an accurate P&L model
• Validate outputs against the current business logic

So I am looking for someone who can take over the project, not someone who only wants to start from zero.

BUDGET AND LONG-TERM OPPORTUNITY

For the initial project, I am offering the same pay structure already agreed for this build (see pay per milestone below). Additional contingency buffer: $500 for extra work if needed and agreed.

After the initial project is finished, there will be ongoing maintenance and new BI projects.

For that longer-term work, the hourly rate will be in the range of $6 to $10 USD/hour depending on experience, reliability, and ownership.

I am not looking for a temporary freelancer only. I want the right person to become an embedded part of my company. As the business grows, the plan is to increase hours, responsibility, ownership and pay.

CURRENT STACK

• Airbyte for ingestion
• Google BigQuery as warehouse
• dbt for transformations and KPI logic
• Looker Studio or similar for dashboards
• Google Sheets only for manual inputs where needed

PROJECT DESCRIPTION AND MILESTONES

Milestone 1: Foundation + Amazon Replacement

Timeline: ~3–4 weeks
Budget allocation: $400

• Channel-agnostic warehouse foundation
• Amazon fully implemented end-to-end (sales, ads, fees, core profit KPIs)
• dbt models as the single source of truth
• Full replacement of my current Amazon Google Sheets logic
• Side-by-side validation against existing Sheets

Milestone 2: Multi-Channel Ingestion

Timeline: ~2–3 weeks
Budget allocation: $300

• WooCommerce ingestion (orders, refunds, products)
• eBay ingestion (orders, fees, refunds)
• All channels mapped into the same schema as Amazon
• KPIs reused from Phase 1 (no duplicate logic, no redesign later)

Milestone 3: Cross-Channel KPIs and Dashboards

Timeline: ~1–2 weeks
Budget allocation: $200

• Cross-channel KPI tables (Amazon vs Woo vs eBay)
• Looker Studio dashboards built on curated dbt models
• No business logic in dashboards

Milestone 4: Product Matching, Currency and Handover

Timeline: ~1 week
Budget allocation: $100

• Product matching across Amazon, WooCommerce, and eBay
• Currency handling implemented in the warehouse
• Lightweight documentation and final walkthrough

The goal is that by the end of Phase 2, Amazon, WooCommerce, and eBay all feed into the same warehouse model, with KPIs defined once and reusable for future platforms without rework.

WHAT I'M LOOKING FOR
• Strong SQL skills
• Strong data modeling skills
• Experience with BigQuery
• Experience with dbt
• Experience with ELT / ETL pipelines
• Able to take over and improve an existing setup
• Practical and cost-conscious
• Able to explain things clearly
• Reliable and organized

NICE TO HAVE
• E-commerce analytics experience
• Amazon data experience
• Ads data and P&L experience
• Looker Studio experience
• Experience replacing spreadsheet reporting with a proper warehouse setup

NOT A FIT IF
• You are a VA or data-entry profile
• You only build dashboards
• You put business logic inside BI tools or spreadsheets
• You prefer over-engineered or expensive SaaS-heavy setups
• You only want a very short freelance project

CONFIDENTIALITY
You will have access to confidential company data, including sales data, financial data, advertising data, product data, and internal metrics.

All data, models, transformations, dashboards, and project outputs created during this work remain the exclusive property of my company.

TO APPLY, PLEASE ANSWER
1. What experience do you have with BigQuery, dbt, and Airbyte?
2. Have you ever taken over a partially completed BI or data project before?
3. How would you approach reviewing and completing an existing setup like this?
4. What is your expected timeline for finishing the remaining work?
5. What hourly rate would you want for ongoing work after the initial project?

Please keep your reply clear and concise.

Thanks in advance for your application.

Cheers,
Friso

SKILL REQUIREMENT

Data Engineering Bigquery SQL

SHARE THIS POST

Job Post	Reporter	Rank	Reason	Date

BENCHMARKS

Loading Time: Base Classes	0.0008
Controller Execution Time ( Jobseekers / Job )	0.0134
Total Execution Time	0.0148

GET DATA

No GET data exists

MEMORY USAGE

1,524,984 bytes

POST DATA

No POST data exists

URI STRING

jobseekers/job/Senior-Analytics-Engineer-Data-Engineer-for-E-commerce-BI-Project-BigQuery-dbt-Airbyte-1613118

CLASS/METHOD

jobseekers/job

DATABASE: onlinejobs (Jobseekers:$db) QUERIES: 13 (0.0083 seconds) (Hide)

0.0004	`SELECT * FROM exrates WHERE rate_name = 'USD-PHP'`
0.0004	SELECT * FROM `employer_jobs` WHERE `job_id` = 1613118 LIMIT 1
0.0009	SELECT * FROM `employers` WHERE `employer_id` = 897206 LIMIT 1
0.0008	SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 1613118 AND `misc`.`id` IS NULL
0.0005	SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-16',ej.date_added) duration_days, DATEDIFF('2026-04-16',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_jobs ej WHERE e.employer_id = ej.employer_id AND ((e.user_level >= '500' AND ej.date_added <= e.rebill_date) OR e.employer_id = '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-04-16',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1613118'
0.0003	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1613118
0.0007	`UPDATE employer_jobs SET hit_counts = '*Mar-30-2026=457Mar-31-2026=96Apr-01-2026=66Apr-02-2026=33Apr-03-2026=32Apr-04-2026=20Apr-05-2026=4Apr-06-2026=18Apr-07-2026=14Apr-08-2026=27Apr-09-2026=24Apr-10-2026=10Apr-11-2026=4*Apr-16-2026=1' WHERE job_id= '1613118'`
0.0006	`UPDATE employer_jobs SET monthly_hits = '*Mar-2026=552*Apr-2026=253' WHERE job_id= '1613118'`
0.0009	`SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1613118' AND status LIKE 'sent%' ORDER BY id DESC`
0.0003	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1613118
0.0019	SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '897206' AND `date_added` >= '2022-06-08'
0.0003	`select * from teasers`
0.0002	`SELECT * FROM skill_categories WHERE skill_cat_id=''`

HTTP HEADERS (Show)

SESSION DATA (Show)

__ci_last_regenerate	1776353022
last_page	https://v1.stage.onlinejobs.ph/jobseekers/job/Senior-Analytics-Engineer-Data-Engineer-for-E-commerce-BI-Project-BigQuery-dbt-Airbyte-1613118
csrf-token	7abac381d753a05842e64906774c47a7

CONFIG VARIABLES (Show)

base_url	https://v1.stage.onlinejobs.ph
log_threshold	2
enable_profiler
index_page
uri_protocol	PATH_INFO
url_suffix
language	english
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
composer_autoload	vendor/autoload.php
permitted_uri_chars	a-z 0-9~%.:_\=\-\+\@?\&
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
allow_get_array	1
log_path
log_file_extension
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key	OdBUArjiWg9I7u7bvAwQ7Fu35VB1kzga
sess_driver	files
sess_cookie_name	ci_session
sess_expiration	2678400
sess_save_path
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
standardize_newlines
global_xss_filtering	1
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
ojadmin	JpjZkQN5A8l@^L
salt	+UFjSAT49tPZLtmU2CIG2FYN7pRhgsWyLHgSyQa6k3I=
queue_enabled
twilio	Array ( [sid] => AC00c0594045c6eef9407e8fff01f3d467 [token] => f0bfc0b73444a077894a43f5f75e6d41 [length] => 6 [from] => +639221200200 [code_expiry_seconds] => 14400 )
maintenance	Array ( [admin] => Array ( [verification] => ) [announcement_bar] => Array ( [show_slow_issue_message] => ) )
trustpilot	Array ( [to_email] => onlinejobs.ph+3d844ebf71@invite.trustpilot.com )
services	Array ( [google_tag_manager] => Array ( [id] => GTM-T5CQMS6P ) [chatgpt] => Array ( [secret] => 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 ) [claude] => Array ( [secret] => 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 ) )
v2_url	https://v2.stage.app.onlinejobs.ph
replacemyself_secret_key	Kk1WpgTMkc4wBQOqC5rqCssdLhACKrsJeTtO1ywUkT4=
app	Array ( [app] => Array ( [command] => Array ( [map] => Array ( [OnlineJobs\Mailer\Command\SendEmailCommand] => OnlineJobs\Mailer\Handler\SendEmailHandler [OnlineJobs\Mail\Command\SendEmailCommand] => OnlineJobs\Mail\Handler\SendEmailHandler [OnlineJobs\Mail\Command\QueueEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueEmailPendingHandler [OnlineJobs\Mail\Command\QueueJobEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueJobEmailPendingHandler [OnlineJobs\Mail\Command\QueueUnapprovedEmailCommand] => OnlineJobs\Mail\Handler\QueueUnapprovedEmailHandler [OnlineJobs\Mail\Command\ProcessEmailQueueCommand] => OnlineJobs\Mail\Handler\ProcessEmailQueueHandler [OnlineJobs\Mail\Command\PutJobseekerEmailOnHoldCommand] => OnlineJobs\Mail\Handler\PutJobseekerEmailOnHoldHandler [OnlineJobs\Purchase\Command\RealEstateVaCourseCommand] => OnlineJobs\Purchase\Handler\RealEstateVaCourseHandler [OnlineJobs\Test\Command\HelloCommand] => OnlineJobs\Test\Handler\HelloHandler ) [middleware] => Array ( ) ) [providers] => Array ( [0] => OnlineJobs\Bus\BusServiceProvider [1] => OnlineJobs\Database\DbServiceProvider [2] => OnlineJobs\Mailer\MailerServiceProvider [3] => OnlineJobs\Support\SupportServiceProvider [4] => OnlineJobs\Employer\ServiceProvider [5] => OnlineJobs\Jobseeker\ServiceProvider [6] => OnlineJobs\Mail\ServiceProvider [7] => OnlineJobs\Postal\ServiceProvider [8] => OnlineJobs\Queue\ServiceProvider [9] => OnlineJobs\Courier\ServiceProvider [10] => OnlineJobs\Job\ServiceProvider [11] => OnlineJobs\Purchase\ServiceProvider ) ) )
meta	Array ( [facebook] => Array ( [input] => 1 [connect] => 2 [timezone] => 3 [url] => 30 [id] => 31 [photo] => 32 [name] => 33 [email] => 34 [review] => 35 ) [trust] => Array ( [government_id] => 4 [utility_bill] => 5 [selfie_photo] => 6 [profile_picture] => 7 [phone_number] => 8 [facebook] => 9 ) [verify] => Array ( [profile_picture] => 10 [government_id] => 11 [selfie_photo] => 12 [utility_bill] => 13 [address] => 14 [name] => 15 [reviewed] => 16 [government_group] => 28 [address_group] => 29 [mobile] => 38 ) [address] => Array ( [complete] => 17 [room_unit_no] => 20 [house_no] => 21 [street] => 22 [subdivision] => 23 [barangay] => 24 [city] => 25 [province] => 26 [postcode] => 27 ) [reviewed] => Array ( [similar_names] => 1 ) [name] => 18 [phone] => 19 [sms_verification_code] => 36 [resend_verification_code] => 37 [address_read] => 39 [first_name] => 100 [middle_name] => 101 [last_name] => 102 [edit] => Array ( [government_id_group] => 40 [address_group] => 41 [mobile_group] => 42 ) [salary_re_entry] => 103 [id_proof_recalibrate] => 104 [email] => 44 [mobile_verification_type] => 45 )
honeypot	Array ( [name_field] => my_name [enabled] => 1 )

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION	Upgrade
SERVER_PORT	80
SERVER_NAME	v1.stage.onlinejobs.ph
REMOTE_ADDR	127.0.0.1
SERVER_SOFTWARE	Apache/2.4.58 (Ubuntu)
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR	216.73.216.136
HTTP_DNT

Holtrex B.V.

Senior Analytics Engineer / Data Engineer for E-commerce BI Project (BigQuery / dbt / Airbyte)

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

SALARY

HOURS PER WEEK

DATE UPDATED

Why is this blurred?