Position:
Data Analyst (Power BI Specialist)
Experience:
At least 3 years working in a similar role
Salary:
Based on experience
Hours:
Full-time
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.
Data Analyst Role
We are seeking an adaptable and highly skilled Data Analyst with advanced Power BI expertise to join our agency. In this role, you will be the lead architect for the custom Power BI dashboards we offer to our clients.
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.
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.
Skills / Qualities
* Experience: 3+ years of experience in data analytics, business intelligence, or consulting, preferably within an agency or consultancy.
* Power BI Mastery: 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.
* 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.
#J-18808-Ljbffr