Lead Data Engineer

Seattle, WA

Company Description

Dropbox is the world’s first smart workspace that helps people and teams focus on the work that matters. With more than 600 million registered users across 180 countries, we’re on a mission to design a more enlightened way of working. Dropbox is headquartered in San Francisco, CA, and has 12 offices around the world.

Team Description

Our Business Strategy & Operations team sets and drives key business initiatives across the company. We complement and support product, engineering, sales, and marketing teams across three critical areas: corporate and business unit strategy, business planning and sales operations, and business systems and tools development.

Role Description

The Data Engineer is responsible for designing and developing robust, scalable solutions for collecting, analyzing large data sets, creating and maintaining data pipelines, data structures and reports to be used by the revenue organization at Dropbox.

Responsibilities

  • Understand business processes, applications and how data is gathered; and tie application telemetry to transactional data model.
  • Design, build and manage data marts to satisfy our growing data needs.
  • Develop and manage data pipelines at enterprise scale
  • Build data expertise and own data quality for various data flows
  • Launch and support new data models that provide intuitive analytics to internal customers
  • Design and develop new framework and automation tools to enable teams to consume and understand data faster
  • Use your expert coding skills across a number of languages like SQL, Python and Java to support analysts and data scientists
  • Interface with internal data consumers to understand data needs
  • Collaborate with multiple teams in high visibility roles and own the solution end-to-end

Requirements

  • 5+ years of SQL (Oracle, AWS Redshift, Hive, etc) experience required, No-SQL experience is a plus.
  • 5+ years of Python or Java development experience.
  • 5+ years of experience with schema design and dimensional data modeling.
  • Hands-on experience working in data warehousing, data architecture and/or data engineering environments at enterprise scale.
  • Ability to analyze data to identify deliverables, gaps and inconsistencies.
  • Experience designing, building and maintaining data processing systems
  • Experience working with visualization tools like Tableau or MicroStrategy
  • Communication skills including the ability to identify and communicate data driven insights
  • BS or MS degree in Computer Science or a related technical field

Benefits and Perks

  • 100% company paid individual medical, dental, & vision insurance coverage
  • 401k + company match
  • Market competitive total compensation package
  • Free Dropbox space for your friends and family
  • Wellness Reimbursement
  • Generous vacation policy
  • 10 company paid holidays
  • Volunteer time off 
  • Company sponsored tech talks (technology and other relevant professional topics)
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).

Other open positions