Data Architect

Data Architect

Requirements

• 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

Responsibilities

• 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 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

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