Purpose of the Role: To be a key support to the Analytics Team. This team is responsible for developing and implementing value driving sourcing mechanisms to support our account team’s multi-million-pound print spend. These sourcing mechanisms include development of various bespoke tool, building data and reports using BI tools (like DOMO, Power Query, etc.). Data is the window into strategic sourcing and this role requires an analytical yet creative thinker. The data supplied into business can take many different forms; it is important to have the ability to adapt to meet the varied goals.Activities to be Performed:Monthly Reporting / Dashboard Maintenance:The collation and processing of Business MI dataRunning of DOMO/DiSS Reports for circulation within the teamVarious Dashboard ReportingOne off Jobs:Support for new business tenders, when large amt. of data needs manual intervention.Pricing exercise: Some print knowledge would be advantage. The translation of a client supplied data set can be transposed into table format to allow pricing to take place.Building of Excel models to calculate pricing from predetermined rate cards. Support Activities / Admin Tasks:Pricing data capture – Using a central email inboxSpecification site input complianceDatabase Builds and MaintenanceExcel / Access / MS Outlook VBA codingBuilding of workflow toolsAdvanced Data Managing Tool (like Power Query, Power BI, etc.)ESSENTIAL SKILLS:Must be advanced level skilled in the use of Microsoft Excel and Microsoft Access along with the ability to understand and manipulate VBA codingData analysis and management reportingStrong Math’s and Statistics skillsMust have knowledge in Power QueryBe strong at Planning and organizing multiple pieces of information into a coherent structureOrganized have the skill to work on more than one task at a time.Knowledge of SQLMust be familiar with any BI Tool (DOMO, Tableau, Power BI, etc.)LOCATIONWe currently work in a remote hybrid model with offices in Chennai and Bangalore.TIMINGSWe work on rotational shifts that change depending on the region you are working with and at the discretion of your line manager.
Job Title
Data Analyst