Note: The job is a remote job and is open to candidates in USA. Virtuous is on a mission to inspire global generosity by helping nonprofits build better relationships with their donors. The Data Migration Engineer will be responsible for extracting, mapping, formatting, and importing client data from legacy systems to Virtuous, ensuring that data is aligned with the needs of nonprofit customers.
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 SQL
- Feel comfortable adapting customer needs on the spot to determine the best method of aligning their legacy data with the most aligned spot in our CRM
- Collaborate with our internal team on data migration strategy, tooling, and questions
Skills
- 4+ years of experience working in Data Migration and/or a SQL / dbt environment
- Experience writing complex SQL scripts and transformations
- Experience with dbt
- Experience with Snowflake is a plus
- Experience with GitHub is a plus
- Experience with API, Integrations a plus
- Knowledge of XML, SSMS and Python is a plus
- Experience working with nonprofit software is a plus
- 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
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.
Company Overview
Our mission is to move the needle on global generosity by helping nonprofits better connect with and inspire their supporters. It was founded in 2014, and is headquartered in Phoenix, Arizona, USA, with a workforce of 51-200 employees. Its website is https://www.virtuous.org.