Virtuous is hiring a Data Migration Engineer to lead the extraction, mapping, formatting, and import of client data from legacy systems into the Virtuous platform for our largest and most sophisticated nonprofit customers. In this role, you will become an expert in both our product and nonprofit fundraising data, spending an average of 6-12 hours per week directly with customers to ensure successful migrations.
What You'll Do
- Extract, map, format, and import client data from legacy systems (e.g., Blackbaud Raiser’s Edge, eTapestry, Salesforce, DonorPerfect) into Virtuous.
- Understand data structure, determine data relationships, and become a Virtuous expert to properly map data into strategic areas within the platform.
- Manage complex and custom migrations without a predetermined mapping structure.
- Scope complex migrations with nonprofit customers during and/or post-sale to help determine an implementation project plan.
- Collaborate with internal teams on data migration strategy, tooling, and questions.
- Map, join, transform, and clean large, complex data sets using ETL tools with an emphasis on SQL.
What We're Looking For
- 4+ years of experience working in Data Migration and/or a SQL / dbt environment.
- Experience writing complex SQL scripts and transformations.
- Comprehensive understanding of the ETL process.
- Deep knowledge & understanding of database design, setup, and maintenance.
- Strong written and oral communication skills and a collaborative approach to implementing new processes.
- Exceptional time management, organization, and the ability to work with a project manager to set and meet deadlines.
- Self-driven, extremely detail-oriented, and comfortable problem-solving complex data issues.
- Aptitude for learning software and innovation.
- Interest in becoming an expert in nonprofit fundraising and Virtuous products.
Nice to Have
- Experience with dbt.
- Experience with Snowflake.
- Experience with GitHub.
- Knowledge of XML, SSMS and Python.
- Experience working with nonprofit software.
Technical Stack
- SQL, dbt, Snowflake, GitHub, XML, SSMS, Python
Team & Environment
This is a collaborative role, working with project managers and internal team members on strategy and execution.
Benefits & Compensation
- 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.
- Unlimited PTO.
- Paid volunteer days and company holidays.
- Employer-contributed healthcare benefits (medical, dental, vision), with plans for dependents and options for HSA and FSA.
- 12 weeks primary parent leave, 4 weeks secondary parent leave - full pay (adoption as well).
- Company outings and events.
Virtuous is an equal opportunity employer.
