Our campaign performance reports rely heavily on a complex series of Google Sheets that interact with other organizational platforms. The Campaign Reporting Software Engineer supports all of our operations in a few major ways:
– Writing scripts in Google Apps Script to generate reports
The majority of our reporting is powered by scripts that read data from multiple spreadsheets and/or other APIs and databases and then write out reporting data to other spreadsheets. Candidates should be skilled at integrating with APIs, authentication, data validation and munging, and basic strategies for algorithm optimization.
– Writing code to integrate other APIs and systems
In addition to the operational reporting that is powered by Google Sheets, our recruiting team uses a custom app created in Zoho, as well as Docusign for managing interviewing and onboarding. These systems use code to manage the workflows in the candidate and onboarding pipeline, and information collected in Docusign is integrated into the Zoho app using a custom-developed lambda function. Candidates should be able to learn the Zoho programming language, Deluge, and should be able to debug and extend the functionality of the Docusign integration, and should also be able to envision and implement code to enable other integrations and workflows.
– Debugging code and data issues in existing systems
The other major component of the job is debugging issues that arise with the existing code. Reading data from Google Sheets means that there are inevitably data entry errors/data integrity issues, and dozens of untested scripts means that there are bugs in the code as well. These issues are first investigated by our team of system admins, who are non-professional coders and debuggers, but the trickiest problems will get escalated to you. You must be comfortable getting to the bottom of these issues, no matter how difficult the (time zone, race condition, timeout, intermittent data corruption) issue may be.
The Campaign Reporting Software Engineer reports to the Director of Data and Technology.
Location: This position is remote.
- Advanced skills in Excel/Sheets. This includes proficiency with formulas, data validation, queries and sheet protection mechanisms.
- Experience being bottom line on a large project with urgent deadlines
- Ability to coordinate across departments and communicate with other leadership/department heads
- Track record of centering equity and justice in your work
- Good planner
- Willingness to work evenings and weekend hours
Nice to have:
- At least 1-2 years of experience in face to face field operations (voter contact, voter reg, organizing, fundraising, etc)
- Proficiency with App Script and macros.
- Experience with or fluency in Java, Zoho Deluge, SFTPs.
- Experience project managing or testing software
Salary: The salary for this position is $79,000-91,000 annually depending on experience. We offer a generous benefits package, including paid vacation, paid sick leave, health insurance, hands-on training, and opportunities for advancement. This is a Specialist 2-level position.
Timeline: This position begins immediately and runs through November 30th, 2022 with the possibility of extension.
Equity: If you are interested in this position but don’t think you qualify for everything, please don’t let that stop you from applying! At The Outreach Team, we prioritize equity and inclusion and believe our work is better when it benefits from the knowledge, experience, and wisdom of people who have faced systemic barriers.
We are an equal opportunity employer and we strongly encourage Black, indigenous, people of color, women, people with previous felony convictions, members of the LGBTQIA+ community, and others who identify with underrepresented groups to apply
Who We Are
The Outreach Team is the national engine of campaigners and organizers powering the progressive movement. With an on-the-ground presence in communities all across the country, our world-class team runs successful civic engagement campaigns on behalf of progressive organizations and campaigns—to build a future that’s fairer, cleaner, safer and more peaceful for everyone.
Our client list includes organizations such as the Black Progressive Action Coalition, Everytown for Gun Safety Action Fund, Climate Action Campaign, Planned Parenthood, For our Future, Solar Rights Alliance, The United Food and Commercial Workers International Union, and more.