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.