Lead Data Engineer – Dropbox at Dropbox in San Francisco, California | AnalyticTalent.com

Company Description

Dropbox is a leading global collaboration platform that’s transforming the way people work together, from the smallest business to the largest enterprise. With more than 500 million registered users across more than 180 countries, our mission is to unleash the world’s creative energy by designing a more enlightened way of working.

Headquartered in San Francisco, CA, Dropbox has more than 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 Python or Ruby development experience is necessary;
  • 8+ years of SQL (Oracle, AWS Redshift, Hive, etc) experience is required, No-SQL experience is a plus;
  • 8+ years of experience in custom or structured (ie. Informatica/Talend/Pentaho) ETL design, implementation and maintenance;
  • 8+ years of experience with schema design and dimensional data modeling.
  • Ability to analyze data to identify deliverables, gaps and inconsistencies.
  • Ability in managing and communicating data warehouse plans to internal clients.
  • Experience designing, building and maintaining data processing systems
  • Experience working with either a Map Reduce or a MPP system on any size/scale
  • 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

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).

Author:

Just a figment of your imagination.