Senior Data Engineer

Engineering Redwood City, California New York, New York


Shutterfly is seeking an experienced Senior Data Engineer with Software Engineering skills to join the Data Warehouse Development team. You will own, manage and drive end-to-end solutions and data infrastructure. You will work with analytics and business partners to deliver data solutions in support of insights and analysis of a multi-million customer ecommerce business with both internal and external data. If you like applying your expertise with data-warehousing technical concepts, CS fundamentals and data and system architecture to multi-terabyte, multi-source data, come join the Shutterfly Data Warehouse Development team!



  • Build data expertise and own data quality for the pipelines you build
  • Architect, build and launch new data models and data marts that provide intuitive analytics to your customers
  • Design, build and launch extremely efficient & reliable data pipelines to move data (both large and small amounts) into and out of the Shutterfly Data Warehouse
  • Design and develop new systems and tools to enable folks to consume and understand data faster
  • Use your coding skills across a number of languages including Python and Java
  • Have a clear understanding of the reports/analyses/insights to be driven by data and build data solutions to optimally support the analytics needs
  • Integrate third party data to enrich our data environment and enable new analytic perspectives
  • Become fully immersed in the context of Business Development and Partner business initiatives
  • Work across multiple teams in high visibility roles and own solutions end-to-end
  • Work with program managers, business partners and other engineers to develop and prioritize project plans



  • 5+ years of experience with implementing big data business solutions at productions scale

  • Expert knowledge of SQL
  • History of building, maintaining and automating reliable and efficient ETL, ELT jobs
  • Strong CS fundamentals and experience developing with object-oriented programming (Java, Python)
  • Expertise with dimensional warehouse data models (star, snowflake schemas)
  • Experience with Cloud Data Warehouses, like Google BigQuery and Amazon Redshift, is preferred
  • Experience with multi-Terabyte MPP relational databases, such as Teradata, and concepts
  • Understanding of Hadoop or Spark, including manipulating data with with Pig, Hive and potentially with Java or Python
  • Understanding of streaming technologies and concepts used with data warehouses, is preferred
  • Understanding of automation and orchestration platforms such as Automic (formerly UC4) and Airflow