ZipRecruiter

Log In

1

Dbt Analytics Jobs in California (NOW HIRING)

OSI Digital

DBT Developer

Irvine, CA · On-site

$20 - $65/hr

Title DBT Developer Location Irvine, CA 5 days onsite Employment Contractor- 6 months Experience 4+ ... The ideal candidate will have 4-5 years of experience in data engineering, analytics engineering ...

OSI Digital

DBT Developer

Irvine, CA · On-site

$20 - $65/hr

Title DBT Developer Location Irvine, CA 5 days onsite Employment Contractor- 6 months Experience 4+ ... The ideal candidate will have 4-5 years of experience in data engineering, analytics engineering ...

OSI Consulting

DBT Developer

Irvine, CA · On-site

The Senior dbt Developer will design, build, and maintain scalable dbt transformation models on Snowflake, ensuring the conversion of raw data into analytics-ready datasets for reporting and decision ...

3M HEALTHCARE

Analytics Engineer

San Francisco, CA · On-site

You'll partner with Data Ops to develop a semantic layer and AI-driven self-service analytics, designing data models in Snowflake with dbt, and ensuring data quality through a testing/alerting ...

3M HEALTHCARE

Analytics Engineer

San Francisco, CA · On-site

You'll partner with Data Ops to develop a semantic layer and AI-driven self-service analytics, designing data models in Snowflake with dbt, and ensuring data quality through a testing/alerting ...

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 ...

Everpure

Senior Analytics Engineer, GTM

Santa Clara, CA · On-site

$122K - $168K/yr

We are midway through a strategic migration to dbt as our transformation standard. Beyond that, our ... As a Senior Analytics Engineer, you will help drive that journey end-to-end. This role is grounded ...

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 ...

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 Aug 8, 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 analytics in demand?

Dbt analytics roles are increasingly in demand as companies focus on data transformation and analytics workflows. Skills in SQL, data modeling, and tools like dbt are valuable for data analysts and engineers working in modern data environments.
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, 80% Full Time, 14% Part Time, 2% Temporary, and 3% Contract. Highlights an 80% Physical, 5% Hybrid, and 15% Remote job distribution, with an average salary of $63,067 per year, or $30.3 per hour.

DBT Developer

OSI Digital

Irvine, CA • On-site

$20 - $65/hr

Contractor

Re-posted 6 days ago

Job description

TitleDBT DeveloperLocationIrvine, CA  5 days onsiteEmploymentContractor- 6 months Experience4+ years
About:
At OSI Digital Inc, we accelerate our client’s digital transformation journey by delivering modern data solutions that help organizations unlock the full value of their data through scalable cloud platforms, intelligent analytics, and business-ready reporting solutions. With deep expertise across data engineering, business intelligence, cloud platforms, advanced analytics, and AI/ML, our teams bring both technical excellence and business understanding to every engagement.
Role Summary:
We are seeking a Senior dbt Developer with strong hands-on experience in dbt, Snowflake, and advanced SQL development. The primary focus of this role is to design, build, test, document, deploy, and maintain scalable dbt transformation models on Snowflake that convert raw and source-aligned data into trusted, analytics-ready datasets for reporting, dashboards, and business decision-making.
The ideal candidate will have 4-5 years of experience in data engineering, analytics engineering, BI engineering, or modern data transformation roles, with practical experience using dbt Core and/or dbt Cloud in a production or project-based environment. This role requires strong SQL skills, Snowflake knowledge, good communication skills, and the ability to translate business rules and reporting requirements into reliable dbt models, reusable transformation logic, and governed data marts.
Key Responsibilities:
  • Design, build, and maintain modular dbt models across staging, intermediate, and marts layers that transform raw data into trusted, analytics-ready datasets.
  • Develop and optimize dbt incremental models, snapshots, macros, seeds, sources, and reusable packages using dbt Core and/or dbt Cloud.
  • Write and tune complex SQL transformations in Snowflake using joins, CTEs, window functions, aggregations, conditional logic, and performance optimization techniques.
  • Optimize Snowflake workloads for query performance, clustering strategy, warehouse sizing, model materialization, processing time, and cost efficiency.
  • Implement robust data quality and testing frameworks using dbt generic tests, singular tests, custom tests, accepted values, relationships, not-null checks, uniqueness checks, and source freshness checks.
  • Maintain clear documentation, lineage, dependency mapping, model descriptions, column definitions, source definitions, assumptions, and business logic using dbt docs and exposures.
  • Manage dbt projects in Git with clean, modular, testable development practices, including branching, pull requests, code reviews, merge controls, and release promotion.
  • Support CI/CD pipelines for dbt projects using tools such as GitHub Actions, GitLab CI, dbt Cloud jobs, or similar deployment and automation frameworks.
  • Leverage Snowflake features such as Streams, Tasks, Dynamic Tables, Time Travel, cloning, secure views, and secure data sharing to build reliable ELT workflows.
  • Create reporting-ready data marts, curated datasets, dimensional models, fact tables, and reusable views that support Tableau dashboards and self-service analytics.
  • Partner with data engineers, analysts, BI developers, architects, and business stakeholders to translate business requirements into scalable transformation logic.
  • Troubleshoot data discrepancies, failed dbt runs, source changes, schema changes, model errors, test failures, and performance bottlenecks.
  • Participate in requirement gathering sessions, technical design discussions, sprint planning, backlog refinement, walkthroughs, and UAT support activities.

