ZipRecruiter

Log In

1

Dbt Analytics Jobs in California (NOW HIRING)

P2PSoftTek Inc

DBT Developer with AWS

Pleasanton, CA · On-site

Develop optimized analytical models in Amazon Redshift . * Optimize SQL queries and Redshift workloads to improve performance and reduce compute costs. * Orchestrate dbt and AWS data pipelines using ...

Fivetran

Staff Product Manager - dbt v2

Oakland, CA · On-site

About Us Fivetran and dbt Labs are bringing together two industry-leading companies with a shared ... Together, we support thousands of organizations as they build a trusted foundation for analytics ...

Fivetran

Staff Product Manager - dbt v2

Oakland, CA · Remote

About Us Fivetran and dbt Labs are bringing together two industry-leading companies with a shared ... Together, we support thousands of organizations as they build a trusted foundation for analytics ...

Northern Base

Lead Data Engineer

Irvine, CA · On-site

$110K - $144K/yr

Transform existing ETL workloads to modern ELT patterns using dbt. * Analyze source environments and define migration approaches, roadmap, and execution strategy. * Drive code conversion, performance ...

AmaWaterways, LLC

Data Analytics Engineer

Calabasas, CA · On-site

$90K - $100K/yr

Governed semantic models in dbt for our top business KPIs: bookings, occupancy, revenue ... Cortex Analyst semantic YAML for natural-language data exploration by our internal users. * Data ...

Prosum Inc.

Senior BI / Analytics Engineer

Los Angeles, CA · On-site

$112K - $154K/yr

The ideal candidate brings deep expertise in dbt, Snowflake, Power BI, and modern ingestion platforms, with a strong foundation in data modeling, analytics engineering, and business intelligence best ...

Banc of California

VP, Analytics Engineering

Santa Ana, CA · On-site

$58.17 - $97.12/hr

THE OPPORTUNITY The VP, Analytics Engineering will lead the design and delivery of enterprise data ... Guide reusable dbt models, macros, and semantic models, and lead dimensional data modeling ...

Banc of California

VP, Analytics Engineering

Santa Ana, CA · On-site

$187K - $241K/yr

THE OPPORTUNITY The VP, Analytics Engineering will lead the design and delivery of enterprise data ... Guide reusable dbt models, macros, and semantic models, and lead dimensional data modeling ...

New

Prosum

Senior BI / Analytics Engineer

Culver City, CA · On-site

$114K - $156K/yr

The ideal candidate brings deep expertise in dbt, Snowflake, Power BI, and modern ingestion platforms, with a strong foundation in data modeling, analytics engineering, and business intelligence best ...

next page

Showing results 1-20

All JobsDbt Analytics JobsDbt Analytics Jobs in California

Dbt Analytics information

See California salary details

$37K

$63.1K

$90.8K

How much do dbt analytics jobs pay per year?

As of Sep 4, 2026, the average yearly pay for dbt analytics in California is $63,067.00, according to ZipRecruiter salary data. Most workers in this role earn between $52,300.00 and $70,100.00 per year, depending on experience, location, and employer.

What is a dbt analytics?

A dbt Analytics job typically refers to a role focused on using dbt (data build tool) to transform, test, and document data within a data warehouse. Professionals in this field design and manage data models, write SQL-based transformations, and ensure data quality for analytics purposes. They collaborate with data engineers and analysts to build efficient, maintainable workflows that support business intelligence and data-driven decision-making. dbt Analytics jobs require strong SQL skills, familiarity with modern data stack tools, and an understanding of data modeling best practices.

What are the key skills and qualifications needed to thrive as a dbt analytics professional?

To thrive as a DBT Analytics professional, you need strong SQL skills, a solid understanding of data modeling, and experience with analytics engineering, typically backed by a degree in a quantitative field. Familiarity with the DBT (Data Build Tool) platform, cloud data warehouses like Snowflake or BigQuery, and version control systems such as Git is essential. Attention to detail, problem-solving abilities, and effective communication help you collaborate with stakeholders and ensure data reliability. These skills and tools are crucial for transforming raw data into actionable insights and maintaining robust, scalable analytics infrastructure.

How does a dbt analytics professional typically collaborate with data engineers and analysts within a team?

