Key Responsibilities
Design, develop, and maintain ETL pipelines using DBT and other data integration tools.
Collaborate with data engineers, analysts, and business teams to define requirements and deliver data solutions.
Build and optimize data models (star/snowflake schemas, fact/dimension tables) to support reporting and analytics.
Write, test, and document DBT models and macros for data transformation.
Implement data quality checks, testing, and validation frameworks within DBT.
Optimize query performance and troubleshoot pipeline bottlenecks.
Manage version control (Git), deployment, and CI/CD pipelines for DBT projects.
Ensure compliance with data governance, security, and privacy standards.
Stay updated with the latest modern data stack technologies (Snowflake, BigQuery, Redshift, Airflow, Fivetran, etc.).
Required Skills & Experience
Proven experience as an ETL Developer / Data Engineer with hands-on DBT expertise.
Strong knowledge of SQL and relational databases (Snowflake, Redshift, BigQuery, PostgreSQL, etc.).
Experience in cloud data warehouses and modern ELT/ETL frameworks.
Proficiency in data modeling (Kimball/Inmon methodologies).
Familiarity with version control (Git), CI/CD pipelines, and collaborative workflows.
Understanding of data governance, security, and quality best practices.
Strong problem-solving skills with the ability to optimize and debug pipelines.