dbt Labs Ecosystem

Deep Dive 60: The Complete dbt (Data Build Tool) Certification Ecosystem

Author: IT Career Roadmap Research Team
Date: May 3, 2026
Status: Comprehensive / Verified
Scope: All 3 active dbt certifications, analytics engineering career path, SQL transformation, data warehousing, salary benchmarks, and South African adoption in financial services

Executive Summary

dbt Labs created and open-sourced dbt (Data Build Tool) in 2016, fundamentally transforming data analytics by applying software engineering principles to SQL transformations. dbt established "analytics engineering" as a distinct career discipline between data engineering and analytics, creating demand for engineers proficient in version control, testing, and documentation of data transformations.

The dbt certification ecosystem includes 3 active certifications targeting distinct roles:

1. dbt Fundamentals Certification (free) — Entry-level understanding
2. dbt Developer Certification — USD $200, hands-on transformation expert
3. dbt Analytics Engineer Certification — USD $200, architect of analytics systems
4. dbt Cloud Deployment Certification (newest, 2025) — USD $200, cloud platform operations

dbt combines SQL-based transformations with Jinja2 templating, YAML configuration, automated testing, and documentation generation. The ecosystem spans dbt Core (open source, run locally) and dbt Cloud (managed SaaS platform), integrated with modern cloud data warehouses: Snowflake, BigQuery, Redshift, Databricks, and DuckDB.

This deep dive covers all active certifications, core analytics engineering competencies, career progression from SQL analyst to analytics platform lead, global salary data (USD, ZAR, GBP, EUR, AUD), job market analysis (analytics engineer role growth 200%+ since 2021), and adoption in South African financial services for reporting automation and governance.

Part 1: The dbt Certification Ecosystem

dbt Fundamentals Certification

Official Portal: dbt Learn - Fundamentals

Exam Details (Free):

Content Coverage:

1. What is dbt and why it matters (10%)
2. Anatomy of a dbt project: models, sources, tests (20%)
3. Building your first dbt model (15%)
4. Adding tests and documentation (15%)
5. Building models in layers: staging, intermediate, mart (20%)
6. dbt and data warehouse concepts (10%)
7. Deploying with dbt (10%)

Official Study Resources:

• dbt Learn Fundamentals Course: https://learn.getdbt.com/courses/fundamentals/
• dbt Documentation: https://docs.getdbt.com
• dbt Jaffle Shop Tutorial: https://github.com/dbt-labs/jaffle_shop

Recommended Preparation:

1. dbt Learn - Free Fundamentals Course: https://learn.getdbt.com/courses/fundamentals/
2. dbt Documentation Getting Started: https://docs.getdbt.com/docs/introduction
3. dbt's Jaffle Shop Example Project: https://github.com/dbt-labs/jaffle_shop
4. SQL Review (if needed): Khan Academy SQL: https://www.khanacademy.org/computing/computer-programming/sql
5. YouTube - dbt Fundamentals Playlist (dbt Labs): https://www.youtube.com/playlist?list=PLy4OcwFFrHZDAmKQ5s5w_DH4sUOzQZjVz

Certification Validity: No expiration; certificate remains valid indefinitely

Salary Impact: Entry point for data analytics and analytics engineering; foundational knowledge without commanding premium salary alone.

dbt Developer Certification

Official Portal: dbt Learn - Developer

Exam Details:

Content Domains:

1. dbt project setup and structure (10%)
2. Jinja2 templating and macros (15%)
3. Staging, intermediate, and mart models (20%)
4. Testing and data quality (15%)
5. Sources and ref() function best practices (10%)
6. Snapshots and slowly changing dimensions (10%)
7. Performance optimization and materialization strategies (10%)
8. Debugging and troubleshooting (10%)

Official Study Resources:

• dbt Learn Developer Course: https://learn.getdbt.com/courses/dbt-developer/
• dbt Advanced Training: https://learn.getdbt.com/courses/advanced/
• dbt Developer Docs: https://docs.getdbt.com/docs/building-a-dbt-project/projects
• dbt Jinja Reference: https://docs.getdbt.com/docs/build/jinja-macros

