Data Engineer, Fundraising

Title: Data Engineer, Fundraising
Department: Development
Status: Exempt
Reports to: Vice President of Development Operations
Positions Reporting to this Position: None
Location: United States
Remote Work Eligibility: Yes; Regular Remote Work
Travel Requirements: Up to 10%
Union Position: Yes
Job Classification Level: E
Salary Range (depending on qualified experience): $90,236 – $110,236

General Description:

The League of Conservation Voters, Inc. (“LCV”), a non-profit organization, believes our earth is worth fighting for because everyone has a right to clean air, water, and a safe, healthy community. To ensure those rights are protected, we help people use their power to shape policy, hold politicians and polluters accountable, and influence elections.

For more than 50 years, LCV has grown into a potent political force for protecting our planet and everyone who inhabits it. We have built a powerful national movement with 30+ state affiliates, and grassroots and community organizing programs across the country. LCV and our state affiliates, collectively called the Conservation Voters Movement (CVM), have committed to building an anti-racist national network by advancing racial justice and equity in everything we do. This organizational work involves an active process of identifying racism and other interlocking forms of oppression as they exist in our policies, practices, and institutions; changing and applying internal policies and power dynamics in ways that work to eliminate systemic racial inequities; and, working to change societal policies and power dynamics to eliminate systemic racial inequities. 

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. 

General working conditions:

• Operate in a professional office or home office environment, and routinely use standard office equipment including, but not limited to,  computers, phones,  photocopiers, and audiovisual systems. 
• Largely sedentary, often standing or sitting for prolonged periods. 

Applicants must be located in and legally authorized to work in the United States. 

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.

Qualifications:

• Work Experience: Required – At least 5 years of experience working with relational databases in a data role and 3 years working with a data warehouse. Experience with Civis or another SQL warehouse. Experience with SQL scripts and job dependencies/orchestration; APIs or other data interfaces; Salesforce, EveryAction or a similar CRM. Strongly Preferred – Experience integrating and normalizing multiple data sources, managing identity resolution and tracking data lineage. Preferred – Experience in a non-profit or political organization. Experience setting up or maintaining data integrations with Salesforce and EveryAction. 
• Skills: Required – Demonstrated ability to build and maintain multiple integrations and to document and communicate technical information to a non-technical audience. Solid judgment; attentive to detail; critical thinking skills; a sense of teamwork and community; highly organized; commitment to environmental protection and mission of LCV. Strongly Preferred – Familiarity with Python or Tableau.
• Racial Justice and Equity Competencies: Demonstrated awareness of how one’s life experiences influence one’s personal attitudes, biases, and assumptions. Demonstrated commitment to continual learning and ability to successfully deliver culturally responsive services. Commitment to equity and inclusion as organizational practice and culture. Understands how environmental issues intersect with racism, economic and social inequality in the U.S. and has a passion for working to dismantle these systems.

LCV offers a comprehensive and competitive benefits package that includes vacation, sick and parental leave, personal days, paid holidays, health insurance (two plan options for staff to choose from), dental and vision insurance, life and disability insurance (short- and long-term), Flexible Spending Account, 401(k) retirement plan with company matching contribution, commuter benefits program, sabbatical, and student loan assistance.

To Apply: Send cover letter and resume to [email protected] with “Data Engineer, Fundraising” in the subject line by February 3, 2025. No phone calls please.

LCV is an Equal Opportunity Employer committed to a racially just, equitable and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information, or any other protected status. LCV is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. If you require a reasonable accommodation to participate in the employee selection process, including, completing the application, interviewing, or pre-employment testing, please contact [email protected].