ERP Data Team Lead

Taleo Social Sourcing•Chicago, IL

About The Position

The ERP Data Team Lead will orchestrate the migration of on-premise Oracle E-Business and Oracle PeopleSoft data to Oracle Fusion Cloud and support Business Intelligence analytical reporting to meet the business and technical requirements of CPS’s multi-year ERP modernization program. The role is part of ERP Portfolio Management within Information and Technology Services and reports to the Director of ERP Portfolio Management. The position leads data governance and migration planning and execution, including data cleansing, reconciliation, validation, mapping, security controls, test planning, mock conversions, and production deployment. It also recruits, onboards, directs, and develops the data governance team, coordinating with data owners, functional and technical leads, business users, SMEs, and system integrators. The role documents migration timelines and outcomes, develops checklists and sign-off processes, and contributes to lessons learned. Other duties and workstreams may be assigned. CPS employees must establish and maintain residency within the City of Chicago within six months of hire and throughout employment. All CPS employees must be Illinois residents; the Chicago residency requirement does not apply to temporary or part-time positions.

Requirements

  • Bachelor’s degree from an accredited college or university.
  • At least 7 years of ERP data migration experience.
  • At least 5 years managing and leading an Oracle Fusion Cloud integration workstream involving migration from on-premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud.
  • At least 5 years managing data migration activities for the Oracle ERP Cloud tech stack.
  • At least 2 years of recent, end-to-end full life-cycle experience as an Oracle Fusion data migration lead implementing Oracle Fusion Financials, HCM, Projects, Grants & Assets, and Procurement Cloud Services.
  • Experience developing data models and data integrity and normalization rules, and developing data extraction, loading, and transformation scripts.
  • Experience with the business context of data in Oracle E-Business Financials and Procurement and Oracle PeopleSoft HCM and Payroll, and migrating on-premises data to relevant Oracle Fusion Cloud services.
  • Experience with data transformation, data-load testing, and related tools and technologies.
  • Experience migrating master and transactional data from on-premise Oracle systems.
  • Experience using Oracle and other industry-leading ETL tools and technologies for large-scale ERP data migration.
  • Experience migrating master data such as chart of accounts, employees, suppliers, and assets, as well as transactional and historical data.
  • Experience with Oracle data migration and integration processes, including migration strategy, conversion plans, data-load timing, object dependencies, and task sequencing.
  • Experience using ADFdi, FBDI, ETL, SQL, and third-party data migration tools.
  • Experience working with Oracle Financials, Procurement, Assets, Projects, Grants, HCM, and Time and Labor Cloud modules.
  • Expertise in migrating master and transactional data, including extraction, cleansing, transformation, loading, and validation from legacy systems to Oracle Fusion Cloud.
  • Strong project management, time management, and organizational skills.
  • Ability to work with large-scale ERP program system integrators to complete each phase on time.
  • Expertise in payroll data conversion and reconciliation.
  • Excellent oral and written communication skills.
  • Ability to collaborate effectively with functional and technical leads, business users, and subject-matter experts.
  • Establish and maintain Chicago residency within six months of hire and throughout employment; all CPS employees must be Illinois residents.

Nice To Haves

  • Master of Business Administration.
  • Oracle ERP Cloud certifications.
  • Oracle Fusion Technical Certification.
  • Experience implementing Oracle Fusion Cloud ERP in K-12 education.

Responsibilities

  • Develop data governance policies, plans, and procedures, including data cleansing strategies, action plans, reconciliation plans, and scripts.
  • Recruit, onboard, direct, guide, and manage the performance and development of the data governance team, fostering collaboration and alignment with division-wide initiatives.
  • Determine the validity of data-element values and review and validate data relationships.
  • Coordinate with data owners to validate cleansed data.
  • Determine data migration requirements and define roles and responsibilities for migration activities.
  • Recommend and implement data governance policies and procedures covering data retention, archival, and purging.
  • Review and comment on data management and migration plans, checklists, timelines, and conversion reports.
  • Document timelines for mock conversions and production deployment.
  • Develop migration checklists and sign-off processes to ensure planned activities are completed.
  • Map current data, including account codes, to the formats and future values in conversion templates.
  • Assist in determining data migration security controls.
  • Develop unit and end-to-end integration migration test plans for data extraction, transformation, loading, and validation.
  • Validate data across mock conversions and the full migration, coordinating with unit and end-to-end integration testing to ensure accurate data flow from source to target applications.
  • Document end-to-end data migration test results and lessons learned.
  • Perform other assigned duties and workstreams.

Benefits

  • Medical plan options
  • Pharmacy coverage
  • Dental insurance
  • Vision insurance
  • Behavioral health and Employee Assistance Program
  • Employee Wellness Program
  • Basic life insurance
  • Life and disability insurance
  • Pension plans
  • Supplemental retirement plans (403(b) and 457(b))
  • Flexible Spending Accounts (FSAs)
  • Spot Pet Insurance
  • Paid leave
  • Sick leave
  • Vacation days
  • Parental leaves
  • Short-term disability
  • Religious holidays leaves
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service