How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Position: Data Analyst
Salary: Based on experience
Hours: Full-time
Location: Calverley, Leeds (Hybrid)
About HUB
HUB is an integrated marketing agency based in Leeds. We are a collection of creative and technically skilled individuals, who have all been carefully selected to deliver the talent and enthusiasm needed to successfully deliver quality services for our clients. We’ve been working hard for over 19 years to achieve our vision.
HUB opened its doors in January 2007 as a startup, driven by three passionate individuals with a determination to succeed. Since then, the agency has recruited diverse and skilled individuals who fit with our ethos. These people have helped us grow to become a thriving business.
The company is built on a simple foundation of driving success for our clients, which ultimately means success for HUB. The core of our philosophy is that hard work and great ideas deliver both our vision and that of our clients, creating rewarding careers for talented individuals along the way.
The Role
We are seeking an adaptable and highly skilled Data Analyst with Power BI expertise to join our agency. In this role, you will be supporting with the development of the custom Power BI dashboards we offer to our clients as well as scrutinising the data in an analyst capacity.
Because our clients’ needs vary, you will not be looking at just marketing data. You will ingest, model, and visualize data across multiple business functions—including marketing performance, sales pipelines, e-commerce transactions, inventory/stock levels, and operational metrics. The ideal candidate would be able to connect data from several systems (Big Query database, Google Sheets etc), build scalable data models, and present intuitive dashboards that our clients love to use.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
You will work closely with internal teams and clients to translate business requirements into impactful data visualisations that support strategic decision-making.
Main Duties
- Client Requirements & Scoping: Consult with clients and internal account managers to understand specific business goals, identify key metrics (marketing, sales, inventory, etc.), and scope custom dashboard requirements.
- Custom Power BI Development: Design, build, and maintain interactive, white-labelled Power BI reports tailored to individual client needs. Ensure UI/UX best practices so dashboards are intuitive for non-technical clients.
- Diverse Data Integration: Extract and transform data from a wide variety of client sources, including marketing platforms and custom SQL databases/Excel dumps.
- Data Modelling & DAX: Build robust, scalable relational data models within Power BI. Write advanced DAX formulas to create custom KPIs, time-intelligence metrics, and cross-functional reporting.
- External Sharing & Security: Manage Power BI workspaces, apps, and sharing protocols. Implement Row-Level Security (RLS) to ensure clients only see their own proprietary data.
- Client Presentation & Support: Walk clients through their new dashboards, provide insights on the data, answer technical questions, and iterate on reports based on client feedback.
- Data Quality Assurance: Troubleshoot data connection issues, monitor scheduled refreshes, and ensure the absolute accuracy of the data being presented to clients.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Skills and Qualities
- Experience: 3+ years of experience in data analytics, business intelligence, or consulting, preferably within an agency or consultancy.
- Power BI Skills: Advanced proficiency in Power BI Desktop and Service, including Power Query (M), complex DAX, data modelling, and workspace administration.
- SQL & Database Skills: Strong SQL skills for querying and joining data from various relational databases.
- Excel: Advanced MS Excel skills (pivot tables, VLOOKUP/XLOOKUP, power query).
- Client-Facing Skills: Excellent verbal and written communication skills. Ability to translate highly technical concepts into plain English for clients and stakeholders.
- Adaptability: Proven ability to manage multiple projects simultaneously, pivot quickly between different client requests, and make sense of unstructured or “messy” client data.
Nice to Haves
- Previous experience working in a marketing agency or consultancy.
- Familiarity with cloud data warehouses (e.g., Google BigQuery, Azure).
- Knowledge of Python or R for advanced data manipulation.
- Business Acumen: A strong understanding of general business operations beyond marketing, including sales cycles, supply chain/inventory basics, and financial KPIs.
What We Offer
- Hybrid working (3 days office/2 days optional home working).
- Your birthday off work.
- Free parking.
- Regular free lunches and quarterly social events.
- Employee Assistance Programme (EAP).
- Access to discounted holiday travel booking.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location