Analytics Engineer

Job Description

The ACLU is seeking an Analytics Engineer to join its Technology Department. This role involves transforming data into analysis-ready forms, scraping data from public sources, and improving the overall data and analysis pipeline. The Analytics Engineer will collaborate with data scientists, data engineers, data analysts, and business users to enable data-driven methods and advanced analytics.

Responsibilities:

• Design, develop, and maintain scalable data models using dbt.
• Collaborate with third-party vendors during CRM migration and dbt model rebuilds.
• Build and orchestrate Python ETL pipelines in Dagster.
• Scrape data from public websites.
• Ensure high-quality, accurate, and timely data availability.
• Use data warehousing and SQL best practices.
• Define and document consistent business data practices.
• Provide data support for legal crises and issue-based campaigns.

Requirements:

• Extensive experience with data warehouses and SQL.
• Experience building data models and writing ETL.
• Undergraduate degree in an analytical field or equivalent experience.
• Experience with Python.
• Experience translating business metrics into tasks and requirements.
• Familiarity with BI tools.
• Familiarity with CRM or volunteer management data.

The ACLU offers:

• Time away with a generous paid time-off policy
• Comprehensive healthcare benefits
• 401k plan and employer match
• Professional development funds