About the role:
The successful candidate will design and maintain Power BI semantic models built on top of the Gold layer, ensuring all reporting is consistent, performant, and certified for organisational use. They will also prepare curated, structured datasets optimised for use with Microsoft Fabric data agents, Copilot experiences, and other AI-driven capabilities.
This role requires expertise in Power BI report design, data modelling, and DAX, along with the ability to analyse structured and unstructured data using Microsoft Fabric and related technologies. The analyst will work closely with internal business teams, data engineers, and platform experts to deliver high-quality analytics, reporting, and data models that drive intelligent business solutions.
Responsibilities:
Own and maintain the Gold layer within the organisation’s Medallion Architecture, ensuring it provides clean, trusted, business-ready data for enterprise reporting.
Design, develop, and maintain Power BI reports and semantic models using Power BI and Microsoft Fabric analytics tools.
Write DAX calculations for KPIs, time intelligence, advanced metrics, and custom business logic.
Conduct exploratory and statistical analysis on structured and unstructured datasets to identify trends, patterns, and opportunities.
Partner with Data Engineers to ensure Bronze and Silver layers are well-structured and optimised for downstream consumption.
Build and maintain Fabric semantic models, dataflows, and transformations that support reporting and the Gold dataset layer.
Translate business requirements into analytical specifications, KPIs, and measurable outcomes.
Prepare high-quality curated datasets optimised for Fabric data agents and other AI-driven experiences.
Communicate analytical findings clearly to both technical and non-technical stakeholders through storytelling, visualisation, and documentation.
Support the development of Copilot-driven insights by preparing trustworthy datasets and metadata.
Ensure all analytical solutions adhere to data governance, security, and compliance standards.
Requirements:
Proven expertise in data analysis, business intelligence, or analytics roles.
Experience working within a Medallion Architecture, ideally with direct responsibility for Gold layer curation.
Expertise in Power BI, including:
Intermediate DAX
Star schema modelling and semantic model design
Report UX/UI best practices
Performance optimisation
Hands-on experience with Microsoft Fabric features such as Lakehouse, Data Warehouse, dataflows, and semantic models.
SQL skills for data exploration, transformation, and quality assurance.
Experience analysing both structured and unstructured data sources.
Ability to translate business questions into measurable insights.
Strong communication skills, including the ability to simplify complex analytical concepts for business stakeholders.
Desirable
Knowledge of Python for analytical scripting, data manipulation, and advanced statistical techniques.
Familiarity with AI-enhanced analytics tools such as Copilot, AI Foundry, or Fabric-based AI services.
Understanding of data governance, metadata management, and data quality best practices.
Experience with statistical modelling, forecasting, or machine learning techniques.
Relevant Microsoft certifications (Power BI, Fabric, or Data Analyst Associate).
Work in a way that works for you: We promote a healthy work/life balance across the organisation. We offer an appealing working prospect for our people. With numerous wellbeing initiatives, shared parental leave, study assistance and sabbaticals, we will help you meet your immediate responsibilities and your long-term goals.
Working for you: We know that your wellbeing and happiness are key to a long and successful career. These are some of the benefits we are delighted to offer:
Generous holiday allowance with the option to buy additional days
Health screening, eye care vouchers and private medical benefits
Wellbeing programs
Life assurance
Access to a competitive contributory pension scheme
Save As You Earn share option scheme
Travel Season ticket loan
Electric Vehicle Scheme
Optional Dental Insurance
Maternity, paternity and shared parental leave
Employee Assistance Programme
Access to emergency care for both the elderly and children
RECARES days, giving you time to support the charities and causes that matter to you
Access to employee resource groups with dedicated time to volunteer
Access to extensive learning and development resources
Access to employee discounts scheme via Perks at Work
About the Business: RELX is a global provider of information-based analytics and decision tools for professional and business customers.
RELX serves customers in more than 180 countries and has offices in about 40 countries. It employs more than 36,000 people over 40% of whom are in North America. The headquarters is in London. The market capitalization is about £60bn ($80bn), making it one of the 10 largest listed companies in the UK. The company is listed on the London Stock Exchange, Euronext and NYSE.
The company has four market segments. It develops information-based analytics and decision tools for professional and business customers in the Risk, Scientific, Technical & Medical, Legal, and Exhibitions sectors.
We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form or please contact 1-855-833-5120.
Criminals may pose as recruiters asking for money or personal information. We never request money or banking details from job applicants. Learn more about spotting and avoiding scams here.
Please read our Candidate Privacy Policy.
We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law.
USA Job Seekers: