Supplier Costing Data Analyst Job at Summit Companies in Mendota Heights

Job Description Direct message the job poster from Summit Companies. This 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 Integration 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. ETL & Data Transformation 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. Cross‑Functional Collaboration 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. Continuous Improvement: Identify opportunities to automate, simplify, and enhance data workflows. Qualifications Bachelor’s degree in Business or a 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. Valid driver’s license with acceptable driving record. Must comply with SFPH’s Drug and Alcohol policy and background screening requirements. Occasional travel required, up to 20%. Proficiency in Microsoft Office, required. Must have the ability to effectively read, write, and communicate in English with employees and customers. Strong communication skills, including clear documentation and conveying data and process information. Strong technical agility and adaptability with data tools, file formats, and integration methods. Collaboration and partnership building across internal teams and suppliers. Physical & Work Environment Requirements Reasonable accommodations may be made to enable individuals with disabilities to perform essential job duties. 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 Employee will consistently be required to work indoors in an office setting, work alone and with others. Office settings are mild to moderate temperatures. Equal Opportunity We are fully committed to equal opportunities for employment to all individuals regardless of race, national origin, gender, religion, sexual orientation, disability, familial status, and any other classification protected under the law. We are an Equal Opportunity, affirmative action employer. While this job description is intended to be an accurate reflection of the position, management reserves the right to modify, add, or remove duties and to assign other duties as necessary. About Us Summit Companies, through its subsidiaries, is a full‑service provider for fire detection, suppression, and security with a full suite of capabilities that includes design, installation, testing, inspections, and maintenance. We serve customers across many verticals on a local, regional, and national scale. We’re proud of our well‑deserved reputation for quality work that’s completed by our talented and experienced installation workforce. Summit Companies is a dynamic organization with endless growth opportunities spanning over 100 locations in more than 30 states. Our company is consistently recognized for service excellence in the fire protection industry. Summit Companies supports trade skills and workforce development by hosting recognized apprenticeships and on‑the‑job training (OJT) programs for new career‑seekers. Many members of our leadership team serve as chair on NFPA code compliance committees, serve on regional safety boards, and support technical education in local schools. Summit Companies supports employees in their professional development by offering continued development, training, and education by encouraging NICET and other career‑advancing certifications. We continually strive to be the Employer of Choice for highly motivated team members who want to succeed in a high‑growth environment. We encourage initiative, independence, diversity, and personal career growth. The combination of experience, knowledge, and customer service is the key to our performance and helps us achieve our goal of providing the highest quality of fire protection services to protect lives and property. Benefits Summit Companies offers extensive training opportunities, career advancement, competitive pay, bonus opportunities, and an industry‑leading and affordable benefits package for eligible employees. Our benefits package includes: 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 Seniority level Mid‑Senior level Employment type Full‑time Job function Management and Manufacturing #J-18808-Ljbffr