Summit Companies · 2 weeks ago
Supplier Costing Data Analyst
Mendota Heights, MN
Full-time
Onsite
Mid Level
3+ years expSummit Companies is the nation’s leading fire protection company, dedicated to providing high-quality services across various verticals. The Supplier Costing Data Analyst will manage and synchronize supplier cost data, ensuring accuracy and efficiency in data processes while collaborating with internal teams and suppliers.
Public Safety
Hiring Manager
Nadine Filsinger
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
Required
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%
Preferred
Bachelor's degree in Business, or related field, preferred
Benefits
Paid Vacation and Holidays
Medical Insurance
Dental Insurance
Vision Insurance
401(k) Plan with Company Match
Flexible Spending Accounts
Long-Term Disability – Employer Paid
Short-Term Disability – Employer Paid
Additional Voluntary Ancillary Benefits such as Accident and Hospital Indemnity
Life Insurance for Team Members and Dependents
Employee Assistance Program
Employee Referral Program
Company
Summit Companies
Summit Companies has deep experience and a successful history in fire protection services for commercial, industrial and large-scale residential applications.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Quintin Rubald
President & Founder
Company data provided by crunchbase