ZipRecruiter

Log In

1

Dbt Developer Jobs in Philadelphia, PA (NOW HIRING)

IntegriChain

AI Data Engineer

Philadelphia, PA · On-site +1

$115K - $138K/yr

  • Medical

  • Retirement

  • PTO

Optimize Snowflake SQL and dbt workloads for performance, scalability, cost, and maintainability. * Work with orchestration and DevOps/SRE teams to support CI/CD, environment promotion, pipeline ...

IntegriChain

AI Data Engineer

Philadelphia, PA · On-site

$115K - $138K/yr

  • Medical

  • Retirement

  • PTO

Optimize Snowflake SQL and dbt workloads for performance, scalability, cost, and maintainability. * Work with orchestration and DevOps/SRE teams to support CI/CD, environment promotion, pipeline ...

IntegriChain

AI Data Engineer

Philadelphia, PA

$115K - $138K/yr

  • Medical

  • Retirement

  • PTO

Optimize Snowflake SQL and dbt workloads for performance, scalability, cost, and maintainability. * Work with orchestration and DevOps/SRE teams to support CI/CD, environment promotion, pipeline ...

Fivetran

Customer Solutions Engineer

Philadelphia, PA · Remote

About Us Fivetran and dbt Labs are bringing together two industry-leading companies with a shared ... We're looking for a customer solutions engineer, Customer Solutions Engineering (CSE) team ...

Globo Language Solutions

AI/ML Engineer

Philadelphia, PA · On-site

$109K - $131K/yr

The AI/ML Engineer works across GLOBO's modern data stack (Fivetran, dbt, Snowflake) and AI infrastructure (AWS Bedrock, LLMs, agentic frameworks) to deliver reliable, well-tested solutions. This ...

Aramark

Data Engineer

Philadelphia, PA · On-site

$100K - $130K/yr

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

Develop scalable, well-modeled data transformation pipelines (dbt) that unlock analytical and AI-driven capabilities. * Establish and enforce data engineering best practices - including CI/CD for ...

Aramark

Data Engineer

Philadelphia, PA · On-site

$100K - $130K/yr

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

Develop scalable, well-modeled data transformation pipelines (dbt) that unlock analytical and AI-driven capabilities. * Establish and enforce data engineering best practices -- including CI/CD for ...

Arbor

Data Engineer

Philadelphia, PA · Remote

$117K - $140K/yr

You'll own our dbt transformation layer end-to-end -- modeling energy market data, customer ... You'll partner closely with engineering, operations, and leadership to deliver analytics that ...

TriOptus LLC

Data Engineer

Philadelphia, PA · On-site

$109K - $131K/yr

... experience working with dbt. • 3+ years of experience with orchestration tooling (Airflow ... Data Engineer Background Check : No Drug Screen : No

Daymark Health

Data Engineer

Philadelphia, PA · On-site

$140K - $160K/yr

... seeking a Data Engineer who is passionate about building scalable, impactful data pipelines ... Snowflake, dbt, AWS, Sigma) to support analytics, reporting, and real-time data exchange with ...

Fivetran

Product Counsel

Philadelphia, PA · Hybrid

Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable ...

Fivetran

Commercial Counsel

Philadelphia, PA · Hybrid

Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable ...

SEI Investments

Technical Lead

Oaks, PA

  • Medical

  • Dental

  • Vision

  • Life

  • Retirement

  • PTO

You should be able to deliver individual code as well as technically lead a team of developers; and ... Creating data pipelines using Snowflake/DBT/Airflow * Deploying and configuring well performing ...

New

next page

Showing results 1-20

All JobsDbt Developer JobsDbt Developer Jobs in Philadelphia, PA

Dbt Developer information

See Philadelphia, PA salary details

$16

$50

$78

How much do dbt developer jobs pay per hour?

As of Aug 14, 2026, the average hourly pay for dbt developer in Philadelphia, PA is $50.50, according to ZipRecruiter salary data. Most workers in this role earn between $38.61 and $61.78 per hour, depending on experience, location, and employer.

What is the difference between Dbt Developer vs Data Engineer?

AspectDbt DeveloperData Engineer
Primary FocusBuilding and maintaining data transformation pipelines using dbtDesigning, developing, and managing data infrastructure and pipelines
Skills & CertificationsSQL, dbt, data modeling, analytics skillsSQL, Python, ETL tools, cloud platforms, data architecture
Work EnvironmentAnalytics teams, data warehouses, BI projectsData platforms, cloud environments, big data systems

While both roles involve working with data, a Dbt Developer specializes in transforming data using dbt within analytics and BI projects, whereas a Data Engineer focuses on building and maintaining the broader data infrastructure and pipelines across various systems.

What are the key skills and qualifications needed to thrive as a dbt developer, and why are they important?

