Job Description:
The Data Analyst/Programmer will play a key role in the successful implementation of the new Workday student information system (SIS) by supporting data migration from student legacy platforms.
They will provide support for data extraction, preparation, and validation efforts for the SIS implementation proc
ess. Working with the guidance of the Senior IT Data Specialist and closely with functional experts, this role will develop and execute SQL queries, will assist in data cleaning, conduct validation and reconciliation of data, and maintain thorough documentation of the data handling processes.
Essential Job Functions:
25% A. Create and run SQL queries and scripts for data extraction.
• Create, test and run queries to extract data from multiple legacy systems for migration into Workday Student
• Assist with preparing data for migration into Workday Student
• Perform basic checks to ensure that data extraction is successful
25% B. Assist in validating data before and after migration.
• Perform data quality checks on extracted legacy data prior to migration
• Run queries to validate that data migrated data correctly into Workday
• Document and escalate data validation issues for resolution
25% C. Support data reconciliation and documentation efforts.
• Compare reports from legacy and Workday systems to identify gaps or discrepancies
• Record reconciliation results in project tracking tools
• Maintain documentation of data migration steps, validation results and updates
25% D. Assist technical and functional teams in resolving data discrepancies.
• Work with IT staff and business users in investigating data mismatches
• Clearly document issues found during testing and assist in tracking them to resolution.
• Communicate findings in a clear and simple way to business users when needed
This position is fully remote; however, candidates must reside in one of the following states:Arizona, Colorado, Delaware, District of Columbia, Illinois, Indiana, Iowa, Maryland, Michigan, New Jersey, New York, North Carolina, Pennsylvania, Rhode Island, South Carolina, Tennessee, Texas, Virginia, or Wisconsin.
Job Category:
Staff
Pay Range:
$30.00-$42.50
Application Instructions:
Consideration of applications will begin immediately and will continue until the position is filled.
Please submit the following application materials:
• Cover Letter
• Resume
• 3 references
Goucher College is an Equal Opportunity Employer
Candidates must be able to provide proof of eligibility to work in the USA. No Visa sponsorship is offered for this position.
Goucher College is committed to increasing the equity of our community and seeks applicants dedicated to applying principles of equity and inclusion in all areas of the campus community.