Analytics Engineer

ACLU • San Francisco, NY

1d • Hybrid

About The Position

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. The ACLU Technology Department is a broad umbrella covering both the ACLU’s Analytics and its Product & Engineering teams, two robust and innovative divisions that power the work of the ACLU. The department provides trusted, dependable, and impactful analytics, engineering, as well as product design and management expertise for the ACLU. In partnership with experts across the ACLU, the technology team delivers best-in-class solutions, services, and innovation that advance the ACLU mission and organizational priorities. The tech team strives to ensure the ACLU leads by example in the ethical use of technology by ensuring privacy and security standards are maintained, directional insights are used to inform programming and business strategy, best-in-class products are designed to get the ACLU message out into the world and grow the ACLU supporter base, as well as to help steward high standards for algorithmic fairness, accountability, and transparency. The Analytics division includes analysts, data scientists, survey experts, social scientists, and analytics engineers that support evidence-based decision making and bring quantitative insights on our issues to the courtroom and the public. This position is part of a collective bargaining unit. It is represented by ACLU Staff United (ASU).

Requirements

• 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.

Nice To Haves

• 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

Responsibilities

• 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

Benefits

• generous paid time-off policy
• comprehensive healthcare benefits (including medical, dental and vision coverage, parental leave, gender affirming care & fertility treatment)
• 401k plan and employer match
• annual professional development funds
• internal professional development programs and workshops

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree