Data Engineer II

In Shutterstock, our data ecosystem is continuously growing as we consistently expand our business domains. We are looking for ambitious Data Analytics Engineers with a passion for analytics engineering, the Modern Data Stack [Snowflake, DBT, Airflow, Monte Carlo, Hightouch, Tableau, Looker, etc], data modeling, data accuracy, and insightful analysis. As the organization evolves, so does its dependence on data - we are looking for a Data Analytics Engineer to expand how we get data into the hands of decision-makers, analysts, and developers across our multiple businesses. A successful candidate will understand the big-picture needs of a publicly-traded international eCommerce business and deliver information with speed, accuracy, and clarity.The day to day: 

• Partner with BI analysts, business and technical stakeholders to understand requirements and collaborate on providing solutions at scale

• Design and build end-to-end analytics solutions, including data acquisition, modeling, transformation, reporting, activation and insights

• Manipulate large datasets quickly and efficiently in both relational and “big” data stores

• Support streamlining and automation of ad-hoc and standardized reporting functions

• Build data models and transformations using DBT with an emphasis on best practices, consistency, performance, and scalability

• Day-to-day operational support of data and analytics engineering infrastructure, products, and services, including on-call routine

What you’ll bring to the role: 

• 3+ years of hands-on experience as a Data Engineer, Analytics Engineer, or BI Engineer translating requirements into technical solutions

• 2+ years professional experience with data modeling (including dimensional modeling), data warehouse design, building ETL/ELT pipelines, and end-to-end analytics solutions.

• Hands-on experience with DBT including SQL optimization, CTEs, and windowing functions

• Experience with Cloud Data Warehousing technology such as Snowflake

• Strong understanding of data access patterns and impacts on performance for relational and dimensional models [including columnar formats]

• BS or MS degree in Computer Science, Mathematics, Physics, a related field, or equivalent professional experience.

Any of these would be a bonus: 

• Professional hands-on experience working as Data Modeler, Data Architect

• Domain experience in Marketing, CRM, Customer Analytics

• Experience with CDP / Reverse ETL (Hightouch, etc)

• Hands on AWS experience using such items as IAM, DynamoDB, Lambda, etc

• Experience developing software in one of the following languages: Python, Java/Scala (or another JVM language)

• Experience using Looker to build dashboards and model data (LookML)

Why Shutterstock:

• You have a direct impact on the success of the company. Your team’s work matters and is essential to the evolution of our core business!

• Executive leadership cares personally. They prioritize growth and planning your career path with your goals and passions in mind

• Flexibility to work between home and office with everything you need to be successful in both

• Extensive and competitive benefits package. 

Shutterstock connects diverse artists and creative professionals around the globe with the agencies, brands and people who need their work and services. It’s a place where creators come to be inspired and discover new ways to produce their best work.Shutterstock enables its employees to drive culture and tap into the world around them to develop the toolbox and solutions that help others share their world views. At Shutterstock, your ideas will be welcomed, your uniqueness will be celebrated, and you will be  supported in presenting your view of the world as you  experience it. We’re champions of resiliency;  quickly learning from our shortcomings in our pursuit of continuous growth.

Shutterstock Values

We are one team collectively focused on creating an unrivaled experience for our Customers and Contributors. Our Values represent the mindset of the employee who will thrive at Shutterstock.  If you are passionate about what you do, and want to become part of a cutting-edge technology company building industry leading products, please apply.

Shutterstock is an Equal Opportunity Employer. Suitably qualified and eligible candidates are encouraged to apply  regardless of age, color, disability, national origin, ancestry, race, religion, gender, sexual orientation, gender identity and/or expression, veteran status, genetic information, or any other status protected by applicable law.

Shutterstock ensures that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.  Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, accommodation_request@shutterstock.com.