Business Analyst
Job Description
Job Description
ABOUT THE COMPANY
Founded in 1888, Lee Kum Kee, a Hong Kong-based global food company, specializes in creating condiments and sauces that promote Chinese cuisine worldwide.
With more than 200 products to choose from, Lee Kum Kee takes the mystery out of cooking authentic and delicious Asian foods in the comfort of your kitchen.
Lee Kum Kee is committed to providing authentic and innovative condiments and sauces featuring the highest quality ingredients.
Armed with a unique management culture, stringent quality control, superb and innovative products, coupled with the century-long brand reputation, Lee Kum Kee has achieved unanimous recognition and won numerous prestigious awards.
Lee Kum Kee (USA) Inc., a division of Lee Kum Kee International Holdings Ltd., has its headquarters and manufacturing facilities in Southern California with more than 300 employees.
We are looking for the best and brightest talents to join our company and work together to bring the next level of success!
BENEFITS
- Medical, dental, life insurance covered by the company
- 401(k) retirement plan with company match
- Two (2) weeks vacations
- Ten (10) paid holidays
POSITION SUMMARY
The Business Analyst will be responsible for managing and maintaining SAP HANA platform, generating and running sales reports and AC Nielsen reports, preparing presentations, and performing ad hoc business analytics assignments.
This position will analyze and conduct product and sales channel reviews to identify opportunities and review product performance.
Additionally, this position will make feasible recommendations to the team manager and VP of Strategic Planning aimed at enhancing category effectiveness and overall business performance.
ESSENTIAL FUNCTIONS
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Conduct data analysis and generate insightful reports to support Sales, product development, logistics, and operations teams in their decision-making processes.
- Design, develop, and manage reports, dashboards, and reporting portals that integrate data from multiple sources. These tools will be essential for measuring progress, sales performance, and key performance indicators for various business initiatives.
- Maintain and support AC Nielsen sales data, SAP product data, and SAP HANA sales data. Use this data to create reports that enable managers to monitor sales and product performance effectively.
- Collaborate with stakeholders to assist in the budgeting process. Monitor performance variances against budget regularly and provide actionable recommendations to address any deviations.
- Perform ad hoc duties and tasks as assigned, contributing to the overall efficiency and success of the organization.
COMPETENCIES
- Problem-Solving
- Detail-Oriented
- Planning & Organizing
- Customer Focus
- Self-development
SUPERVISORY RESPONSIBILITIES
This job has no supervisory responsibilities.
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactory. The requirements listed below are representative of the knowledge, skills, and / or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- REQUIRED EDUCATION, SKILLS and EXPERIENCE
- Bachelor's degree in Math, Statistics, Computer Science, or equivalent quantitative training.
- At least 2 years of experience in analyzing and interpreting data, along with preferred team / project management experience.
- Mastery of Microsoft Excel and PowerPoint, along with proficiency in data visualization tools such as Power BI, Tableau, and Qlik Sense, is essential.
- Eagerness to learn and adapt to data retrieval from systems, including SAP ERP and SAP (HANA) CRM.
- Possess strong organizational skills, excellent written and verbal communication abilities, and a natural talent for problem-solving.
- Demonstrate exceptional problem-solving and analytical skills with a keen eye for detail.
- Demonstrate logical and critical thinking skills to effectively analyze problems and make data-driven decisions.
- LANGUAGE SKILLS
- This individual must possess excellent communication and presentation skills both written and verbal.
- Must be fluent in English.
- Bilingual skills (read, speak and write) in Chinese (Mandarin or Cantonese) is a must is preferred.
- MATHEMATICAL SKILLS
- The individual must be able to apply mathematical concepts such as probabilities and statistical inference to forecast annual sales and budget.
- The individual must apply fractions, percentages, ratios, and proportions to practical situations.
- PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Regularly required to use hands and fingers to work on computer keyboard, cell phone, and office equipment.
- Required to stand, sit, kneel, and walk when performing this job.
- Occasional lifting and / or moving up to 50 pounds may be necessary (e.g. moving products, supplies, materials or samples).
- WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
- The noise level in the work environment is light to moderate.
- The position is often in a typical office setting.
It is Lee Kum Kee’s policy to seek and employ the most qualified persons in all jobs in a manner which will ensure equal employment opportunity as well as administer personnel actions in a manner as to not discriminate against any person on the basis of race, color, religion, national origin, age, sex, sexual orientation, disability or protected veteran status.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.