To thrive as a DBT Developer, you need strong SQL expertise, data modeling skills, and experience with ETL processes, typically supported by a background in computer science or data engineering. Familiarity with DBT (Data Build Tool), version control systems like Git, and cloud data warehouses such as Snowflake or BigQuery is essential. Attention to detail, problem-solving abilities, and effective communication help you deliver scalable data solutions and collaborate with cross-functional teams. These skills are crucial for building reliable data pipelines, ensuring data quality, and enabling data-driven decision-making within organizations.

What is a dbt developer?

A Dbt Developer is a data professional who specializes in using dbt (data build tool) to transform raw data into clean, reliable datasets for analytics and business intelligence. They write modular SQL code to perform data transformations, manage data models, and ensure data quality within modern data warehouses. Dbt Developers collaborate closely with data engineers, analysts, and business users to create efficient, maintainable data workflows. Their work enables organizations to make informed decisions based on trustworthy and well-structured data.

How does a dbt developer typically collaborate with data engineers and analysts on a project?

DBT Developers frequently work alongside data engineers to ensure that data pipelines provide clean, reliable data to downstream users. They collaborate with analysts to understand data requirements, define business logic, and implement transformations that support analytics and reporting. Regular communication is essential for aligning on naming conventions, documenting models, and troubleshooting issues. This collaboration often takes place through code reviews, shared documentation, and agile ceremonies such as sprint planning or stand-ups.

What are popular job titles related to Dbt Developer jobs in Philadelphia, PA?

For Dbt Developer jobs in Philadelphia, PA, the most frequently searched job titles are:

What job categories do people searching Dbt Developer jobs in Philadelphia, PA look for?

The top searched job categories for Dbt Developer jobs in Philadelphia, PA are:

What cities near Philadelphia, PA are hiring for Dbt Developer jobs?

Cities near Philadelphia, PA with the most Dbt Developer job openings:

Dbt Developer jobs near you
Infographic showing various Dbt Developer job openings in Philadelphia, PA as of August 2026, with employment types broken down into 75% Full Time, 9% Part Time, 1% Temporary, and 15% Contract. Highlights an 79% Physical, 6% Hybrid, and 15% Remote job distribution, with an average salary of $105,039 per year, or $50.5 per hour.

AI Data Engineer

IntegriChain

Philadelphia, PA • On-site, Remote

$115K - $138K/yr

Full-time

Medical, Retirement, PTO

Re-posted 28 days ago

Job description

Company Description
IntegriChain is the data and application backbone for market access departments of Life Sciences manufacturers. We deliver the data, the applications, and the business process infrastructure for patient access and therapy commercialization. More than 250 manufacturers rely on our ICyte Platform to orchestrate their commercial and government payer contracting, patient services, and distribution channels. ICyte is the first and only platform that unites the financial, operational, and commercial data sets required to support therapy access in the era of specialty and precision medicine. With ICyte, Life Sciences innovators can digitalize their market access operations, freeing up resources to focus on more data-driven decision support. With ICyte, Life Sciences innovators are digitalizing labor-intensive processes - freeing up their best talent to identify and resolve coverage and availability hurdles and to manage pricing and forecasting complexity.
We are headquartered in Philadelphia, PA (USA), with offices in: Ambler, PA (USA); Pune, India; and Medellín, Colombia. For more information, visit www.integrichain.com, or follow us on Twitter @IntegriChain and LinkedIn.
This role offers flexibility, but candidates must reside in Pennsylvania, New Jersey, or New York and be within a reasonable travel distance of our Philadelphia office, as regular in-person collaboration is required.
Job Description
Mission
Join the Data Science team as an AI Data Engineer responsible for building the data foundations that make enterprise AI products accurate, explainable, and scalable. This role will design and implement Snowflake and dbt pipelines from raw source data to curated gold-layer datasets, create semantic models that LLM tools can use reliably, and partner with data science, product, and engineering teams to convert data dictionaries and business definitions into AI-ready data products. The ideal candidate is a strong data engineer with deep Snowflake/dbt experience and a practical understanding of how semantic layers, ER relationships, denormalized models, and metadata quality influence LLM and agent performance.
Position Overview
  • Snowflake and dbt engineering: Design, build, optimize, and operate Snowflake pipelines and dbt models across raw, curated, and gold-layer datasets.
  • AI-ready semantic modeling: Create semantic models, relationships, metrics, dimensions, and curated views that allow LLM tools and agents to answer questions accurately.
  • Data dictionary-driven delivery: Translate team-defined data dictionaries, business definitions, and source mappings into tested, governed, and reusable data products.
  • Agent consumption focus: Design datasets for AI agents, natural-language analytics, Snowflake Cortex Analyst, and other LLM-powered tools.
  • Enterprise data modeling: Balance normalized source models, ER relationships, dimensional models, denormalized consumption layers, and semantic-layer needs.

Key Responsibilities
Snowflake, dbt, and Data Pipeline Development
  • Build reliable data pipelines from raw source data through curated silver layers and business-ready gold layers using Snowflake and dbt.
  • Develop modular dbt models, tests, documentation, exposures, and lineage-friendly transformation patterns.
  • Implement incremental processing, snapshots, audit columns, reconciliation, data quality checks, and restartable pipeline patterns.
  • Optimize Snowflake SQL and dbt workloads for performance, scalability, cost, and maintainability.
  • Work with orchestration and DevOps/SRE teams to support CI/CD, environment promotion, pipeline monitoring, and operational runbooks.