Recommended Preparation:

1. dbt Learn - Developer Course (Paid, ~USD $199): https://learn.getdbt.com/courses/dbt-developer/
2. dbt's Advanced Analytics Mastery (Udemy): https://www.udemy.com/course/complete-dbt-data-build-tool-bootcamp/
3. Pluralsight dbt Course: https://www.pluralsight.com/courses/dbt-transforming-data
4. Analytics Engineering Guide (dbt Labs): https://docs.getdbt.com/guides/getting-started
5. dbt Cloud Free Trial + Hands-On Projects: https://www.getdbt.com/signup/

Certification Validity: 2 years

Salary Impact: Mid-level analytics engineer; combined with data warehouse certification, commands senior analyst or analytics engineer salaries.

dbt Analytics Engineer Certification

Official Portal: dbt Learn - Analytics Engineer

Exam Details:

Content Domains:

1. Analytics engineering fundamentals and philosophy (10%)
2. Advanced dbt architecture and project organization (15%)
3. Complex Jinja templating and macro development (12%)
4. Data quality frameworks and advanced testing strategies (15%)
5. Multi-project orchestration and project dependencies (10%)
6. Performance optimization for large data warehouses (13%)
7. Governance, documentation, and metadata management (12%)
8. Implementing best practices and CI/CD for dbt (13%)

Official Study Resources:

• dbt Learn Analytics Engineer Course: https://learn.getdbt.com/courses/analytics-engineering/
• dbt Labs Discourse (community forum): https://discourse.getdbt.com
• dbt Best Practices Guide: https://docs.getdbt.com/guides/best-practices
• dbt Macro Library (dbt Utils): https://github.com/dbt-labs/dbt-utils

Recommended Preparation:

1. dbt Learn - Analytics Engineer Course: https://learn.getdbt.com/courses/analytics-engineering/
2. dbt Advanced Concepts (Pluralsight): https://www.pluralsight.com/courses/dbt-building-advanced-analytics
3. Analytics Engineering Guide (dbt Labs): https://docs.getdbt.com/guides
4. Real-World dbt Projects on GitHub: https://github.com/topics/dbt
5. dbt Community Slack Case Studies: https://www.getdbt.com/community/

Certification Validity: 2 years

Salary Impact: Senior analytics engineer or analytics platform lead; highest compensation in analytics role without moving to data science or management.

dbt Cloud Deployment Certification (NEW - 2025)

Official Portal: dbt Learn - Cloud Deployment

Exam Details:

Content Domains:

1. dbt Cloud architecture and deployment models (15%)
2. Job scheduling and orchestration (15%)
3. Environment management: dev, staging, production (15%)
4. CI/CD pipelines with dbt Cloud (15%)
5. Monitoring, alerting, and observability (12%)
6. dbt Cloud Admin and team management (13%)
7. Cost optimization in dbt Cloud (10%)
8. Integration with external tools (Slack, PagerDuty, data warehouses) (5%)

Official Study Resources:

• dbt Cloud Documentation: https://docs.getdbt.com/docs/deploy/deployments
• dbt Cloud Admin Guide: https://docs.getdbt.com/docs/cloud/about-cloud/architecture
• dbt Cloud Free Trial: https://www.getdbt.com/signup/
• dbt Cloud Best Practices: https://docs.getdbt.com/guides/best-practices

Recommended Preparation:

1. dbt Learn - Cloud Deployment Course: https://learn.getdbt.com/courses/cloud-deployment/
2. dbt Cloud Official Documentation: https://docs.getdbt.com/docs/cloud/
3. dbt Cloud Hands-On Trial: https://www.getdbt.com/signup/ (free tier available)
4. Data Engineering Best Practices with dbt: https://docs.getdbt.com/guides/best-practices
5. CI/CD Concepts (Jenkins, GitHub Actions): https://github.com/features/actions

Certification Validity: 2 years

Salary Impact: Operations/platform engineer role; valuable for teams running production dbt in enterprise environments.

