Data Engineer at Seven Up Bottling Company

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