Job details
Salary $80,027 - $97,248 a year job type full-time number of hires for this role 1
Full job description
Title: data engineer
Department: campaigns
Status: exempt
Reports to: director, data and analytics
Positions reporting to this position: none
Location: flexible (within the united states)
Union position: yes
Job classification level: e
Salary range (depending on experience): $80,027-$97,248
General description:
Lcv believes our earth is worth fighting for because everyone has a right to clean air, water, and a safe, healthy communityTo 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 itWe have built a powerful national movement with 30 state affiliates, and grassroots and community organizing programs across the country.
Lcv is hiring a data engineer who will serve as lcv’s data steward, responsible for maintaining the data warehouse as well as the coordination and integration of multiple databases that are connected with itThis role will work with the campaigns and fundraising teams and must understand the different ways data is used by each while also finding the commonalities in data usageThese teams are fast paced, like to innovate and are growing in both staff and program sizeThe data engineer must keep up with demands while finding ways to be efficient and effective.
Responsibilities:
Serve as administrator for the civis platform, which houses lcv’s data warehouse, managing the data architecture and access of the tool.
Maintain all data integrations and pipelines that carry information to and from the warehouse and salesforce, lcv’s crmThese include sql scripts and workflows, apis, uploads and third-party tools such as frakture and zapier.
Create or project manage new integrations, as needed, making sure they blend seamlessly with the existing data architecture.
Monitor the warehouse and integrations to ensure high functionality, spotting potential problems before they impact programs.
Develop, maintain and improve existing process flows.
Document changes to the data infrastructure and maintain existing documentation.
Collaborate with key staff on the campaigns and fundraising operations teams and external partners, vendors or consultants to determine and implement solutions to data problems.
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 membership, volunteer, and voter data and recommend measures to expand stakeholder diversity.
Analyze racial, gender and economic justice impact of government policies and programs on lcv’s stakeholders and population at-large.
Contribute to the campaigns department’s racial justice and equity work and help ensure an inclusive organizational culture.
Perform other duties as assigned.
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 warehouseExperience with sql scripts and workflows, apis or other data interfaces, salesforce or a similar crmPreferred - experience in a non-profit or political organizationExperience with civis or another sql warehouseExperience setting up or maintaining data integrations with salesforce.
Skills: required - demonstrated ability to maintain a working administrative knowledge of multiple databases and to document and communicate technical information to a non-technical audienceMust be able to juggle requests from multiple colleagues at the same time and be able to do both the technical work and the customer service interfacing required of this roleSolid judgment; attentive to detail; critical thinking skills; a sense of teamwork and community; highly organized; commitment to environmental protection and mission of lcvStrongly preferred - familiarity with python or tableauPreferred - familiarity with javascript, frakture and/or zapier.
Cultural competence: demonstrated awareness of one’s own cultural identity, views about difference, and the ability to learn and build on varying cultural and community normsCommitment to equity and inclusion as organizational practice and cultureUnderstands how environmental issues intersect with racism, economic and social inequality in the u.sAnd has a passion for working to dismantle these systems.
Working conditions: this job operates in a professional office environment, and routinely uses standard office equipment such as computers, phones, photocopiers, and audiovisual systemsThis position is largely sedentary, often standing or sitting for prolonged periodsThe person in this position frequently communicates with partners and must be able to exchange accurate informationThe location of this position is flexibleApplicants need to be located in and legally authorized to work in the united statesPlease note that most lcv staff are currently working remotely during the covid-19 pandemic.
To apply: send cover letter and resume to via email with “data engineer” in the subject line by october 19, 2021No phone calls please.
Lcv is an equal opportunity employer committed to a racially just, equitable and inclusive workplaceAll 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 statusLcv is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activitiesIf you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please contact us via email.
Job type: full-time
Pay: $80,027.00 - $97,248.00 per year
Benefits:
401(k)
401(k) matching
Dental insurance
Employee assistance program
Flexible spending account
Health insurance
Life insurance
Paid time off
Parental leave
Professional development assistance
Vision insurance
Schedule:
Monday to friday
Work location:
Fully remote
Work location: remote
