ERP Data Migration Analyst

University of California - San Francisco; San Francisco (CA); On-site; USD 85,000 - 120,000; Part time

Job summary

University of California - San Francisco is seeking an ERP Data Migration Analyst for a 6‑month remote position with possible on‑site days. You will lead extraction, transformation, and validation of legacy supply chain data for Oracle Cloud, ensuring data integrity across vendor, item, and location files.

You will collaborate with Technology Operations and Supply Chain leadership, enforce master data standards, perform audits, and troubleshoot data quality issues using Excel and ERP tools.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• Experience collecting, validating, or resolving data issues with stakeholders.
• 2–4 years in Master Data Management, Supply Chain systems, or data analysis.
• Advanced Excel with VLOOKUP/XLOOKUP, PivotTables, and parsing/cleaning data.
• Experience in an ERP environment (Oracle/SAP/Infor/PeopleSoft/Allscripts) ideally during migration.
• Strong negotiation and stakeholder management to collaborate across teams.
• Analytical thinking and ability to improve business processes for data lifecycle.
• Self-motivated, curious, and able to work independently.

Responsibilities

• Data Extraction & Integration: Independently extract and integrate complex datasets from multiple legacy systems.
• ETL & Data Transformation: Use Excel to clean, map, and transform data for Oracle Cloud upload.
• Database Integrity & Maintenance: Audit and report updates to align with business rules.
• Issue Resolution: Identify, troubleshoot, and resolve data anomalies and quality issues.
• Stakeholder Collaboration: Serve as technical point of contact for data inquiries with Tech Ops and Supply Chain.
• Compliance & Standards: Enforce master data management policies to ensure long-term data health.

Skills

Advanced Excel

Data analysis

Stakeholder management

ETL experience

ERP data migration

Vendor collaboration

Education

Bachelor's degree in Information Systems / Business Administration

Tools

Oracle

SAP

Infor

PeopleSoft

Allscripts

Job description

Employment Duration: 6 months. This position is primarily remote; however occasional on-site presence may be required.

The ERP Data Migration Analyst plays a critical role in the successful migration of legacy supply chain data to Oracle Cloud. This position bridges the gap between raw technical data and business utility and is responsible for the end-to-end integrity of master data, including vendor, item, and location files. The role ensures data is accurately extracted, transformed, and validated for use within the new ERP environment.

Responsibilities

• Data Extraction & Integration: Independently extract and integrate complex datasets from multiple legacy systems and disparate text file formats to support migration workstreams.
• ETL & Data Transformation: Utilize advanced Excel functions to clean, map, and transform raw data into upload‑ready formats for Oracle Cloud.
• Database Integrity & Maintenance: Perform regular audits and status reporting to ensure database updates are accurate and consistent with business rules.
• Issue Resolution: Identify, troubleshoot, and resolve data anomalies and quality issues using error detection and process improvement strategies.
• Stakeholder Collaboration: Serve as a technical point of contact for data‑related inquiries, working closely with Technology Operations and Supply Chain leadership to maintain project timelines.
• Compliance & Standards: Enforce master data management policies and standards to ensure long‑term data health following migration.

Required Qualifications

• Bachelor's degree in Information Systems, Business Administration, or a related field, or an equivalent combination of education and relevant experience.
• Direct experience working with vendors, suppliers, or internal business stakeholders to collect, validate, or resolve data issues.
• 2-4 years of experience in Master Data Management (MDM), Supply Chain systems (MMIS), or data analysis.
• Advanced Excel proficiency, including experience with VLOOKUP/XLOOKUP, PivotTables, and data parsing/cleaning techniques.
• Experience working within an ERP environment (e.g., Oracle, SAP, Infor, PeopleSoft, Allscripts), preferably supporting a system migration or implementation.
• Strong negotiation and stakeholder management skills with the ability to collaborate across teams.
• Strong analytical and critical thinking skills, with demonstrated ability to design and improve business processes for managing data throughout its lifecycle.
• Highly self‑motivated and intellectually curious, with the ability to work independently and proactively identify opportunities for improvement.

Preferred Qualifications

• Experience with Power Query or Macros for handling large text file exports.

Salary Information

The final salary and offer components are subject to additional approvals based on UC policy. Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement. To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html

Equal Employment Opportunity

The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law.