Datavail

Senior Technical Specialist - DBT

Posted 2 Days Ago

Be an Early Applicant

3 Locations

In-Office or Remote

Senior level

Database

The Role

Design, develop, and maintain scalable data warehouse solutions using dbt and SQL. Build incremental models, snapshots, tests, and macros. Implement dimensional data models and semantic layers, optimize queries, and ensure data quality and performance while collaborating with stakeholders.

Summary Generated by Built In

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

About UsDatavail 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. About the Team

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.

Skills Required

Hands-on experience with dbt (Data Build Tool)
Advanced SQL proficiency
Strong understanding of data warehouse modeling concepts (dimensional/star/snowflake schemas)
Experience building and managing semantic layers
Any Degree in Computer Science (or any degree specified)
Experience with Power BI
Experience with Looker
Experience with Tableau
Experience with Amazon QuickSight
Exposure to Amazon Redshift
Exposure to Snowflake
Exposure to Databricks
Experience creating DAGs using Apache Airflow
Exposure to AI/ML models or agents for automation
Knowledge of IaC tools (Terraform, Pulumi, AWS CloudFormation)

View all jobs at Datavail

View Datavail Profile

Report Job

Am I A Good Fit?

beta

Get Personalized Job Insights.

Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

HQ: Broomfield, CO

263 Employees

Year Founded: 2007

What We Do

A premiere data services company serving clients in North America, Datavail has 1,000 data professionals, data engineers, developers, project managers, consultants, and business experts, supported by industry-leading automation and intellectual property. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. At Datavail, we look for more than smarts, experience and proficiency. On top of those requirements, we seek people who mesh with our corporate values. We seek brilliance without bravado and know-how without a know-it-all attitude. We hold low ego in high regard, embrace problem-solving as a passion and welcome every day as a new opportunity to learn. We’re flexible and hard working. We’re committed to our clients and colleagues. We help our people grow so they can help our clients grow. That makes us grow so we can help even more customers leverage organizational data for business value. Our Core Values: 1. We desire to serve. 2. We embody flexibility for availability 3. We exemplify low ego. 4. We work hard. 5. We strive for continuous improvement. 6. We are growth-oriented.