Marketing Data Analyst

About UsAt IronmongeryDirect, we've been a trusted name in architectural ironmongery for over 50 years. What started as a traditional ironmongery shop has since grown into the UK's leading direct supplier, delivering thousands of parcels each week. With a vast range of over 18,000 high-quality products available for next-day delivery, we're the reliable choice for tradespeople who value efficiency, expert advice, and top-tier service.Our Marketing Team is a vibrant, fast-paced group that loves to challenge the status quo while supporting each other every step of the way. If you're someone who enjoys diving into data, uncovering insights, and influencing strategy-all while being part of a fun, friendly, and sociable work environment-this is the role for you!About the RoleWe are seeking an experienced Data Analyst to support the Marketing Team by leveraging data to execute campaigns, generate insights, and drive marketing strategies. This role is perfect for a detail-oriented problem-solver who can work independently while keeping a finger on the pulse of our marketing campaigns.We offer a hybrid working model, with two days in the office and three from home, giving you the flexibility to work in a way that suits you. Most importantly, you'll be part of a dynamic and collaborative culture where your impact truly matters.Key Responsibilities:Data Analysis & Insights: Collect, analyse, and interpret large volumes of customer data using SQL, Excel/Power Query, and PowerBI to gain actionable insights.Performance Tracking: Evaluate marketing activities across multiple channels, analysing metrics such as ROI, conversion rates, AOV, and LTV.Data Interpretation: Identify trends and make recommendations to optimize marketing campaigns and identify more profitable channels.Customer Journey Analysis: Monitor customer touchpoints and measure the effectiveness of communications.Dashboard & Report Creation: Build PowerBI dashboards, Excel reports, and PowerPoint presentations with charts and graphs for data visualization and stakeholder communication.Data Management: Manage customer data files for marketing campaigns using models like RFM (Recency, Frequency, Monetary value).Marketing Reports Ownership: Develop, automate, and maintain essential business and marketing reports while handling ad-hoc analytic requests.Financial Modelling: Collaborate with Finance and Data teams to support business reporting and ensure data consistency. Key Skills & Experience:Proficient in marketing research and statistical analysis. Strong analytical skills with a high degree of business acumen.Advanced Excel, Power Query, and Google Sheets proficiency.SQL expertise: Ability to create stored procedures, understand/amend complex SQL scripts, and manipulate datasets.Experience with marketing analytics tools such as Google Analytics (GA).Knowledge of programming languages such as PowerBI (DAX formulas), Python, or VBA.Excellent organizational, communication, and presentation skills.Ability to manage multiple projects with attention to detail and accuracy. What We Offer:25 days annual leave plus public bank holidays.Hybrid working arrangements.40 hours of training & development investment per employee annually.Private healthcare (subsidised) for employees and their families.Health & Wellbeing support via Health Shield, including claim-back medical costs, EAP services, GP Anytime, and the Thrive wellbeing app.Discretional annual company performance bonus.Bi-monthly WOW awards for outstanding contributions.Staff discounts on our extensive product range.Long service awards.Two paid volunteer days per year.£500 refer-a-friend incentive scheme. If you're a data-driven professional looking to make an impact in a dynamic marketing environment, apply today to join our team