Position Summary
The Senior Data Conversion Consultant - Programmer is part of our Professional Services team and collaborates with higher education clients and internal teams to execute Jenzabar software implementations and custom programming solutions. A general understanding of the higher education industry is a plus as this position works with data from Student Information Systems (SIS). These systems cover the following areas: Registration, Advising, Student Life, Admissions, Financial Aid, Advancement, Business Office, and Human Resources.
This position is responsible for the successful transformation of customer legacy data and requires understating of application and database requirements and constraints. This role develops SQL scripts in accordance with data conversion mapping documentation, transforming data from customer source system(s) for loading to the Jenzabar platform. The implementation process requires multiple passes, coding updates, management of translation tables, participation in data validation, and go-live engagements. The position calls for strong T-SQL skills and clear, effective internal/external communication.
Essential Tasks
- Develop SQL scripts based on mapping documentation to transform client legacy data, from one or more sources, in preparation for Jenzabar software implementation
- Adhere to project timelines and execute work outlined in project plans and resulting from client engagements
- Communicate frequently and effectively with clients and internal teams to provide status updates, identify risks and roadblocks, and obtain information as needed to keep projects on track
- Own tasks fully, documenting feedback and updates in project tracking software, ensuring successful hand-offs to internal teams and clients
- Provide time estimates for custom tasks outside of original project scope
- Work with the data conversion manager to improve data conversion process and streamline client experience
- Other duties as assigned by management
Skills and Experience
- Bachelor’s Degree or equivalent experience
- 5+ years T-SQL experience, including knowledge of stored procedures, indexing, and script optimization
- ETL experience
- Ability to manage and prioritize multiple projects in a deadline driven environment
- Excellent communication, collaboration, and problem-solving skills
- Experience working for an Accredited College/University or experience in the higher education industry a plus
- Experience with Jenzabar software a plus
The pay range for this position is $58,000-79,000/year; however, base pay offered may vary depending on job-related knowledge, geographic location, skills, and experience. This position is eligible for an annual bonus in addition to a full range of benefits. This information is provided per the relevant state and local pay transparency laws for the location in which this position will be performed.
#LI-Remote
