At a Glance
- Tasks: Lead the design and delivery of custom dashboards using Power BI for diverse clients.
- Company: Dynamic marketing agency based in Leeds with a collaborative hybrid working culture.
- Benefits: Enjoy free lunches, birthday off, discounted travel, and a supportive Employee Assistance Programme.
- Other info: Join a vibrant team with opportunities for professional growth and development.
- Why this job: Make an impact by transforming data into insights that drive business decisions.
- Qualifications: 3+ years experience in data analysis, advanced Power BI skills, and strong SQL knowledge.
The predicted salary is between 40000 - 45000 € per year.
Location: Leeds
Working Style: Hybrid Working (up to 2 days at home)
Salary: £40,000 - £45,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.
The Role
We’re seeking an experienced, 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
- 3+ years’ 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.
- 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.
Data & Insights Analyst - Power BI in Leeds employer: Marmion
Join a dynamic team in Leeds as a Data & Insights Analyst, where you will thrive in a supportive hybrid working environment that values employee well-being and collaboration. Enjoy a range of benefits including free on-site parking, regular company socials, and opportunities for professional growth while working with cutting-edge data tools like Power BI to drive impactful insights for clients. With a culture that prioritises work-life balance and community engagement, this role offers a meaningful career path in a vibrant city.
StudySmarter Expert Advice🤫
We think this is how you could land Data & Insights Analyst - Power BI in Leeds
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or attend local meetups in Leeds. You never know who might have the inside scoop on job openings or can refer you directly to hiring managers.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and data models. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by practising common questions related to data analysis and Power BI. Be ready to discuss your past projects and how you've tackled challenges, as this will demonstrate your expertise and adaptability.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data & Insights Analyst - Power BI in Leeds
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data & Insights Analyst role. Highlight your Power BI expertise and relevant experience in data analysis, especially in marketing or e-commerce. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for our team. Share specific examples of your past work with Power BI and how you've helped clients make data-driven decisions. Let us know why you want to join StudySmarter!
Show Off Your Projects:If you've worked on any cool projects using Power BI, don’t hesitate to mention them! Include links or descriptions of dashboards you've created. We love seeing real-world applications of your skills, so show us what you've got!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you get all the updates directly from us. Plus, it’s super easy – just follow the prompts!
How to prepare for a job interview at Marmion
✨Know Your Power BI Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with custom dashboard design, DAX functions, and data modelling. Prepare examples of how you've used Power BI to solve real-world problems.
✨Understand the Client's Needs
Research the company and its clients. Think about how you can tailor your approach to meet their specific needs. Be prepared to discuss how you would handle client requirements and scoping during the interview.
✨Show Off Your Communication Skills
Since you'll be presenting dashboards to clients, practice explaining complex data insights in simple terms. Use clear examples from your past experiences to demonstrate your ability to communicate effectively with both technical and non-technical stakeholders.
✨Prepare for Data Quality Questions
Expect questions about data quality assurance and troubleshooting. Be ready to share your strategies for ensuring accurate reporting and how you've handled data issues in the past. This will show your attention to detail and problem-solving skills.