Semantic Models and AI-Ready Data Products
  • Create Snowflake semantic models and curated views that support accurate natural-language querying through Snowflake Cortex Analyst and related LLM tools.
  • Translate approved data dictionaries into semantic model dimensions, facts, metrics, synonyms, descriptions, relationships, and business rules.
  • Design ER relationships and join paths that are explicit, accurate, and easy for semantic-layer tools and AI agents to use.
  • Create denormalized or consumption-optimized models where appropriate to reduce ambiguity and improve LLM answer quality.
  • Partner with AI developers to understand tool schema needs, agent workflows, and how data model design affects LLM tool performance.

Data Modeling, Integration, and Consolidation
  • Design logical and physical models that support enterprise data consolidation, analytical reporting, AI workflows, and business operations.
  • Work across source systems, files, APIs, cloud storage, operational systems, and analytical platforms to integrate data into Snowflake.
  • Create reusable patterns for source-to-target mapping, schema evolution, master/reference data alignment, and data product publishing.
  • Collaborate with business and technical stakeholders to validate data definitions, grain, relationships, hierarchies, and measures.
  • Support data consolidation across Integrichain by rationalizing overlapping datasets and aligning enterprise definitions.

Snowflake Cortex and AI Platform Enablement
  • Understand Snowflake Cortex capabilities, including Cortex Analyst, Cortex Complete, semantic views/models, and metadata-driven AI workflows.
  • Prepare data models and semantic layers for accurate LLM usage, including clear naming, descriptions, relationships, metrics, and governance metadata.
  • Support AI Explorer and similar applications by ensuring curated datasets are reliable, performant, explainable, and governed.
  • Partner with AI and application teams to troubleshoot semantic model issues, poor AI answers, ambiguous joins, missing metadata, or incorrect measures.
  • Contribute to standards for AI-ready data design, semantic model review, data dictionary alignment, and LLM-friendly data modeling.

Qualifications
  • 6+ years of experience in data engineering, analytics engineering, database engineering, or data platform development in production environments.
  • Strong hands-on experience with Snowflake, including SQL development, performance tuning, security-aware design, cost optimization, and large-volume processing.
  • Strong hands-on experience with dbt or comparable ELT tooling, including models, tests, documentation, lineage, and environment promotion.
  • Experience building raw-to-curated-to-gold data pipelines and business-ready datasets.
  • Strong SQL and Snowflake development skills, including complex transformations, views, stored procedures/Snowflake Scripting, and query optimization.
  • Experience creating semantic layers, semantic models, metrics, dimensions, relationships, and curated analytical views.
  • Good understanding of ER modeling, dimensional modeling, denormalized consumption models, and data grain management.
  • Experience translating data dictionaries and business definitions into physical models, dbt models, and semantic-layer definitions.
  • Understanding of Snowflake Cortex capabilities such as Cortex Analyst, Cortex Complete, and semantic-model-driven natural-language querying.
  • Ability to partner with data science, product, engineering, and business teams to deliver AI-ready data products.

Preferred Experience
  • Experience in life sciences, healthcare, pharma commercialization, MDM, patient data, channel data, or commercial data platforms.
  • Experience with Snowflake semantic views, Cortex Analyst, Cortex Search, or other AI/LLM data platform capabilities.
  • Experience with data quality frameworks, metadata management, data observability, and lineage tooling.
  • Experience with orchestration tools such as dbt Cloud jobs, Airflow, Dagster, cloud-native schedulers, or similar platforms.
  • Experience with Python for data automation, metadata processing, testing, or API integrations.
  • Experience designing governed data products for BI, AI/ML, natural-language analytics, or agentic applications.
  • Snowflake SnowPro, dbt certification, or equivalent data engineering credentials.

Additional Information
What does IntegriChain have to offer?
  • Mission driven: Work with the purpose of helping to improve patients' lives!
  • Excellent and affordable medical benefits + non-medical perks including Student Loan Reimbursement, Flexible Paid Time Off and Paid Parental Leave
  • 401(k) Plan with a Company Match to prepare for your future
  • Robust Learning & Development opportunities including over 700+ development courses free to all employees

#LI-ZG1
IntegriChain is committed to equal treatment and opportunity in all aspects of recruitment, selection, and employment without regard to race, color, religion, national origin, ethnicity, age, sex, marital status, physical or mental disability, gender identity, sexual orientation, veteran or military status, or any other category protected under the law. IntegriChain is an equal opportunity employer; committed to creating a community of inclusion, and an environment free from discrimination, harassment, and retaliation.
Our policy on visa sponsorship for US based positions: Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by IntegriChain.
Videos To Watch
https://youtu.be/2Q_ODlJxDcQ?feature=shared

Apply