Apply on Employer Site

Protegis Fire & Safety · 1 month ago

Supplier Costing Data Analyst

1250 Northland Drive, Mendota Heights, MN, 55120, US

Full-time

Onsite

Mid Level

3+ years exp

Protegis Fire & Safety is seeking a Supplier Costing Data Analyst responsible for managing and synchronizing supplier cost data across multiple business systems. This role involves developing data exchange processes, managing cost files, and ensuring data quality through ETL principles while collaborating with various internal teams and suppliers.

Facilities Support ServicesService Industry

Responsibilities

Manage 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

Use 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

Support 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

Maintains high standards of accuracy and compliance across pricing data

Demonstrates adaptability with data tools, file formats, and integration methods

Clearly documents and conveys data and process information

Builds strong partnerships across internal teams and with suppliers

Identifies opportunities to automate, simplify, and enhance data workflows

Qualification

ETL skillsPower QueryOracle Fusion ERPData analytics experienceAPIsFTP/SFTPMicrosoft OfficeAttention to detailCommunication skillsCollaboration skills

Required

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

Must have the ability to effectively read, write and communicate in English with employees and customers

Proficiency in Microsoft Office, required

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%