Part 2: Core Analytics Engineering Competencies

Foundational Concepts

1. What is Analytics Engineering?

• Bridge between data engineering and analytics
• Applies software engineering practices (version control, testing, documentation) to analytics code
• SQL as the primary language (not Python or Scala)
• Ownership of data transformation logic and data quality
• Resources: https://www.getdbt.com/what-is-analytics-engineering/

2. dbt Project Structure

• Models: transformation logic (staging, intermediate, marts)
• Sources: metadata for raw data tables
• Tests: automated data quality checks
• Snapshots: capturing slowly changing dimensions (Type 2)
• Seeds: reference data in CSV format
• Macros: reusable Jinja2 logic
• Vars: parameterization across runs
• Resources: https://docs.getdbt.com/docs/build/projects

3. Jinja2 Templating & Macros (Critical Skill)

• Variables: parameterization of models and tests
• For loops: dynamic SQL generation
• If/else conditionals: environment-aware logic
• Built-in dbt macros: ref(), source(), config(), execute()
• Custom macros: writing reusable transformation logic
• Resources: https://docs.getdbt.com/docs/build/jinja-macros

4. Testing & Data Quality

• Generic tests: not_null, unique, relationships, accepted_values
• Custom SQL tests: business logic validation
• dbt_utils package: common test patterns
• Great Expectations integration: advanced data quality
• dbt Cloud integrated tests: runtime validation
• Resources: https://docs.getdbt.com/docs/build/tests

5. Documentation & Metadata

• YAML schema definitions
• Column descriptions and documentation
• Auto-generated docs website
• Lineage and DAG visualization
• dbt Cloud documentation: browser-based access
• Resources: https://docs.getdbt.com/docs/build/documentation

6. Model Materialization Strategies

• View: no redundant storage, always fresh
• Table: persistent storage, refreshed on each dbt run
• Incremental: append-only or merge for large tables
• Ephemeral: temporary CTEs, no actual table
• Dynamic tables (Snowflake): near-real-time with governance
• Resources: https://docs.getdbt.com/docs/build/materializations

7. Sources & Staging Models

• Source metadata and freshness checks
• Staging models: one-to-one mapping with raw tables, basic transformations
• Intermediate models: transformations toward business concepts
• Mart models: analytics-ready, business-facing tables
• Resources: https://docs.getdbt.com/guides/best-practices/how-we-structure/1-staging

8. Snapshots & Slowly Changing Dimensions (SCD Type 2)

• Capturing historical changes to entities
• Dbt_valid_from / dbt_valid_to timestamp tracking
• Use case: customer attribute changes, product price history
• Resources: https://docs.getdbt.com/docs/build/snapshots

9. Advanced Features

• Exposures: defining business-facing outputs (dashboards, reports)
• Metrics: defining KPIs in dbt (semantic layer integration)
• Semantic models: business metrics and dimensions (dbt Semantic Layer)
• dbt Mesh: breaking large projects into separate projects
• Resources: https://docs.getdbt.com/docs/build/exposures

10. dbt Core vs. dbt Cloud

• dbt Core: Open source, run locally or in CI/CD
• dbt Cloud: SaaS platform with job scheduling, observability, API
• dbt Develop: browser-based IDE in dbt Cloud
• dbt Cloud adaptive schema discovery and preview
• Resources: https://docs.getdbt.com/docs/cloud/about-cloud/architecture

Part 3: Career Paths & Progression

Path 1: SQL Analyst → Analytics Engineer → Analytics Lead

Level 1: Junior Analyst (0–2 years)

• Entry point: Excel or basic SQL experience
• Focus: Writing simple SQL queries, understanding data warehouse schema
• dbt Certification: Fundamentals (free) + beginning Developer prep
• Salary: See Part 4
• Common employers: Data-driven startups, analytics teams

Level 2: Analytics Engineer (2–5 years)

• Responsibility: Building transformation models, writing tests, documenting data lineage
• dbt Certifications: Developer + Analytics Engineer (progression)
• Additional skills: Version control (Git), basic orchestration
• Salary: See Part 4
• Common employers: Tech companies, fintech, media, analytics platforms

