Title: Senior Technical Specialist ( DBT ) Location: Hyderabad/Bengaluru/Mumbai Education: Any Degree ( Computer Science ) Job Description: Design, develop, and maintain scalable data warehouse solutions Build and manage dbt models, including: Incremental models Snapshots Tests Macros Develop efficient and optimized SQL queries for data transformation and analysis Implement and maintain data models (dimensional/star/snowflake schemas) Collaborate with stakeholders to translate business needs into robust data solutions Build and maintain semantic layers for business consumption Ensure high standards of data quality, reliability, and performance Must-Have Skills Strong expertise in dbt (Data Build Tool) -- hands-on experience is mandatory Advanced SQL proficiency Strong understanding of data warehouse modeling concepts Experience in building and managing semantic layers Good-to-Have Skills (Optional): Experience with BI tools such as: Power BI Looker Tableau Amazon QuickSight Exposure to cloud data platforms like: Amazon Redshift Snowflake Databricks Experience in DAG creation using Apache Airflow Exposure to AI/ML models or agents for development, testing, or deployment automation Knowledge of Infrastructure as Code (IaC) tools such as: Terraform Pulumi AWS CloudFormation Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. Datavail’s Data Management Services: Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.