Data Warehouse Modeling & DBT Expert
Share
Job Location:
Pathanamthitta - India
Yearly Salary:
₹ 1200000 - 1600000
Posted on:
10 days ago
Vacancies:
1 Vacancy
Job Summary
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
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 Experience:
Junior IC
About Company
At ALIQAN Technologies we provide multiple IT related services to our customers, giving them pure satisfaction and fulfilling all their needs just at one location. We provide them with all kind of related services here, thus saving them from the hardship of moving all over the town. B ... View more
