ERP Data Migration Analyst – Supply Chain

University of California, San Francisco; San Francisco (CA); Hybrid; USD 72,000 - 154,600; Full time

Benefits offered by this job

Flexible work style

Opportunity for career advancement

Job summary

A leading university for health sciences is seeking an ERP Data Migration Analyst for a temporary role lasting 6 months. The position involves migrating legacy supply chain data to Oracle Cloud, requiring strong analytical skills and advanced Excel proficiency. Candidates should have a Bachelor’s degree and 2–4 years of relevant experience. The role is primarily remote with occasional on-site requirements. Join us to contribute to improving healthcare worldwide.

Qualifications

• 2–4 years of experience in Master Data Management (MDM) or data analysis.
• Experience within an ERP environment, preferably supporting a migration.

Responsibilities

• Extract and integrate datasets for migration workstreams.
• Utilize advanced Excel functions for data transformation.
• Perform audits to ensure database accuracy.

Skills

Advanced Excel proficiency

Data analysis

Negotiation skills

Analytical skills

Education

Bachelor’s degree in Information Systems or related field

Tools

Oracle Cloud

Power Query

Job description

TEP-Health Employees

Temporary Employment

88501BR

Job Summary

Employment Duration: 6 months

Pay Range: $72,000 – 154,600

Openings: 2

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.

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

The final salary and offer components are subject to additional approvals based on UC policy.

To see the salary range for this position (we recommend that you make a note of the job code and use that to look up): TCS Non-Academic Titles Search (https://tcs.ucop.edu/non-academic-titles)

Please note: An offer will take into consideration the experience of the final candidate AND the current salary level of individuals working at UCSF in a similar role.

For roles covered by a bargaining unit agreement, there will be specific rules about where a new hire would be placed on the range.

To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html

Department Description

UCSF's Temporary Employment Program (TEP) recruits and hires temporary employees for immediate clerical and technical support services to UCSF Departments and various off-campus locations. UCSF departments deploy temporary employees to work on special projects, fill in for regular employees who are on vacation or leave, or to temporarily fill a vacant position during recruitment. Frequently temporary employees become successful candidates for career and limited appointment positions.

Required Qualifications

• Bachelor’s degree in Information Systems, Business Administration, or a related field, or an equivalent combination of education and relevant experience.
• 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.

About UCSF

The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world’s leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence – also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity – both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available at diversity.ucsf.edu

Join us to find a rewarding career contributing to improving healthcare worldwide.

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.

Organization

TEP

Job Code and Payroll Title: 007739 PROCUREMENT ANL 3

Job Category: Administrative Support, Professional (Non-Clinical), Support Services, Technical & Technologist, Temporary Employment

Bargaining Unit: 99 - Policy-Covered (No Bargaining Unit)

Employee Class: Temporary Employment

Percentage: 100%

Location: San Francisco, CA

Campus: Brisbane

Work Style: Flexible

Shift: Days

Shift Length: 8 Hours