Data Engineer

Dropbox

Remote - Canada: Select locations ·

Job description

<h2>Role Description</h2>
<div>
<p><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">As a Data Engineer on Analytics Data Engineering, you will build and operate the pipelines and data models the rest of Dropbox relies on to understand its products and its business. You will own well-scoped pipelines end to end — design, build, test, ship, monitor — with senior engineers alongside you for the harder architectural calls. Your work feeds the datamarts and KPIs used by data science, product, and company leadership, so the quality of what you build is visible quickly. This is a build-oriented team on a modern stack rather than a maintenance role, and a strong place to develop into an engineer who can own a full data domain.</span></p>
<p><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z">Our Engineering Career Framework is </span><span class="attrlink url author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z"><a class="attrlink" href="https://dropbox.github.io/dbx-career-framework/" target="_blank" data-target-href="https://dropbox.github.io/dbx-career-framework/"><u>viewable by anyone outside the company</u></a></span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z"> and describes what’s expected for our engineers at each of our career levels. Check out our blog post on this topic and more </span><span class="attrlink url author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z"><a class="attrlink" href="https://dropbox.tech/culture/sharing-our-engineering-career-framework-with-the-world" target="_blank" data-target-href="https://dropbox.tech/culture/sharing-our-engineering-career-framework-with-the-world">here</a></span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z">.</span></p>
</div>
<h2>Responsibilities</h2>
<ul>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Build and maintain Spark and SparkSQL jobs that populate company data models</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Own well-scoped pipelines end to end, from requirements through deployment, monitoring, and iteration</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Contribute to data quality frameworks, testing, and data lineage instrumentation</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Partner with data scientists, analysts, product managers, and engineers to turn data needs into durable models</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Extend datamarts and data models supporting recurring reporting and analysis across products</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Improve the reliability and cost efficiency of existing pipelines, dashboards, and frameworks</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Participate in a business-hours on-call rotation and help improve runbooks and alerting</span></li>
</ul>
<p><span class="thread-348589118974529206372994 attrcomment attrcommentfirst thread-348589118974529206372994-first author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z"><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zyz72zz70zz71zz72zhwl8r6xz85zr3z69z6z86zz78zz76zcfvdsgm4t">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.</span></span></p>
<h2>Requirements</h2>
<ul>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">2+ years of development experience in Spark, Python, Java, C++, or Scala</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">2+ years of SQL experience, including query performance tuning</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">2+ years of experience with schema design and dimensional data modeling</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Experience building and maintaining production data pipelines that others depend on</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Working exposure to a cloud data lake or lakehouse platform, Databricks preferred</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Clear written and verbal communication with non-engineering partners, and a track record of asking for help and feedback early</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">BS in Computer Science or a related technical field involving coding</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze h-lparen">(e.g.</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze"> physics or mathematics), or equivalent technical experience</span></li>
</ul>
<h2>Preferred Qualifications</h2>
<ul>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">4+ years of SQL experience</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Experience with medallion architectures and incremental data modeling patterns</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Experience with Airflow or a similar orchestration framework</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Exposure to data quality monitoring using Monte Carlo or similar tools</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze">Exposure to streaming architectures</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze h-lparen">(Kafka,</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zgnz90zacz87zz122zgvz72zz86z85z67z5pz70zloy4qz74zz67zz73zz66znz70ze"> Kinesis, Structured Streaming)</span></li>
</ul>
<div>
<h2><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qowz81zz86z7z65z9wz73z7z75z6emz81zz70z4oz65zrz86z4dnz72ztz67zvoz67zl91">Durable Skills</span></h2>
</div>
<p><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">AI fluency means using these tools to </span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"><em>amplify</em></span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"> human judgment, not replace it. We believe people with these skills will thrive as work and technology</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">continue to evolve:</span></p>
<ul class="listtype-bullet listindent1 list-bullet1" data-testid="bullet-list" data-test-indentation="1">
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"><strong>Awareness:</strong></span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">U</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">nderstand </span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">yourself</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"> and others</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">.</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"><strong>Judgment:</strong></span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">E</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">valuat</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">e</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"> information and mak</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">e </span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">decisions in complex situations</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">.</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"><strong>Adaptability:</strong></span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">L</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">earn, adjust, and stay effective through change</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">.</span></li>
<li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu"><strong>Connection:</strong></span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">C</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">ommunicat</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">e</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">, collaborat</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">e</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">, and build trust</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotv4sz81zsz68zwz85z3z78zbz88z2z76zpz74z2v1z75zz67zz85zjlvz122zz122z6oaz84z">.</span></li>
</ul>
<p><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84z5u1z69zz90zlz73z3ly1nz76zw1r5kz89zz66z4z65zz65zjz122zf092">To learn more about why these skills matter and what the data shows about thriving through change, read this </span><span class="attrlink url author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84z5u1z69zz90zlz73z3ly1nz76zw1r5kz89zz66z4z65zz65zjz122zf092"><a class="attrlink" href="https://www.dropbox.jobs/en/our-blog/employee-stories/the-era-of-durable-skills-what-the-data-tells-us-about-thriving-in-change/" target="_blank" data-target-href="https://www.dropbox.jobs/en/our-blog/employee-stories/the-era-of-durable-skills-what-the-data-tells-us-about-thriving-in-change/">blog post</a></span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85zdz87z113tz83zz67z5n8qpz80zpz89zoz69zcz76zz87zz88zz88z5gsnz85zu">from</span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84z5u1z69zz90zlz73z3ly1nz76zw1r5kz89zz66z4z65zz65zjz122zf092"> our Chief People Officer, Melanie Rosenwasser.</span></p>
<h2 data-usually-unique-id="044234883370604133046166"><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qowz81zqz90zkz74zz76zeez80zz68zz89zz88zvqz86zuxlz73zexxz80zz73z6d6z72zz79zsz77z">Compensation</span></h2><div class="content-pay-transparency"><div class="pay-input"><div class="title">Canada Pay Range</div><div class="pay-range"><span>$101,200</span><span class="divider">&mdash;</span><span>$136,900 CAD</span></div></div></div>

Apply for this job