> Markdown version of [/jobs/ext/3003685-analytics-engineer-dbt-snowflake](https://www.wearedevelopers.com/jobs/ext/3003685-analytics-engineer-dbt-snowflake). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Analytics Engineer - dbt / Snowflake - **Company:** Akaasa Technologies - **Location:** Scottsdale, AZ, United States - **Experience:** Expert - **Salary:** $91,100.0 - $179,500.0 - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Artificial Intelligence, Airflow, Business Analytics Applications, Data Analysis, ARM Architecture, Big Data, Code Review, Continuous Integration, Data Dictionary, Information Engineering, Data Integrity, Data Mart, Data Transformation, Python (Programming Language), SAP ERP, Query Optimization, Raw Data, Power BI, SAP (Applications), Tableau (Software), Scripting, Sql Optimization, GitHub Copilot, Large Language Models, Snowflake, Git, Git Flow, Information Technology, Data Analytics, GPT - **Published:** September 19, 2026 - **Apply:** https://www.careerjet.com/jobad/us1408bceabc02a34fc09c18ab265e2595 ## About the Role * 3+ years of experience in 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, complex transformations, and query optimization. * Experience with semantic views, semantic models, or metric definitions for BI and/or AI-powered analytics. * Experience gathering requirements and working directly with business stakeholders or SMEs. * Strong communication, analytical thinking, and problem-solving skills. * Ability to work independently, manage priorities, and take ownership of deliverables. * Experience with Git, code reviews, and production development workflows. * Python experience for scripting, automation, or custom data quality testing., * Experience with Snowflake semantic models, Cortex Analyst, or dbt Semantic Layer / MetricFlow. * Experience developing analytical datasets for BI tools such as Hex, Tableau, Power BI, or similar platforms. * Experience with dbt packages such as dbt-utils and dbt-expectations. * Exposure to Dagster or other orchestration platforms. * Experience working with financial, operational, procurement, inventory, or asset-management data. * Energy, utilities, financial services, or other enterprise data experience. * Experience with SAP ERP data or collaboration with SAP SMEs. * Familiarity with Snowflake Cortex or LLM-assisted development workflows. * Bachelor's degree in Computer Science, Engineering, Mathematics, or a related quantitative field. What We Are Looking For We are looking for an Analytics Engineer who combines strong technical modeling expertise with excellent communication and business understanding. The successful candidate should be able to independently take raw data and business requirements, design the appropriate dbt and Snowflake models, and deliver reliable, consumable datasets. SAP expertise and specific AI-tool experience are not required. Candidates should have strong dbt, Snowflake, data modeling, semantic layer, and stakeholder collaboration experience is required. ## Description We are seeking an experienced Analytics Engineer to join a data modernization initiative focused on replicating enterprise data into Snowflake and building business-ready analytical data marts and semantic models. The ideal candidate will have strong hands-on experience with dbt Core, Snowflake, advanced SQL, and analytical data modeling. This role will focus on transforming raw data into clean, reliable, well-documented datasets that support business intelligence, self-service analytics, and AI-powered conversational use cases. You will work closely with Data Engineers, SAP SMEs, business stakeholders, and analysts to understand business requirements, define data models, and deliver high-quality analytical solutions., dbt & Data Modeling * Develop and maintain production-grade dbt models across staging, intermediate, and mart layers. * Transform raw operational and financial data into clean, tested, and business-ready analytical datasets. * Design dimensional models, fact and dimension tables, and appropriate data relationships and grain. * Implement incremental models, reusable macros, and dbt packages. * Develop comprehensive data quality tests, including generic, singular, and referential integrity tests. * Maintain model documentation, data dictionaries, and lineage. Snowflake Development * Build and optimize analytical datasets within Snowflake. * Apply SQL optimization techniques and cost-aware data modeling practices. * Work with large datasets and design efficient queries and transformations. * Support reliable and scalable data marts for reporting and self-service analytics. Semantic Layer & AI-Ready Analytics * Build and maintain semantic views or semantic models that define business metrics, dimensions, and relationships. * Structure analytical models with consistent naming conventions, clear definitions, and appropriate metadata. * Develop datasets that enable BI tools and LLM-powered conversational analytics to answer business questions accurately. * Collaborate with analysts and AI solution teams to improve the usability of analytical data. Business Partnership & Requirements Gathering * Work directly with business stakeholders and SMEs to understand data requirements and business rules. * Translate business questions into scalable data models and transformation logic. * Conduct data model walkthroughs and explain technical decisions to both technical and non-technical audiences. * Validate model outputs and ensure alignment with business definitions and reporting requirements. Collaboration & Engineering Practices * Partner with Data Engineers on source data structures, ingestion dependencies, and data contracts. * Collaborate with analysts on analytical datasets and self-service reporting. * Use Git-based workflows, code reviews, and CI/CD practices for dbt development. * Use AI coding assistants such as Claude Code, ChatGPT, or GitHub Copilot when appropriate, applying sound technical judgment and reviewing generated code for accuracy, security, and quality. ## Related Videos - [Headless by Design: Building Enterprise Systems That Agents Can Actually Use](https://www.wearedevelopers.com/videos/100092-headless-by-design-building-enterprise-systems-that-agents-can-actually-use) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [ Evaluating AI models for code comprehension](https://www.wearedevelopers.com/videos/1462-evaluating-ai-models-for-code-comprehension) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)