Bloomerang is looking to solve the problem of extracting, analyzing, and mapping data from customer legacy databases to their new Bloomerang databases, requiring translation of non-technical requests into technical documents for engineers.
Requirements
- 1-2 yrs experience with database conversions/database mapping
- Experience with relational databases
- Moderate skill level in SQL
- Excel expert
- Experience testing/QA of data
- Ability to actively explore, learn, and responsibly integrate AI tools into daily tasks to drive efficiency and support Bloomerang's mission.
- Advanced skill level in SQL
- Experience writing Powershell and/or Python scripts
Responsibilities
- You will export client data from legacy databases via front-end reports and full database backups
- You will research client’s legacy data and create data maps to their Bloomerang database
- You will need to test results of data mapping & coding
- You will provide feedback and recommendations to the Conversion Project Manager and Conversion Engineer teams about data issues, code limitations and industry best practices.
- You will create documentation for new legacy databases, export guides and process changes
- You will work on more entry level & templated data conversions
- You will develop detailed knowledge about how our default code functions to help troubleshoot data errors
Other
- Ability to communicate at a technical level, and able to translate technical information to non-technical team members verbally and in writing
- Must be extremely detail oriented and have a very curious nature
- You will be the subject matter expert for migrating data and have an in-depth understanding of Bloomerang’s capabilities & limitations in regards to migrating data.
- You will develop a firm understanding of non-profit/Bloomerang best practices and apply that knowledge to data conversion projects
- Prior experience with non-profits