About the Role 

• Develop, build, and maintain data ingestion pipelines and storage facilities to underpin the delivery of the PROOF Analytics platform
• Manage and merge internal & external data sources, and prepare this data for analytical processing and data visualisation
• To deliver on performance targets for PROOF Insight as a key component of the PROOF’s Data & Analytics Team

Key Accountabilities 

• Translate business needs to technical specifications
• Maintain and support data visualisation and analytics platforms (specifically Looker, but also PowerBI)
• Create tools to store and enable access to data (e.g. OLAP cubes)
• Collaborate with internal & external data teams to integrate systems
• Develop and update technical documentation
• Work with external stakeholders to enable automation acquisition/delivery of data in a secure and automated way
• Ensure change control processes are in place and adhered to
• Develop and execute ad hoc data queries upon request
• Conduct unit testing and troubleshooting
• Develop, manage, and test back‐up and recovery plans
• Database tuning, optimisation, maintenance plans, and security
• Data will be captured, modelled, and validated across the businesses to ensure the very best information & intelligence is delivered to key stakeholders
• Working with the team, the Senior Data Engineer will ensure that end users have access to the appropriate secure, automated data feeds to enable the production of richly visualised dashboards for both internal and external stakeholders
• In addition to this the Senior Data Engineer will work with the wider Data and Analytics Team, Commercial Finance, IT, and external data partners to ensure all data, rules, and logic are up to date, follow best practice principals, and are fully documented to ensure consistent accurate reporting of transactional data

About you 

• Expertise in Google Cloud Platform (GCP) technology stack including Storage Buckets, BigQuery, Airflow Composer, Vertex AI, Looker
• Expertise in SQL Server Integration Services (SSIS)
• Expertise in solution architecture, analysis, and development
• Expertise in dimensional modelling and data marts (Kimball methodologies)
• Expertise in data analysis and data management including data quality checking and data audits
• Expertise in transactional and real‐time database design, development, and maintenance of database applications on SQL Server in High Volume OLTP/OLAP/BI environment
• Expertise in Python, specifically around ETL, data analysis, and visualisation (e.g. pandas, numpy)
• Expertise in collaborative code writing and distributed version control (GIT, Azure DevOps)
• Experience implementing and supporting data visualisation platforms such as Looker, Power BI, Tableau, etc
• Experience with SQL Server Reporting Services (SSRS)
• Experience in developing and maintaining SQL Server Analysis Services (SSAS) cubes (multidimensional and tabular)
• Experience in SQL Server 2012/2016 (configuration, agent scheduler, security)
• Experience in performance tuning and handling performance issues with I/O, CPU & Memory
• Experience in creating rich visualisations in Looker

Please see attached full job description and person specification

About Us 

Operating through the Matthew Clark, Bibendum, Tennent’s and Bulmers Ireland brands, the Group has a market leading range, scale and reach including an intimate understanding of the markets it serves.  

Together we grow, brew, manufacture, market, and deliver some of the world’s favourite drinks. From grass to glass, and everything in between. C&C Group plc is a premium drinks company which owns, manufactures, markets, and distributes a unique portfolio of beer and cider brands in its home markets and across the globe. 

C&C Group’s portfolio of owned/exclusive brands include: Bulmers, the leading Irish cider brand; Tennent’s, the leading Scottish beer brand; Magners the premium international cider brand; as well as a range of fast-growing, premium and craft ciders and beers, such as Heverlee, Menabrea, Five Lamps and Orchard Pig.  

We seek to champion and embed sustainability in everything that we do at C&C. While delivering joy to customers, we always shine a light on people and the planet. We have a clear ESG vision delivering to a better world. We respect, support, and develop all our people to be their best, with a focus on results by creating a culture of winning together. 

We also recognize that people come with a wealth of experience and talent beyond just the technical requirements of a job. If your experience is close to what you see listed here, please still consider applying. Diversity of experience and skills combined with passion is a key to delivering on our mission. Therefore, we encourage people from all backgrounds to apply. Please let us know if you require accommodations during the interview process. 

C&C Group (and inclusive companies) do not accept unsolicited CVs from recruiters or employment agencies in response to any of our roles. For help, please contact our Talent Acquisition Team at careers@candcgroup.com. All applications need to come through the candidate portal https://careers.candcgroupplc.com/vacancies/