Lion Fountain LLC.

OMG!! NEEDED NOW!! Data Engineer – PostgreSQL, Python & Warehouse Pipelines – Fast Growing Marketing CANADIAN Company

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

: TYPE OF WORK

Part Time

: SALARY

1200

: HOURS PER WEEK

25

: DATE UPDATED

Aug 3, 2026

JOB OVERVIEW

Hey there! I'm looking for a HIGHLY TEACHABLE (Willing to Learn) mid-level Data Engineer with excellent written English to build and maintain the data pipelines and warehouse logic underneath our client dashboards.

In the beginning, this is an on-call/part-time job, but it can grow into a full-time role where you'll own more of the data layer if you prove to be a great fit.

Watch this video to learn more about how our agency works and to also see my personality and style:
---------- /share/b301319feb524d55acb8eacb631cb7c1?sid=b843a7e2-95d ---------- a0-51b42598f74f

---

ABOUT YOU:

• Great communicator in writing
• Detail-oriented and structured
• Extremely reliable
• Positive, no-excuse attitude
• Validates your own work against live data before reporting it done
• Comfortable saying "I do not know yet" instead of guessing

---

IMPORTANT – SCREENING PROCESS:

Our hiring process includes two stages:

Stage 1 – Initial Technical Screening (Unpaid)
Selected applicants may be asked to complete a short, time-bounded screening exercise (approximately 15–20 minutes). This screening is designed to assess problem-solving approach and technical reasoning only. It does not require production-ready code, live system access, or work that will be used operationally. Submissions are used solely for evaluation.

Stage 2 – Final Technical Assessment (Paid)
Candidates who advance past Stage 1 may be invited to complete a structured, time-limited technical assessment using a controlled sample dataset created specifically for evaluation purposes. Final assessment submissions must include a Loom video walkthrough explaining the candidate's approach, reasoning, and implementation decisions.

This stage:

• Is paid at a fixed rate upon written acceptance
• Requires submission of both the technical output and Loom video walkthrough
• Is clearly defined and time-bounded
• Is designed solely to evaluate technical ability
• Is not connected to live client systems or production work

---

KNOWLEDGE REQUIRED:

• Strong PostgreSQL: window functions, CTEs, query plans, indexing. You should be able to explain why a query is slow and prove it from the plan
• Python for data work: requests, pandas or equivalent, and the discipline to write something that runs unattended
• Experience building pipelines that sync from third-party APIs into a warehouse, and fixing them when a vendor changes something without telling anyone
• Regex and parsing logic for messy real-world data, tested against the real data and not against what you assume it looks like
• Comfort running benchmarks and migrations against tables in the tens of millions of rows

Bonus:

• dbt, Airflow, or similar orchestration
• n8n
• Grafana or BI tools
• Experience with a CRM or ad platform API
• Healthcare data

---

ABOUT ME (Alex):

• CEO with over 20 years of experience in digital marketing
• I move very fast and expect the people I work with to operate with clarity and discipline
• I reward performance and reliability
• I run the company remotely and am located in Indonesia

---

ABOUT THE POSITION:

We run attribution and KPI infrastructure for clients in healthcare and automotive. Our warehouse joins ad platforms, call tracking, CRM, and practice management systems into one picture of what a marketing dollar actually produced.

This is not a dashboard job and it is not a reporting job. You will work on the pipelines underneath them. Your role will include writing and optimising warehouse SQL, building and maintaining Python sync pipelines, running benchmarks and migrations against live data, and investigating discrepancies to root cause. When two systems disagree, you find out which one is wrong and why.

Work will be assigned in clearly defined task blocks with specific deliverables and validation criteria.

---

ABOUT THE COMPENSATION:

We offer DAILY PAYMENTS on a task-by-task basis through WISE, ensuring timely and efficient compensation for your work.
We pay bonuses for great work – we reward results.
13th-month bonus for candidates who qualify for a full-time position.

---

HOW TO APPLY:

Send an email with the subject line: Awesome Backend Developer
Include your resume

In your email, answer this: A weekly audit compares two systems and reports a 4% match rate. The documented expected match rate is 96%. Someone has already checked that both systems have data for the period and that the join key exists on both sides. What are the first three things you check, and in what order? Tell me what would make you conclude the audit itself is wrong rather than the data.

Congratulations! You made it to the end, so what are you waiting for?
Please email me at: ----------

SKILL REQUIREMENT

Python SQL PostgreSQL

SHARE THIS POST

Job Post	Reporter	Rank	Reason	Date

BENCHMARKS

Loading Time: Base Classes	0.0008
Controller Execution Time ( Jobseekers / Job )	0.0466
Total Execution Time	0.0479

GET DATA

No GET data exists

MEMORY USAGE

1,527,744 bytes

POST DATA

No POST data exists

URI STRING

jobseekers/job/OMG-NEEDED-NOW-Data-Engineer-PostgreSQL-Python-Warehouse-Pipelines-Fast-Growing-Marketing-CANADIAN-Company-1687559

CLASS/METHOD

jobseekers/job

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

0.0003	`SELECT * FROM exrates WHERE rate_name = 'USD-PHP'`
0.0003	SELECT * FROM `employer_jobs` WHERE `job_id` = 1687559 LIMIT 1
0.0008	SELECT * FROM `employers` WHERE `employer_id` = 245983 LIMIT 1
0.0011	SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 1687559 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-08-08',ej.date_added) duration_days, DATEDIFF('2026-08-08',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-08-08',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1687559'
0.0008	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1687559
0.0006	`UPDATE employer_jobs SET hit_counts = '*Jul-12-2026=230Jul-13-2026=252Jul-14-2026=87Jul-15-2026=52Jul-16-2026=20Jul-17-2026=24Jul-18-2026=15Jul-19-2026=27Jul-20-2026=23Jul-21-2026=18Jul-22-2026=17Jul-23-2026=4Jul-24-2026=18Jul-25-2026=13Jul-26-2026=659Jul-27-2026=223Jul-28-2026=73Jul-29-2026=50Jul-30-2026=41Jul-31-2026=45Aug-01-2026=36Aug-02-2026=18Aug-03-2026=372Aug-04-2026=62**Aug-08-2026=2' WHERE job_id= '1687559'`
0.0005	`UPDATE employer_jobs SET monthly_hits = '*Jul-2026=1891*Aug-2026=490' WHERE job_id= '1687559'`
0.0012	`SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1687559' 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` = 1687559
0.0340	SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '245983' 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	1786220500
last_page	https://v1.stage.onlinejobs.ph/jobseekers/job/OMG-NEEDED-NOW-Data-Engineer-PostgreSQL-Python-Warehouse-Pipelines-Fast-Growing-Marketing-CANADIAN-Company-1687559
csrf-token	4dc3bbaab97823bef40ae6dfb4ae02c6

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.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.227
HTTP_DNT

Lion Fountain LLC.

OMG!! NEEDED NOW!! Data Engineer – PostgreSQL, Python & Warehouse Pipelines – Fast Growing Marketing CANADIAN Company

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

TYPE OF WORK

SALARY

HOURS PER WEEK

DATE UPDATED

Why is this blurred?