Sql data analyst Jobs in Cincinnati, OH

Buyer Analyst

At Gentherm, we believe the next big breakthrough begins with you. As a global leader in thermal management and pneumatic comfort technologies, we develop advanced systems that deliver meaningful solutions to enhance health, wellness, comfort, and efficiency in everyday life. Our products and innovations are created for you, by you. Be part of our team where a human-centric mindset drives everything we dofrom the technologies we build to the careers we support. With decades of expertise, we have pioneered advanced solutions that have become a standard expectation for consumers around the world. The same thoughtful approach we take in developing our technologies guides how we support your career: purposeful, impactful, and tailored to you. Because when you thrive, innovation thrives.

Buyer Analyst uses data and procurement best practices to optimize inventory, make buying decisions, manage supplier relationships, and reduce costs. Work closely with Supply Chain, Sales, Production, Warehouse, Quality, and Suppliers, to achieve company goals. Core responsibilities include Data Analysis, Forecasting, Supplier Management, Planning, and Reporting.

Essential Functions and Responsibilities:

• Place Purchase Orders through our ERP system.
• Use inventory, sales, work order, and forecast information to determine delivery dates, quantities, and pricing.
• Review KPI's and Inventory reports to anticipate, address, and prevent interruptions to production.
• Perform Product Group component analysis to determine forecast threats based on component availability.
• Attend various meetings, virtual and/or in person, as a representative of the Purchasing department, in order to provide updates, help make inventory decisions, or resolve outstanding issues.
• Update/Set component Safety Stock, ROP, and lead-times in the ERP system to support timely order placement and minimize stock-out occurrences.
• Independently manage inventory, projects, and cost savings initiatives to improve company inventory turns and profitability.
• Assist the Accounting department in addressing invoice discrepancies and other vendor payment related issues in a timely manner.
• Work with the Quality Department and Suppliers to address non-conforming materials and help facilitate associated RMA, rework, or scrap activities.
• Support Supplier Set-up and Annual Evaluation processes (Set-up paperwork, quality metric, on-time delivery report, supplier spend, etc.).
• Represent Purchasing during product development by finding new supply sources, managing RFQs, and rationalizing component selection from vendors.

Minimum Qualifications:

• Bachelor's degree from an accredited college or university in business administration or related field and three years of professional purchasing responsibilities; OR graduation from high school or equivalent education and five years of purchasing experience, with a minimum of two years as a Buyer/Planner/Analyst or higher.
• Technical skills, including (but not limited to) proficiency in Microsoft Excel and software tools (Power BI, Tableau, SAP Ariba, Oracle, Coupa, etc.)
• Utilize tactical problem-solving skills to balance order fulfillment priorities pertaining to order size and its impact on lead times, product cost, inventory levels, freight costs, and service levels, to determine which solution meets our companies and customer's needs.
• Ability to work, achieve goals, and meet deadlines independently, with minimal supervision after initial training.
• Prior Material Resource Planning (MRP) / Enterprise Resource Planning (ERP) experience
• Demonstrated negotiating skills in soliciting competing bids from multiple vendors to meet technical, quality, and lead time objectives at the lowest overall cost.
• Have a complete understanding of, and be able to apply, sound Purchasing principles, concepts, and practices.
• Strong organization, attention to detail, project management, and multi-tasking skills.
• Excellent verbal and written communication skills (internal and external) as well as strong Interpersonal and team skills to lead and influence effectively across various levels of the organization

Preferred Qualifications:

• Advanced degree in business administration or related field.
• Prior work history in a manufacturing environment.
• Visual ERP experience.
• CPM or CPSM.
• Previous audit history and/or experience working in FDA or other highly regulated industry.

Gentherm is an Equal Opportunity Employer. We are committed to building an inclusive culture through Our Network of Engagement (ONE) where we value our differences and work together to positively impact the lives of our employees, customers, and communities. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, genetic information, sexual orientation, gender identity, disability, or protected veteran status.