Data Migration Engineer

Summary

Join Virtuous as a Data Migration Engineer and be responsible for migrating client data from legacy systems (like Blackbaud Raiser's Edge, eTapestry, Salesforce, DonorPerfect) to the Virtuous platform. You will extract, map, format, and import data, requiring expertise in data structures, relationships, and SQL. This role demands exceptional time management, organization, and professional communication skills, as you'll interact with nonprofit clients. You'll collaborate internally on data migration strategies and solve complex data issues. The ideal candidate is self-driven, detail-oriented, and eager to learn new software and innovative solutions. This position involves approximately 6-12 hours of customer-facing time per week.

Requirements

• 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
• Interest in becoming an expert in nonprofit fundraising and Virtuous products
• Strong written and oral communication skills and a collaborative approach to implementing new processes

Responsibilities

• Understand the varying needs of nonprofits, and how to migrate associated fundraising data to Virtuous in line with best practices
• Get excited about mapping, joining, transforming and cleaning large, complex data sets using ETL tools with an emphasis on SQL
• Feel comfortable scoping complex migrations with our nonprofit customers during and/or post sale to help determine an implementation project plan
• Collaborate with our internal team on data migration strategy, tooling, and questions

Preferred Qualifications

• Experience with dbt is a strong plus
• Experience with Snowflake is a plus
• Experience with GitHub is a plus
• Knowledge of XML, SSMS and Python is a plus
• Experience working with nonprofit software is a plus

Benefits

• 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