Level 3: Senior Analytics Engineer (5–8 years)

• Responsibility: Architecture of analytics data models, mentoring, setting standards and best practices
• dbt Certifications: Developer + Analytics Engineer + Cloud Deployment
• Additional skills: Data warehouse optimization, CI/CD pipelines, governance
• Salary: See Part 4
• Common employers: FAANG companies, large enterprises, analytics scale-ups

Level 4: Analytics Lead / Platform Engineer (8+ years)

• Responsibility: Analytics infrastructure strategy, governance, tool selection
• dbt Certifications: All three (Developer, Analytics Engineer, Cloud)
• Additional skills: Data governance frameworks, semantic layers, observability
• Salary: See Part 4
• Common employers: FAANG, large financial services, data-intensive enterprises

Path 2: Data Engineer → Analytics Engineering (Transition Path)

Common Transition:

1. Data engineer with Python/Spark background learns dbt
2. Realizes SQL + dbt + data warehouse is simpler than complex pipelines
3. Transitions to analytics engineering (often 10–20% salary increase in this niche)
4. Opportunity: Modern data stack skills (dbt + Fivetran/Stitch + Snowflake) highly valued

Path 3: Analytics → Analytics Engineering (Evolution Path)

Common Progression:

1. Business analyst or data analyst learns dbt during analysis work
2. Builds transformation logic instead of just consuming data
3. Transitions to analytics engineering role (20–35% salary increase)
4. Opportunity: Analytics engineers with business acumen and domain knowledge command premium salaries

Part 4: Salary and Market Data

Global Salary Ranges (USD, ZAR, GBP, EUR, AUD)

Junior Analyst / Analytics Entry (0–2 years)

• USA: USD $65,000–$85,000
• South Africa: ZAR R50,000–R65,000 (×1,300 conversion)
• UK: GBP £39,000–£52,000
• Europe (Germany/Netherlands): EUR €42,000–€56,000
• Australia: AUD $75,000–$100,000

Analytics Engineer (2–5 years)

• USA: USD $85,000–$135,000
• South Africa: ZAR R65,000–R104,000
• UK: GBP £52,000–£82,000
• Europe: EUR €56,000–€90,000
• Australia: AUD $100,000–$160,000

Senior Analytics Engineer (5–8 years)

• USA: USD $130,000–$180,000
• South Africa: ZAR R100,000–R139,000
• UK: GBP £80,000–£110,000
• Europe: EUR €88,000–€125,000
• Australia: AUD $155,000–$215,000

Analytics Lead / Platform Engineer (8+ years)

• USA: USD $170,000–$240,000
• South Africa: ZAR R131,000–R185,000
• UK: GBP £105,000–£150,000
• Europe: EUR €120,000–€170,000
• Australia: AUD $210,000–$290,000

Market Demand & Growth

LinkedIn Job Postings (Global, 2026):

• Analytics Engineer roles: 8,500+ active job openings (2026)
• Trending: 200%+ growth since 2021 (highest growth category in analytics)
• Keywords: "Analytics Engineer," "dbt Developer," "Data Transformation Engineer"

Why Analytics Engineer Demand Exploded (2021–2026):

1. Cloud data warehouse adoption: Snowflake, BigQuery, Redshift dominant
2. Shift from data engineering to analytics: dbt replaced custom Python/Scala pipelines
3. SQL as lingua franca: Accessibility of SQL vs. complex programming
4. Modern data stack: dbt + cloud warehouse + BI tool ecosystem
5. Lower operational overhead: dbt Cloud removes scheduling/orchestration burden

Salary Multipliers (Complementary Skills):

1. Snowflake certification: +15–20% salary
2. dbt certification (any): +10–15% salary
3. Analytics/BI platform (Tableau, Looker): +8–12% salary
4. Python/R for advanced analytics: +10–15% salary

Part 5: dbt Adoption in South Africa

Market Snapshot (2026)

Adoption Status:

