{bc}
linkedin

Data Analyst

Gravity Media
Watford, GBR
Full-time
Mid-Senior
Onsite
Discovered Yesterday
SQLPower BIMicrosoft ExcelData analysisData modellingData cleaning and validation

Full Job Posting

Role overview

Data Analyst in the Assets & Data team within the global Media Services function, reporting to the Head of Assets & Data.

The role supports better use of business data, especially for S&OP, asset management, and resource planning across the Group.

What you'll be responsible for

  • Write and maintain SQL queries to prepare Group business-system data for analysis and reporting.
  • Build and maintain Power BI reports and dashboards for asset utilization, demand, availability, and performance.
  • Analyze asset, resource, and demand-planning data to identify trends, capacity issues, under-utilization, and efficiency or cost opportunities.
  • Work with business teams to understand their questions and deliver useful analysis and reporting.
  • Check and reconcile data, investigate anomalies, and work with data owners to resolve issues.
  • Support consistent data definitions, standards, and quality checks for asset and master data.
  • Document reports, dashboards, calculations, and recurring analysis.
  • Work with IT on reporting needs involving systems, data access, or integrations; IT retains responsibility for architecture, security, access controls, and technical infrastructure.
  • Highlight gaps, inconsistencies, or unclear data ownership in operational systems.
  • Provide regular and ad hoc analysis for S&OP, asset planning, investment decisions, business cases, and improvement activities.
  • Improve reporting through automation and appropriate AI use, checking outputs and protecting company data.
  • Follow company policies, information-security requirements, and relevant processes and controls.

Requirements

  • Relevant degree, professional qualification, or equivalent practical experience, plus at least 2 years in a data analyst, BI analyst, or similar role.
  • Strong SQL skills for querying, combining, and manipulating data.
  • Experience building and maintaining Power BI dashboards and reports, with knowledge of data modelling, measures, and clear presentation.
  • Advanced Excel skills, including pivot tables, lookups, formulas, and larger datasets.
  • Experience cleaning and checking data, including duplicates, missing information, and inconsistencies.
  • Understanding of databases and data structures sufficient to work with IT and system specialists.
  • Strong analytical and problem-solving skills; able to interpret data and explain findings clearly.
  • Able to understand stakeholder information needs and communicate with non-specialists.
  • Attention to detail and practical organization of reports, calculations, and documentation.
  • Commercial awareness of asset utilization, demand, capacity, and investment decisions.
  • Comfort using AI and productivity tools where useful, checking outputs and following data-security requirements.
  • Able to manage priorities, work across teams and countries, and respond calmly to time-sensitive work.

General responsibilities

Take an active part in improving team and wider business practices.

The job description covers main responsibilities and may change as the business and team develop.

Right to work

  • Applicants must have full right to work in the UK; the employer cannot provide sponsorship.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Gravity Media