Data Engineer

New York, NY·Posted today

data-platformspython

Location: New York, NY or Remote within the U.S About the Role  We're looking for a Data Engineer to design and build a unified data platform bringing together our primary research data, third-party data, financial data, and business development information into a single, reliable system. This includes reconciling older historical data with newer data that has drifted over time, so we can run accurate long-term analyses. You'll also build the connections (APIs) between this system and the other software tools we use across the firm.  This is a backend-focused role. You’ll be working with data pipelines, databases, and integrations rather than building user-facing interfaces or dashboards. We use off-the-shelf BI tools for reporting and visualization, so your focus stays on making the underlying data clean, connected, and reliable.  What You'll Do  <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Build and maintain a central data warehouse that consolidates data from research, finance, deliberation, and business development sources </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Design ETL/ELT pipelines to bring data in from internal tools and external vendors on a reliable schedule </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Work through inconsistencies between older and newer datasets (changed formats, renamed fields, different collection methods) so historical and current data can be analyzed together </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1">Build and maintain APIs connecting our internal systems to third-party software (CRM, accounting/finance tools, research platforms, and similar) </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="5" data-aria-level="1">Set up sensible access controls and data-handling practices for sensitive financial and confidential records </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="6" data-aria-level="1">Monitor data quality and troubleshoot pipeline issues as they come up </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="7" data-aria-level="1">Keep documentation current — a data dictionary and clear notes on where data comes from and how it flows, so the system doesn't become a black box </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="8" data-aria-level="1">Partner with our BI/reporting tool setup (e.g., Metabase, Looker Studio, Power BI) to make sure data feeding into dashboards is accurate — building the dashboards is not required </li> </ul> What We're Looking For  <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">3+ years of professional experience in data engineering, backend development, or a closely related role </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Strong working knowledge of SQL and Python </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Experience building or maintaining ETL/ELT pipelines (tools like Airflow, dbt, or similar are a plus, but we're open to candidates who've done this with other stacks) </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1">Comfort designing or working with REST APIs and connecting to third-party services </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="5" data-aria-level="1">Experience with a cloud data warehouse (Snowflake, BigQuery, Redshift, or similar) — or strong SQL fundamentals and a willingness to ramp up on ours </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="6" data-aria-level="1">Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent hands-on experience </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="2" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="7" data-aria-level="1">Comfortable working independently and communicating clearly about data issues to non-technical colleagues </li> </ul> Nice to Have (Not Required)  <ul> <li data-leveltext="" data-font="Symbol" data-listid="3" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Experience reconciling historical/longitudinal datasets, especially from survey or research data </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="3" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Familiarity with data governance or compliance practices for financial or confidential records </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="3" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Prior experience in a legal, research, or professional services environment </li> </ul> What Success Looks Like in the First Year  <ul> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Core historical and current datasets are consolidated into one system, with a clear record of how legacy data was reconciled </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Key third-party integrations (at least the top 2-3 external tools we rely on) are connected and syncing reliably </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Documentation exists so that a new hire or vendor could understand the system without you having to explain it from scratch </li> </ul> <ul> <li data-leveltext="" data-font="Symbol" data-listid="4" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1">Data quality issues are caught proactively, not after someone downstream notices something's wrong </li> </ul> DRC is committed to attracting and retaining exceptional talent and supporting employees’ professional growth and success. Full-time employees are eligible for a competitive benefits package that includes medical, dental, and vision insurance; paid time off; participation in the Firm’s 401(k) plan; and additional employee benefits, subject to the terms and eligibility requirements of the applicable plans and policies. New York Base Salary Range: $120,000–$150,000 annually This range represents the base salary DRC reasonably and in good faith expects to pay for this position when performed in New York. For candidates working remotely from another approved location, the applicable salary range may differ based on geographic market and applicable law. The final base salary will be determined based on legitimate business considerations, including the candidate’s experience, education, qualifications, specialized knowledge, skills, and work location. Candidates outside New York will be provided with the applicable compensation range for their approved work location. Any additional compensation for which the position is eligible, such as a discretionary bonus or incentive compensation, will be communicated separately. Equal Employment Opportunity DRC is an equal opportunity employer. We provide equal employment opportunities to all employees and applicants and prohibit discrimination or harassment based on race, color, religion, creed, national origin, ancestry, citizenship or immigration status, age, sex, pregnancy or related medical conditions, sexual orientation, gender identity or expression, marital or familial status, disability, genetic information, military or veteran status, or any other characteristic protected by applicable federal, state, or local law.

Apply for this role