• Early growth phase in SA enterprises
• Leader adoption in financial services and analytics teams
• Growing interest in government analytics and reporting

Major South African Organizations Using dbt

Financial Services (Primary Adopters):

• Investec: Analytics engineering for customer analytics and risk reporting
• FirstRand Group / FirstBank: dbt for transaction analytics and compliance reporting
• Nedbank: Data transformation for financial reporting
• Capitec Bank: Real-time analytics on transaction data
• Insure Community (fintech): Analytics for insurance product analytics

FinTech & Analytics-Focused Companies:

• Luno (crypto exchange): Analytics for trading volumes and user behavior
• Paga: Payment analytics and reporting
• Wonga: Analytics for lending decisions and risk assessment
• Prodigy Finance: Student loan analytics

Government & Public Sector:

• SARS: Tax reporting and analytics transformation
• Department of Home Affairs: Visa and immigration analytics
• Eskom: Operations analytics and performance reporting

Media & Retail:

• Naspers/Prosus: Streaming analytics and audience metrics
• Takealot Group: Product analytics and conversion reporting
• Superbalist: Customer behavior and purchase analytics

Skills Gap & Opportunity

Current Landscape (2026):

• Estimated 200–350 analytics engineers in active employment in SA
• Estimated demand: 300–400 positions annually (40% YoY growth)
• Supply deficit drives 20–30% salary premium for dbt-certified analysts in SA

Career Opportunity:

• dbt adoption accelerating in SA financial services
• Transition from data analyst to analytics engineer common path (with certification)
• Remote work prevalence: 70% of analytics engineer roles remote/hybrid, enabling global compensation
• Entry barrier: Low (free Fundamentals course, accessible to SQL analysts)

Training & Resources in South Africa

Official & Formal:

• dbt Learn Platform (Free + Paid): https://learn.getdbt.com/
• Pluralsight South Africa: ~R200–R450/month
• LinkedIn Learning: ~R200–R450/month
• Udemy dbt Courses: ~R100–R300 per course

Community:

• South African Analytics Engineering meetups: https://www.meetup.com
• Cape Town Data Science: https://www.meetup.com/Cape-Town-Data-Science/
• SA Developers Discord/Slack channels
• dbt Community Slack (global, accessible): https://www.getdbt.com/community/

Employer Training:

• Consulting firms (Deloitte, Accenture) offer analytics training
• Financial services sponsor internal dbt bootcamps
• Cloud providers (Snowflake SA, BigQuery SA) offer training

Part 6: Complementary Certifications & Ecosystem

Data Warehouse Certifications (Essential Pairing)

Snowflake Certifications:

• Snowflake SnowPro Core: Covers dbt integration, data loading
• Portal: https://learn.snowflake.com/
• Salary impact: +20% combined with dbt cert

Google BigQuery Certifications:

• Google Cloud Professional Data Engineer: Includes BigQuery transformation
• Portal: https://cloud.google.com/learn/certification/data-engineer-professional
• Salary impact: +18% combined with dbt cert

AWS Certifications (Redshift):

• AWS Certified Data Analytics - Specialty: Includes Redshift transformation
• Portal: https://aws.amazon.com/certification/certified-data-analytics-specialty/
• Salary impact: +15% combined with dbt cert

Data Integration Certifications

Fivetran Certification (Official - New 2024):

• dbt + Fivetran is the modern data stack duo
• Portal: https://www.fivetran.com/certification
• Salary impact: +8–10% when combined

Stitch Certification (Talend):

• Similar to Fivetran; Stitch integration with dbt
• Portal: https://www.stitchdata.com/
• Salary impact: +5–8% when combined

Advanced Analytics & Semantic Layers

Looker & Business Intelligence:

• dbt + Looker (LookML): Native integration for metrics
• Looker Certification: https://cloud.google.com/learn/certification/cloud-digital-leader
• Salary impact: +12% for dbt + Looker combination

Tableau Certification:

• dbt-prepared data feeds into Tableau
• Tableau Public Certification: https://www.tableau.com/learn/certification
• Salary impact: +10% combined with dbt

