ERP Data Team Lead

Chicago Public Schools • Chicago, IL

338d

About The Position

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.

Requirements

• 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.
• A minimum of seven (7) years of ERP data migration experience.
• A minimum of five (5) years of experience in managing and leading Oracle Fusion Cloud integration workstream.
• 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.
• Experience developing data models, data integrity and normalization rules.
• Experience in the business context of data in Oracle E-Business Financials and Procurement, and Oracle PeopleSoft HCM and Payroll.
• 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.
• Experience with Data Migration activities for Master Data and Transactional and Historical data.
• Experience with Oracle Data Migration and integration processes.
• 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.

Nice To Haves

• Experience in Education (K-12) ERP Oracle Fusion Cloud Implementation preferred.

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.
• Assist with determining data migration security controls.
• Develop unit and end-to-end integration migration test plans.
• Validate data of multiple mock conversions and the full migration.
• Document the end-to-end data migration test results and lessons learned report.
• Other duties and workstreams as assigned.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Industry: Executive, Legislative, and Other General Government Support
• Education Level: Bachelor's degree