Business Intelligence Developer; Power BI, GMP & Clinical Manufacturing Data Analytics

Hybrid Work - Indianapolis, IN (3 days a week in the office required).

Required Experience:

6 to 10 years

Power BI Developer will be responsible for designing, developing, and deploying business intelligence solutions within the Microsoft Power BI / Fabric environment. This role will work closely with the Data Engineer to build the analytics layer that consumes data from AWS S3 via One Lake shortcuts and delivers actionable insights to engineers, quality personnel, and leadership.

GMP and Clinical Manufacturing / Clinical domains experience is a must have

• Develop data visualization to support the Foundry operational reporting needs
• Configure and establish the Fabric workspace with appropriate security controls for Red data
• Set up One Lake shortcuts to AWS S3 buckets containing 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 (Manufacturing Execution System) and LIMS (Laboratory Information Management System) data
• Implement Row-Level Security (RLS) aligned with Red access requirements
• Establish report development standards and templates
• Expand reporting suite to include Tech Transfer Status tracking
• Build operational KPI dashboards for leadership
• Integrate enterprise reference data from marketplace (SAP materials, QMS events)
• Implement embedded SEEQ visualizations for process analytics where needed
• Create self-service analytics capabilities for power users
• Document semantic model design and report architecture

• Collaborate with the Data Engineer on data pipeline requirements and data quality issues
• Gather requirements from engineers and translate them into BI solutions
• Troubleshoot and optimize report performance
• Support data governance and security compliance review