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.