Senior Analytics Engineer (DBT & Databricks)

Apptad is seeking a Senior Analytics Engineer to design and build scalable data transformation solutions using DBT and Databricks. This role focuses on modernizing data pipelines, improving data models, and enabling high-quality, self-service analytics.

Responsibilities:

• Migrate legacy data pipelines into a modern Databricks + DBT (Lakehouse) architecture
• Analyze existing workflows and redesign them using best-in-class data modeling practices
• Develop and maintain scalable DBT models and transformation pipelines
• Design dimensional and relational data models (fact/dimension, star schema)
• Own transformation layers (Silver/Gold) and ensure data readiness for analytics
• Implement data quality checks, monitoring, and SLA-driven pipelines
• Collaborate with analytics, product, and data engineering teams
• Support data governance, documentation, and lineage
• Enable self-service reporting through well-structured data marts

Requirements:

• 5+ years in data/analytics engineering or data modeling
• Strong hands-on expertise in SQL (advanced level)
• Proven experience with DBT (models, tests, incremental loads, optimization)
• Experience with Databricks on AWS (must-have)
• Strong understanding of data warehousing & dimensional modeling
• Experience handling large-scale datasets and performance tuning
• Hands-on with Python and orchestration tools (Airflow or similar)
• Familiarity with CI/CD, Git, and version control practices