ทักษะ:

Flowaccount, SQL, Amazon AWS

ประเภทงาน:

งานประจำ

• Build and maintain ELT pipelines from operational databases (SQL Server) and domain events (RabbitMQ) into Redshift.
• Write and maintain dbt models and tests; own data-quality checks and freshness SLAs.
• Work in AWS: S3 (staging/lake), Glue/DMS for ingestion, Lambda/Step Functions for orchestration, CloudWatch for monitoring.
• Consume and reason about domain events (e.g. JournalEntryCreated-style events) not just batch table dumps.
• Participate in on-call rotation for pipeline/data incidents.
• Mid (3-5 years).
• Implement pipelines and dbt models to a given design spec.
• Maintain and extend existing Redshift schemas.
• Handle defined CDC jobs and respond to data-quality alerts.
• Senior (6+ years) in addition to the above.
• Own warehouse schema/model design (star/snowflake, SCD strategy, partitioning, dist-key/sort-key strategy for cost and performance).
• Define data contracts with backend/DDD service owners event schema versioning, breaking-change policy, deprecation process.
• Own the data-quality/SLA framework end-to-end, including DLQ handling for failed event consumption and incident runbooks.
• Make build-vs-buy calls on orchestration tooling; mentor Mid-level engineers.
• New-Data Intake (how this role interacts with Analytics Engineering).
• Receive data requirement specs from the Analytics Engineer (what event, what fields, why).
• Determine whether the source data already exists upstream (product/backend event) or needs new instrumentation coordinate with the owning backend team if instrumentation is needed.
• Build/extend the ingestion pipeline and warehouse schema to land the new data.
• Hand off to Analytics Engineering once the data is queryable.
• You own how new data gets into the warehouse. Analytics Engineering owns what data is needed and why.
• Strong SQL (Redshift or another columnar/MPP warehouse).
• Python or Spark for pipeline/transformation work.
• Experience with dbt and an orchestrator (Airflow, Dagster, or equivalent).
• Experience with streaming/event-driven ingestion (Kafka, Kinesis, MSK, or RabbitMQ), not just batch ETL.
• Familiarity with AWS data services (S3, Glue, Lambda, Step Functions).
• (Senior) Track record owning data-model design and cross-team data contracts.
• Preferred.
• Experience with CDC tools (DMS, Debezium).
• Experience handling PII/financial data under a compliance regime (PDPA or equivalent) including tenant/row-level isolation in a multi-tenant warehouse.
• Prior experience in a DDD/microservices backend environment.
• What We Offer.
• Build products used by tens of thousands of businesses.
• Ship code that reaches customers quickly.
• High ownership with minimal bureaucracy.
• Learn from experienced engineers and product leaders.
• Flexible work hours and 45 days/year work from anywhere.
• Competitive compensation, health & accident insurance from day one.
• 17-19 public holidays, 12 personal leave days, and 8 annual leave days.
• A friendly, collaborative team that genuinely enjoys building together.
• Clear opportunities to grow your career as the company scales.
• BKK BangRak Office (MRT Samyan or BTS Saladaeng).
• Work with a modern tech stack | Impact thousands of users | Collaborative, growth-oriented team.

ทักษะ:

Flowaccount, SQL, Amazon AWS

ประเภทงาน:

งานประจำ

• Build and maintain ELT pipelines from operational databases (SQL Server) and domain events (RabbitMQ) into Redshift.
• Write and maintain dbt models and tests; own data-quality checks and freshness SLAs.
• Work in AWS: S3 (staging/lake), Glue/DMS for ingestion, Lambda/Step Functions for orchestration, CloudWatch for monitoring.
• Consume and reason about domain events (e.g. JournalEntryCreated-style events) not just batch table dumps.
• Participate in on-call rotation for pipeline/data incidents.
• Mid (3-5 years).
• Implement pipelines and dbt models to a given design spec.
• Maintain and extend existing Redshift schemas.
• Handle defined CDC jobs and respond to data-quality alerts.
• Senior (6+ years) in addition to the above.
• Own warehouse schema/model design (star/snowflake, SCD strategy, partitioning, dist-key/sort-key strategy for cost and performance).
• Define data contracts with backend/DDD service owners event schema versioning, breaking-change policy, deprecation process.
• Own the data-quality/SLA framework end-to-end, including DLQ handling for failed event consumption and incident runbooks.
• Make build-vs-buy calls on orchestration tooling; mentor Mid-level engineers.
• New-Data Intake (how this role interacts with Analytics Engineering).
• Receive data requirement specs from the Analytics Engineer (what event, what fields, why).
• Determine whether the source data already exists upstream (product/backend event) or needs new instrumentation coordinate with the owning backend team if instrumentation is needed.
• Build/extend the ingestion pipeline and warehouse schema to land the new data.
• Hand off to Analytics Engineering once the data is queryable.
• You own how new data gets into the warehouse. Analytics Engineering owns what data is needed and why.
• Strong SQL (Redshift or another columnar/MPP warehouse).
• Python or Spark for pipeline/transformation work.
• Experience with dbt and an orchestrator (Airflow, Dagster, or equivalent).
• Experience with streaming/event-driven ingestion (Kafka, Kinesis, MSK, or RabbitMQ), not just batch ETL.
• Familiarity with AWS data services (S3, Glue, Lambda, Step Functions).
• (Senior) Track record owning data-model design and cross-team data contracts.
• Preferred.
• Experience with CDC tools (DMS, Debezium).
• Experience handling PII/financial data under a compliance regime (PDPA or equivalent) including tenant/row-level isolation in a multi-tenant warehouse.
• Prior experience in a DDD/microservices backend environment.
• What We Offer.
• Build products used by tens of thousands of businesses.
• Ship code that reaches customers quickly.
• High ownership with minimal bureaucracy.
• Learn from experienced engineers and product leaders.
• Flexible work hours and 45 days/year work from anywhere.
• Competitive compensation, health & accident insurance from day one.
• 17-19 public holidays, 12 personal leave days, and 8 annual leave days.
• A friendly, collaborative team that genuinely enjoys building together.
• Clear opportunities to grow your career as the company scales.
• BKK BangRak Office (MRT Samyan or BTS Saladaeng).
• Work with a modern tech stack | Impact thousands of users | Collaborative, growth-oriented team.