Senior Data Engineer

KwikCare; Pasig; In loco; PHP 900.000 - 1.300.000; Tempo pieno

Descrizione del lavoro

KwikCare Corp. is seeking a Data Engineer to design, build and run batch and incremental pipelines from MySQL service databases, Zoho CRM, Meta Ads and other SaaS sources into a central analytics warehouse.

You will model clean tables and own data quality with tests and reconciliations, protecting PII per RA 10173 and feeding dashboards for multiple teams. You will work with backend engineers to ensure data is emitted cleanly, write runbooks, and maintain lineage and metric definitions while

Competenze

• Bachelor degree in CS/IT/Data Science or analytics.
• 3–5 years building production data pipelines.
• Strong SQL and MySQL knowledge with CDC basics.
• Python for ETL/ELT, APIs and scripting.
• Experience with cloud data warehouses and AWS services.

Mansioni

• Design, build and run batch and incremental pipelines into a central analytics warehouse.
• Model clean, documented tables for deals, customers, payments, policies, affiliates and leads.
• Own data quality: tests, freshness checks, reconciliation against source systems and alerts.
• Protect customer PII via masking, encryption and RBAC as per RA 10173.
• Feed reporting and dashboards for sales, marketing, finance and affiliates.
• Prepare reliable, PII-safe datasets for AI and automation (starting with sales workflows).
• Collaborate with backend engineers to emit clean data without heavy load on production DBs.
• Write runbooks and maintain lineage and metric definitions.

Conoscenze

SQL & MySQL

Python ETL

REST APIs

Data warehousing

Cloud platforms (AWS)

ETL orchestration

dbt

CDC

Git & CI/CD

Zoho CRM / Meta API

Formazione

Bachelor's Degree in Computer Science / IT / Data Science

Strumenti

Airflow

Dagster

dbt

Redshift/Snowflake/BigQuery

AWS (S3, IAM, Secrets Manager)

Debezium / AWS DMS

Zoho CRM / Meta Marketing API

Descrizione del lavoro

KwikCare Healthcare Plans make quality healthcare truly affordable and accessible for the modern Filipino by leveraging technology and operational efficiency, bringing comprehensive HMO coverage within reach for more Filipinos.

About the role

As a Data Engineer, you will design, build and run batch and incremental pipelines from MySQL service databases, Zoho CRM, Meta Ads and other SaaS sources into a central analytics warehouse. You will model clean, documented tables for deals, customers, payments, policies, affiliates and marketing leads, and own data quality through tests, freshness checks, reconciliation against source systems and alerts when numbers drift. You will protect customer PII through masking, encryption, role-based access and audit trails in line with the Philippine Data Privacy Act (RA 10173), and feed reporting and dashboards for sales, marketing, finance and affiliate performance.

Key Responsibilities

• Design, build and run batch and incremental pipelines from MySQL service databases, Zoho CRM, Meta Ads and other SaaS sources into a central analytics warehouse
• Model clean, documented tables for deals, customers, payments, policies, affiliates and marketing leads
• Own data quality: tests, freshness checks, reconciliation against source systems and alerts when numbers drift
• Protect customer PII: masking, encryption, role-based access and audit trails in line with the Philippine Data Privacy Act (RA 10173)
• Feed reporting and dashboards for sales, marketing, finance and affiliate performance
• Prepare reliable, PII-safe datasets for AI and automation, starting with the sales assistant and n8n workflows
• Work with backend engineers so new services emit data cleanly, without adding load on fragile production databases
• Write runbooks and keep pipeline, lineage and metric definitions documented

Qualifications

• Bachelors Degree in Computer Science, Information Technology, Data Science / Analytics
• 3–5 years building production data pipelines
• Strong SQL and solid MySQL knowledge (schemas, indexing, binlog replication) and a working understanding of change data capture (CDC)
• Python for ETL/ELT, APIs and scripting
• Hands‑on with at least one cloud data warehouse (Redshift, Snowflake, BigQuery or similar) and working knowledge of AWS (S3, IAM, Secrets Manager)
• Experience with an orchestrator (Airflow, Dagster, Prefect or similar) and a transformation tool such as dbt
• Pulling data from REST APIs with auth, pagination and rate limits
• Git, code review and CI/CD habits
• Preferred Industry: Healthcare or Life Insurance, fintech or e-commerce data experience
• Zoho CRM or Meta Marketing API integrations
• Hands‑on with CDC tools such as Debezium or AWS DMS