Marketing Data Engineer

Marketing Redwood City, California


Description

2019 - Marketing Platform - Data Engineer

The Marketing Platform Data Engineer will have a solid background in Data Warehousing  and Marketing.  The Engineer will also work with a team of Data Engineers and work closely with the Marketing Business, Marketing Operations, Marketing Analytics, and Corporate Data Warehouse teams to implement, fine tune, and troubleshoot the Marketing Data Infrastructure.  This person will primarily support the building of data pipelines for the Shutterfly Business Unit; to make data available in the cloud.  Finally, this person will enhance and adhere to strict development standards for both themselves and their team.

Role:

  • Support migration of data to AWS cloud for Shutterfly Marketing
  • Support the building of Marketing ETLs for the Operations and Analytics teams
  • Build data pipelines in AWS ( S3, EC2, EMR, Redshift ) & Talend
  • Monitor and Maintain Marketing ETLs
  • Work efficiently with Marketing Stakeholders
  • Migrate Marketing ETLs to new platforms, with new services, on new systems

Requirements:

  • BS or MS in Computer Science or equivalent with at least 1 year of AWS work experience
  • Experience working with large scale Data Warehousing environments
  • Experience with industry standard ETL tools, e.g. Talend
  • Experience with Salesforce Marketing Cloud - Automation Studio
  • Proficient with SQL

Desired:

  • Knows about and has implemented the latest data infrastructure technologies
  • Willing to learn and educate ETL design best practices
  • Experience with Oracle SQL
  • Has experience with Databricks
  • Eager to learn and implement cloud technologies like AWS, S3, Redshift
  • Understands scripting languages
  • Wants to be mentored
  • Support and challenge team members
  • Experience with APIs (Specifically Batch and Data APIs)
  • Experience in Python, Spark ETL and Airflow

Extra Goodies That Are Nice To Have (with working examples):

  • loves to leave things better than how you found them
  • Has a great sense of humor
  • Has ETL horror campfire stories to tell
  • Likes to get nerdy

#LI-GM1