Banner Data Conversion & Migration Lead — ERP Implementation

About the Role
Data Capital Inc. is seeking a Banner Data Conversion and Migration Lead to oversee the extraction, transformation, and loading (ETL) of 29 years of legacy Ellucian Banner data into a new cloud ERP platform at a large R1 public university in Virginia. This is a high-visibility, critical workstream role — data conversion is among the most complex components of this implementation.

What You''''ll Do

• Lead end-to-end data conversion strategy for Banner Finance and HCM data migration to the target cloud ERP
• Analyze Banner database schema (Oracle RDBMS) — tables, relationships, custom columns, and locally developed data structures
• Develop and maintain data mapping documentation — source Banner fields to target ERP fields across all modules
• Identify and remediate legacy data quality issues — duplicates, orphaned records, invalid codes accumulated since 1997
• Manage multiple mock conversion cycles — plan, execute, validate, and track resolution
• Support cutover planning — final conversion sequencing, blackout period, and go-live data validation

What You Need

• 5+ years experience with Ellucian Banner data structures — Finance and HCM Oracle database schema
• Hands-on Banner data extraction experience — SQL, PL/SQL, Banner APIs, or Banner Extensibility
• Prior experience leading or supporting a Banner data migration or ERP conversion project
• Strong data analysis and data quality assessment skills
• Experience with ETL tools and data transformation methodologies
• Strong documentation skills — data mapping specs, conversion runbooks, validation reports

Nice to Have

• Direct experience at a Virginia public university (VT, UVA, VCU, GMU, ODU)
• Knowledge of VT-specific Banner customizations and locally developed enhancements
• Experience with legacy data remediation and historical data archiving strategies
• Familiarity with Banner Document Management and imaging systems

Secondary Skills:
11. Banner APIs
12. Banner Extensibility
13. Data Quality Assessment
14. Legacy Data Remediation
15. ERP Migration
16. Data Validation
17. Higher Education ERP
18. Mock Conversion
19. Cutover Planning
20. Data Mapping Documentation