Reporting and Data Analyst [INTE-20], American Civil Liberties Union, Information Technology Department, NY

National Offices, New York, NY
New York
June 13, 2017

Career Opportunity
Reporting and Data Analyst [INTE-20]
American Civil Liberties Union
Information Technology Department, NY

For nearly 100 years, the ACLU has been our nation’s guardian of liberty, working in courts, legislatures, and communities to defend and preserve the individual rights and liberties guaranteed by the Constitution and laws of the United States.  Whether it’s ending mass incarceration, achieving full equality for the LGBT community, establishing new privacy protections for our digital age, or preserving the right to vote or the right to have an abortion, the ACLU takes up the toughest civil liberties cases and issues to defend all people from government abuse and overreach. With more than a million members, activists, and supporters, the ACLU is a nationwide organization that fights tirelessly in all 50 states, Puerto Rico, and Washington, D.C., for the principle that every individual’s rights must be protected equally under the law, regardless of race, religion, gender, sexual orientation, age, disability, national origin and record of arrest or conviction.

The Information Technology (IT) Department of the National office in New York City is seeking applicants for a full-time Reporting and Data Analyst.


Reporting to the Associate Director, Enterprise Database Systems, the Reporting and Data Analyst is responsible for delivering timely, high-quality reporting expertise and supportsthe ACLU’s National Fundraising Department and nationwide Affiliate offices. The Analyst will be responsible for enforcing best practices and standards in reporting and record keeping to ensure end users have accurate information for making critical business decisions about ACLU fundraising efforts and constituent programs. The Reporting and Data Analyst serves as a subject matter expert on technical issues related to business rules and database architecture. On a daily basis, the Analyst will regularly work with internal partners and external vendors to gather requirements, program and test reports according to specifications, and conduct ad-hoc analysis as needed.


  • Create and/or implement complex reporting solutions for enterprise CRM users.

  • Work with end users to develop new reports and modify template reports for their needs using the Salesforce native report builder.

  • Conduct QA testing on converted reports to ensure accuracy and adherence to ACLU business rules, working with implementation vendors to resolve errors and business questions.

  • Support ad hoc queries and reporting needs on legacy systems (PIDI Donor Direct, QSM, Infoview) for the duration of their lifetime.

  • Work with CRM project team and business users with troubleshooting and resolving potential errors or questions related to migrated data.

  • Define business processes, best practices and standardization of reporting and analysis for the organization, including Communication, Development, Advocacy and IT.

  • Partner with outside vendors to accomplish business goals and ensure proper data security.

  • Create and manage ongoing data hygiene processes.  Working with technical staff and vendors to resolve data hygiene problems and ensure the integrity of donor data.

  • Manage implementation, maintenance, and enhancements to synchronizations between the CRM system and related systems.

  • Serve as a technical resource for solving and implementing business process needs, including the visioning and functional design of reporting and BI solutions for the next generation of the ACLU’s enterprise CRM.

  • Perform data maintenance when necessary, including data uploads.

  • Create and administer technical and end-user documentation as needed.

  • Provide 2nd tier business support for users in 53 remote Affiliate Offices and NY National Office for the ACLU’s nationwide fundraising database, with emphasis on data requests and reporting-based support issues.

  • Test enhancements and bugs in database application(s) and related tools as assigned.

  • Write specifications for database enhancements and new functionality as necessary.

  • Undertake special projects as assigned.

  • Demonstrate a commitment to diversity within the workflow using a personal approach that values all individuals and respects differences in regards to race, ethnicity, age, gender identity and expression, sexual orientation, religion, ability and socio-economic circumstance.

  • Commitment to work collaboratively and respectfully toward resolving obstacles and/or conflicts.


  • Bachelor’s degree and a minimum of 4 years of experience as a database report writer, business analyst, researcher, or other technical services role.

  • Background with nonprofits and fundraising CRM systems is strongly preferred.

  • Strong background in report writing, technical specifications and documentation, data analysis, and translating business needs in a complex data-driven environment.

  • Demonstrated ability to apply database solutions to complex business situations and strategies, with expertise being drawn from prior experience.

  • Ability to test, diagnose and debug self-created reports and reports created by others.

  • Ability to advise and provide leadership to others on procedures or technical matters.

  • Strong communication skills, verbal and writing; strong interpersonal and customer service skills.

  • Ability to solve problems and make independent decisions of crucial consequence, while considering organizational guidelines and strict confidentiality.

  • Ability to work independently and as part of a team, while fostering a team-focused environment that encourages collaboration and peer support.

  • Willingness to travel, as needed.

  • Ability to work independently as well as part of a team.

  • Commitment to the mission of the ACLU.


  • Demonstrated knowledge of relational database best practices and concepts.

  • Proficiency with Salesforce native reports and dashboards required. Familiarity with Salesforce-based roundCorner NGO Connect application desirable.

  • Ability to develop custom reports with standard industry reporting tools. Knowledge of SQL-based database functions preferred.

  • Knowledge of enterprise business intelligence, data visualization, and reporting tools. Familiarity with SAP Business Objects is a plus.

  • Proficiency with Microsoft Office and advanced Excel skills required. 


The ACLU offers a generous and comprehensive compensation and benefits package, commensurate with experience and within parameters of the ACLU compensation scale.


Please send a cover letter (with salary requirements) and resume to Reference [INTE-20] in the subject line.

Applications will be accepted until the position is filled. 

Please indicate where you learned of this job posting.

This job description provides a general but not comprehensive list of the essential responsibilities and qualifications required. It does not represent a contract of employment. The ACLU reserves the right to change the job description and/or posting at any time without advance notice.

ACLU is an equal opportunity employer. We value a diverse workforce and an inclusive culture. The ACLU encourages applications from all qualified individuals without regard to race, color, religion, gender, sexual orientation, gender identity or expression, age, national origin, marital status, citizenship, disability, veteran status and record of arrest or conviction.

The ACLU undertakes affirmative action strategies in its recruitment and employment efforts to assure that persons with disabilities have full opportunities for employment in all positions.

We encourage applicants with disabilities who may need accommodations in the application process to Correspondence sent to this email address that is not related to requests for accommodations will not be reviewed. Applicants should follow the instructions above regarding how to apply.

The ACLU comprises two separate corporate entities, the American Civil Liberties Union and the ACLU Foundation. Both the American Civil Liberties Union and the ACLU Foundation are national organizations with the same overall mission, and share office space and employees. The ACLU has two separate corporate entities in order to do a broad range of work to protect civil liberties. This job posting refers collectively to the two organizations under the name “ACLU.”


Sign Up for Breaking News