Data Engineer (DBT / AWS Redshift) – Pharma Commercial

Job Title: Data Engineer (DBT / AWS Redshift) – Pharma Commercial Location: Alameda, CA (Onsite) Employment Type: Contract- 12+ Months Job Summary: We are looking for a skilled Data Engineer with strong experience in DBT, AWS Redshift, and Pharma Commercial data. The ideal candidate will design, build, and optimize scalable data pipelines to support business analytics and reporting in the pharmaceutical commercial domain. Key Responsibilities: • Design, develop, and maintain data pipelines using DBT (Data Build Tool) • Work with AWS Redshift for data warehousing and performance optimization • Develop and manage transformations using DBT Cloud • Collaborate with business stakeholders to understand Pharma Commercial data requirements • Build data models for sales, marketing, and commercial analytics • Ensure data quality, integrity, and governance standards • Optimize SQL queries and data workflows for performance and scalability • Integrate data from multiple sources into a unified data platform Required Skills: • Strong experience in Data Engineering concepts • Hands-on experience with DBT (Data Build Tool) • Experience with AWS Redshift and cloud data platforms • Strong SQL skills and data modeling experience • Experience with DBT Cloud • Understanding of ETL/ELT pipelines • Experience in handling large datasets