Data Engineer, Analytics Data Engineering

Dropbox; Canada; Remote; CAD 125,000 - 170,000; Full time

Job summary

An innovative firm is seeking a Data Engineer to build large-scale analytics pipelines using cutting-edge technologies. This role offers the opportunity to create from the ground up, leveraging the latest Big Data tools without the constraints of legacy systems. You will collaborate with cross-functional teams to define data assets, optimize pipelines, and design sophisticated data models that support various products. If you're passionate about transforming data into actionable insights and thrive in a dynamic environment, this is the perfect role for you. Join a forward-thinking company that values your contributions and fosters growth.

Benefits

Competitive medical, dental and vision coverage

Retirement savings plan

Flexible PTO policy

Income Protection Plans

Business Travel Protection

Perks Allowance

Parental benefits

Mental health and wellness benefits

Qualifications

• 5+ years of experience in Spark, Python, Java, C++, or Scala.
• Experience with schema design and dimensional data modeling.

Responsibilities

• Build large, scalable analytics pipelines using modern data technologies.
• Collaborate with teams to develop long-term Data Platform architecture.

Skills

Spark

Python

Java

C++

Scala

SQL

Data Modeling

Data Architecture

Education

Bachelor's Degree in Computer Science

Equivalent Technical Experience

Tools

Databricks

Airflow

MonteCarlo

Job description

Dropbox is a Virtual First company. For this role, we are currently only authorized to hire candidates from the following provinces: Alberta, British Columbia, Ontario, and Saskatchewan.

Company Description

Dropbox isn’t just a workplace—it’s a living lab for more enlightened ways of working. We're a global community of bold visionaries and resourceful doers who are shaping the future of Dropbox—and with it the future of work. Our Virtual First model combines the autonomy of a distributed workplace with the power of human connection, making space for both meaningful work and meaningful relationships. With our start-up mindset and enterprise-level opportunities, you can be who you are and grow into who you’re meant to be. Here, you can own your impact to make work more intuitive, joyful, and human—for you as a Dropboxer and for hundreds of millions of people worldwide. If you're ready to push boundaries—and yourself— Dropbox is ready for you.

Team Description

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!

• 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

Preferred Qualifications

• 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

Compensation

$125,000—$169,100 CAD

The range listed above is the expected annual salary/OTE for this role, subject to change.

Salary/OTE is just one component of Dropbox’s total rewards package. All regular employees are also eligible for the corporate bonus program or a sales incentive (target included in OTE) as well as stock in the form of Restricted Stock Units (RSUs).

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**
• Flexible PTO/Paid Time Off policy in addition to statutory holidays, allowing you time to unplug, unwind, and refresh
• Income Protection Plans: Life and disability insurance*
• Business Travel Protection: Travel medical and accident insurance*
• 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
• Mental health and wellness benefits

Additional benefits details are available upon request.

*Where group plans are not available, allowances may be provided

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

Dropbox is a Virtual First company. For this role, we are currently only authorized to hire candidates from the following provinces: Alberta, British Columbia, Ontario, and Saskatchewan.

Company Description

Dropbox isn’t just a workplace—it’s a living lab for more enlightened ways of working. We're a global community of bold visionaries and resourceful doers who are shaping the future of Dropbox—and with it the future of work. Our Virtual First model combines the autonomy of a distributed workplace with the power of human connection, making space for both meaningful work and meaningful relationships. With our start-up mindset and enterprise-level opportunities, you can be who you are and grow into who you’re meant to be. Here, you can own your impact to make work more intuitive, joyful, and human—for you as a Dropboxer and for hundreds of millions of people worldwide. If you're ready to push boundaries—and yourself— Dropbox is ready for you.

Team Description

The Dropbox Engineering Team builds the technology that creates more enlightened ways of working for hundreds of millions of people. Every day, our platforms—including Dropbox Dash, Dropbox Sign, and our core sync engine—handle over a billion files for users worldwide, creating engineering challenges as great as the opportunity for impact. Our software engineering team uses a range of technologies to solve interesting problems, including Python, React, Node.js, JavaScript, MongoDB, PostgreSQL, and Android development. We think like a startup but build for an enterprise, exploring new possibilities that transform how people work. If you're excited about turning complex technical challenges into intuitive solutions at scale, join our Engineering team.Areas of work include Machine Learning Engineers, Infrastructure Engineer, Product SWE Frontend and Backend, Mobile Software Engineers (iOS and Android), Engineering Manager, Data Engineer, Software Development Engineer in Test, Security Engineering, Site Reliability Engineer, Technical Program Managers, Network Engineer, Datacenter Engineer, Technical Supply Chain Manager and more.

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

Preferred Qualifications

• 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

Compensation

Canada Pay Range $125,000—$169,100 CAD

The range listed above is the expected annual salary/OTE for this role, subject to change.

Salary/OTE is just one component of Dropbox’s total rewards package. All regular employees are also eligible for the corporate bonus program or a sales incentive (target included in OTE) as well as stock in the form of Restricted Stock Units (RSUs).

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**
• Flexible PTO/Paid Time Off policy in addition to statutory holidays, allowing you time to unplug, unwind, and refresh
• Income Protection Plans: Life and disability insurance*
• Business Travel Protection: Travel medical and accident insurance*
• 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
• Mental health and wellness benefits

Additional benefits details are available upon request.

*Where group plans are not available, allowances may be provided

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

Dropbox is an equal opportunity employer. We are a welcoming place for everyone, and we do our best to make sure all people feel supported and connected at work. A big part of that effort is our support for members and allies of internal groups like Asians at Dropbox, BlackDropboxers, enABLE, TODOS (Latinx), Pridebox (LGBTQ), Vets at Dropbox, and Women at Dropbox.

Other open positions