Analytics Engineer
<h2><strong>ABOUT THE JOB</strong></h2>
<p>The ACLU seeks applicants for the full-time position of <strong><span class="TextRun SCXW222733757 BCX8" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW222733757 BCX8">Analytics Engineer</span></span></strong> in the <strong><span class="TextRun SCXW222733757 BCX8" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW222733757 BCX8">Analytics division of the Technology Department</span></span><span class="TextRun SCXW222733757 BCX8" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW222733757 BCX8"> </span></span></strong>of the ACLU’s National office in <strong>New York, NY, Washington, DC, or San Francisco, CA. </strong><span data-ccp-props="{"><span class="TextRun SCXW106118647 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW106118647 BCX0">This is a <strong>hybrid role </strong>that has in-office requirements of two (2) days per week or eight </span></span><span class="TextRun SCXW106118647 BCX0" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW106118647 BCX0">(8) days per month.</span></span></span><span class="EOP SCXW106118647 BCX0" data-ccp-props="{"> </span></p>
<p><span data-contrast="auto">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. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></p>
<p><span data-contrast="auto">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.</span></p>
<p><span data-teams="true">This position is part of a collective bargaining unit. It is represented by ACLU Staff United (ASU).</span></p>
<h2><strong>WHAT YOU'LL DO</strong> </h2>
<p><span data-contrast="auto">Reporting to the <strong>Director of Analytics Engineering</strong>, the <strong>Analytics Engineer</strong> 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.</span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></p>
<p><span data-contrast="auto">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. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></p>
<h2><strong>YOUR DAY TO DAY</strong></h2>
<p><span class="TextRun SCXW134410917 BCX8" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW134410917 BCX8">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: </span></span><span class="EOP Selected SCXW134410917 BCX8" data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></p>
<ul>
<li><span data-contrast="auto">Design, develop, and maintain scalable data models to support reporting, business intelligence, and analytics needs using dbt. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">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 </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">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. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Scrape data from public websites to support legal, organizing, and advocacy projects. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Ensure high-quality, accurate, and timely data is available for stakeholders across departments. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Use and help others use data warehousing and SQL best practices to keep our analytics swift and reliable </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li>Partner with internal departments to define and document consistent business data practices </li>
<li><span data-contrast="auto">Collaborate with our Legal and Advocacy Analytics teams to provide data support for fast developing legal crises & issue-based campaigns </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
</ul>
<h2><strong>FUTURE ACLU'ERS WILL </strong></h2>
<ul>
<li>Be committed to advancing the mission of the ACLU</li>
<li>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</li>
<li>Be committed to work collaboratively and respectfully toward resolving obstacles and conflicts</li>
</ul>
<h2><strong>WHAT YOU'LL BRING</strong></h2>
<ul>
<li><span data-contrast="auto">Extensive experience with data warehouses and database query languages (e.g., Redshift, SQL) </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Experience building data models and writing ETL in a business setting </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Undergraduate degree in an analytical field (e.g., Economics, Statistics, Computer Science, Business) or equivalent experience </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Skilled in using a modern scripting language (e.g. Python) </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Proficiency in translating business metrics into well-scoped tasks and requirements </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Working knowledge of BI tools such as Hex, Tableau, or Looker </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li>Familiarity with customer relationship management (CRM) or volunteer management systems, such as Salesforce, Blackbaud, or VAN. </li>
</ul>
<h3><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"><strong><span class="TextRun SCXW127949087 BCX8" lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW127949087 BCX8">PREFERRED QUALIFICATIONS</span></span></strong></span></h3>
<ul>
<li><span data-contrast="auto">Demonstrated experience with a modern data stack, especially dbt for SQL data modeling </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Experience with an orchestration tool (e.g. Dagster, Airflow, Prefect) </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Knowledge of latest trends and technologies in data warehousing/data engineering </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Working knowledge of common Unix command line operations (e.g. file system operations, Docker, Git) </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Familiarity with AWS services such as S3 and Redshift </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559740":240}"> </span></li>
<li><span data-contrast="auto">Familiarity with voter file data</span></li>
</ul>
<h2><strong>COMPENSATION</strong></h2>
This listing is from Greenhouse. View original listing ↗