Max Smith Email & Phone Number

London, Gb

London Area, United Kingdom

Working with Director of D&T and Managing Director to set out the strategic direction for Data & Analytics at Beavertown over the next three years. Leading on Data Management, including Data governance, Data quality and the design, transformation and modelling of data within our storage layer. Shaping future data capability through developing the departmental data analyst and reporter community as well as leading on advanced analytics projects.

London

Providing ad hoc and regular data analysis upon request to answer specific business questions for stakeholders in Production, Logistics, Commercial and Finance departments. This usually involves writing SQL to query our SAP B1 database and then creating reports or dashboards in Excel. More recently, I have been leading on rolling out ZAP Data Hub (our business intelligence tool) to Operations departments. This involves consulting stakeholders on requirements, mapping and modelling… Show more Providing ad hoc and regular data analysis upon request to answer specific business questions for stakeholders in Production, Logistics, Commercial and Finance departments. This usually involves writing SQL to query our SAP B1 database and then creating reports or dashboards in Excel. More recently, I have been leading on rolling out ZAP Data Hub (our business intelligence tool) to Operations departments. This involves consulting stakeholders on requirements, mapping and modelling disparate source tables, building pipelines, relationships and measures.Designing end to end Supply Chain planning tools including 18 month and 13 week demand , supply and materials planning tools. This involved working closely with stakeholders to understand their requirements and creating a flexible solution that worked across Excel and ZAP Business intelligence platforms.Helping to increase data governance within the company by embedding and maintaining a report catalogue, database schema and glossary for measures and KPIs for all operational data. Owner of master data including Item Master, Bill of Materials, Brand Master, Pack Type and Item Templates.Line managing the Junior Data Analyst. This is an entry level role. Responsible for day-to-day performance management as well as guiding their ongoing personal development at Beavertown.Technical skill set includes advanced Excel (Power Query, Power Pivot, VBA), SQL, ZAP ETL data warehouse and Business Intelligence tool. I am also learning Python for Data Analysis. Show less

London

Identifying opportunities to enhance current Data Analytics capabilities. Identify how new data capture or new data reports can solve business problems or improve efficiency. This may include GAP analysis, where I defined ‘as is’ and ‘to be’ business processes.Defining how data should be entered into SAP and capturing this by writing and maintaining Standard Operating Procedure (SOPs).Writing SQL queries to pull data out of SAP B1 and deliver insights to Operations users. For… Show more Identifying opportunities to enhance current Data Analytics capabilities. Identify how new data capture or new data reports can solve business problems or improve efficiency. This may include GAP analysis, where I defined ‘as is’ and ‘to be’ business processes.Defining how data should be entered into SAP and capturing this by writing and maintaining Standard Operating Procedure (SOPs).Writing SQL queries to pull data out of SAP B1 and deliver insights to Operations users. For example, a report on production yield at contractor sites assisted the Technical Brewing Manager in working with contractor sites to improve efficiency and bring down cost per litre.Writing SQL queries to catch incorrect data entry to SAP B1 and scheduling them to run at certain times of day and deliver in-app notifications for end users. This automation meant I did not need to run the alerts manually and email users each morning. Show less

London, United Kingdom

Working with senior management to identify measurable KPIs and reporting on these through dashboards in Google Sheets using Google Query to bring together data from accounting, sales and production teams.Project managed the implementation of Unleashed, an inventory management system. This involved worked alongside teams to learn their processes, mapping out data capture, developing SOPs and training all users.Ad hoc analysis and presentations to senior management and board… Show more Working with senior management to identify measurable KPIs and reporting on these through dashboards in Google Sheets using Google Query to bring together data from accounting, sales and production teams.Project managed the implementation of Unleashed, an inventory management system. This involved worked alongside teams to learn their processes, mapping out data capture, developing SOPs and training all users.Ad hoc analysis and presentations to senior management and board requiring excellent communication skills – translating detail and data into actionable insight. Show less

London

Leading on research reports. Examples included regular market updates on national, regional newspapers, magazines, classified advertising.Strategic consulting projects on digital transition for print publishers, in some cases presenting these findings to strategy directors at client companies.

London

Responsible for maintaining, updating and cleaning all press industry data in Excel (from NRS, ABC, comScore, Nielsen, Companies House, Omniture).Manipulating, analysing and illustrating data through charts in PowerPoint to reveal client / market insights. This work often conducted at pace to meet client deadlines.

First Class Ba, English Literature

Creative And Life Writing Ma, Distinction