Analytics Engineer
Job Location:
San Francisco, CA - USA
Yearly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
The ACLU seeks applicants for the full-time position ofAnalytics Engineer in the Analytics division of the Technology Departmentof the ACLUs National office inNew York NY Washington DC or San Francisco CA.This is ahybrid rolethat 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 ACLUs 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 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).
Reporting to the Director of Analytics Engineering the Analytics Engineer will be part of a team focused on reliably transforming data in the ACLUs internal systems into analysis-ready forms scraping data from public sources and working to improve our overall data and analysis 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.
Theanalytics 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.
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
- 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
- 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
For over 100 years the ACLU has worked to defend and preserve the individual rights and liberties guaranteed by the Constitution and laws of the United States. Whether its ending mass incarceration achieving full equality for the LGBTQ community establishing new privacy protections for our digital age or preserving the right to vote or the right to have an abortion the ACLU takes up the toughest civil liberties cases and issues to defend all people.
We know that great people make a great organization. We value our people and know that what we offer is essential not just their work but to their overall well-being.
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
Accessibility equity diversity and inclusion are core values of the ACLU and central to our work to advance liberty equality and justice for all. For us diversity equity accessibility and inclusion are not just check-the-box activities but a chance for us to make long-term meaningful change. We are a community committed to learning and growth humility and grace transparency and accountability. We believe in a collective responsibility to create a culture of belonging for all people within our organization one that respects and embraces difference; treats everyone equitably; and empowers our colleagues to do the best work possible. We are as committed to anti-oppression anti-ableism and anti-racism internally as we are externally. Because whether were in the courts or in the office we believe We the People means all of us.
With this commitment in mind we strongly encourage applications from all qualified individuals without regard to race color religion gender sexual orientation gender identity or expression age national origin marital status citizenship disability veteran status and record of arrest or conviction or any other characteristic protected by applicable law.
The ACLU is committed to providing reasonable accommodation to individuals with disabilities. If you are a qualified individual with a disability and need assistance applying online please complete theAccommodation Request Form
If you are selected for an interview you will receive additional information regarding how to request an accommodation for the interview process.
The Department of Education has determined that employment in this position at the ACLU does not qualify for the Public Service Loan Forgiveness Program.
Required Experience:
IC
About Company
The ACLU dares to create a more perfect union — beyond one person, party, or side. Our mission is to realize this promise of the United States Constitution for all and expand the reach of its guarantees.