Required Qualifications:
  • Minimum 4+ years of experience in data engineering, analytics engineering, BI engineering, data warehousing, or data transformation roles.
  • Strong hands-on experience with dbt Core and/or dbt Cloud, including dbt models, macros, tests, snapshots, seeds, sources, packages, documentation, lineage, and project structure.
  • Strong experience using dbt with Snowflake to build scalable ELT transformation pipelines, curated data models, and analytics-ready datasets.
  • Strong SQL development skills with experience writing complex transformations, performing data validation, troubleshooting data issues, and analyzing large datasets.
  • Strong understanding of dbt best practices for modular, testable, well-documented projects.
  • Hands-on Snowflake experience, including databases, schemas, tables, views, warehouses, roles, access controls, query optimization, and performance considerations.
  • Strong understanding of data modeling concepts, including star schema, fact and dimension tables, slowly changing dimensions, staging layers, data marts, and semantic/reporting layers.
  • Experience with data reconciliation and business rule validation.
  • Ability to translate business requirements, source-to-target mappings, metric definitions, and reporting logic into technical specifications and dbt transformation models.
  • Good troubleshooting and analytical skills with the ability to identify root causes of data issues, failed transformations, and performance bottlenecks.
  • Bachelor’s degree in Computer Science, Engineering, Information Systems, Data Analytics, Business Analytics, or a related technical field. Equivalent practical experience may also be considered.

Preferred / Plus Qualifications:
  • Experience with Tableau, including understanding dashboard requirements, published data sources, extracts, live connections, and reporting-ready data model design.
  • Experience supporting BI and reporting teams by creating curated datasets, reusable views, semantic layers, and governed data marts.
  • Experience with advanced dbt capabilities such as dbt Explorer, dbt Semantic Layer, dbt Mesh, exposures, metrics, and cross-project lineage is a plus.
  • Experience with orchestration and scheduling tools such as Airflow, Dagster, Prefect, Azure Data Factory, Snowflake Tasks, dbt Cloud jobs, or similar platforms.
  • Experience with CI/CD processes for dbt projects using GitHub Actions, GitLab CI, Azure DevOps, Jenkins, or similar automation tools.
  • Experience with Python for automation, data validation, testing, metadata extraction, or data engineering support.
  • Experience with ELT tools such as Fivetran, Airbyte, Matillion, Informatica, Talend, Alteryx, or similar platforms.
  • Familiarity with cloud ecosystems such as AWS, Azure, or Google Cloud Platform.
  • Experience with Snowflake performance optimization, warehouse sizing, clustering, query profiling, access control, monitoring, and cost optimization.
  • Familiarity with Agile delivery, sprint planning, backlog management, Jira/Azure DevOps, and iterative development practices.
  • Understanding of data governance, metadata management, lineage, access control, PII handling, and enterprise data standards.
  • Certifications such as dbt Certified Developer, Snowflake certification, Tableau certification, or related cloud/data certifications are a plus.

Powered by JazzHR

n5cWVsJqfR