Data Architect and Reporting Analyst

Brief: This is a role that combines aspects of Data Architecture and Data Analyst together which will drive technical innovation with our use of data across the business, enabling new products and running/contributing to data-related projects. Owing all aspects of integrating data from multiple sources and making it available for use by analysts - designing and building databases, automating data-processes, using SQL whilst providing client reporting alongside the Reporting team.

Responsibilities

• Design, build and maintain databases that integrate the following types of data:

o Retailer sales data (usually provided weekly in CSV format)

o Field marketing activity data (gathered by our field teams using our in-house software and held in an SQL database)

o Store location database (also SQL)

o Product data, e.g. screen-size for TV products (sourced online)

• Reporting: produce dynamic and interactive dashboards for clients, analysing impact and ROI of marketing activities.
• Support technical innovation within the Insight and Reporting Department; e.g. integrate new data sources and information into our reporting; identify new opportunities for RMG Insight using data.
• Take responsibility for how the business can access and interact with data and databases; work with other departments to map out their use of data and automating their data-flow processes.
• Data development: be the focal point for research into new data technologies and drive product development in this area (e.g. conduct proof of concept projects for new solutions).
• Skills & Experience
• SQL databases: design, build, maintenance, data extraction, data-flow processes.
• Familiarity with Microsoft SQL Server Management Studio & Microsoft SQL Business Intelligence Development Studio.
• Advanced Excel, with experience of solving automation problems using VBA.
• Familiarity with PowerPivot / Excel cube solutions, and with other BI tools, e.g. Tableau.
• Strong analytical and dashboarding skills.
• Here at Retail Marketing Group we specialise in representing Consumer Electronics, IT and Telecommunications brands assisting our client partners through field marketing, insights and intelligence to grow awareness of their brand and sales of their devices. We are like no other agency out there because we are passionate about our brand, about our service and, most importantly, about our people.

Why work for us?

• We care about you, your development and most importantly your happiness!
• Work for the Best Company to work for in Thames Valley alongside passionate people, you will have autonomy to make decisions that really make a difference on our great culture and globally recognised service delivery.
• We offer some great rewards including:
• Increasing holiday allowance
• Health care
• Pension
• Childcare vouchers Computing scheme
• Cycle to work scheme and flexible working
• Fun and welcoming environment to work in with free breakfasts
• Company Parties, Client discounts on consumer electronics and much more!!!