Dbt Analytics professionals play a key role in bridging the work of data engineers and data analysts. They transform raw data into clean, well-documented, and analysis-ready datasets using dbt (data build tool), ensuring consistency and reliability. Collaboration often involves working closely with data engineers to understand data sources and pipelines, while also partnering with analysts to tailor data models to business needs. Effective communication and regular feedback loops are crucial, as dbt professionals often serve as the link between technical data infrastructure and business-facing analysis.

What is the difference between Dbt Analytics vs Data Analyst?

AspectDbt AnalyticsData Analyst
Required CredentialsSQL, data modeling, analytics certificationsStatistics, Excel, SQL, sometimes certifications
Work EnvironmentData teams, analytics platforms, cloud environmentsBusiness units, reporting tools, spreadsheets
Industry UsageData transformation, modeling, analytics pipelinesData interpretation, reporting, insights

While Dbt Analytics focuses on transforming and modeling data within analytics workflows, Data Analysts primarily interpret data and generate reports. Both roles require SQL skills and work closely with data teams, but Dbt Analytics emphasizes data transformation using tools like dbt, whereas Data Analysts focus on analyzing and communicating insights.

Is dbt in demand?

Dbt analytics engineers are increasingly in demand as organizations adopt modern data transformation tools to improve data workflows. Skills in SQL, data modeling, and familiarity with cloud platforms enhance job prospects in this field, which is growing alongside the broader data analytics industry.

What are the most commonly searched types of Dbt Analytics jobs in California?

The most popular types of Dbt Analytics jobs in California are:

What are popular job titles related to Dbt Analytics jobs in California?

For Dbt Analytics jobs in California, the most frequently searched job titles are:

What job categories do people searching Dbt Analytics jobs in California look for?

The top searched job categories for Dbt Analytics jobs in California are:

What cities in California are hiring for Dbt Analytics jobs?

Cities in California with the most Dbt Analytics job openings:

Dbt Analytics jobs near you
Infographic showing various Dbt Analytics job openings in California as of August 2026, with employment types broken down into 1% Internship, 91% Full Time, 6% Part Time, and 2% Contract. Highlights an 79% Physical, 6% Hybrid, and 15% Remote job distribution, with an average salary of $63,067 per year, or $30.3 per hour.

DBT Developer with AWS

P2PSoftTek Inc

Pleasanton, CA • On-site

Other

Posted 4 days ago

Job description

Role : DBT Developer with AWS

Location : Pleasanton ,CA

Description

  • Design, develop, and maintain scalable dbt models and ELT pipelines for enterprise data platforms.
  • Develop staging, intermediate, fact, and dimension models using dbt and advanced SQL.
  • Build complex SQL transformations using CTEs, joins, window functions, aggregations, and subqueries.
  • Develop and optimize incremental dbt models for large-volume datasets.
  • Create reusable dbt macros using Jinja to standardize transformation logic.
  • Develop custom data quality tests and implement validation rules for critical datasets.
  • Configure and maintain dbt sources, snapshots, seeds, exposures, documentation, and lineage.
  • Implement source freshness monitoring and data quality checks.
  • Build and maintain AWS-based data pipelines using services such as Amazon S3, AWS Glue, Amazon Redshift, Lambda, Step Functions, and CloudWatch.
  • Develop data lake solutions using Amazon S3 for raw, curated, and processed datasets.
  • Create and maintain AWS Glue ETL jobs, Crawlers, and Data Catalog configurations.
  • Develop optimized analytical models in Amazon Redshift.
  • Optimize SQL queries and Redshift workloads to improve performance and reduce compute costs.
  • Orchestrate dbt and AWS data pipelines using Apache Airflow, Amazon MWAA, or other workflow orchestration tools.
  • Implement automated deployment pipelines for dbt using AWS CodePipeline, CodeBuild, GitHub Actions, Jenkins, or similar CI/CD tools.
  • Integrate dbt development with Git-based source control, branching strategies, pull requests, and code reviews.
  • Automate dbt execution including dbt build, dbt run, dbt test, and documentation generation.
  • Implement secure AWS access using IAM roles, policies, KMS, and AWS Secrets Manager.
  • Monitor production data pipelines using Amazon CloudWatch and troubleshoot failures.
  • Perform root-cause analysis for dbt, SQL, AWS Glue, Redshift, and data quality issues.
  • Work with data engineers and business stakeholders to convert business requirements into scalable data solutions.
  • Maintain technical documentation for data models, pipelines, data lineage, and operational procedures.
  • Participate in Agile/Scrum ceremonies, sprint planning, backlog refinement, code reviews, and production releases.

Apply