Lead Data Platform Engineer

Job description

ABOUT US Virtuous is on a mission to inspire global generosity by helping nonprofits build better relationships with their donors. We offer a modern software platform that provides mid-sized charities with elegant tools for fundraising, marketing, volunteerism, and online giving. Our talented team is driven to disrupt the status quo in the nonprofit sector. We are hungry, humble, and committed to delivering best-in-class software solutions, customer success interactions, and sales experiences to the world’s leading nonprofits We also recognize the importance of giving back and making a difference in the communities where we live and work. That's why we practice radical generosity by volunteering at nonprofits or going the extra mile for our team and the customers we serve. We take our work seriously, but we don’t take ourselves too seriously. We believe that life is too short not to love what you do. The ideal candidate for Virtuous embodies our values by: - Asking questions with a spirit of curiosity - Giving feedback freely with candor & grace, welcoming it in return - Displaying a passion for philanthropy and technology - Serving with joy. Everyone is willing to make the coffee! - Celebrating the wins & milestones of others - Assuming good intent & demonstrating trust in others - Pursuing relationships with people different from themselves & creates space to be human Find our core values & more here https://virtuous.org/company/about/. Position Summary Virtuous is evolving its data platform into an AI-ready foundation that powers trusted decision-making and self-service analytics across the company. We’re hiring a Lead Data Platform Engineer to design, build, and own the systems that power our data ecosystem. This role is ideal for a highly motivated self-starter who is comfortable with ambiguity and thrives at the intersection of systems design, business semantics, and AI enablement. This is not a traditional data engineering role focused on building one-off pipelines, dashboards, or ad hoc reports. Success in this role comes from designing and building durable platform capabilities — security models, access patterns, cost controls, and shared data foundations — that enable teams (and AI systems) to safely and confidently use data at scale. You’ll work closely with the Director of Data Operations as well as our Finance, Product, Engineering and Security Teams to ensure our data platform is accurate, governable, and ready to support AI-enabled workflows across the company. What You'll Build & Own DATA PLATFORM & AI-ENABLEMENT - Own the evolution of Virtuous’s data platform, primarily on Snowflake and dbt, as a secure, scalable, and AI-ready system. - Design data models, metadata, and access patterns that support natural-language querying and AI-assisted analysis. - Partner with Data Operations and Teams across the company to ensure data structures are accurate, reusable, and aligned with business definitions. - Prepare data foundations that allow AI tools to deliver consistent, timely, and trustworthy answers. - Ensure AI systems access data exclusively through governed service accounts and role-scoped permissions, with query activity auditable and restricted according to enterprise data classification and access standards. ACCESS, TRUST & GOVERNANCE BY DESIGN - Architect and implement role-based access controls within Snowflake and related data systems (including row- and column-level security), ensuring enforcement aligns with enterprise IAM standards, approved access policies, and centralized identity governance processes. - In partnership with Security Operations and IT, translate approved enterprise access and compliance policies into enforceable platform-level controls, and maintain technical configurations to ensure ongoing alignment with those standards. - Ensure all platform-level access controls integrate with the enterprise identity provider (SSO, SCIM, role lifecycle management), and support automated provisioning, deprovisioning, and periodic access certification processes. - Build governance patterns that are enforced by design — not by manual process. - Support periodic access reviews and control validation processes in coordination with Security and Compliance teams, ensuring appropriate separation of duties between policy definition, approval, and technical implementation. PLATFORM LEVERAGE & STANDARDS - Build and maintain CI/CD pipelines, testing strategies, and deployment patterns for dbt and Snowflake. - Design deployment, testing, and validation patterns that make accuracy the default. - Establish platform standards, templates, and best practices that enable others to move faster without sacrificing quality or security. - Increase the amount of trusted work the organization can do without increasing Data Ops involvement. - Reduce ad hoc work by building reusable systems and guardrails. - Act as a technical leader and thought partner across data-related initiatives. RELIABILITY, COST & PERFORMANCE - Own Snowflake warehouse strategy, resource governance, and cost optimization. - Continuously improve performance, scalability, and reliability across the data platform. - Identify and eliminate inefficiencies that increase cost, risk, or operational overhead. - Collaborate with IT and Cloud Engineering to ensure Snowflake networking, storage integrations, and data movement patterns align with enterprise cloud security baselines, network segmentation standards, and infrastructure governance policies. What Success Looks Like - Teams reliably self-serve data and insights without increasing DataOps workload or risk. - AI-powered tools consistently answer business questions accurately, using governed data, with access enforced by role and context. - Data access, governance, and correctness are enforced by platform design rather than manual review or process. - Platform improvements materially reduce cost, operational risk, or time-to-insight. - Shared, trusted models replace bespoke datasets and one-off definitions. - At least one company-critical initiative (e.g., AI enablement, cost optimization, access expansion) succeeds specifically because of systems you designed and built. Who This Role is For - Care about leverage, durability, and outcomes — not just shipping artifacts. - Think deeply about how AI and automation change the role of data platforms. - Are highly self-directed and motivated, and take pride in ownership. - Thrive in ambiguity and are comfortable making decisions with incomplete information. - Are motivated by leverage, correctness, and long-term impact — not ticket volume or titles. - Readily navigate cross-functional tradeoffs to build shared data foundations that serve the whole company, not individual teams. You Must Have - 7+ years of experience in data engineering, platform engineering, or related infrastructure roles, with ownership of production systems. - Deep expertise in Snowflake, especially: - Roles and RBAC - Row-level and column-level security - Warehouse design and cost optimization - Performance tuning and governance - Strong experience using dbt to build and maintain shared data models, including macro development, testing strategies, source freshness, group model security implementation, and production deployment patterns.. - Advanced SQL skills and experience designing reliable ELT/ETL pipelines. - Proven systems-thinking mindset, with the ability to reason about tradeoffs across correctness, access, cost, and speed. - Clear communicator who can explain complex technical concepts to both technical and non-technical partners. Nice to Have - dbt certification strongly preferred - Experience enabling AI/ML or natural-language data access. - Familiarity with data observability, lineage, or metadata tooling. - Experience designing platforms for self-service analytics. - Exposure to BI tools such as Sigma, Looker, or Tableau. - Experience working in lean, fast-growing organizations where leverage matters more than headcount. What We Offer - Market competitive pay leveraging Carta data - Employee recognition through Bonusly (birthdays, anniversaries, achievements, etc.) - 401(k) retirement plan with company matching- 50% match up to 6% of compensation after 90 days - We value our employee’s work-life balance and encourage taking advantage of Unlimited PTO - Supportive time off including paid volunteer days and company holidays - Employer-contributed healthcare benefits, encompassing medical, dental, and vision coverage, with plans available for dependents and choices for Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA). - 12 weeks primary parent leave, 4 weeks secondary parent leave - full pay (adoption as well) - We pride ourselves on Community and host exciting company outings and events. We’ve recently noticed an increase in recruitment scams where individuals are impersonating recruiters to obtain personal or financial information through fraudulent interviews and job offers. Please note that all legitimate communication from Virtuous will only come from the @virtuous.org http://virtuous.org domain. If you receive a message from other domains, even if they look similar (e.g., virtuouscareers.org http://virtuouscareers.org or virtuousjobs.com http://virtuousjobs.com), they are not legitimate and we recommend disregarding it immediately.