Data Analytics & Insights Specialist - Power BI

Location: Leeds

Working Style: Hybrid Working (up to 2 days at home)

Salary: £40,000pa

Benefits: Employee Assistance Programme (EAP) | Free On-site Parking | Regular Free Lunches & Company Socials | Birthday off work | Access to discounted holiday travel booking and dining

Due to the nature of our roles, candidates must be a UK resident residing within commutable distance to Leeds. Please note that we cannot offer visa sponsorship for overseas candidates.

The Role:

We’re seeking an adaptable & confident Data Analyst with advanced Power BI expertise to lead the design and delivery of custom dashboards for clients. You’ll work with data across marketing, sales, e-commerce, inventory, and operations - connecting sources such as BigQuery and Google Sheets, building scalable data models, and creating intuitive, insight-driven dashboards that support business decision-making.

Roles & Responsibilities:

• Client Requirements & Scoping: Work with clients and account managers to define goals, key metrics, and dashboard requirements.
• Custom Power BI Development: Design, build, and maintain white-labelled Power BI reports tailored to client needs, with intuitive UX for non-technical users.
• Diverse Data Integration: Extract and transform data from a range of client sources, including marketing platforms, SQL databases, and Excel files.
• Data Modelling & DAX: Build scalable data models in Power BI and use advanced DAX to create KPIs, time-based metrics, and cross-functional reports.
• External Sharing & Security: Manage Power BI workspaces, apps, and sharing, including Row-Level Security to protect client data.
• Client Presentation & Support: Present dashboards to clients, explain insights, answer questions, and refine reports based on feedback.
• Data Quality Assurance: Troubleshoot data issues, monitor refreshes, and ensure the accuracy of client reporting.

Skills & Experience:

• Please note that we cannot offer visa sponsorship for overseas candidates.
• Solid experience as a Data Analytics & Insights Specialist, Business Intelligence Analyst, or similar is essential.
• Experience working within a Marketing Agency or Consultancy, or an internal role working with eCommerce data would be preferred.
• Advanced skills in Power BI Desktop and Service, including Power Query (M), complex DAX, data modelling, and workspace administration.
• Confident communicating with both internal and external stakeholders, with excellent verbal and written communication skills.
• Strong SQL skills for querying and joining data from various relational databases.
• Advanced MS Excel skills, including pivot tables, VLOOKUP/XLOOKUP, and Power Query.
• Great attention to detail, with the ability to manage multiple projects at once, pivot between different client requests, and make sense of unstructured client data.
• Familiarity with cloud data warehouses and knowledge of Python or R would be desirable.

If you feel you are suitable, please apply today by submitting your CV. If you would like to discuss this opportunity further, please contact Alice McGlaughlin.

For more on Marmion, check out our 5* reviews on Trustpilot & Google.

Thank you for your interest. We carefully review every CV and will contact shortlisted applicants by phone or email. If you don’t hear from us within 5 working days, unfortunately your application hasn’t been successful on this occasion.