The Senior 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.
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
5+ years of Python or Java 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 simplifies the way people work together. 500 million registered users around the world use Dropbox to work the way they want, on any device, wherever they go. With 150,000 businesses on Dropbox Business, we’re transforming everyday workflows and entire industries.