> Markdown version of [/jobs/ext/2983323-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/2983323-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # analytics engineer - **Company:** the American Civil Liberties Union - **Location:** New York, NY, United States - **Salary:** $128,294.0 - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Amazon S3, Data Analysis, Data Transmissions, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Database Queries, File Systems, Python (Programming Language), Salesforce.Com, SQL Databases, Tableau (Software), Unix Commands, Scripting, Git, Data Lakes, Information Technology, Looker Analytics, Docker - **Published:** September 18, 2026 - **Apply:** https://job-boards.greenhouse.io/aclu/jobs/8816450002 ## About the Role * 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., * 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, You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to: * Blindness * Deafness * Cancer * Diabetes * Epilepsy * Autism * Cerebral palsy * HIV/AIDS * Schizophrenia * Muscular dystrophy * Bipolar disorder * Major depression * Multiple sclerosis (MS) * Missing limbs or partially missing limbs * Post-traumatic stress disorder (PTSD) * Obsessive compulsive disorder * Impairments requiring the use of a wheelchair * Intellectual disability (previously called mental retardation) Significant Disability Status Select... ## Description 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, At the ACLU, we deeply value diversity, inclusion, and belonging. We actively work to ensure that we are addressing everyone appropriately and that we're acknowledging their identity as they would like. Examples of common pronouns are 'she/her/hers,' 'he/him/his,' and 'they/them/theirs.' This is optional, but if you're comfortable, please share your pronouns. First Name/Common Use First Name (optional) A common use name (sometimes known as a chosen name, nickname, or a name-in-use) is the use of a name, usually a first name, that is different from a person's legal name. Common use names can be used in organizational communications and informational materials such as email correspondence, staff directories, business cards, software and similar systems which do not require the use of a legal name. Legal names will continue to be used where required by law or organizational policy, including but not limited to, formal organizational and employment correspondence in addition to immigration, payroll, tax, benefits and insurance documents. The following demographic questions are optional. They are used to help us better understand our applicant pool and to continually improve our outreach and recruitment efforts. Individuals seeking employment at the ACLU are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. Select... Race and/or Ethnicity: Select... If you chose 'A race or ethnic group not listed,' please let us know how you self-identify: Gender: Select... If you chose "A gender not listed," please let us know how you self-identify: Disability Status: Select... ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Docker Compose: Rediscovered](https://www.wearedevelopers.com/videos/1978-docker-compose-rediscovered) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Rethinking Intelligence: AI, Accessibility, and the Future of Inclusive Work - Artur Ortega](https://www.wearedevelopers.com/videos/1377-rethinking-intelligence-ai-accessibility-and-the-future-of-inclusive-work-artur-ortega) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Dev Digest 119 - ❤️ === ❤️](https://www.wearedevelopers.com/magazine/454-dev-digest-119) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix) - [Dev Digest 139 - Soft and hard queries](https://www.wearedevelopers.com/magazine/487-dev-digest-139-soft-and-hard-queries)