DBT Data Pipeline Developer

Overview

Remote
Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 2 month(s)

Skills

Python
Regression Testing
Data Modeling
Airflow
data pipelines
data transformations
AWS Glue
AWS Lambda
Data Reconciliation
Cloud Data Warehouse
Data Lineage
Dimensional modeling
Amazon Redshift
Orchestration tools
DBT Developer
DBT Data Pipeline Developer
DBT Core
DBT Cloud
ELT / ETL Development
Star Schema
SQL Modeling
AWS Redshift
Enterprise Data Warehouse (EDW)
Data Lake / Lakehouse
Multi-layer Architecture
Oracle EBS Accounts Receivable
EBS AR Data
AR Invoices / Payments / Receipts
Oracle EBS Data Model
ERP Source Data Integration
Financial Data Pipelines
DBT Tests
Data Quality Validation
Record Count Validation
Business Rules Validation
DBT Documentation
YAML Metadata
Data Flow Documentation
AR Aging reports
Incremental Data Pipelines
Fact & Dimension Tables
Unit & Integration Testing

Job Details

Solution IT Inc. is looking for a DBT Data Pipeline Developer for one of its clients in Remote

Job Title: DBT Data Pipeline Developer

Summary:

We are seeking an experienced DBT Data Pipeline Developer to support a project focused on extracting, transforming, and loading Accounts Receivable (AR) data from Oracle E-Business Suite (EBS) into Amazon Redshift. The resource will help build out our Enterprise Data Warehouse architecture, moving data from source to staging, and ultimately into a cleansed and modeled Gold Layer using a star schema design.

Responsibilities:

Data Pipeline Development

  • Develop DBT models and pipelines to extract and stage Oracle EBS AR data into Redshift.
  • Build transformation logic in DBT to load curated data into a dimensional star schema model in the Gold Layer.
  • Design and implement incremental models, materializations (views/tables), and data lineage.

Testing & Validation

  • Implement and automate DBT tests for data quality, accuracy, and business logic across all layers (staging, core, mart).
  • Validate record counts, AR balances, and business rules between EBS source and warehouse layers.
  • Support unit, integration, and regression testing in DBT Cloud or equivalent CI/CD pipelines.

Collaboration & Documentation

  • Work closely with data architects, analysts, and business users to gather requirements and deliver verified and governed datasets.
  • Document models, data flows, and transformation logic using DBT's built-in documentation and version control.
  • Provide hands-on troubleshooting, monitoring, and improvements for production-grade pipelines.

Required Skills:

  • 3+ years of experience building ELT/ETL pipelines, with at least 1+ year of hands-on DBT development (DBT Core or DBT Cloud).
  • Strong SQL development skills with the ability to work with large datasets in Amazon Redshift.
  • Proven experience building curated and refactored dimensional/star schema models.
  • Ability to write and maintain DBT tests, YAML metadata, macros, and documentation.
  • Familiarity with CI/CD pipeline concepts and version control (Git).

Preferred skills:

  • Oracle EBS data model knowledge, specifically for Accounts Receivable (AR).
  • Experience with EBS modules or AR processes (e.g., invoices, payments, receipts, aging).
  • Familiarity with Python, Airflow, or AWS Glue is a plus.
  • Experience with enterprise data warehouses in a multi-layer architecture (bronze/silver/gold).

Work Site: Remote

Duration: 2 months

Expected Start Date: 2 Weeks

Number of Positions: 1

Please send your responses back to

About Solution IT

Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston, Massachusetts.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.