Associate Conversion Data Analyst

As part of the larger Conversions team, Associate Conversion Data Analysts extract data from customers' legacy databases, analyze that data and then create data maps to customer’s new Bloomerang databases. You will translate non-technical customer requests to technical documents for engineers to implement in code. This role requires a high level of detail, creative thinking and collaboration between teams. Imagine a 1,000 piece puzzle where every piece is missing one connecting side. If this sounds like fun, this job's for you!

What You Will Do

• 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 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
• You will develop detailed knowledge about how our default code functions to help troubleshoot data errors

What You Need to Succeed

• 1-2 yrs experience with database conversions/database mapping
• Experience with relational databases
• Moderate skill level in SQL
• Excel expert
• 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
• 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.

Nice to Haves But Not Required

• Advanced skill level in SQL
• Experience writing Powershell and/or Python scripts
• Prior experience with non-profits