Back to jobs

ERP Data Team Lead

Central-42 West Madison Street (Information & Technology Svcs)

Actively hiring, first seen by us 3 days ago
Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Lead the data governance team, including hiring and performance management

  • Map source data to Oracle Fusion templates, including account code mapping

  • Validate data across mock conversions and the full migration

  • Develop data cleansing strategies, reconciliation plans and migration scripts

  • Build migration checklists, timelines and end-to-end test plans

From the employer’s posting
Recruit, onboard, and provide direction, guidance, and strong leadership and performance management to the data governance team
Map the data in the format provided in conversion templates.
Validate data of multiple mock conversions and the full migration
Develop data governance policy, plans, and procedures with solid experience in developing data cleansing strategies, action plans, reconciliation plans, and scripts.
Develop a data migration checklist and sign-off process to ensure completion of planned activities.

Before you apply

Eligibility
Establish/Maintain Chicago Residency - Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. — eligibility source
Establish/Maintain Chicago Residency - Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois.
Read the full posting
Education & alternatives
Education Required: - Bachelor’s degree from an accredited college or university is required. - Master’s of Business Administration
- Bachelor’s degree from an accredited college or university is required. - Master’s of Business Administration - Oracle ERP Cloud certifications preferred.

Benefits in the posting

Full benefits wording
  • Health & Wellness: Your Care, Your Choice
  • CPS is committed to providing comprehensive health coverage to our employees and their eligible dependents. You'll have access to a variety of choices to best fit your needs:
  • Medical Plan Options
  • Pharmacy
  • Dental
  • Vision
  • Behavioral Health & EAP
  • Employee Wellness Program
  • We understand the importance of financial stability, which is why CPS offers strong retirement and savings options:
  • Basic Life Insurance
  • Life and Disability Insurance
  • Pension Plans
  • Supplemental Retirement Plans (403(b) and 457(b))
  • Vacation Days
  • Short-Term Disability
  • Religious Holidays
  • Leaves

From the employer’s posting.

Apply at Cpsk12il

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 6 and day 56.

From 14,770 similar postings that came down. Coming down is not always a hire.

Cpsk12il is hiring

