Data Migration Engineer

Position Summary A Virtuous Data Migration Engineer will be in charge of extracting, mapping, formatting, and importing client data from legacy systems to Virtuous for our biggest and most sophisticated nonprofit customers. Common legacy systems include but are not limited to Blackbaud Raiser’s Edge, eTapestry, Salesforce, DonorPerfect, etc. They must understand data structure, determine data relationships and become a Virtuous expert to properly map data into the most strategic areas within Virtuous. Virtuous Data Migration Engineers manage migrations that are most often seen as complex and custom, without a predetermined mapping structure. This role requires proficient knowledge of SQL and relational databases. Exceptional time management, organization, and the ability to work with a project manager to set and meet deadlines is a necessity. This is a customer facing role with an average of 6-12 hours of customer facing time per week. Oftentimes customers will be organizational leaders and will require professional communication skills. This role, though collaborative, will require a self-driven individual who is extremely detail oriented and is comfortable problem-solving complex data issues and integrating small details with higher-level customer data strategy. Must have an aptitude for learning software and innovation. While this role is open to remote candidates within the US, we're initially prioritizing candidates based in the Phoenix, AZ area who are open to a hybrid work arrangement. 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 You Must Have 4+ years of experience working in Data Migration and/or a SQL / dbt environment Experience writing complex SQL scripts and transformations Experience with dbt is a plus 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 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. #J-18808-Ljbffr Ascent360