Data Engineer - Pharma Agency

Role: Data Engineer (Contract) Location: Remote (EST/Must be located in and authorized to work in the US) Hybrid/On-site/Remote: Remote (Must be located in and authorized to work in the US) No C2C Clutch Creative is a rapidly growing staffing agency. We support our clients by identifying unreachable talent that helps their businesses grow. Our candidates work with us because they know we have the best opportunities available to them and will help them navigate their next career move. We care, we're honest, and we hustle—that's what makes us Clutch. Clutch is looking for an experienced Contract Data Engineer for a client of ours. This is a freelance opportunity focused on supporting a Data Strategy team by managing complex pipelines and ensuring the integrity of marketing data across multiple cloud environments. Responsibilities • Pipeline Management: Create and manage robust data pipelines from various sources including SFTP, S3, Google Cloud Storage, and Email, ingesting data into BigQuery or Snowflake. • Data Provisioning: Support the Data Strategy team by provisioning necessary data and addressing day-to-day engineering needs. • Marketing Data Integration: Integrate and monitor new monthly data streams (e.g., Voice Media, Crossix, iSpot) while ensuring accurate mapping for cost and Marketo data. • Database Design: Design, create, and update tables in Snowflake and BigQuery that strictly adhere to evolving business requirements. • Reporting & Validation: Support monthly reporting cycles by validating data accuracy, addressing gaps, and providing the visualization team with access to relevant data sources. • Documentation: Maintain comprehensive documentation for all code changes and pipeline modifications. Qualifications • Cloud & Tools Expertise: Hands-on experience with GCP services, BigQuery, Snowflake, DBT, and Google Cloud Composer. • ETL Proficiency: Familiarity with ETL/ELT tools such as Fivetran and Hevo. • Coding Skills: Expert-level SQL and Python are mandatory. • Domain Knowledge: Strong understanding of marketing data ecosystems, including Google Analytics, Google Campaign Manager, and Google Ads. • Data Architectural Skills: Ability to work across multiple storage solutions (S3, GCS) and warehouse environments (BigQuery, Snowflake) simultaneously. • Pharma Agency experience preferred. Please read: Contact from Clutch employees will always come from the domain @clutchnow.com ONLY and we will always provide a phone number where you can contact us. Clutch will NEVER present a job offer without a verbal or video interview and we will never ask you to transfer or pay money to get hired. If you are skeptical about any email or job offer, please reach out to us directly.