ABOUT THE JOB

The ACLU seeks applicants for the full-time position of Analytics Engineer in the Analytics division of the Technology Department of the ACLU's National office in New York, NY, Washington, DC, or San Francisco, CA. This is a hybrid role that has in-office requirements of two (2) days per week or eight (8) days per month.

Reporting to the Director of Analytics Engineering, the Analytics Engineer will be part of a team focused on reliably transforming data in the ACLU's internal systems into analysis-ready forms, scraping data from public sources, and working to improve our overall data and analysis pipeline. In partnership with other analytics engineers and analysts, you will use your strong technical, modeling, and analytical knowledge to assist with the data model rebuild as the ACLU migrates to a new CRM.

The analytics engineer will work alongside data scientists, data engineers, 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.
YOUR DAY TO DAY

You will be part of the Analytics Engineering team and work with team members across Analytics as well as stakeholders across the ACLU. You will work primarily with membership/donation data, voter files, web, and other data. Below is a sampling of projects you can expect to dive into:

• Design, develop, and maintain scalable data models to support reporting, business intelligence, and analytics needs using dbt.
• Collaborate with third-party vendors and our Analytics Engagement team as we prepare to migrate CRMs and re-build dbt models used for business essential reporting
• Build and orchestrate Python ETL (Extract, Transform, Load) pipelines in Dagster, to ensure the efficient flow of data from various sources into data warehouses or data lakes.
• Scrape data from public websites to support legal, organizing, and advocacy projects.
• Ensure high-quality, accurate, and timely data is available for stakeholders across departments.
• Use and help others use data warehousing and SQL best practices to keep our analytics swift and reliable
• Partner with internal departments to define and document consistent business data practices
• Collaborate with our Legal and Advocacy Analytics teams to provide data support for fast developing legal crises & issue-based campaigns

FUTURE ACLU'ERS WILL

• Be committed to advancing the mission of the ACLU
• Center and embed the principles of equity, inclusion and belonging in their work by demonstrating commitment to diversity with an approach that respects and values multiple perspectives
• Be committed to work collaboratively and respectfully toward resolving obstacles and conflicts

WHAT YOU'LL BRING

• Extensive experience with data warehouses and database query languages (e.g., Redshift, SQL)
• Experience building data models and writing ETL in a business setting
• Undergraduate degree in an analytical field (e.g., Economics, Statistics, Computer Science, Business) or equivalent experience
• Skilled in using a modern scripting language (e.g. Python)
• Proficiency in translating business metrics into well-scoped tasks and requirements
• Working knowledge of BI tools such as Hex, Tableau, or Looker
• Familiarity with customer relationship management (CRM) or volunteer management systems, such as Salesforce, Blackbaud, or VAN.

PREFERRED QUALIFICATIONS

• Demonstrated experience with a modern data stack, especially dbt for SQL data modeling
• Experience with an orchestration tool (e.g. Dagster, Airflow, Prefect)
• Knowledge of latest trends and technologies in data warehousing/data engineering
• Working knowledge of common Unix command line operations (e.g. file system operations, Docker, Git)
• Familiarity with AWS services such as S3 and Redshift
• Familiarity with voter file data

COMPENSATION

The ACLU is committed to equity, transparency, and clarity in pay. Consistent with our compensation philosophy, there is a set salary for each role based on geographic work location. The annual salary for this position is $128,294 (Level G), reflecting the salary of a position based in New York, NY. Salaries are subject to a regional pay adjustment if authorization is granted to work outside of the location listed in this posting.

For details on our pay structure, please visit: https://www.aclu.org/careers/ACLU_Geographic_Pay_Structure-July_2024.pdf

At the ACLU, we offer a broad range of benefits, which include:

• Time away to focus on the things that matter with a generous paid time-off policy
• Focus on your well-being with comprehensive healthcare benefits (including medical, dental and vision coverage, parental leave, gender affirming care & fertility treatment)
• Plan for your retirement with 401k plan and employer match
• We support employee growth and development through annual professional development funds, internal professional development programs and workshops