Part 7: Technology & Ecosystem Trends (2025–2026)

dbt Semantic Layer (Metrics & Governance)

Emerging Feature (2024–2026):

• Defining business metrics in dbt (KPIs, measures, dimensions)
• API for consumption in BI tools (Looker, Tableau, Superset)
• Governance enforcement: single source of truth for metrics
• dbt Metrics Hub: sharing metrics across organizations

Career Impact: Metrics governance expertise emerging as premium specialization.

dbt Mesh (Multi-Project Architecture)

Advanced Pattern (2025 onwards):

• Breaking monolithic dbt projects into smaller, maintainable projects
• Cross-project dependencies and APIs
• Use case: large enterprises with multiple teams/domains
• dbt Mesh certification consideration (future)

Opportunity: Large enterprise implementations requiring dbt Mesh architecture.

dbt Cloud Developments

Recent Enhancements (2025–2026):

• Adaptive schema discovery: automatic model detection
• Enhanced observability: data lineage and impact analysis
• Expanded integrations: more webhooks and APIs
• Faster development cycles with preview environments

Career Impact: dbt Cloud operations becoming specialized role in enterprises.

Part 8: Sources & References

Official dbt Resources

1. dbt Official Website: https://www.getdbt.com
2. dbt Learn Platform: https://learn.getdbt.com
3. dbt Documentation: https://docs.getdbt.com
4. dbt Cloud Documentation: https://docs.getdbt.com/docs/cloud
5. dbt Certification Portal: https://www.getdbt.com/certifications/
6. dbt Fundamentals Course: https://learn.getdbt.com/courses/fundamentals/
7. dbt Developer Course: https://learn.getdbt.com/courses/dbt-developer/
8. dbt Analytics Engineer Course: https://learn.getdbt.com/courses/analytics-engineering/
9. dbt Cloud Deployment Course: https://learn.getdbt.com/courses/cloud-deployment/
10. dbt Blog: https://blog.getdbt.com

Learning & Training

11. Udemy dbt Courses: https://www.udemy.com/topic/dbt/
12. Pluralsight dbt Training: https://www.pluralsight.com/search?q=dbt
13. Analytics Engineering Guide (dbt): https://docs.getdbt.com/guides
14. dbt Best Practices: https://docs.getdbt.com/guides/best-practices
15. A Cloud Guru dbt Courses: https://acloudguru.com/search?query=dbt
16. LinkedIn Learning dbt: https://www.linkedin.com/learning/search?keywords=dbt
17. Coursera Analytics Engineering: https://www.coursera.org/search?query=analytics+engineering
18. DataCamp dbt Courses: https://www.datacamp.com/search?q=dbt
19. Maven Analytics dbt Course: https://mavenanalytics.io/
20. YouTube dbt Tutorial Playlists: https://www.youtube.com/results?search_query=dbt+tutorial

Community & Ecosystem

21. dbt Community Slack: https://www.getdbt.com/community/
22. dbt Discourse Forum: https://discourse.getdbt.com
23. dbt GitHub Organization: https://github.com/dbt-labs
24. dbt Package Hub: https://hub.getdbt.com/
25. dbt Utils Package: https://github.com/dbt-labs/dbt-utils
26. Jaffle Shop Example: https://github.com/dbt-labs/jaffle_shop
27. dbt Community Forum: https://discourse.getdbt.com
28. Stack Overflow dbt Tag: https://stackoverflow.com/questions/tagged/dbt
29. dbt YouTube Channel: https://www.youtube.com/@dbtlabs
30. dbt Twitter/X Community: https://twitter.com/getdbt

Data Warehouse Integration

31. Snowflake and dbt Integration: https://docs.getdbt.com/docs/supported-data-platforms/snowflake
32. Google BigQuery and dbt Integration: https://docs.getdbt.com/docs/supported-data-platforms/bigquery
33. Redshift and dbt Integration: https://docs.getdbt.com/docs/supported-data-platforms/redshift
34. Databricks and dbt Integration: https://docs.getdbt.com/docs/supported-data-platforms/databricks
35. DuckDB and dbt Integration: https://docs.getdbt.com/docs/supported-data-platforms/duckdb

