Data Engineer, Fundraising

Position Summary

LCV is hiring a Data Engineer for the Development department who will build and maintain integrations between our data warehouse and databases maintained internally and by our state affiliate partners. This role will work closely with the national Development and State Capacity Building teams, as well as staff at our state affiliate partners. This role is being hired in advance of a new initiative where LCV and state affiliates will fundraise in a unified manner. The Data Engineer is responsible for extracting data from multiple databases, standardizing, and loading data back into multiple databases. The Data Engineer will participate in the design and mapping process and will be responsible for building scalable data infrastructure, integrations, and reporting tables.

This position is classified as “Regular Remote Work”, which means the position is not assigned to an office and can work remotely full-time.Responsibilities:
Build and maintain all data integrations and pipelines that carry information to and from the Civis data warehouse and state affiliates’ CRMs (EveryAction or Salesforce), including tracking data lineage.
In coordination with the State Capacity Building and Development data teams, identify commonalities in data usage and standardize into consistent architecture.
In coordination with the Data Engineer for Campaigns, determine the appropriate tools for these integrations and ensure seamless integration with the existing warehouse architecture.
Implement the data sharing guidelines agreed upon between organizations, and elevate areas of oversight where non-technical stakeholders may miss gaps.
Build tables to support Tableau reporting.
Develop, maintain and improve existing process flows.
Create and edit existing technical documentation, and contribute to end user documentation of infrastructure.
Collaborate with key staff on the state capacity building, fundraising operations teams and external partners, vendors or consultants to determine and implement solutions to data problems.
Monitor the warehouse and integrations to ensure high functionality, spotting potential problems before they impact programs.
Provide technical expertise and input on the strategic direction to meet data needs.
Write new support programs and scripts to fix data problems.
Create new scripts and data models as needed to help meet LCV’s strategic plan goals.
Analyze demographic and socioeconomic trends in unified data and recommend measures to expand stakeholder diversity.
Contribute to the Development department’s racial justice and equity work and help ensure an inclusive organizational culture.
Perform other duties as assigned.
Travel up to 10% of the time for in-person work, including staff retreats, trainings, meetings, conferences, and professional development opportunities, as needed.