About the job

Location: Leeds

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

Salary: Up to £40,000 pa DOE

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.

We're searching for a talented Data Analyst with Power BI experience to join our client's established Data Analytics team and support the design and delivery of custom dashboards for clients; working 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.
• Previous experience as a Data & Insights Analyst, Data Analyst, Business Intelligence Analyst, or similar is essential.
• Experience working in a Marketing Agency or Consultancy, or an internal role working with eCommerce data.
• Confident skills & professional experience 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.