6 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Oracle
Where the posting names them
- Experience with Oracle Data Migration and integration processes, including preparation of migration strategy, conversion plan, timing of data loads, object dependencies, and sequencing of tasks. - Experience using ADFdi, FBDI, ETL, SQL, and any third-party tools used for data migration. - Experience working with Oracle Financials, Procurement, Assets, Projects, Grants, HCM, and Time and Labor Cloud modules.
Chicago Public Schools (CPS) is a district on the rise, serving over 320,000 students in 500+ schools and employing over 44,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that prepares each for success in college, career, and civic life. In order to fulfill this mission, we make three commitments to our students, their families, and all Chicagoans: academic progress, financial stability, and integrity. Six core values are embedded within these commitments – student-centered, whole child, equity, academic excellence, community partnership, and continuous learning. CPS is currently undertaking a multi-year ERP modernization program for migrating and upgrading on-premise Oracle E-Business Financials, and Oracle PeopleSoft Human Capital Management Applications, and Kronos Workforce Management System to the latest SaaS-based Oracle Cloud ERP Platform as part of business and technology transformation. Job Summary:
Job Summary: The ERP Data Team Lead is responsible for the orchestration of migrating On-Premise Oracle E-Business and Oracle PeopleSoft data to Oracle Fusion Cloud and Business Intelligence Analytical Reporting to meet the business and technical requirements for the ERP Modernization Program. This position resides in ERP Portfolio Management of the Information and Technology Services (ITS) and reports to the Director of ERP Portfolio Management. This role will be responsible for the orchestration of On-Premise Oracle E-Business and Oracle PeopleSoft data migration activities to Oracle Fusion Cloud to meet business requirements. The ERP Data Team Lead will be held accountable for the following responsibilities:
- Master’s of Business Administration - Oracle ERP Cloud certifications preferred. - Oracle Fusion Technical Certification preferred.
- Oracle ERP Cloud certifications preferred. - Oracle Fusion Technical Certification preferred. Experience Required:
- A minimum of seven (7) years of ERP data migration experience, including. - A minimum of five (5) years of experience in managing and leading Oracle Fusion Cloud integration workstream- On-Premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud. - A minimum of five (5) years of experience managing data migration activities for Oracle ERP Cloud Tech stack.
- A minimum of five (5) years of experience in managing and leading Oracle Fusion Cloud integration workstream- On-Premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud. - A minimum of five (5) years of experience managing data migration activities for Oracle ERP Cloud Tech stack. - A minimum of two (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.
- A minimum of five (5) years of experience managing data migration activities for Oracle ERP Cloud Tech stack. - A minimum of two (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, data integrity and normalization rules, and developing data extraction, load, and transformation scripts.
- Experience developing data models, data integrity and normalization rules, and developing data extraction, load, and transformation scripts. - Experience in the business context of data in Oracle E-Business Financials and Procurement, and Oracle PeopleSoft HCM and Payroll and migrating the on-premises data to relevant Oracle Fusion Cloud Services. - Experience with data transformation, data load testing, and related tools and technologies.
- Experience in migrating master data and transactional data from On-Premise Oracle. - Experience utilizing Oracle and other industry-leading ETL tools and technologies to support large-scale ERP data migration efforts. - Experience with Data Migration activities for Master Data such as COA, Employees, Suppliers, Assets, etc., and Transactional and Historical data.
- Experience with Data Migration activities for Master Data such as COA, Employees, Suppliers, Assets, etc., and Transactional and Historical data. - Experience with Oracle Data Migration and integration processes, including preparation of migration strategy, conversion plan, timing of data loads, object dependencies, and sequencing of tasks. - Experience using ADFdi, FBDI, ETL, SQL, and any third-party tools used for data migration.
- Experience using ADFdi, FBDI, ETL, SQL, and any third-party tools used for data migration. - Experience working with Oracle Financials, Procurement, Assets, Projects, Grants, HCM, and Time and Labor Cloud modules. - Experience in Education (K-12) ERP Oracle Fusion Cloud Implementation preferred.
- Experience working with Oracle Financials, Procurement, Assets, Projects, Grants, HCM, and Time and Labor Cloud modules. - Experience in Education (K-12) ERP Oracle Fusion Cloud Implementation preferred. Knowledge, Skills, and Abilities:
Knowledge, Skills, and Abilities: - E-Business and Oracle PeopleSoft to Oracle Fusion Cloud. - Expertise in Data Migration of Master data and transactional data, including Extraction, Cleansing, Transformation, Loading, and Validation from Legacy systems to Oracle Fusion Cloud.
- E-Business and Oracle PeopleSoft to Oracle Fusion Cloud. - Expertise in Data Migration of Master data 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.

Your next step

Complete your application on cpsk12il.taleo.net. The employer’s form will show what is required.

Applying through Taleo

  • You sign in or register with the employer’s Taleo careers section before you can apply. Each employer sets its own accepted files and size limit.

Already applied? Track this application

Job description

View original posting ↗

Chicago Public Schools (CPS) is a district on the rise, serving over 320,000 students in 500+ schools and employing over 44,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that prepares each for success in college, career, and civic life.  In order to fulfill this mission, we make three commitments to our students, their families, and all Chicagoans: academic progress, financial stability, and integrity.  Six core values are embedded within these commitments – student-centered, whole child, equity, academic excellence, community partnership, and continuous learning.

CPS is currently undertaking a multi-year ERP modernization program for migrating and upgrading on-premise Oracle E-Business Financials, and Oracle PeopleSoft Human Capital Management Applications, and Kronos Workforce Management System to the latest SaaS-based Oracle Cloud ERP Platform as part of business and technology transformation.

 

Job Summary: 

The ERP Data Team Lead is responsible for the orchestration of migrating On-Premise Oracle E-Business and Oracle PeopleSoft data to Oracle Fusion Cloud and Business Intelligence Analytical Reporting to meet the business and technical requirements for the ERP Modernization Program. This position resides in ERP Portfolio Management of the Information and Technology Services (ITS) and reports to the Director of ERP Portfolio Management. This role will be responsible for the orchestration of On-Premise Oracle E-Business and Oracle PeopleSoft data migration activities to Oracle Fusion Cloud to meet business requirements.

The ERP Data Team Lead will be held accountable for the following responsibilities:

  • Develop data governance policy, plans, and procedures with solid experience in developing data cleansing strategies, action plans, reconciliation plans, and scripts.
  • Recruit, onboard, and provide direction, guidance, and strong leadership and performance management to the data governance team to ensure robust learning and career development consistent with the CPS values and mission; foster collaboration and effective integration of efforts with division-wide initiatives.
  • Determine the validity of the values of the data elements and review and validate data relationships.
  • Coordinate with data owners to validate cleansed data.
  • Determine data migration requirements.
  • Define roles and responsibilities for the data migration activities.
  • Recommend and implement policies and procedures around data governance, including data retention, data archival, and purging.
  • Review and provide comments and suggestions on the data management plan, data migration plan, checklist, timeline, and conversion report delivered.
  • Document migration activity timelines for mock conversions and production deployment.
  • Develop a data migration checklist and sign-off process to ensure completion of planned activities.
  • Map the data in the format provided in conversion templates. This includes mapping the current account codes to the future account codes etc.
  • Assist with determining data migration security controls.
  • Develop unit and end-to-end integration migration test plans (including testing for data extraction, transformation, data loading, and data validation).
  • Validate data of multiple mock conversions and the full migration, coordinating with unit and end-to-end integration testing to ensure the flow of data from the source applications to the target applications is accurate.
  • Document the end-to-end data migration test results and lessons learned report.
  • Other duties and workstreams as assigned.

In order to be successful and achieve the above responsibilities, the Data Team Lead must possess the following qualifications: 

Education Required: 

  • Bachelor’s degree from an accredited college or university is required. 
  • Master’s of Business Administration
  • Oracle ERP Cloud certifications preferred.
  • Oracle Fusion Technical Certification preferred.

Experience Required: 

  • A minimum of seven (7) years of ERP data migration experience, including.
    • A minimum of five (5) years of experience in managing and leading Oracle Fusion Cloud integration workstream- On-Premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud.
    • A minimum of five (5) years of experience managing data migration activities for Oracle ERP Cloud Tech stack.
    • A minimum of two (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, data integrity and normalization rules, and developing data extraction, load, and transformation scripts.
  • Experience in the business context of data in Oracle E-Business Financials and Procurement, and Oracle PeopleSoft HCM and Payroll and migrating the on-premises data to relevant Oracle Fusion Cloud Services.
  • Experience with data transformation, data load testing, and related tools and technologies.
  • Experience in migrating master data and transactional data from On-Premise Oracle.
  • Experience utilizing Oracle and other industry-leading ETL tools and technologies to support large-scale ERP data migration efforts.
  • Experience with Data Migration activities for Master Data such as COA, Employees, Suppliers, Assets, etc., and Transactional and Historical data.
  • Experience with Oracle Data Migration and integration processes, including preparation of migration strategy, conversion plan, timing of data loads, object dependencies, and sequencing of tasks.
  • Experience using ADFdi, FBDI, ETL, SQL, and any third-party tools used for data migration.
  • Experience working with Oracle Financials, Procurement, Assets, Projects, Grants, HCM, and Time and Labor Cloud modules.
  • Experience in Education (K-12) ERP Oracle Fusion Cloud Implementation preferred.

Knowledge, Skills, and Abilities: 

  • E-Business and Oracle PeopleSoft to Oracle Fusion Cloud.
  • Expertise in Data Migration of Master data 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 for timely completion of each phase.
  • Expertise in Payroll data conversion and reconciliation.
  • Excellent oral and written communication skills.
  • Ability to successfully collaborate with functional and technical leads, business users, and SMEs.

 

Conditions of Employment

As a condition of employment with the Chicago Public Schools (CPS), employees are required to:

  • Establish/Maintain Chicago Residency - Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois.
Benefits:
Health & Wellness: Your Care, Your Choice
CPS is committed to providing comprehensive health coverage to our employees and their eligible dependents. You'll have access to a variety of choices to best fit your needs:
  • Medical Plan Options
  • Pharmacy
  • Dental
  • Vision
  • Behavioral Health & EAP
  • Employee Wellness Program
Financial Security: Planning for Today and Tomorrow
We understand the importance of financial stability, which is why CPS offers strong retirement and savings options:
  • Basic Life Insurance
  • Life and Disability Insurance
  • Pension Plans
  • Supplemental Retirement Plans (403(b) and 457(b))
  • Flexible Spending Accounts (FSAs)
  • Spot Pet Insurance
Work-Life Balance: Supporting Your Personal and Professional Life
CPS values the well-being of its employees and offers competitive paid time off policies:
  • Paid Leave
  • Sick Leave
  • Vacation Days
  • Parental Leaves
  • Short-Term Disability
  • Religious Holidays
  • Leaves
Reference the Chicago Public Schools: A Comprehensive Benefits Overview or the benefits handbook for comprehensive details.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Central-42 West Madison Street (Information & Technology Svcs)

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.