[Hiring] Data Analyst/Programmer @Goucher College

Role 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 process. Working with the guidance of the Senior IT Data Specialist and closely with functional experts, this role will develop and execute SQL queries, 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 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.

Requirements

• 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.

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

Company Description

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.