Data Engineer Sr (DBT)

Roles & Responsibilities • Design and implement staging, core, and mart layers using standard dbt patterns and folder structures. • Develop and maintain dbt tests (schema tests, data tests, custom tests) to ensure data quality and integrity. • Implement snapshots, seeds, macros, and reusable components where appropriate. • Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently. • Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs. • Participate in performance tuning of dbt models and Snowflake queries. • Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations. • Contribute to documentation of dbt models, data lineage, and busine