Solutions Architect, Migrations
SnowflakeFull Time
Junior (1 to 2 years)
The ideal candidate will have over 4 years of experience in Data Migration or a SQL/dbt environment, with proficiency in writing complex SQL scripts and transformations. Experience with dbt, Snowflake, GitHub, XML, SSMS, and Python are considered strong advantages, as is prior experience with nonprofit software. A comprehensive understanding of the ETL process, database design, setup, and maintenance is essential, along with strong written and oral communication skills and a collaborative approach. An interest in becoming an expert in nonprofit fundraising and Virtuous products is also required.
The Data Migration Engineer will be responsible for extracting, mapping, formatting, and importing client data from legacy systems to Virtuous, managing complex and custom migrations without predetermined mapping structures. This role involves understanding data structures and relationships, becoming a Virtuous expert to strategically map data, and collaborating with project managers to meet deadlines. The engineer will also understand nonprofit needs for migrating fundraising data, perform data mapping, joining, transformation, and cleaning using ETL tools with an emphasis on SQL, scope complex migrations with customers to develop implementation plans, and collaborate with the internal team on data migration strategy, tooling, and questions.
Nonprofit CRM and fundraising platform
Virtuous provides a customer relationship management (CRM) and fundraising platform specifically designed for nonprofit organizations. The platform helps these organizations manage their donor relationships and enhance their fundraising efforts. It includes tools for donor management, marketing automation, and executing campaigns across multiple channels. Users can analyze donor data through segmentation analytics and automate personalized donor journeys, which helps create a more engaging experience for supporters. Unlike many competitors, Virtuous focuses on treating all donors as major donors, which encourages long-term relationships and support. The goal of Virtuous is to simplify the fundraising process for nonprofits, enabling them to effectively connect with their donors and increase their overall impact.