Description
We are seeking a Power BI Developer to help build and scale enterprise Trial Analytics across a global clinical trial portfolio. This role sits within the business (Project Finance & Analytics) and partners closely with Data Engineering and Corporate IT to deliver decision-ready insights for clinical operations, finance, and executive leadership. The ideal candidate blends strong technical BI capabilities with an ability to work closely with clinical operations, project finance, and project management stakeholders to deliver actionable insights.
This position works at the center of operational and financial transparency—supporting CTMS‑derived trial metrics, ERP‑based financial performance, and cross‑functional KPI reporting. The focus of this role is semantic modeling, KPI standardization, and analytics performance, not source system ingestion or ad hoc report building.
Business Analysis & Collaboration
- Work closely with Trial Operations, Project Finance, and Project Managers to gather reporting requirements and translate them into technical solutions
- Serve as the subject‑matter expert on metric definitions, business rules, and reporting logic
- Provide insights and recommendations based on trend visualization and dashboard usage
Power BI & Semantic Modeling
- Design, build, and maintain Power BI semantic models, including DAX measures, KPIs, hierarchies, and table relationships
- Build reusable, governed DAX measures aligned to approved KPI definitions
- Implement calculation groups, time intelligence, and standardized metric logic
- Optimize data models for performance, scalability, and refresh efficiency
- Ensure all metrics reflect correct business logic, including enrollment rules, milestone definitions, revenue calculations, and project financial structures
Trial & Portfolio Analytics
- Translate business-defined KPIs into scalable analytical logic
- Support analytics across:
- Trial execution & delivery
- Portfolio health and risk
- Financial performance and margin
- Milestones, enrollment, and operational cadence
- Ensure metrics roll consistently from trial → program → portfolio
Governance & Collaboration
- Partner with Data Engineering to ensure analytics-ready data structures and consistent grain, validate dataset readiness, and report on data discrepancies
- Align with Corporate IT / Data Warehouse teams on data contracts and refresh schedules
- Validate metrics with Finance, Clinical Operations, and Business Operations stakeholders
- Document datasets, measures, and assumptions for transparency and reuse
- Implement and maintain row-level security (RLS), workspace permissions, and dataset access controls
- Manage versioning, QA testing, and deployment of dashboards across environments
- Ensure alignment with internal data governance and compliance standards
Enablement & Scale
- Develop certified datasets to enable self-service analytics across the organization
- Reduce ad hoc reporting by standardizing core analytics views
- Contribute to analytics standards and best practices across the business
- Provide training, documentation, and support to functional teams using Power BI dashboards
- Promote BI best practices across teams and encourage responsible data consumption
What This Role Is Not
- Not responsible for ETL or source system ingestion
- Not a report factory for one-off trial requests
Required Qualifications
- Bachelor’s degree in Data Analytics, Information Systems, Business Intelligence, Finance, or related field (or equivalent hands‑on experience)
- 3-5 years of experience developing enterprise Power BI solutions
- Strong expertise in:
- DAX, including complex measures and time intelligence
- Power BI semantic modeling
- Power Query (M) for light transformations
- SQL (for validation and analysis)
- Strong experience with data modeling (star schema, grain management)
- Experience building analytics for executive and operational audiences
- Experience working with operational or financial datasets
- Ability to translate business logic into clear analytical models
- Knowledge of data visualization best practices and optimization techniques
Preferred Qualifications
- Experience in clinical trials, CROs, or life sciences and with clinical trial operations datasets (CTMS, enrollment tracking, subject visit structures)
- Exposure to financial or operational analytics, including ERP financial datasets (actuals, budgets, revenue recognition, WIP, invoicing)
- Experience working with centralized data warehouse teams
- Familiarity with Power BI performance tuning and capacity considerations
- Familiarity with Azure data tools and the Power BI Service (workspaces, gateways, datasets)
- Experience working within professional services, life sciences, or project‑based environments
Key Competencies
- Strong analytical judgment and attention to detail
- Comfortable working in ambiguous, fast-moving environments
- Ability to translate business questions into scalable analytical solutions
- Collaborative mindset with both technical and non-technical stakeholders
- Excellent communication and stakeholder engagement abilities
- Ability to manage multiple dashboards and competing deadlines
- Comfortable working cross‑functionally with Data Engineering, Finance, and Trial Operations
Any data provided as a part of this application will be stored in accordance with our Privacy Policy. For CA applicants, please also refer to our CA Privacy Notice.
Precision Medicine Group is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other characteristics protected by law.
If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact Precision Medicine Group at myHR@precisionmedicinegrp.com.
Recruitment Fraud Warning: Please be aware that fraudulent individuals and websites may impersonate Precision Medicine Group or its affiliates and attempt to obtain personal, financial, or banking information through fake job postings or employment offers. Precision Medicine Group will never request payment, banking details, or other sensitive financial information as part of the recruitment process. If you believe you have been targeted by a recruitment scam, we encourage you to report the incident to your local law enforcement authorities, consumer protection agency, or relevant cybercrime reporting organization in your country. Please also notify us at myHR@precisionmedicinegrp.com so we can investigate and take appropriate action.
Similar jobs
We are seeking a Power BI Developer to help build and scale enterprise Trial Analytics across a global clinical trial portfolio. This role sits within the business (Project Finance & Analytics) and partners closely w…
Position Summary: The Senior Analyst II will be responsible for developing and maintaining Tableau dashboards and SQL programming to support clinical data management and analysis. This role requires a strong technical ba…
Position Summary: The Senior Analyst II will be responsible for developing and maintaining Tableau dashboards and SQL programming to support clinical data management and analysis. This role requires a strong technical ba…
We are building the Data Hub, a centralized data platform responsible for consolidating legacy data infrastructure, establishing enterprise-grade data foundations, and enabling advanced analytics and AI capabilities acro…
We are building the Data Hub, a centralized data platform responsible for consolidating legacy data infrastructure, establishing enterprise-grade data foundations, and enabling advanced analytics and AI capabilities acro…
We’re expanding our data engineering capabilities across Mexico, Brazil, Argentina, Colombia, Chile, and Peru, and we’re hiring a Senior Clinical Data Engineer to help build the foundation of this new regional function.…
We’re expanding our data engineering capabilities across Mexico, Brazil, Argentina, Colombia, Chile, and Peru, and we’re hiring a Senior Clinical Data Engineer to help build the foundation of this new regional function.…
Est. 90,000 USD
***Unfortunately, the Client Services Business Analyst II - Healthcare Data role is not able to provide sponsorship now or anytime in the future.*** ***This role requires you to be located in the Indianapolis area, and r…
Est. 90,000 USD
***Unfortunately, the Client Services Business Analyst II - Healthcare Data role is not able to provide sponsorship now or anytime in the future.*** ***This role requires you to be located in the Indianapolis area, and r…
We’re expanding our capabilities across Mexico, Brazil, Argentina, Colombia, Chile, and Peru, and we’re hiring a Senior Clinical Data Manager to help build the foundation of our clinical data operations in Mexico. The Se…
We’re hiring a Clinical Trial Manager to help build and lead our expanding clinical operations across Latin America. This is an exciting, high‑impact opportunity based in Mexico, supporting rapid growth across Mexico, Br…
We’re hiring a Clinical Trial Manager to help build and lead our expanding clinical operations across Latin America. This is an exciting, high‑impact opportunity based in Mexico, supporting rapid growth across Mexico, Br…
We’re expanding our capabilities across Mexico, Brazil, Argentina, Colombia, Chile, and Peru, and we’re hiring a Senior Clinical Data Manager to help build the foundation of our clinical data operations in Mexico. The Se…
The Data Analyst supports client business processes and operations activities to ensure on-time and high-quality deliverables. Data Analyst combines best-in-class operational and analytic skills with strong problem-solvi…
The Data Analyst supports client business processes and operations activities to ensure on-time and high-quality deliverables. Data Analyst combines best-in-class operational and analytic skills with strong problem-solvi…
Position Summary: The Principal Clinical Scientist, Clinical Science Analytics & Insights is responsible for & manages the operational clinical science function from study start up through database lock for assig…
Position Summary: The Principal Clinical Scientist, Clinical Science Analytics & Insights is responsible for & manages the operational clinical science function from study start up through database lock for assig…
Est. 155,800 USD
Position Summary: Serves as the clinical trial lead responsible for the planning, conduct and oversight of the operational portion of clinical studies per defined scope of work and ensures that clinical studies are condu…
Est. 155,800 USD
Position Summary: Serves as the clinical trial lead responsible for the planning, conduct and oversight of the operational portion of clinical studies per defined scope of work and ensures that clinical studies are condu…
Est. 195,150 USD
Position Summary: Provides statistical leadership and support for all phases of clinical development. Specific responsibilities include consulting with clients regarding clinical trial study design and regulatory strateg…
Est. 195,150 USD
Position Summary: Provides statistical leadership and support for all phases of clinical development. Specific responsibilities include consulting with clients regarding clinical trial study design and regulatory strateg…
Precision AQ is seeking a Reporting Analyst to help produce routine and ad hoc commercial operations reporting. This individual will work closely with Commercial Operations Leadership to produce reports and analysis rega…
Precision AQ is seeking a Reporting Analyst to help produce routine and ad hoc commercial operations reporting. This individual will work closely with Commercial Operations Leadership to produce reports and analysis rega…
Global trials for oncology, rare diseases and other complex diseases face unique challenges. Precision partners with our clients to meet them head-on through our extensive footprint across the globe. We succeed by pairin…
Est. 65,000 GBP
Due to Precision's continual growth, we are looking for a Principal Innovation Business Analyst to join our European team. The position can be covered fully remotely from the UK. Position Summary: The Principal Innovatio…
Est. 65,000 GBP
Due to Precision's continual growth, we are looking for a Principal Innovation Business Analyst to join our European team. The position can be covered fully remotely from the UK. Position Summary: The Principal Innovatio…
Precision for Medicine is a Clinical Research Organization. Precision’s uniquely integrated offering enables the science of precision medicine by combining novel clinical trial designs, industry-leading operational and m…
Est. 35,000 EUR
Precision for Medicine is a Clinical Research Organization. Precision’s uniquely integrated offering enables the science of precision medicine by combining novel clinical trial designs, industry-leading operational and m…
Precision for Medicine is a Clinical Research Organization. Precision’s uniquely integrated offering enables the science of precision medicine by combining novel clinical trial designs, industry-leading operational and m…
Precision for Medicine is a Clinical Research Organization. Precision’s uniquely integrated offering enables the science of precision medicine by combining novel clinical trial designs, industry-leading operational and m…