Analytics Engineer | dbt + Snowflake Specialist (Hybrid)

Akaasa Technologies; Scottsdale (AZ); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Akaasa Technologies is seeking an Analytics Engineer to join a data modernization initiative focusing on replicating enterprise data into Snowflake and building business-ready analytical data marts and semantic models.

The role emphasizes dbt Core, Snowflake, advanced SQL, and analytical data modeling to transform raw data into reliable, well-documented datasets for BI, self-service analytics, and AI-powered use cases. Working with data engineers, SAP SMEs, and stakeholders is expected.

Qualifications

• 3+ years of Analytics Engineering, Data Engineering, BI Engineering, or a related role.
• Strong hands-on experience developing production dbt models, preferably with dbt Core.
• Strong Snowflake experience in analytical data development.
• Excellent data modeling skills, including transforming raw source data into business-ready data marts.
• Advanced SQL skills, including CTEs, window functions and complex transformations.
• Experience with semantic views, semantic models, or metric definitions for BI/AI analytics.
• Experience gathering requirements with business stakeholders or SMEs.
• Strong communication, analytical thinking, and problem-solving skills.
• Ability to work independently and manage priorities.

Responsibilities

• Develop and maintain production-grade dbt models across staging, intermediate, and mart layers.
• Transform raw data into clean, tested, business-ready datasets.
• Design dimensional models and appropriate data relationships and grain.
• Implement incremental models, reusable macros, and dbt packages.
• Develop data quality tests and maintain documentation and lineage.
• Build and optimize analytical datasets within Snowflake.
• Apply SQL optimization and cost-aware data modeling practices.
• Support reliable data marts for reporting and self-service analytics.
• Build semantic views/models defining metrics, dimensions, and relationships.
• Collaborate with analysts and AI solution teams to improve usability of data.

Skills

dbt Core

Snowflake

Advanced SQL

Data modeling

Semantic layer

Git workflows

Python scripting

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or related quantitative field

Tools

Git

CI/CD

dbt packages

Dagster

BI tools (Tableau/Power BI)

Job description

Akaasa Technologies is seeking an Analytics Engineer to join a data modernization initiative focusing on replicating enterprise data into Snowflake and building business-ready analytical data marts and semantic models.

The role emphasizes dbt Core, Snowflake, advanced SQL, and analytical data modeling to transform raw data into reliable, well-documented datasets for BI, self-service analytics, and AI-powered use cases. Working with data engineers, SAP SMEs, and stakeholders is expected.