Description

Key Skills: Power BI, DAX, Semantic Modeling, SQL, Power Query, Data Modeling, Business Intelligence, Analytics, Data Visualization, KPI Development

Good to Have Skills: Experience in clinical trials, CROs, or life sciences 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.

Roles & Responsibilities:

• Work closely with Trial Operations, Project Finance, and Project Managers to gather reporting requirements and translate them into technical solutions.
• 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 and implement calculation groups, time intelligence, and standardized metric logic.
• Optimize data models for performance, scalability, and refresh efficiency while ensuring all metrics reflect correct business logic.
• Translate business-defined KPIs into scalable analytical logic and support analytics across trial execution, portfolio health, financial performance, and operational cadence.
• Partner with Data Engineering to ensure analytics-ready data structures and consistent grain, validate dataset readiness, and report on data discrepancies.
• Implement and maintain row-level security, workspace permissions, and dataset access controls while managing versioning, QA testing, and deployment of dashboards.
• Develop certified datasets to enable self-service analytics across the organization and reduce ad hoc reporting by standardizing core analytics views.
• Provide training, documentation, and support to functional teams using Power BI dashboards and promote BI best practices across teams.

Experience Required: 3-5 years of experience developing enterprise Power BI solutions with strong experience in data modeling and building analytics for executive and operational audiences.

Education: Bachelor's degree in Data Analytics, Information Systems, Business Intelligence, Finance, or related field (or equivalent hands-on experience)

Key Skills

Education

Any Graduate