Build scalable analytics pipelines with modern data technologies, define data models, collaborate across teams, and optimize data processing systems.
Role Description
In this role you will build large, scalable analytics pipelines using modern 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.
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
- Collaborate with engineers, product managers, and data scientists to understand data needs, 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
- Optimize pipelines, dashboards, frameworks, and systems to facilitate easier development of data artifacts
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- 5+ years of Spark, Python, Java, C++, or Scala development experience
- 5+ years of SQL experience
- 5+ years of experience with schema design, dimensional data modeling, and medallion architectures
- Experience with the Databricks platform and data lake architectures for large-scale data processing and analytics
- 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
- 7+ years of SQL experience
- 7+ years of experience with schema design, dimensional data modeling, and medallion architectures
- Experience with Airflow or other similar orchestration frameworks
- Experience building data quality monitoring using MonteCarlo or similar tools
US Zone 1
This role is not available in Zone 1
US Zone 2
$145,400—$196,600 USD
US Zone 3
$129,200—$174,800 USD
Top Skills
Airflow
C++
Databricks
Hivesql
Java
Montecarlo
Python
Scala
Spark
Sparksql
SQL
Dropbox Boston, Massachusetts, USA Office
Boston, MA, United States
Similar Jobs at Dropbox
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
As a Staff Data Engineer at Dropbox, you'll build scalable commerce data pipelines and support data strategy, governance, and architecture to enhance business decisions.
Top Skills:
AirflowDatabricksHive Map/ReducePythonSnowflakeSparkSQL
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
The Senior Insights Analyst will build a data foundation, drive analytics, and provide actionable insights to enhance sales performance and revenue growth.
Top Skills:
DatabricksExcelPythonRSalesforceSQLTableau
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
The Senior Director will lead a data science team, drive data-informed decision-making, and create a strong analytical culture within the organization.
Top Skills:
Applied MathematicsComputer ScienceEconomicsEngineeringMachine LearningPredictive ModelingSQLStatistics
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
