Data Architect

Tbwa Chiat/Day Inc; Durham (CA); Remote; USD 183,000; Full time

Job summary

An established industry player is seeking a skilled Data Architect to join their innovative Technology Department. This full-time role offers the opportunity to design and implement scalable data architecture solutions, ensuring compliance with privacy regulations while collaborating with cross-functional teams. The ideal candidate will have extensive experience in managing complex data structures and a strong understanding of data governance. This role not only emphasizes technical expertise but also a commitment to advancing the organization's mission through impactful data strategies. Join a forward-thinking team that values equity, inclusion, and the ethical use of technology.

Benefits

Generous paid time-off policy

Comprehensive healthcare benefits

401k plan with employer match

Professional development funds

Internal professional development programs

Qualifications

• Significant experience as a data architect or in a similar role.
• Expertise in SQL databases and cloud-based data platforms.

Responsibilities

• Design and implement scalable data architecture solutions.
• Collaborate with teams to support data governance initiatives.

Skills

Data Architecture

SQL

Data Governance

Data Modeling

Problem Solving

Collaboration

Education

Bachelor's Degree in Computer Science or related field

Tools

Redshift

Snowflake

Azure Data Warehouse

BigQuery

Tableau

Job description

Durham, North Carolina, United States · New York, New York, United States · Remote - National · San Francisco, California, United States · Washington, District of Columbia, United States

ABOUT THE JOB

The ACLU seeks applicants for the full-time position of Data Architect in the Technology Department of the ACLU’s National office in New York, NY, Washington, DC, San Francisco, CA, or Durham, NC. This position is also eligible for remote work in the United States.

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 ideal candidate is an experienced data architect or principal engineer with extensive experience in designing and implementing large-scale, high-performance enterprise-level data management solutions and architectural designs that address complex organizational, compliance, and data governance requirements. The ideal candidate would also have demonstrated expertise in conceptual, logical and physical data modeling to manage highly complex data structures.

WHAT YOU'LL DO

Reporting to the Director of Engineering, Data, the Data Architect will join the Data Pod, which leads the ACLU’s operational data engineering efforts. In this role, you will design and implement scalable data architecture solutions, support data governance initiatives, ensure compliance with privacy regulations, and collaborate with cross-functional teams to support the ACLU’s mission through robust data strategies and systems. Your work will ensure that the ACLU and its affiliates can execute fundraising, advocacy, and engagement strategies while prioritizing data privacy and security.

YOUR DAY TO DAY

• You will build, optimize, and maintain conceptual and logical data models and database architecture in support of operational and data analytics systems.
• You will partner with technical and non-technical stakeholders to understand, document, and optimize data flows across the ACLU's ecosystem.
• You will architect and help build a consent management data model and data flows to ensure the ACLU is compliant with privacy legislation and constituent preferences.
• You will play a key role in the migration of our primary fundraising CRM, helping architect future state together with analytics and fundraising stakeholders.
• You will work with business leaders across the organization to understand, document, and deliver on compliance, performance, and security requirements; you will help define and execute on an organizational data governance strategy.
• You will sit on our operational data engineering team and partner with our analytics/platform engineering teams to ensure data engineering consistency across the technology team.
• You will partner with privacy engineering to ensure data retention, deletion and access requests are compliant and performant.
• You will improve overall data reliability, quality, accessibility, and security; you will anticipate potential issues and propose right-sized solutions.
• You will write clear, detailed, concise documentation, including architecture diagrams, reference architecture, data flows, data models, design, and implementation plans for both technical and business audiences.
• You will grow the team's technical expertise through mentorship and provide technical guidance.
• You will help build a culture of growth and learning. You will stay ahead of industry trends to propose innovative solutions that improve organizational data capabilities.
• You will "tag in" to perform data engineering tasks when appropriate; you'll work in Python, SQL, dbt, Dagster.
• Engage in special projects and other duties as assigned.

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.

WHAT YOU'LL BRING

• Significant professional experience as a data architect or in a similar role, working on large-scale data management solutions and constituent data.
• Proven track record of developing and implementing data strategies and tactical solutions that support organizational goals and business processes.
• Capacity to manage large, complex projects and lead others.
• Deep experience with SQL databases, familiarity with cloud-based data platforms like Redshift or similar cloud data warehouse solutions, such as Snowflake, Azure Data Warehouse, or BigQuery.
• Strong understanding of data architecture concepts, including MDM, enterprise architecture standards, data curation, ETL/ELT, data pipelines, and data security best practices.
• Ability to work collaboratively with a cross-functional team of peers and stakeholders, navigating complex decision-making in a rapidly changing environment.
• Comfortable with diving into technical work required in modern data practices, such as exploring API driven architectures, discovering limitations, learning independently, and sharing your learnings with others.
• Strong problem-solving mindset as it will be critical to navigate complex data structures and environments to solve data integration and data quality issues.
• Excellent thought leadership, alignment-building, and communication skills.

PREFERRED QUALIFICATIONS

• Experience implementing privacy compliance products and/or consent management.
• Experience implementing master data management solutions.
• Some familiarity with BI tools like Tableau and machine learning frameworks.
• Some familiarity with recent privacy regulations (CCPA, etc.) and standards.

COMPENSATION

The ACLU is committed to equity, transparency, and clarity in pay. Consistent with our compensation philosophy, there is a set salary for each role based on geographic work location. The annual salary for this position is $182,431 (Level D), reflecting the salary of a position based in New York, NY. Salaries are subject to a regional pay adjustment if authorization is granted to work outside of the location listed in this posting.

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 it’s 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.

OUR COMMITMENT TO ACCESSIBILITY, EQUITY, DIVERSITY & INCLUSION

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 we’re in the courts or in the office, we believe ‘We the People’ means all of us.

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 email [e-mail].