Data Warehouse Modeling & DBT Expert 100 Remote
Share
Job Location:
Monthly Salary:
Posted on:
6 hours ago
Vacancies:
1 Vacancy
Job Summary
Data Warehouse Modeling & DBT Expert - 100% Remote
Location - Hybrid or Remote(They are required to work from the office for 5 days during onboarding and for 5 days each quarter)
Job Type - Permanent
Budget- 10L-16L
Experience - 4-8 years
Job Summary
Askilled professional with strong expertise in both data warehouse modeling and modern data transformation using dbt (data build tool). The ideal candidate willbe responsible for designing scalable data models and implementingefficient 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
Strong 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
Experience with Git and CI/CD practices
Strong problem-solving and analytical skills
Location - Hybrid or Remote(They are required to work from the office for 5 days during onboarding and for 5 days each quarter)
Job Type - Permanent
Budget- 10L-16L
Experience - 4-8 years
Job Summary
Askilled professional with strong expertise in both data warehouse modeling and modern data transformation using dbt (data build tool). The ideal candidate willbe responsible for designing scalable data models and implementingefficient 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
Strong 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
Experience with Git and CI/CD practices
Strong problem-solving and analytical skills
Required Skills:
DOCUMENTATIONTESTINGGITVERSION CONTROLCI/CDBIGQUERYSQL QUERIES
