Data Engineer

DRC is an employer seeking a Data Engineer to build and maintain a unified, reliable data platform integrating research, financial, business development, and third-party data. The role focuses on backend data engineering, including data warehouses, ETL/ELT pipelines, APIs, data quality, access controls, documentation, and support for BI reporting tools.

Responsibilities:

• Build and maintain a central data warehouse that consolidates data from research, finance, deliberation, and business development sources
• Design ETL/ELT pipelines to bring data in from internal tools and external vendors on a reliable schedule
• Work through inconsistencies between older and newer datasets (changed formats, renamed fields, different collection methods) so historical and current data can be analyzed together
• Build and maintain APIs connecting our internal systems to third-party software (CRM, accounting/finance tools, research platforms, and similar)
• Set up sensible access controls and data-handling practices for sensitive financial and confidential records
• Monitor data quality and troubleshoot pipeline issues as they come up
• 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
• 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

Requirements:

• 3+ years of professional experience in data engineering, backend development, or a closely related role
• Strong working knowledge of SQL and Python
• 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)
• Comfort designing or working with REST APIs and connecting to third-party services
• Experience with a cloud data warehouse (Snowflake, BigQuery, Redshift, or similar) — or strong SQL fundamentals and a willingness to ramp up on ours
• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent hands-on experience
• Comfortable working independently and communicating clearly about data issues to non-technical colleagues
• Experience reconciling historical/longitudinal datasets, especially from survey or research data
• Familiarity with data governance or compliance practices for financial or confidential records
• Prior experience in a legal, research, or professional services environment