ETL Developer at Seven Up Bottling Company

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.

Job Summary

• As an ETL Developer, you will play a critical role in designing, implementing, and maintaining our data infrastructure.
• Your expertise will be crucial in 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 minimum of 5 years of relevant experience, a proven track record of leading projects, and a strong ambition to achieve goals and drive success.

Responsibilities

• Design, develop, and maintain robust and scalable data pipelines and ETL processes to ensure efficient data flow and integration from various sources.
• Collaborate with cross-functional teams to understand business requirements and translate them into data models, schema, and database structures.
• Implement and manage databases, ensuring data security, integrity, and optimal performance.
• Carry out data quality checks, identify and resolve data discrepancies, and implement measures to improve data quality and accuracy.
• Support master data governance by establishing data standards, documentation, and data quality rules.
• Optimize and fine-tune database performance, conduct capacity planning, and recommend improvements.
• Lead or handle projects related to data engineering, successfully delivering on time and within budget.
• Stay up-to-date with industry trends and best practices, keeping abreast of new tools and technologies that enhance data engineering capabilities.
• Provide technical guidance and mentorship to junior data engineering team members.

Requirements

• Bachelor's Degree in Computer Science, Engineering, or a related field.
• Minimum of 5 years of experience as a Data Engineer, with a focus on building and maintaining data pipelines.
• Expertise in database management, SQL servers, and familiarity with Google Data Analytics solutions.
• Proficiency in ETL tools such as SSIS (SQL Server Integration Services) and reporting tools like SSRS (SQL Server Reporting Services).
• Strong knowledge and experience in data integration from multiple sources.
• In-depth understanding of data quality principles and data governance practices.
• Familiarity with Microsoft Navision and SAP S/4 HANA is a plus.
• Strong problem-solving abilities and attention to detail.
• Proven project management skills with the ability to handle multiple projects simultaneously.
• A goal-getter with a proactive attitude, demonstrating ambition and a drive for success.

Method of Application