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