Data Engineer, New Initiatives

Role Description

In this role you will build very large, scalable platforms using cutting edge data technologies. This is not a “maintain existing platform” or “make minor tweaks to current code base” kind of role. We are effectively building from the ground up and plan to leverage the most recent Big Data technologies. If you enjoy building new things without being constrained by technical debt, this is the job for you!

Our Engineering Career Framework is viewable by anyone outside the company and describes what’s expected for our engineers at each of our career levels. Check out our blog post on this topic and more here.

Please note, Dropbox is currently only authorized to hire candidates from the following provinces: Alberta, British Columbia, Ontario, and Saskatchewan.

Responsibilities

• Help define company data assets (data model), spark, sparkSQL and hiveSQL jobs to populate data models
• Conceptualize and own the data architecture for multiple large-scale projects, while evaluating design and operational cost-benefit tradeoffs within systems
• Create and contribute to frameworks that improve the efficacy of event logging data, while working with engineers to improve event logging completeness and data quality
• Implementing data quality monitoring and validation processes to ensure the accuracy, completeness, consistency, and reliability of data across the entire data lifecycle.
• Collaborate with engineers, product managers, and data scientists to understand data needs and representing key data insights in a meaningful way
• Design, build, and launch collections of sophisticated data models and visualizations that support multiple use cases across different products or domains
• Solve our most challenging data integration problems, utilizing optimal ETL patterns, frameworks, query techniques, sourcing from structured and unstructured data sources
• Determine and implement the security model based on privacy requirements, confirm safeguards are followed and evolve governance processes within allocated areas of ownership

Many teams at Dropbox run Services with on-call rotations, which entails being available for calls during both core and non-core business hours. If a team has an on-call rotation, all engineers on the team are expected to participate in the rotation as part of their employment. Applicants are encouraged to ask for more details of the rotations to which the applicant is applying.

Requirements

• Startup mentality with strong ownership to solve 0-1 problems with minimal guidance and being comfortable with ambiguities
• Excellent product strategic thinking and communications to influence product and cross-functional teams by identifying the data opportunities to drive impact
• BS degree in Computer Science or related technical field involving coding (e.g., physics or mathematics), or equivalent technical experience
• Experience designing, building and maintaining data processing systems
• Experience working with MPP system on any size/scale
• 3+ years of Python/Java/Scala development experience
• 5+ years of SQL experience (No-SQL experience is a plus) dimensional data modeling
• 3+ years of experience with the Distributed data/similar ecosystem (Spark, Hive, Presto) and streaming technologies such as Kafka/Flink
• High tech experiences are preferred