Blue Rock Management · 6 hours ago
Data Reporting Analyst
Indianapolis, IN
Contract
Hybrid
Senior Level, Lead/Staff
6+ years expBlue Rock Management is seeking a highly experienced Senior BI Lead / Power BI Analytics Consultant with expertise in Life Sciences clinical manufacturing and GMP environments. The role involves designing and delivering enterprise-grade reporting solutions, optimizing semantic models in Microsoft Fabric, and developing operational dashboards while ensuring compliance with reporting standards.
Information Services
Responsibilities
Develop data visualization to support the Foundry operational reporting needs
Configure and establish the LMF Fabric workspace with appropriate security controls for Red CCI data
Set up One Lake shortcuts to AWS S3 buckets containing LMF data (Bronze/Silver/Gold zones)
Design and build semantic models (datasets) using Direct Lake mode for optimal performance
Develop initial Batch Review Dashboard integrating MES and LIMS data
Implement Row-Level Security (RLS) aligned with Red CCI access requirements
Establish report development standards and templates for LMF
Prior functional exposure to Clinical Manufacturing environments and strong understanding of Good Manufacturing Practices (GMP)
Experience working directly with clinical manufacturing data sources, not just general data engineering
Hands‑on expertise with PI Historian, LIMS, MES, and real‑time production data
Ability to interpret, model, and analyze data generated from regulated clinical manufacturing processes
Qualification
Required
BI Lead
Life Sciences Clinical Manufacturing Systems and GMP experience is a MUST have
Power BI
Life Sciences and Healthcare Modernization Strategy and Implementation
Power BI Desktop
DAX
Power Query/M language
Semantic Model design
SQL
Data Modeling
Row-level Security (RLS)
PBI Administration
Develop data visualization to support the Foundry operational reporting needs
Configure and establish the LMF Fabric workspace with appropriate security controls for Red CCI data
Set up One Lake shortcuts to AWS S3 buckets containing LMF data (Bronze/Silver/Gold zones)
Design and build semantic models (datasets) using Direct Lake mode for optimal performance
Develop initial Batch Review Dashboard integrating MES and LIMS data
Implement Row-Level Security (RLS) aligned with Red CCI access requirements
Establish report development standards and templates for LMF
Prior functional exposure to Clinical Manufacturing environments and strong understanding of Good Manufacturing Practices (GMP)
Experience working directly with clinical manufacturing data sources, not just general data engineering
Hands‑on expertise with PI Historian, LIMS, MES, and real‑time production data
Ability to interpret, model, and analyze data generated from regulated clinical manufacturing processes
Company
Blue Rock Management
Blue Rock Management is a consulting firm, focused on finding solutions that meet our client's needs.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase