datatrota
Signup Login
Home Jobs Blog

Data Engineer 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.

Summary

Building efficient data pipelines, integrating data from multiple sources, ensuring data quality and accuracy, and supporting master data governance. The ideal candidate will have a proven track record of leading projects, and a strong ambition to achieve goals and drive success. There will be the need to have both design and, SQL programming skills as it would aid in testing the performance of the system and troubleshooting any problems before it goes live

Responsibilities

  • Oversee data collection, data integration and pipeline development.
  • Work with end users to identify, create, and deliver data that needed for reporting according to requirements.
  • Create objects for new data warehouse development and/or changes to existing data marts.
  • Design and manage data warehouse improvement and growth projects.
  • Identify inefficiencies and gaps in current data warehouses and leverage solutions to ensure data accuracy and standards.
  • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
  • Execute data warehouse configuration and performance tuning.
  • Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.
  • Consulting with data management teams to get a big-picture idea of the company’s data storage needs.
  • Presenting the company with warehousing options based on their storage needs.
  • Designing and coding the data warehousing system to desired company specifications.
  • Conducting preliminary testing of the warehousing environment before data is extracted

Requirements

  • A minimum of a Higher National Diploma (HND) or university degree in the field of computer science, information systems or engineering with a minimum of 5 years of relevant work experience as a Data Engineer.
  • Google Professional Data Engineer Certification or Microsoft Azure Data Engineer Associate Certification
  • Experienced using Microsoft BI Stack i.e. SSIS, SSAS, SSRS
  • Experience with Modern Data Stack
  • Scripting skills e.g. SQL, Python, PowerShell, Bash etc.
  • Experience in DBMS like Oracle, MySQL, SQL Server, PostgreSQL, MongoDB
  • Experience with Cloud Database Infrastructure Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM,and ED

Method of Application

Signup to view application details. Signup Now
X

Send this job to a friend