datatrota
Signup Login
Home Jobs Blog

Data Analyst at Seven Up Bottling Company

Seven Up Bottling CompanyLagos, Nigeria Data and Artificial Intelligence
Full Time

Created by the Howdy Corporation in St. Louis, MO, 7UP was an optimistic venture from the very start. After great success with the Howdy Orange drink, company founder C.L. Grigg decided to try his luck with lemons and limes. C.L. Grigg spent more than two years testing over 11 different formulas, all in search of a drink that was refreshing enough to prove irresistible to the people of Missouri and the world at large. In 1929, C.L. Grigg’s bubbliest drink was born. The public quickly developed a taste for Grigg’s caramel colored lemon-lime soda. Bib-Label Lithiated Lemon-Lime Soda sold, and sold well. As the drink grew more and more popular, the original name was traded in for something short and sweet. Bib-Label Lithiated Lemon-Lime Soda became known as 7UP. Early advertising featured a winged 7UP logo with copy that read "a glorified drink in bottles only. Seven natural flavors blended into a savory, flavory drink with a real wallop." The drink was so successful by 1936 that Grigg changed the name of The Howdy Corporation to The Seven-Up Company. By the late 1940s, 7UP had become the third best-selling soft drink in the world. In the decades to follow, 7UP developed iconic branding, setting it apart from industry front-runners. In 1967, 7UP brought the phrase UNCOLA into the national vernacular. The UNCOLA campaign set 7UP apart from its competition and became part of a counter cultural that symbolized being true to yourself and challenging the status quo. Always at the frontier of taste and pop culture, 7UP was also among the first sodas to introduce sugar-free and caffeine free options. Through the years, advertising for 7UP featured everything from a cartoon mascot named Spot, to the "It’s an Up thing" and "Make 7UP yours" taglines.

Responsibilities

  • Collect data from various sources, including databases, spreadsheets, surveys, and external datasets.
  • Clean and preprocess data to ensure accuracy and consistency, addressing missing values and outliers.
  • Analyze data using statistical and analytical techniques to identify patterns and draw meaningful insights.
  • Create charts, graphs, and visual representations of data to effectively communicate findings and trends.
  • Build predictive models and conduct regression analysis to forecast trends or outcomes.
  • Provide context and actionable recommendations based on data analysis and interpretation.
  • Write SQL queries to retrieve and manipulate data from databases.
  • Apply statistical methods to analyze data distributions, correlations, and significance.
  • Ensure data accuracy and integrity through validation processes and quality checks.
  • Extract valuable information from large datasets and identify hidden patterns or trends through data mining.
  • Conduct statistical tests to validate hypotheses and draw conclusions through hypothesis testing.
  • Collaborate with cross-functional teams to understand business requirements and provide data-driven solutions.

Requirements

  • BSc Degree / HND
  • Minimum of 3 years’ experience using Excel and Power BI
  • FMCG Business Knowledge is an added advantage.
  • Microsoft Power BI Data Analyst Associate Certification
  • Microsoft Office Specialist for Excel Certification
  • Experience in using SS Analysis Services (SSAS) and SS Reporting Services (SSRS)
  • Ability to carry out data and report quality assurance and consistency
  • Experience using Python.

Method of Application

Signup to view application details. Signup Now
X

Send this job to a friend