Data Engineer

Company Description

Dropbox is a special place where we are all seeking to fulfill our mission to design a more enlightened way of working. We’re looking for innovative talent to join us on our journey. The words shared by our founders at the start of Dropbox still ring true today. Wouldn’t it be great if our working environment—and the tools we use—were designed with people’s actual needs in mind? Imagine if every minute at work were well spent—if we could focus and spend our time on the things that matter. This is possible, and Dropbox is connecting the dots. The nearly 3,000 Dropboxers around the world have helped make Dropbox a living workspace - the place where people come together and their ideas come to life. Our 700+ million global users have been some of our best salespeople, and they have helped us acquire customers with incredible efficiency. As a result, we reached a billion dollar revenue run rate faster than any software-as-a-service company in history. Dropbox is making the dream of a fulfilling and seamless work life a reality. We hope you’ll join us on the journey.

Team Description

Our Engineering team is working to simplify the way people work together. They’re building a family of products that handle over a billion files a day for people around the world. With our broad mission and massive scale, there are countless opportunities to make an impact.

Role Description

• Do you dream about Data and talk to your friends in SQL?
• Do you want to inspire and be inspired by working with the best and brightest?
• You’re friendly, positive, professional, and fun to work with!
• You’re a creative thinker with excellent problem­ solving and decision ­making ability. 
• You’re proactive, self­ starting, organized, and willing to take on difficult problems.
• You have excellent communication skills, both written and verbal. 
• You’re self­ motivated, energetic, and passionate.

You’ll be the genius who understands data at Dropbox, knows where to find it and manages the process to make that data useful for Growth and Monetization at Dropbox. You love thinking about the ways the business can consume this data and then figuring out how to build it. On a typical day you may be consulted on the information architecture of our subscriptions / invoicing systems and help design the event collection infrastructure. You will also be responsible for understanding and curating Gold datasets associated to all Dropbox customers that will be used for marketing, segmentation and several other analytics and operational use cases. You’ll build the data models and ETL processes to provide this data for business use. You've got some practical experience working with large datasets. You are interested in reporting platforms and data visualization.

You may be interested in machine learning or statistics or one of several similar fields. But the most important factor is you have a strong foundation in test driven development and building scalable data pipelines. As part of the Dropbox’s FDE team, you'll own a problem end-to-end, so those skills will come in handy not just to collect, extract and clean the data, but also to understand the systems that generated it, and automate your processes to produce reliable and trustworthy data. On an on-going basis, you'll be responsible for improving the data by adding new sources, coding business rules and producing new metrics that support the business.

As a data engineer, you have experience spanning traditional DW and ETL architectures and big data ecosystems like Databricks / Snowflake / EMR / Airflow. You’ve probably been in the industry an engineer and have developed a passion for the data that drives businesses. You'll need to be technical at heart, comfortable with the idea of extending systems by writing code, rather than just relying on in-built functionality.

Our Engineering Career Framework is viewable by anyone outside the company and describes what’s expected for our engineers at each of our career levels. Check out our blog post on this topic and more here.

Responsibilities

• Build and manage data pipeline generating P0 (most critical) metrics for Dropbox
• Pay meticulous attention to end-to-end data quality, validation, and consistency
• Solve our most challenging data integration problems, utilizing optimal ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data sources
• Challenge status quo and adopt industry best practices
• Work closely with Dropbox business and engineering teams and anticipate how they'd like to use the curated data sets
• Excellent communication skills and comfortable with Agile software development methodologies 
• Collaborate with cross functional teams, product managers, and data scientists to understand data needs, representing key data insights in a meaningful way
• Define and manage SLA for all data sets in allocated areas of ownership
• Build cost optimized and efficient data pipelines that are easy to govern and manage
• Strong ownership to solve 0-1 problems with minimal guidance and being comfortable with ambiguities

Many teams at Dropbox run Services with on-call rotations, which entails being available for calls during both core and non-core business hours. If a team has an on-call rotation, all engineers on the team are expected to participate in the rotation as part of their employment. Applicants are encouraged to ask for more details of the rotations to which the applicant is applying.

Requirements

• Proficient in spark, sparkSQL and hiveSQL
• Experience working with Snowflake / Databricks or similar distributed compute systems
• Excellent understanding of scheduling and workflow frameworks. Prefer prior experience with Airflow
• You've used version control systems like Git and have experience with test automation and CICD
• 4+ years of SQL experience
• 4+ years of experience with schema design and dimensional data modeling
• Experience designing, building and maintaining data processing systems
• BS degree in Computer Science or related technical field involving coding (e.g., physics or mathematics), or equivalent technical experience

Dropbox is an equal opportunity employer. We are a welcoming place for everyone, and we do our best to make sure all people feel supported and connected at work. A big part of that effort is our support for members and allies of internal groups like Asians at Dropbox, BlackDropboxers, Latinx, Pridebox (LGBTQ), Vets at Dropbox, Women at Dropbox, ATX Diversity (based in Austin, Texas) and the Dropbox Empowerment Network (based in Dublin, Ireland).