Data Architect

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 Architect 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.
  • Build an adaptable data architecture allowing our revenue / marketing analysts and data scientists to build and iterate on new data marts quickly.
  • Define standards for modeling, naming, governing and delivering data across revenue organization.
  • Develop and maintain processes and standards to enable data access, reporting, quality and master data management.
  • 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
  • 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
  • 8+ years of experience with schema design and dimensional data modeling.
  • 8+ years of SQL (Oracle, AWS Redshift, Hive, etc) experience is required.
  • 8+ years of experience in custom or structured (ie. Informatica/Talend/Pentaho) ETL design, implementation and maintenance;
  • Ability to analyze data to identify deliverables, gaps and inconsistencies.
  • Ability in managing and communicating data warehouse project 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
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).


Meet Some of Dropbox's Employees

Will K.

Staff Engineer

Will operates as the tech lead for a soon-to-be-released initiative and other special Dropbox projects. He also pushes for modern best practices for client application development on Mac and iOS.

Constance D.

Software Engineer

Constance builds Dropbox’s channel platform for reseller partners, which enables Dropbox to expand to users and businesses in new regions. She has also contributed to several monetization platform launches, including chargeback automation and Dropbox Education.


Back to top