Middle Data Analytics Engineer

Location: Ukraine

Department: Shutterstock Team

We are looking for a Middle Data Analytics Engineer to build reusable, production-grade pipelines that power our data deals, which are large-scale curated training sets for leading AI labs. You’ll ship engineering solutions with immediate revenue impact and collaborate with some of the world’s largest AI companies. 

Responsibilities:

• Work with the business development (BD) team, content experts, data science, and engineering teams to understand customer requirements and available metadata.
• Map customer requirements to our existing metadata and apply data modelling practices to maximize reusability and scalability
• Build DBT models that are capable of querying up to 1B rows efficiently
• Refine DBT models based on visual QA to ensure accurate datasets at scale.
• Propose and implement automated solutions that streamline the curation process and increase scalability.
• Serve as the engineering point of contact, partnering with Business Development to ensure accurate timelines, clear requirements, and manage all technical implementation pieces of the workflow
• Assist the expansion of the data curation workflow to accommodate data science approaches within DBT, streamline the review process to ensure a more rigorous statistical approach with more comprehensive testing

Requirements:

• Strong SQL background with an understanding of query optimization and Snowflake experience.
• DBT experience preferred. 
• Great communication skills.
• 3-5 years of experience in analytics/data engineering.
• Perform code reviews and collaborate with the team to create an optimized ecosystem.

Nice to have:

• BigQuery.
• Python.
• ClickHouse.
• Experience delivering projects in an operational environment. 
• Interest in data science to aid the understanding of customer use cases.
• Interest in photography, music and video creation.