ABOUT THE JOB

The ACLU seeks applicants for the full-time position of Data Engineer II in the Analytics Department of the ACLU’s National office in New York, NY/ Remote*.

ACLU Analytics partners with teams across the organization to enable the ACLU to make smart, evidence-based decisions and bring quantitative insights on our issues to the courtroom and the public. Our team's work ranges from social science research for litigation & advocacy, to analysis & reporting for fundraising and engagement, to building and maintaining our data infrastructure. We strive to ensure the ACLU leads by example in the ethical use of data and technology. This includes maintaining our privacy and security standards, pushing for transparent data practices from government and corporate actors, and helping to steward high standards for algorithmic fairness, accountability, and transparency.

Reporting to the Director of Data Infrastructure, Analytics, the Data Engineer II will be focused on reliably transforming data in the ACLU’s internal systems into analysis-ready forms, extracting data from public datasets (e.g. court dockets) and working to improve our overall data and analysis pipeline. Data engineers will work in teams alongside data scientists, data analysts, and business users, to enable the use of innovative data-driven methods and advanced analytics to transform the way the ACLU approaches fundraising, digital communications, and supporter engagement, as well as program work in litigation and advocacy.

* Note: this position can function remotely from a U.S. location on an interim basis and may be eligible for permanent remote work from a location within the U.S

RESPONSIBILITIES

• Use transformation tools like Python, DBT, and Looker to maintain a well-tested analytical layer (e.g., modeling donor data from multiple sources into an event stream)
• Use and mentor others on the team use data warehousing and SQL best practices to keep our analytics swift and reliable
• Advise other ACLU engineering teams such as Web and CRM on architecture decisions that impact data quality
• Support our Legal Analytics team to provide data support for fast developing legal crises
• Collaborate with leadership of the ACLU Data Infrastructure team to architect complex data pipelines, plan work, and set team policy
• Communicate complicated technical solutions to members of the ACLU in a friendly and easy to understand way
• Engage in special projects and other duties as assigned
• Center principles of equity, inclusion, and belonging in all work, embedding the values in program development, policy application, and organizational practices and processes
• Commitment to the mission of the ACLU
• Demonstrate a commitment to diversity within the office using a personal approach that values all individuals and respects differences in regards to race, ethnicity, age, gender identity and expression, sexual orientation, religion, disability and socio-economic circumstance
• Commitment to work collaboratively and respectfully toward resolving obstacles and/or conflicts

EXPERIENCE & QUALIFICATIONS

• Substantial experience with databases and database query languages (e.g., Redshift, SQL) 
• Experience with using a modern scripting language (e.g. Python) for problems such as job orchestration, scraping, data wrangling, etc.  

PREFERRED QUALIFICATIONS

• Knowledge of latest trends and technologies in data infrastructure and data warehousing
• Knowledge of common software engineering best practices (e.g. interacting with file system, using version control) 
• Familiarity with AWS services such as S3, IAM, EC2
• Knowledge of Looker and Lookml
• Knowledge of CRM technologies such as Salesforce

COMPENSATION

The annual salary for this position is $103,968 (Level G). This salary is reflective of a position based in New York, NY. This salary will be subject to a locality adjustment (according to a specific city and state), if an authorization is granted to work outside of the location listed in this posting. Note that most of the salaries listed on our job postings reflect New York, NY salaries, where our National offices are headquartered.

ABOUT THE ACLU

The ACLU dares to create a more perfect union – beyond one person, party, or side. Our mission is to realize this promise of the United States Constitution for all and expand the reach of its guarantees.

For over 100 years, the ACLU has worked 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 LGBTQ+ 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.

Equity, diversity, and inclusion are core values of the ACLU and central to our work to advance liberty, equality, and justice for all. We are a community committed to learning and growth, humility and grace, transparency and accountability. We believe in a collective responsibility to create a culture of belonging for all people within our organization – one that respects and embraces difference; treats everyone equitably; and empowers our colleagues to do the best work possible. We are as committed to anti-oppression and anti-racism internally as we are externally. Because whether we’re in the courts or in the office, we believe ‘We the People’ means all of us.

The 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, or any other characteristic protected by applicable law. Black people, Indigenous people, people of color; lesbian, gay, bisexual, transgender, queer, and intersex people; women; people with disabilities, protected veterans, and formerly incarcerated individuals are all strongly encouraged to apply.

The ACLU makes every effort to assure that its recruitment and employment provide all qualified persons, including persons with disabilities, with full opportunities for employment in all positions.

The ACLU is committed to providing reasonable accommodation to individuals with disabilities. If you are a qualified individual with a disability and need assistance applying online, please email benefits.hrdept@aclu.org. If you are selected for an interview, you will receive additional information regarding how to request an accommodation for the interview process.

The Department of Education has determined that employment in this position at the ACLU does not qualify for the Public Service Loan Forgiveness Program.