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.
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.
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.
- 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
- 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
- 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)
Back to top