Data Engineer

<div class="content-intro"><p>Keystone is a premier economics, technology, and strategy consulting firm built to help companies lead through transformation. As breakthrough innovations reshape industries, redefine competition and change our society, complex and highly competitive ecosystems emerge. Keystone advises technology leaders, Fortune 100 companies, their legal counsel, and governments on business, economic, litigation, and regulatory strategy in relation to these innovations and competitive eco-systems. We operate globally from offices in Boston, New York City, San Francisco, Seattle, Washington, D.C., London, Dubai, and Bengaluru.</p></div><p><span data-contrast="none">K.ATS Foundry is Keystone’s engineering center of excellence, embedding data, platform, and forensic expertise into the firm’s most complex and high-impact projects. Foundry builds secure, reusable infrastructure and scalable technical solutions that accelerate project delivery and </span><span data-contrast="none">ensure defensible, data-driven outcomes. Our engineers work across disciplines—from automating data pipelines and managing cloud platforms to conducting forensic code investigations—helping every engagement start faster, run smoother, and deliver greater impact.</span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></p> <p><span style="text-decoration: underline;"><strong><span data-contrast="none">About the Data Engineer Role</span></strong></span></p> <p><span data-contrast="none">You will lead the design and implementation of reproducible, scalable data workflows that power Keystone’s most data-intensive projects. You will architect infrastructure, guide technical implementation across engagements, and develop reusable frameworks that accelerate work across the firm.</span><span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559738":0,"335559739":160,"335559740":257}"> </span></p> <p><span data-contrast="none">This role sits at the intersection of data engineering, platform design, and applied analytics, supporting cross-disciplinary teams in building data systems that are robust, defensible, and automation-first. You’ll serve as a senior individual contributor and mentor, own project-level architecture, shape technical standards, and contribute to Foundry’s shared engineering culture.</span></p> <p><span style="text-decoration: underline;"><strong><span data-contrast="none">Key Responsibilities</span></strong></span></p> <p><strong><span data-contrast="none">Technical Leadership</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559685":0,"335559737":0,"335559738":0,"335559739":0,"335559740":257,"335559991":0}"> </span></p> <ul> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-contrast="none">Architect and implement end-to-end data pipelines, transformations, and infrastructure across cloud environments (AWS, GCP, Azure, Snowflake).</span></li> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Develop reproducible workflows using Infrastructure as Code and data orchestration tools (Airflow, dbt, Spark, or equivalent).</li> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Design data models and storage systems optimized for performance, scalability, and defensibility in regulatory and litigation contexts.</li> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Build and maintain reusable templates, libraries, and automation frameworks that improve engineering efficiency across projects.</li> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Conduct code reviews, mentor peers, and ensure technical rigor and reproducibility in all project deliverables.<span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559738":0,"335559739":0,"335559740":257}"> </span></li> </ul> <p><strong><span data-contrast="none">Collaboration and Delivery</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559685":0,"335559737":0,"335559738":0,"335559739":0,"335559740":257,"335559991":0}"> </span></p> <ul> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-contrast="none">Partner with client-facing teams, economists, and data scientists to translate analytical goals into scalable, automated data solutions.</span></li> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Collaborate with Platform and Forensic Engineering peers to develop integrated solutions across Foundry focus areas.</li> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Support the design and delivery of data visualization and analytic tooling (e.g., Power BI, Tableau, Streamlit) for client and internal projects.</li> <li data-leveltext="" data-font="Symbol" data-listid="6" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Contribute to documentation and internal guides that capture lessons learned, reusable modules, and technical standards.<span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559738":0,"335559739":0,"335559740":257}"> </span></li> </ul> <p><strong><span data-contrast="none">Practice Development</span></strong><span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559685":360,"335559737":0,"335559738":0,"335559739":0,"335559740":257,"335559991":0}"> </span></p> <ul> <li data-leveltext="" data-font="Symbol" data-listid="8" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2"><span data-contrast="none">Mentor junior engineers and foster adoption of best practices in data architecture, version control, testing, and CI/CD.</span></li> <li data-leveltext="" data-font="Symbol" data-listid="8" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Participate in Scaling Days to share learnings, refine templates, and advance the firm’s reusable engineering assets.</li> <li data-leveltext="" data-font="Symbol" data-listid="8" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Identify opportunities to generalize project solutions into reusable Foundry tooling and QuickStarts.</li> <li data-leveltext="" data-font="Symbol" data-listid="8" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Contribute to research and evaluation of emerging technologies (e.g., SQLMesh, OpenLineage, LLM data evaluation pipelines).</li> <li data-leveltext="" data-font="Symbol" data-listid="8" data-list-defn-props="{"335552541":1,"335559683":1,"335559684":-2,"335559685":1440,"335559991":360,"469769226":"Symbol","469769242":[9675],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="2">Travel 10 – 25% depending on project assignments.</li> </ul> <p><span style="text-decoration: underline;"><strong>What You'll Bring</strong></span></p> <ul> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">6+ years of experience in data engineering, data infrastructure, or software engineering roles.</span></li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Deep proficiency in Python, SQL, and modern data stack tools (Airflow, dbt, Spark, Snowflake, BigQuery, or equivalent).</li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Strong understanding of cloud architecture and Infrastructure as Code (Terraform, CloudFormation, or similar).</li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Experience with version control, CI/CD workflows, and containerization (Docker, Kubernetes).</li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Proven ability to architect and optimize large-scale data systems for performance, reliability, and reproducibility.</li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Excellent communication skills with the ability to convey technical concepts to non-technical audiences.</li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Demonstrated collaboration across disciplines and commitment to mentoring and technical excellence.</li> <li data-leveltext="" data-font="Symbol" data-listid="10" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Bachelor’s or advanced degree in Computer Science, Engineering, or related field.<span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559738":0,"335559739":0,"335559740":257}"> </span></li> </ul> <p><span style="text-decoration: underline;"><strong><span data-contrast="auto">Preferred Experience</span></strong></span></p> <ul> <li data-leveltext="" data-font="Symbol" data-listid="11" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Prior experience at a consulting firm or matrix-based organization.</span></li> <li data-leveltext="" data-font="Symbol" data-listid="11" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Experience developing internal libraries, frameworks, or automation solutions.</li> <li data-leveltext="" data-font="Symbol" data-listid="11" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Familiarity with data governance, lineage tracking, or privacy-preserving techniques.</li> <li data-leveltext="" data-font="Symbol" data-listid="11" data-list-defn-props="{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Exposure to AI/ML data pipelines, LLM evaluation, or text analytics systems.<span data-ccp-props="{"134233117":false,"134233118":false,"201341983":0,"335551550":0,"335551620":0,"335559738":0,"335559739":0,"335559740":257}"> </span></li> </ul> <p><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></p> <p> </p><div class="content-pay-transparency"><div class="pay-input"><div class="description"><p><span class="cf0">The salary range below represents total annual compensation across all U.S. locations. Actual compensation will depend upon the level the individual is hired into based on their experience, knowledge, skills and qualifications. In addition to annual salary, we offer a comprehensive benefits package, 401k contribution, and a culture grounded in integrity, curiosity, and teamwork. </span></p></div><div class="title">Annual Salary Range</div><div class="pay-range"><span>$143,000</span><span class="divider">—</span><span>$173,000 USD</span></div></div></div><div class="content-conclusion"><p> </p> <p><em>At Keystone, we value the varied backgrounds, experiences, and perspectives our colleagues bring to our firm. We are committed to building an inclusive culture where everyone feels respected, has a sense of belonging, and has opportunities to grow.</em></p> <p><em>This commitment extends to how we hire. Keystone is an equal opportunity employer committed to fair and inclusive hiring practices. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity or expression, national origin, disability, protected veteran status, or any other characteristic protected by applicable law.</em></p></div>