9 days ago
Ho Chi Minh City, VietnamMid Level
Responsibilities
- Model assigned business domains in dbt Core through layered staging, intermediate, and tested mart models.
- Partner with Product Analysts to translate business definitions and questions into correct, documented, and tested data models.
- Build tested marts that support certified business metrics.
- Prove value parity between dbt marts and the legacy stored procedures they replace using recorded row counts and key aggregates.
- Own and evolve dbt layer standards, normalization rules, source paths, and enforcement scripts.
- Declare primary keys and write tests that detect model failures and data-quality issues.
- Repoint consumers from legacy procedure outputs to dbt models and record each cutover for auditability.
- Collaborate with Data Engineering teammates to keep production dbt builds and parity tracking on schedule.
- Review pull requests for owned production models within one working day.
- Work with cross-domain analysts and engineers when models meet at business-domain boundaries.
Requirements
- 3+ years of analytics engineering or data engineering experience with production ownership of transformation models.
- Expert SQL skills including window functions, common table expressions, and multi-entity warehouse-scale joins.
- Strong SQL Server and T-SQL experience, plus working fluency in PostgreSQL.
- Hands-on experience building and maintaining dbt projects, including models, layers, references, tests, and documentation.
- Strong dimensional modeling judgment, including defining model grain, selecting keys, and placing logic in the correct layer.
- Experience with Git-based workflows, pull requests, CI checks, and code review practices.
- Python experience for tooling around data models.
- Ability to read legacy stored procedures, understand the business questions they answer, and identify discrepancies with documentation.
- Ability to work directly with Product Analysts and explain modeling trade-offs in business terms.
- Attention to data-boundary issues such as joins that silently produce no matches.
- Preferred experience with Azure PostgreSQL, Elastic Cluster, Microsoft Fabric Warehouse, OneLake, or another Delta lakehouse.
- Preferred experience supporting warehouse platform migrations.
- Preferred experience migrating stored procedures or warehouse SQL into dbt or a similar transformation framework.
- Preferred Airflow or comparable orchestration experience.
- Preferred experience with data-quality, lineage, parity, or audit tooling.
- Preferred experience authoring standards or tooling adopted by other engineers.
Tech Stack
Categories
Data Engineering
About OPSWAT
OPSWAT builds cybersecurity software for critical infrastructure, delivering malware prevention, content disarm and reconstruction, secure file transfer, and device access control across IT, OT, and ICS environments. It sells enterprise software and SaaS platforms to public- and private-sector organizations worldwide. Founded in 2002 and headquartered in Tampa, Florida, the privately held company is used in regulated industries such as energy, government, and finance.