Goucher College · 16 hours ago
Lead Data Analyst/Programmer
United States
Full-time
Remote
Lead/Staff
$30/hr - $42.50/hrGoucher College is seeking a Lead Data Analyst/Programmer to oversee the technical execution of data extraction, transformation, and loading processes for the transition to the Workday Student Information System. The role involves ensuring data integrity through advanced SQL scripting and managing data validation while collaborating with cross-functional teams and external vendors.
Higher Education
No H1B
Responsibilities
Lead design and development of SQL-based ETL workflows
Extract, cleanse, and transform student data from PowerCampus for migration
Document data mapping, validation, and reconciliation processes
Resolve data integrity issues pre and post migration
Collaborate with cross-functional teams and external vendors
Supervise the work of the Junior IT Data Analyst and Reporting Specialist
Qualification
Required
Lead design and development of SQL-based ETL workflows
Design, develop, and maintain SQL-based ETL workflows for extracting, transforming, and loading student data into Workday Student
Ensure scalability, repeatability, and accuracy of ETL processes
Extract, cleanse, and transform student data from PowerCampus for migration
Extract, cleanse, and transform student, academic, and administrative data from PowerCampus and other legacy sources
Support iterative test migrations and reconcile results to ensure consistency
Document data mapping, validation, and reconciliation processes
Document data mapping, transformation logic, and migration processes
Establish validation protocols to confirm accuracy of migrated data across systems
Resolve data integrity issues pre and post migration
Identify and resolve data integrity and quality issues before and after migration
Partner with functional stakeholders to ensure records align with institutional requirements
Collaborate with cross-functional teams and external vendors
Collaborate with cross-functional business partners, IT colleagues, and external vendors to align migration strategy with project timelines
Provide data insights and technical support to project leadership
Supervise the work of the Junior IT Data Analyst and Reporting Specialist
Mentor and guide the Junior IT Data Analyst and Reporting Specialist assigned to the project
Share best practices in SQL, ETL, and data management
Candidates must be able to provide proof of eligibility to work in the USA
No Visa sponsorship is offered for this position
Company
Goucher College
Goucher College is an education institution offering courses which prepares its students for careers that haven't been invented yet.
Founded in 1885
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Claire Corliss
Student Record Manager & Academic Advisor at Goucher Prison Education Partnership
Dr. Julie Love
Faculty at Goucher Prison Education Partnership
Recent News
Technically Media
2025-05-27
Seattle TechFlash
2025-04-28
Company data provided by crunchbase