ABOUT THE ROLE

We are looking for two hands-on dbt Developers with deep, production-proven experience across the full dbt ecosystem. This is not a querying or reporting role we need engineers who have built and owned dbt projects end-to-end in complex data environments. You will be the primary owner of the transformation layer in our AWS-based Healthcare Data Lake, responsible for modelling, testing, documentation, and semantic layer design across Member, Claims, Provider, and Clinical domains.

KEY RESPONSIBILITIES

Data Modelling
- Design and build modular, layered dbt models across Bronze / Silver / Gold (Medallion) architecture for healthcare domains: Member, Provider, Claims, Clinical, and Pharmacy.
- Apply dimensional modelling principles (Star Schema, Data Vault 2.0) to create analytics-ready data marts.
- Implement incremental materialization strategies (incremental, table, view, ephemeral) to optimize performance and cost.
- Define and enforce naming conventions, folder structure, and model hierarchy standards across the dbt project.




- Collaborate with Data Architects to ensure logical and physical models align with the enterprise data model.

Testing Data Quality
- Implement comprehensive dbt auto-testing frameworks: built-in generic tests (not_null, unique, accepted_values, relationships) and custom singular tests.
- Integrate dbt-expectations for advanced, data-quality assertions (row count checks, column-level distributions, regex patterns, freshness thresholds).
- Define and enforce data SLAs through source freshness tests and automated alerting.
- Build test coverage dashboards and maintain minimum test coverage standards across all models.
- Triage and resolve data quality failures in CI/CD pipelines; document root-cause findings.

Snapshots
- Design and implement dbt Snapshots to track slowly changing dimensions (SCDs) for Member eligibility, Provider rosters, and Plan configurations.
- Define appropriate snapshot strategies (timestamp vs. check)

📌 dbt Developer (India)
🏢 Aventus Informatics
📍 India