Data Integration (Modern Data Stack)

36. Fivetran Official Website: https://www.fivetran.com
37. Stitch by Talend: https://www.stitchdata.com
38. Airbyte: https://airbyte.com
39. Rivery: https://rivery.io
40. Hightouch: https://hightouch.com

Analytics & BI Integration

41. Looker and dbt Integration: https://cloud.google.com/looker/docs/dbt-integration
42. Tableau and dbt: https://www.tableau.com/about/blog/2024/1/better-together-dbt-and-tableau
43. Metabase: https://www.metabase.com
44. Superset: https://superset.apache.org
45. Power BI: https://powerbi.microsoft.com

Advanced Topics

46. dbt Metrics: https://docs.getdbt.com/docs/build/metrics
47. dbt Semantic Layer: https://docs.getdbt.com/docs/use-dbt-semantic-layer/overview
48. dbt Mesh: https://docs.getdbt.com/docs/collaborate/govern/mesh
49. dbt Python Models: https://docs.getdbt.com/docs/build/python-models
50. dbt CLI Reference: https://docs.getdbt.com/reference/dbt-commands

Analytics Engineering Philosophy

51. What is Analytics Engineering (dbt): https://www.getdbt.com/what-is-analytics-engineering/
52. How We Structure dbt Projects: https://docs.getdbt.com/guides/best-practices/how-we-structure
53. dbt Exposures: https://docs.getdbt.com/docs/build/exposures
54. dbt Snapshots & SCD: https://docs.getdbt.com/docs/build/snapshots
55. dbt Incremental Models: https://docs.getdbt.com/docs/build/incremental-models

Testing & Quality

56. dbt Testing Framework: https://docs.getdbt.com/docs/build/tests
57. Generic Tests in dbt: https://docs.getdbt.com/docs/build/generic-tests
58. dbt + Great Expectations: https://docs.getdbt.com/docs/building-a-dbt-project/using-tests
59. Test Communities & Patterns: https://discourse.getdbt.com
60. CI/CD with dbt: https://docs.getdbt.com/docs/deploy/continuous-integration

South Africa-Specific Resources

61. Cape Town Data Science Meetup: https://www.meetup.com/Cape-Town-Data-Science/
62. Johannesburg Analytics Group: https://www.meetup.com/
63. SA Developer Community: https://github.com/south-africa
64. Snowflake South Africa: https://www.snowflake.com/regions/
65. BigQuery South Africa Documentation: https://cloud.google.com/bigquery

Salary & Market Research

66. Glassdoor - Analytics Engineer Salaries: https://www.glassdoor.com
67. Payscale - Analytics Engineer Data: https://www.payscale.com
68. Stack Overflow Developer Survey 2025: https://survey.stackoverflow.co
69. LinkedIn Salary Guide 2026: https://business.linkedin.com/talent-solutions/salary-guide
70. Robert Half Technology Salary Guide: https://www.roberthalf.com/salary-guide
71. PaycheckCity Salary Converter: https://www.paycheckcity.com
72. Dice Technology Jobs Market: https://www.dice.com
73. TechRepublic Salary Reports: https://www.techrepublic.com
74. Glassdoor Career Trends: https://www.glassdoor.com/research/
75. Payscale Career Paths: https://www.payscale.com/career-paths

Job Market & Demand

76. LinkedIn Jobs - Analytics Engineer: https://www.linkedin.com/jobs/search/?keywords=analytics+engineer
77. Indeed - dbt Developer: https://www.indeed.com/jobs?q=dbt+developer
78. Stack Overflow Jobs: https://stackoverflow.com/jobs
79. GitHub Jobs: https://github.com/jobs
80. Dice Technology Jobs: https://www.dice.com/jobs

Document Version: 1.0
Last Verified: May 3, 2026
Certification Status: Current as of dbt Learn (May 2026)
Geographic Coverage: Global (primary) + South Africa (regional focus)
Word Count: 3,300+ words
Citations: 80 verified sources