Junior Marketing Analyst - Colart UK

This is an exciting opportunity for a Junior Marketing Analyst to contribute to the marketing efforts of a company within the retail industry. The role involves analysing data, creating reports, and supporting the marketing team to optimise campaigns and strategies.

Client Details

The employer is a well-established organisation within the retail industry, known for its commitment to delivering high-quality products and services. Operating as part of a collaborative team, the company offers a supportive environment for individuals looking to develop their skills in marketing and data analysis.

Description

• Collaborate with the BI team to ensure the accuracy and suitability of data integration for analysis.
• Build and maintain Power BI dashboards and reports, including data modelling and DAX calculations.
• Connect, clean, and transform data from multiple sources using Power Query, SQL, and API connections.
• Build insightful data visualisations and dashboards for KPI tracking and campaign analysis.
• Optimise report performance and manage data refresh schedules.
• Conduct analysis on key sales data, including Epos, price, and promotions to identify trends and opportunities.
• Translate business questions into clear, actionable insights and visual stories.
• Train non-technical stakeholders on reporting tools and complex data insights.
• Support the Group Marketing Director in managing insight projects where applicable.

Profile

• A strong foundation in marketing principles and data analysis.
• Proven experience building and maintaining Power BI dashboards end-to-end.
• Working knowledge of SQL for data extraction and transformation.
• Experience integrating and managing data from multiple sources.
• Proficiency with Power Query and DAX.
• Strong understanding of data modelling principles and performance optimisation.
• Excellent analytical and problem-solving skills, with attention to detail.
• Ability to communicate complex data insights clearly and effectively.
• Experience in data analysis, ideally within the FMCG or consumer goods sector.

Job Offer

• Competitive salary up to £38K per annum.
• Permanent position within the retail industry.
• Working in modern White City offices in London
• High flexibility with 3 work from home days/ week
• Opportunities for professional growth and development.
• Supportive and collaborative company culture.
• Access to company resources and tools to succeed in the role.
• Huge career growth potential with strong cross-specialty collaboration encouraged.