dbt & Analytics Engineer

Appit LLC; Hyderabad; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

APPIT Software Solutions in Hyderabad, India is hiring a dbt & Analytics Engineer to transform raw data into trusted analytical datasets using dbt and analytics engineering practices. You will build modular dbt models, implement data quality tests, and document data lineage.

Ideal candidates have 3-5 years of analytics or BI experience, strong SQL, and familiarity with cloud warehouses like Snowflake, BigQuery, or Redshift.

Qualifications

• 3-5 years of analytics engineering, data engineering, or BI development.
• Hands-on experience with dbt Core or dbt Cloud for data transformation.
• Strong SQL with a cloud data warehouse (Snowflake/BigQuery/Redshift).
• Familiar with Git workflows and code reviews in dbt projects.
• Experience with BI tools (Tableau/Looker/Power BI/Metabase).

Responsibilities

• Build and maintain dbt models, tests, and documentation for the analytics data layer.
• Design modular, reusable SQL transformations following dbt best practices.
• Implement data quality testing using dbt tests, macros, and dbt-expectations.
• Manage dbt project lifecycle with CI/CD and deployment via dbt Cloud or CLI.
• Collaborate with analysts to translate requirements into dimensional models.
• Generate and maintain data documentation and lineage graphs using dbt docs.

Skills

dbt Core/Cloud experience

SQL proficiency

Dimensional modeling (Kimball)

Git-based workflows

BI tools experience

Tools

dbt Core

dbt Cloud

CI/CD tooling

Job description

APPIT Software Solutions is hiring a dbt & Analytics Engineer in Hyderabad, India. Transform raw data into trusted, well-documented analytical datasets using dbt and modern analytics engineering practices at APPIT Software in Hyderabad.

Responsibilities

• Build and maintain dbt models, tests, and documentation for the analytics data layer
• Design modular, reusable SQL transformations following dbt best practices and style guides
• Implement data quality testing using dbt tests, custom macros, and dbt-expectations package
• Manage the dbt project lifecycle including version control, CI/CD, and deployment with dbt Cloud or CLI
• Collaborate with business analysts to translate requirements into dimensional models and metrics
• Generate and maintain data documentation and lineage graphs using dbt docs

Requirements

• 3-5 years of experience in analytics engineering, data engineering, or BI development
• Hands‑on experience with dbt Core or dbt Cloud for data transformation projects
• Expert‑level SQL proficiency with experience in at least one cloud data warehouse (Snowflake, BigQuery, or Redshift)
• Understanding of dimensional modeling, Kimball methodology, and analytics design patterns
• Familiarity with Git‑based workflows, pull requests, and code review processes for dbt projects
• Experience with BI tools (Tableau, Looker, Power BI, or Metabase) for validating data models

Nice to Have

• dbt Analytics Engineering certification
• Experience with Jinja templating and custom dbt macros
• Knowledge of data observability tools like Monte Carlo or Elementary

About APPIT Software Solutions

APPIT Software Solutions is a leading technology company building AI-powered enterprise products. Join 150+ professionals working on cutting‑edge solutions in AI/ML, cloud computing, and digital transformation. We offer competitive salaries, flexible work arrangements, and opportunities for career growth across our global offices.