Data Engineer II

At Shutterfly, we make life’s experiences unforgettable. We believe there is extraordinary power in the self-expression. That’s why our family of brands helps customers create products and capture moments that reflect who they uniquely are.

As part of the Shutterfly Data Engineering team, our Data Engineer will tackle the scalability, performance and distributed computing challenges needed to collect, process and store data for the company with a primary focus on manufacturing data. You will work in conjunction with analytics teammates to lay the data-foundations for analytic tool development, understand the business context of data assets, and actively maintain and improve the team's portfolio of value-add logic/code and data processes. Additionally, you will work with various functional units to ensure solutions are successfully deployed, operationalized, and maintained.

You will also help support the migration of our manufacturing operations data to AWS Cloud, supporting the breadth and depth of the company’s analytic needs.  You will build, design, develop, test, deploy, maintain and enhance full-stack data engineering solutions. Experience with the AWS platform is a big plus! The Data Engineer role will report to the Director of Data Engineering, Manufacturing Operations.

Great to Haves (Your Skills)

• Experience designing Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies
• Experience documenting database design including data modeling, metadata and business process flow for business integration requirements
• Experience documenting technical ETL specifications for a data warehouse – including data quality and integrity checks
• Strong analytical and interpersonal skills
• Strong debugging and problem-solving skills
• Experience with Agile/Scrum methodologies
• Enthusiastic, highly motivated and ability to learn quickly
• Ability to work through ambiguity in a fast-paced, dynamically changing business environment
• Ability to manage multiple tasks at the same time with minimum supervision

Great to Haves (Your Background)

• Bachelor’s degree from an accredited university or college in computer science or related field
• 3+ years’ experience in the data warehouse space
• 3+ years’ experience working with large scale ETL systems (implementation and maintenance, CDC/Event-driven architectures)
• Experience with ETL Tools like: Informatica, Oracle Data Integrator, Talend, Snaplogic, etc.
• Experience dealing with large databases
• Experience working with databases such as MemSQL, MySQL, Postgres, Redshift
• SQL proficiency
• Experience with AWS services such as S3, EC2, DMS, EMR, RDS, Glue, Athena, Kinesis
• Experience in any of the following are preferred but not required: Spark, Python, PySpark
• Strong written and verbal communication skills to collaborate with stakeholders at all levels of the company

Supporting a diverse and inclusive workforce is important to Shutterfly not only because it directly reflects our value of Embracing our Differences, but also because it’s the right thing to do for our business and for our people. We welcome all applicants and evaluate them based on their qualifications, without regard to age, race, creed, color, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, nationality, sex, or other characteristic covered by law. Learn more about our commitment to Diversity, Equity, and Inclusion on our Career Site.

This position will accept applications on an ongoing basis until filled.

The compensation package for this role is based on multiple factors, such as job level, responsibilities, location, and candidate experience. The base pay ranges included below are specific to the locations listed and may not be applicable to other locations.

California : [$122,550 - 174,000]

Connecticut, New York, and Rhode Island: [$122,550 159,250]

Colorado and Washington: [$122,550 - 147,500]

Nevada: [$115,250 - 159,250]

This position may be eligible for a bonus incentive, health benefits, a 401K program, and other employee perks. More details about our company benefits can be found at https://shutterflyinc.com/benefits/.

This opportunity can be remote, but candidates must reside in a state in which Shutterfly is registered to do business. This includes all US states except District of Columbia, North Dakota, Mississippi, Rhode Island, Vermont, and Wyoming.