Supplier Costing Data Analyst

DescriptionThis position is located in-office in Mendota Heights, MN.JOB SUMMARY:The Supplier Costing Data Analyst is responsible for managing, transforming, and synchronizing supplier cost data across multiple business systems, including Oracle Fusion and proprietary quoting and sourcing tools. This role ensures accurate costs, structured data flow, and timely updates by working directly with suppliers and internal technology platform owners.The Analyst develops repeatable and controlled data exchange processes, manages cost files, and applies ETL (Extract, Transform, Load) principles to ensure data quality and consistency across platforms.ESSENTIAL JOB DUTIES: Supplier Cost & Data IntegrationManage intake, validation, and processing of supplier cost and pricing files for Oracle Fusion and related quoting systems.Partner with suppliers to define file formats, transmission methods, and update cadence.Build automated and repeatable costing synchronization processes across systems.Maintain data mapping, control, and staging files for audit traceability.Troubleshoot data transfer, formatting, and transformation issues.ETL & Data TransformationUse Power Query and other ETL tools to clean, transform, and prepare supplier pricing data for system consumption.Ensure consistent file structures, attribute mapping, and cost component accuracy.Build and improve automated workflows using tools such as Power Automate where applicable.Maintain detailed documentation for file specifications, mapping logic, and transformation steps. Cross-Functional CollaborationSupport sourcing, quoting, and purchasing teams with accurate pricing and cost data.Partner with Procurement, Finance, and IT to ensure synchronization of supplier data across Oracle Fusion and related tools.Participate in testing, validation, and improvement of system integrations and pricing update processes.Data Accuracy: Maintains high standards of accuracy and compliance across pricing data.Technical Agility: Demonstrates adaptability with data tools, file formats, and integration methods.Communication: Clearly documents and conveys data and process information.Collaboration: Builds strong partnerships across internal teams and with suppliers.Continuous Improvement: Identifies opportunities to automate, simplify, and enhance data workflows.Other duties may be assigned. QUALIFICATIONSThe qualifications listed below are representative of the elements required to perform the job successfully, however in some cases, an equivalent combination of Education, Training, Certifications and Experience may meet the job qualifications. Education, Training, Certifications: Bachelor's degree in Business, or related field, preferred. 3–5 years of experience in data analytics, procurement data operations, or master data management.Strong ETL skills and proficiency with Power Query and Excel.Experience working with APIs, FTP/SFTP transfers, and structured data formats (XLSX, CSV, TXT, XML).Working knowledge of Oracle Fusion ERP or similar enterprise systems.Strong analytical ability, attention to detail, and data validation discipline.Experience, Knowledge, Skill Requirements:Communication Skills:Must have the ability to effectively read, write and communicate in English with employees and customers. Systems and Software Skills:Proficiency in Microsoft Office,  .  Other Qualifications:Valid driver's license with acceptable driving record required. Must be able to comply with SFPH's Drug and Alcohol policy and Background screening requirements, which may also include customer specific requirements based on contractual agreement.Occasional travel required, up to 20%.PHYSICAL & WORK ENVIRONMENT REQUIREMENTSReasonable accommodations may be made to enable individuals with disabilities to perform Essential Job Duties.Physical Requirements:While performing the duties of this job, the employee is required to sit for long periods. Employee will occasionally be required to bend, kneel, balance, lift