Senior Data Conversion Consultant - Programmer
Remote
For over four decades, the higher education experts at Jenzabar have been helping colleges and universities across the world thrive through multiple services. The Jenzabar culture is one that fosters an entrepreneurial environment, where employees are encouraged to be creative, work hard, and have a great time while doing so. We believe in open doors, asking tough questions, respecting each other, and surpassing our clients’ expectations every step of the way. It’s an enjoyable place to be, with casual dress and a relaxed atmosphere.
Mission Statement:
We believe everyone is a masterpiece with great work to do on Earth. Jenzabar’s mission is to create pathways to empower all to know who they are, what work they are destined to do, and how they can unlock their full potential – at home, at work, and in the world!
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
- 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
Benefits
Medical Insurance, Life Insurance, Dental Insurance, Vision Insurance, Paid Vacation, Paid Sick Days, Paid Parental Leave, Paid Holidays, Short Term Disability, Long Term Disability, 401K, Educational Assistance
Jenzabar does not discriminate in employment opportunities or practices on the basis of race, color, sex, gender, gender identity, pregnancy, childbirth and related medical conditions, genetics, genetic markers and carrier status, creed, religion, national origin, ancestry, age, disability, medical condition, marital status, sexual orientation, military service, veteran status, or any other status protected by state and federal laws.
Please Note: Jenzabar does not sponsor applicants for work visas.
ApplyJob Profile
Benefits/PerksAnnual bonus Casual dress Dental Insurance Educational Assistance Entrepreneurial environment Life Insurance Long Term Disability Medical Medical Insurance Paid holidays Paid parental leave Paid Sick Days Paid Vacation Relaxed atmosphere Short Term Disability Vision Insurance
Tasks- Communicate with clients and teams
- Develop SQL scripts
- Document project updates
- Improve data conversion process
- Transform client legacy data
Admissions Advising Collaboration Communication Database Management Data Conversion Documentation ETL Financial Aid Problem-solving Project Management Registration Software implementation SQL Stored Procedures T-SQL
Experience5 years
Education