Data Engineer

<h2>Role Description</h2> <p><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8">Dropbox is looking for a Data Engineer to join our Analytics Data Engineering <span class=" h-lparen">(ADE)</span> team within Data Science &amp; AI Platform. In this role you will build large, scalable analytics pipelines using modern data technologies. This is not a</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8 h-ldquo">“maintain</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8"> existing platform” or</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8 h-ldquo">“make</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8"> 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!</span></p> <div> <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-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Define company data assets</span> <span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib h-lparen">(data</span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib"> model), </span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">S</span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">park, </span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">S</span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">parkSQL jobs to populate data models</span></li> <li><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Define and design data integrations, data quality frameworks and design and evaluate open source/vendor tools for data lineage</span></li> <li><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Work closely with Dropbox business units and engineering teams to develop strategy for long term Data Platform architecture to be efficient, reliable and scalable&nbsp;</span></li> <li><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Conceptualize and own the data architecture for multiple large-scale projects, while evaluating design and operational cost-benefit tradeoffs within systems</span></li> <li><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Collaborate with engineers, product managers, and data scientists to understand data needs, representing key data insights in a meaningful way</span></li> <li><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Design, build, and launch collections of sophisticated data models and visualizations that support multiple use cases across different products or domains</span></li> <li><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zrtz85zz69zr5z66zz80zz83zdjz69zyol9lz77zz70zz79zz81zz71zz83z5z90z4z81zib">Optimize pipelines, dashboards, frameworks, and systems to facilitate easier development of data artifacts</span></li> </ul> <p><span class="thread-348589118974529206372994 attrcomment attrcommentfirst thread-348589118974529206372994-first author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z95lz89zy6z71zz79zz84zz68zyz69zupz72zz79zcz69zz76zkz79zp1z66ztz67zxz71zz89zz86zz71z">On-call work may be necessary occasionally to help address bugs, outages, or other operational issues, with the goal of maintaining a stable and high-quality experience for our customers.</span></p> <h2>Requirements</h2> <ul> <li><span class="highlight author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qowz81zz86z7z65z8z79ztz77ziz87zz74z8p95dob7z122zz72zz89zz78zz72zz68zz79zz77zjqz67zz67z" data-highlight-color="#F7CC62">5</span><span class="highlight author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp" data-highlight-color="#F7CC62">+ years of Spark, Python, Java, C++, or Scala development experience</span></li> <li><span class="highlight author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qowz81zz86z7z65z8z79ztz77ziz87zz74z8p95dob7z122zz72zz89zz78zz72zz68zz79zz77zjqz67zz67z" data-highlight-color="#F7CC62">5</span><span class="highlight author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp" data-highlight-color="#F7CC62">+ years of SQL experience</span></li> <li><span class="highlight author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qowz81zz86z7z65z8z79ztz77ziz87zz74z8p95dob7z122zz72zz89zz78zz72zz68zz79zz77zjqz67zz67z" data-highlight-color="#F7CC62">5</span><span class="highlight author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp" data-highlight-color="#F7CC62">+ years of experience with schema design, dimensional data modeling, and medallion architectures</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">Experience with the Databricks platform and data lake architectures for large-scale data processing and analytics</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">Excellent product strategic thinking and communications to influence product and cross-functional teams by identifying the data opportunities to drive impact</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">BS degree in Computer Science or related technical field involving coding</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp h-lparen">(e.g.,</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp"> physics or mathematics), or equivalent technical experience</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">Experience designing, building and maintaining data processing systems</span></li> </ul> <h2>Preferred Qualifications</h2> <ul> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">7+ years of SQL experience&nbsp;</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">7+ years of experience with schema design, dimensional data modeling, and medallion architectures</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotvooz66zfz73zz77zhz67zvz87zz83zz122zz89zz67zz67zz73zlz75zz83ztz76z5z83zz88zikvjz65zp">Experience with Airflow</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8"> or other similar orchestration frameworks</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qovwiyz82zz65zz72zz78zz122zz89z1y9z85zz71zz78zxz67zymxl9z74zz73z9vlz78zmg8">Experience building data quality monitoring using MonteCarlo or similar tools</span></li> </ul>