Logo of Huzzle

Home

Matches

Explore

Manage

Data Engineer, Analytics

image

Shutterstock

3mo ago

  • Job
    Full-time
    Mid & Senior Level
  • Data
    Software Engineering
  • Dublin
  • Quick Apply

AI generated summary

  • You should have hands-on experience in data engineering, strong SQL skills, ETL/ELT pipeline creation, DBT proficiency, AWS tools, Python/Java knowledge, and familiarity with BI tools and cloud warehousing.
  • You will design and build analytics solutions, manipulate large datasets, support reporting automation, develop data models with DBT, and provide operational support for data infrastructure.

Requirements

  • Relevant hands-on experience as a Data Engineer, Data Modeler, Data Architect, Analytics Engineer, or BI Engineer translating requirements into technical solutions
  • Strong SQL expertise, including experience with large datasets
  • Professional experience with data modeling (including dimensional modeling), data warehouse design, building ETL/ELT pipelines, and end-to-end analytics solutions (using Airflow, Fivetran)
  • Hands-on experience with DBT including SQL optimization, CTEs, and windowing functions
  • Strong understanding of data access patterns and impacts on performance for relational and dimensional models [including columnar formats]
  • Experience developing software in one of the following languages: Python, Java/Scala (or another JVM language)
  • Hands on AWS experience using such items as IAM, DynamoDB, Lambda, Glue, etc
  • BS or MS degree in Computer Science, Mathematics, Physics, a related field, or equivalent professional experience
  • Domain experience in Marketing, CRM, Customer Analytics
  • Experience using BI tools to build dashboards and model data
  • Experience with CDP / Reverse ETL (Segment, Hightouch, etc)
  • Experience with Cloud Data Warehousing technology such as Snowflake
  • Linux and Docker knowledge
  • Experience with enterprise databases like Oracle, Netezza, and Teradata

Responsibilities

  • Partner with BI analysts 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, 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

FAQs

What does the role of a Data Engineer, Analytics at Shutterstock entail?

The role involves partnering with BI analysts and technical stakeholders, designing and building end-to-end analytics solutions, manipulating large datasets, and supporting the day-to-day operations of data and analytics engineering infrastructure.

What technologies and tools should I be familiar with for this role?

Candidates should have experience with the Modern Data Stack, including Snowflake, DBT, Monte Carlo, Hightouch, and Looker, as well as expertise in SQL, AWS, and data modeling tools.

What kind of experience is required for this position?

Relevant hands-on experience as a Data Engineer, Data Modeler, Data Architect, Analytics Engineer, or BI Engineer is required, along with strong SQL expertise and experience in data warehouse design, ETL/ELT pipelines, and analytics solutions.

Is a specific degree necessary for applying to this position?

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

Are there any additional skills or experiences that would be beneficial?

Yes, knowledge in areas such as Marketing, CRM, Customer Analytics, experience with BI tools, Cloud Data Warehousing technology like Snowflake, and familiarity with Linux and Docker would be advantageous.

What is the company's stance on work-life balance?

Shutterstock offers flexibility to work between home and office, ensuring employees have everything they need to be successful in both environments.

Does Shutterstock provide support for career development?

Yes, executive leadership prioritizes growth and plans career paths with employees' goals and passions in mind.

What kind of impact will this role have within the company?

The Data Engineer, Analytics role has a direct impact on the success of the company by delivering essential information to decision-makers, analysts, and developers across various businesses.

Is Shutterstock an equal opportunity employer?

Yes, Shutterstock is an Equal Opportunity Employer and encourages all qualified candidates to apply regardless of various protected statuses.

How does Shutterstock support employees with disabilities?

Shutterstock ensures that individuals with disabilities are provided reasonable accommodation to participate in the job application process and perform essential job functions.

image

Shutterstock

Shutterstock bridges the gap between idea, design, and execution, inspiring the world to create with confidence.

Technology
Industry
1001-5000
Employees
2003
Founded Year

Mission & Purpose

Shutterstock, Inc. (NYSE: SSTK) is a premier partner for transformative brands and digital media and marketing companies, empowering the world to create with confidence. Fueled by millions of creators around the world, a growing data engine and a fearless approach to product innovation, Shutterstock is the leading global platform for licensing from the most extensive and diverse collection of high-quality 3D models, videos, music, photographs, vectors and illustrations. From the world's largest content marketplace, to breaking news and A-list entertainment editorial access, to all-in-one content editing platform and studio production service—all using the latest in innovative technology—Shutterstock offers the most comprehensive selection of resources to bring storytelling to life. At Shutterstock we understand that Diversity, Equity and Inclusion makes us more effective and is essential to innovation. We are deeply focused on equality and are committed to diversity across areas including race, gender, gender identity or expression, sexual orientation, disability, religion, ethnicity and national origin. Guided by our Seek Diversity principle, our goal is to build a workforce, contributor network, and content library that is representative of the diverse global community.