Job Description Data Warehouse Modeling & DBT Expert
Role: Data Warehouse Modeling & DBT Expert
Experience: 48 years
Hiring mode- Permanent
Working mode-Hybrid or Remote(They are required to work from the office for 5 days during onboarding and for 5 days each quarter)
Notice period- Immediate
Job Summary
A skilled professional with strong expertise in both data warehouse modeling and modern data transformation using dbt (data build tool). The ideal candidate will be responsible for designing scalable data models and implementing efficient ETL/ELT pipelines to support analytics and reporting needs.
Key Responsibilities
Design and implement scalable data warehouse models (star, snowflake schemas)
Develop and maintain fact and dimension tables aligned with business requirements
Build and manage data transformation pipelines using dbt
Translate business requirements into well-structured, reusable data models
Implement data validation, testing,
and documentation within dbt
Optimize SQL queries and transformations for performance and scalability
Collaborate with stakeholders, data engineers, and analysts for data requirements
Ensure data quality, consistency, and governance standards
Integrate dbt workflows into CI/CD pipelines and version control systems
Required Skills
Solid experience in data warehouse design and dimensional modeling
Hands-on expertise with dbt (data build tool)
Advanced SQL skills for large-scale data transformation
Experience working with cloud data warehouses (Snowflake, BigQuery, Redshift, or Azure Synapse)
Solid understanding of ETL/ELT pipelines and modern data architecture