Job Description
JOB SUMMARY:
Provides data entry and analysis support for Color Group North American operation primarily in DevEx, JDE and TraceGains. Responsible for the governance of raw material, packaging, services and reaction chemical data, address book and item master in DevEx, Tracegains and in Sensient JD Edwards system.
ESSENTIAL DUTIES & RESPONSIBILITIES:
· Write and maintain COGNOS and PowerBi reports and dashboards.
· Work with Supply Chain to pull data for performance analysis to generate process/financial improvements.
· Analyze data to identify trends, patterns, and anomalies.
· Use SQL, Oracle, Python or other programing languages to prepare and present data in a way that is visually appealing and simple for clients to navigate and comprehend.
· Responsible for entry of finished goods, raw material, customer and vendor data in appropriate systems. Including but not limited to TraceGains, DevEx and JD Edwards.
· Maintain contact with manufacturing sites to ensure consistent application of finished goods and raw material data.
· Support Master Data Manager in changes and mass data updates for items, finished goods, and raw materials,
· Validate changes in customers, vendors and related items.
· Identify potential improvement opportunities and subsequent communication with local process owners or management.
· Provide backup assistance for data clean-up.
· Responsible for data accuracy, data integrity checks and assuring consistent master data administration processes and improvements within Colors entities.
· Create and maintain master data and business unit level data as required.
· Verify and approve all mass uploads of manufacturing, customer and vendor data at manufacturing sites
· Manage approval for routing changes and completion of master data views with business owners.
· Make daily decisions concerning master data elements and the application of business rules, policy, and strategy.
· Responsible for assuring consistent master data administration processes.
· Update and maintain needed DevEx and JDE training and SOP documentation.
· Maintain policies for master data objects and views
· Other duties as required.
EDUCATION & EXPERIENCE:
· Bachelor’s degree in Supply Chain or Computer Science. In lieu of degree 5 years relevant work experience required.
· Minimum one to three years of related experience in data analysis, report creation, validation and maintenance.
· Expert proficiency in Microsoft Excel required.
· SQL/ COGNOS 1 year experience preferred
· Tableau / PowerBi 1 year experience preferred
· JDE experience preferred
· Knowledge of TraceGains and Devex preferred
SKILLS & ABILITIES:
· Ability to communicate clearly with employees at all levels throughout the organization, strong problem solving skills required.
· Strong organizational skills with outstanding attention to detail.
· Has demonstrated project management skills, and the ability to prioritize.
· Understanding of performance measures and their impact on the organization.
As a dynamic and diversified global leader, we offer an excellent salary and comprehensive benefits package. For more information, visit our website at http://www.sensient.com.
Company Description
About Sensient Technologies Corporation Sensient Technologies Corporation is a leading global manufacturer and marketer of colors, flavors, and fragrances. Sensient employs advanced technologies at facilities around the world to develop specialty food and beverage systems, cosmetic and pharmaceutical systems, and colors, and other specialty and fine chemicals. The Company's customers include major international manufacturers representing most of the world's best-known brands. Sensient is headquartered in Milwaukee, Wisconsin. As a dynamic and diversified global leader, we offer an excellent salary and comprehensive benefits package. For more information, visit our website at http://www.sensient.com/. Equal Opportunity Employer Sensient Technologies Corporation has facilities around the world that produce a broad range of innovative products for many of the world’s best-known consumer and industrial companies. We provide customized food and beverage systems, pharmaceutical colors and coatings, cosmetic and personal care formulations, specialty inks and colors, and other fine chemicals.