Senior Data Engineer, New Initiatives

Key Skills

C++, Data Modeling, Data science techniques, ETL frameworks, Java Programming, MapReduce, NoSQL, Python Programming, SLA, Spark-SQL

Job 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!

Responsibilities

• Help define company data assets (data model), spark, sparkSQL and hiveSQL jobs to populate data models
• Help define and design data integrations, data quality frameworks and design and evaluate open source/vendor tools for data lineage
• Work closely with Dropbox business units and engineering teams to develop strategy for long term Data Platform architecture to be efficient, reliable and scalable 
• 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 logging data, while working with data infrastructure to triage issues and resolve
• Collaborate with engineers, product managers, and data scientists to understand data needs, representing key data insights in a meaningful way
• Define and manage SLA for all data sets in allocated areas of ownership
• Determine and implement the security model based on privacy requirements, confirm safeguards are followed, address data quality issues, and evolve governance processes within allocated areas of ownership
• 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
• Optimize pipelines, dashboards, frameworks, and systems to facilitate easier development of data artifacts

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
• 5+ years of Python or Java, C++, Scale development experience
• 7+ years of SQL experience (No-SQL experience is a plus)
• 5+ years of experience with schema design and dimensional data modeling
• Proven ability in regards to 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
• High tech experiences are preferred

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.

Benefits

Dropbox is committed to investing in the holistic health and wellbeing of all Dropboxers and their families. Our benefits and perks programs include, but are not limited to:

• Competitive medical, dental and vision coverage*
• Retirement Savings through a defined contribution pension or savings plan**
• Dropbox provides a Flexible PTO Policy in addition to your statutory holidays allowing you to unplug, unwind, and refresh
• Dropbox also provides exclusive additional paid time off for all FTE employees across the Globe, in addition to any relevant statutory holidays
• Protection Plans including Life and Disability Insurance*
• A Perks Allowance to be used on what matters most to you, whether that’s wellness, learning and development, food & groceries, and much more
• Parental benefits including; Parental Leave, Fertility Benefits, Adoptions and Surrogacy support, and Lactation support 

Additional benefits details are available upon request.

*Where group plans are not available, allowances are provided

**Benefit, amount, and type are dependent on geographical location, based upon applicable law or company policy