Job Description


Job Overview

  • Job ID:

    J54989

  • Job Title:

    DBT Engineer with Airflow & SQL

  • Location:

    Oaks, PA

  • Duration:

    12 Months + Extension

  • Domain Exposure:

    Material

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2, 1099, C2C

  • Work Authorization:

    US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: DBT Engineer with Airflow & SQL
Location: Oaks, PA (Hybrid – 3 Days Onsite per Week)
Duration: 12+ Months
Bill Rate: $65 (C2C)
Job Type: W-2, 1099, C2C
Client: To be Disclosed
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:

We are seeking an experienced DBT Engineer with strong expertise in SQL, Python, Apache Airflow, and Snowflake. The ideal candidate will be responsible for developing and maintaining scalable data transformation models and ELT/ETL pipelines while ensuring data quality, security, and performance.

Roles and Responsibilities:

  • Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
  • Optimize data models and design star and snowflake schemas.
  • Manage data warehouse performance and implement clustering and materialized views.
  • Create scalable ELT/ETL pipelines to ingest and transform data from multiple sources.
  • Write modular and testable SQL code using version control.
  • Manage DBT project structures and development workflows.
  • Implement data quality checks, automated testing, and anomaly detection.
  • Implement data security measures, including RBAC, data masking, and row-level access controls in Snowflake.
  • Collaborate with data engineering and analytics teams.

Required Skills:

  • 5+ years of experience with DBT and hands-on DBT development.
  • 3+ years of experience with Python development.
  • 3+ years of experience with Apache Airflow.
  • 3+ years of experience with Snowflake.
  • Strong SQL development and query optimization skills.
  • Good understanding of data warehousing concepts.
  • Bachelor's degree in Computer Science, Data Engineering, or a related field.

Nice to Have:

  • Experience with cloud platforms such as AWS, GCP, or Microsoft Azure.

Apply Now
Equal Opportunity Employer

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.





Managed Solutions

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you:
Reduce your capital prices. Skip large, direct hardware purchases - and revel in prices that are a lot for a foreseeable future over time. Our superior analytics and business intelligence solutions drive bottom-line results, while not acquisition the prices related to developing in-house system.
Boost your employee's savings. Scale back your dependence on already overtaxed internal staffing resources by looking forward to Cloud Analytics Technologies, LLC for professional capability coming up with and support. Additionally, free your employees to target proactive business enhancements.
why