SENIOR DATA ANALYST (POWER BI) - London

At CluePoints, we’re redefining how clinical trials are run. As the premier provider of Risk-Based Quality Management (RBQM) and Data Quality Oversight software, we harness advanced statistics, artificial intelligence, and machine learning to ensure the quality, accuracy, and integrity of clinical trial data, helping life sciences organizations bring safer, more effective treatments to patients faster. We’re proud to be an ambitious, fast-growing technology scale-up with a dynamic and diverse international team representing more than 20 nationalities. Collaboration, flexibility, and continuous learning are part of our DNA. At CluePoints, you’ll find a culture where you can grow, make an impact, and have fun along the way. Guided by our values of Care, Passion, and Smart Disruption, we’re united by a shared mission: to create smarter ways to run efficient clinical trials and deliver AI-powered insights that improve human outcomes worldwide. CluePoints provides best-in-class statistical and AI-driven software solutions to enable the Life Sciences industry to focus on what matters most. Our products enable both risk planning and operational risk monitoring and utilize advanced statistical algorithms to determine the quality of clinical trial data both during and following study execution.    The Role We are looking for a Senior Data Analyst with deep Power BI expertise who will act as the technical owner of our Power BI reporting landscape. This role is primarily focused on Power BI development, semantic modelling, performance optimization, and governance, while also supporting ad hoc analytical initiatives when needed. This person will have to be able to spend a few days per week in the London office.  You will work closely with Data Engineering, fellow Data Analysts, and business stakeholders across the organization to design scalable, high-performing, and trusted BI solutions that enable data-driven decision-making.   Experience * 5+ years of experience in Data  Analytics / Business Intelligence roles. * Proven experience designing and delivering Power BI solutions in a production environment. * Experience in SaaS or similar fast-paced, data-driven environments is strongly preferred.   Technical Skills * Advanced Power BI expertise: * Strong data modeling skills (star schema, dimensional modeling, relationships, granularity management). * Advanced DAX for complex calculations and performance tuning. * Advanced SQL skills: * Writing complex queries for data extraction, transformation, validation, and performance optimization. * Experience working with enterprise data warehouses, including: * Medallion architecture (Bronze/Silver/Gold layers). * Kimball dimensional modeling methodology. * Strong understanding of BI performance optimization techniques (model design, aggregation,      incremental refresh, efficient measures).   Analytical & Soft Skills * Strong analytical and  problem-solving mindset with the ability to troubleshoot data and      reporting issues. * Excellent stakeholder management  and communication skills, with the ability to explain complex insights in      clear, business-friendly language. * Ability to manage multiple  priorities and deliver high-quality outputs within deadlines. * Strong documentation and organizational discipline.   GOOD TO HAVE: * Experience with Microsoft Fabric (including Lakehouse, Warehouse, Direct Lake, Dataflows Gen2) as we may      transition towards Fabric in the future. * Experience with cloud data platforms such as Azure, AWS, or Google Cloud. * Familiarity with Power BI deployment pipelines and enterprise governance setups. * Knowledge of advanced visualization and dashboard UX best practices. * Exposure to predictive analytics or  data science workflows. * Experience with scripting languages such as Python or R for automation, advanced analysis, or API      integrations. * Relevant certifications such as: * Microsoft Certified: Power BI Data Analyst Associate * Microsoft Certified: Fabric Analytics Engineer Associate * Other BI or analytics-related certifications   Our current data stack is built on a Medallion-based Enterprise Data Warehouse implemented in Azure SQL, following Kimball dimensional modeling principles. On top of this foundation, we maintain a mature and business-critical Power BI environment comprising 50+ production-grade reports and semantic models used across the organization. This role offers the opportunity to further strengthen and scale a well-established BI ecosystem within a growing, innovation-driven company operating in the e-clinical space, contributing directly to data-driven excellence in clinical research Power BI Development & Ownership   * Design, develop, and maintain enterprise-grade Power BI solutions, including semantic models (datasets), reports, and dashboards. * Build scalable and optimized data models following best practices  (star schema, Kimball methodology, proper relationships, reusable measures). * Develop advanced DAX measures and calculations to support complex  business logic. * Use Power Query (M) for efficient data transformation and shaping. * Ensure performance optimization of reports and datasets (model size control, query folding, measure optimization, incremental refresh where  applicable). * Manage deployment processes across environments (e.g., Dev/Test/Prod) and promote version control and structured release practices.   Data Modeling & Architecture Collaboration   * Partner closely with the Senior Data Engineer to ensure data is structured according to BI best practices (medallion architecture, curated      layers, dimensional modeling). * Contribute to defining and maintaining a scalable semantic layer  that enables self-service analytics while maintaining consistency. * Support data architecture decisions from a reporting and analytics  perspective.   Data Quality & Governance   * Validate and reconcile data using SQL and other tools to ensure accuracy and consistency across reporting assets. * Implement and uphold governance standards in Power BI (naming conventions, documentation, workspace organization, certified datasets,  access control). * Ensure reports are aligned with data governance policies and security requirements (e.g., row-level security where needed).   Business Engagement & Insight Delivery   * Translate business requirements into robust, intuitive, and  scalable BI solutions. * Partner with Finance, HR, Professional Services, R&D, and other teams to understand reporting needs and define KPIs. * Deliver actionable insights through well-designed dashboards that follow modern data visualization best practices. * Support ad hoc analysis and deep dives to answer strategic or  operational questions.   Performance & Continuous Improvement * Optimize SQL queries and data retrieval processes to ensure high  performance and reliability. * Proactively identify opportunities to improve existing dashboards,  models, and reporting processes. * Stay up to date with evolving Power BI capabilities and BI best  practices. 🇬🇧 What We Offer – United Kingdom * Private Medical Insurance through Vitality Health (full hospital cover, 24/7 GP, and therapy sessions) * Group Critical Illness Cover with Aviva * Life Insurance (death-in-service lump sum) * Pension Scheme with 9% employer contribution via Scottish Widows * Opportunities for professional development and sponsored certifications * A hub-based hybrid model that blends flexibility with purpose — connecting teams through collaboration, learning, and a vibrant social culture. 🇬🇧 Equal Opportunities & Data Protection StatementCluePoints is an equal opportunities employer. We celebrate diversity and are committed to creating an inclusive environment for all employees and applicants.   We welcome applications from all individuals regardless of age, disability, gender identity or expression, marital or civil partnership status, pregnancy or maternity, race, religion or belief, sex, or sexual orientation. Any personal data you share during your application will be processed in accordance with the UK GDPR and the Data Protection Act 2018 and will be used solely for recruitment purposes.  By submitting your application, you consent to the processing of your data for recruitment and employment purposes.   🌐 At CluePoints, we believe that diverse teams make better decisions and drive innovation. We’re committed to building a workplace that reflects the communities we serve and where everyone can thrive.