BI Platforms Administrator (Microsoft Fabric/Power BI)

Scorpion Therapeutics; Indianapolis (IN); On-site; USD 65,000 - 158,000; Full time

Benefits offered by this job

Company bonus

401(k)

Medical/dental/vision

Life insurance

Time off

Well-being benefits

Job summary

Scorpion Therapeutics in Indianapolis, IN, seeks an experienced Fabric/Power BI Platform Administrator to oversee day-to-day operations, deployments, and governance across Dev, QA, and Production environments. You will ensure reliability, plan upgrades, and coordinate with security teams.

The role requires strong scripting, REST API, and SQL skills, plus expertise in gateway administration and cloud connectors (Azure/AWS). On-site with relocation as needed.

Qualifications

• Deep Fabric/Power BI architecture knowledge with capacity management and DR planning.
• Strong On-Premises Data Gateway expertise and maintenance experience.
• Ability to analyze diagnostic logs for health and incident investigation.
• Networking fundamentals for SaaS connectivity and security practices.
• Proficiency in PowerShell and REST API with SQL skills.
• Experience with enterprise identity/security/SSO (AD, Azure AD).
• Azure/AWS knowledge and Fabric capacity management in cloud environments.
• Ability to translate business needs into configuration changes.

Responsibilities

• Administer Fabric/Power BI platforms and ensure reliability.
• Lead installations, upgrades, and large deployments across environments.
• Maintain high availability, patches, and security updates.
• Run CAPA activities and update quality documentation.
• Optimize data gateways and dataset refresh reliability.
• Govern workspaces, datasets, reports, and permissions; perform audits.
• Build automation scripts and DevOps pipelines using APIs and PowerShell.
• Collaborate with infrastructure/security teams; support cloud integrations.
• Mentor junior admins and develop SOPs; act as platform SME.

Skills

Fabric/Power BI architecture

On-Premises Data Gateway

Diagnostic log analysis

Networking for SaaS

PowerShell

REST API

SQL

Identity/Security/SSO

Azure/AWS knowledge

GitHub Actions CI/CD

Communication

Education

High School Diploma/GED

Tools

Power BI

Report Server

Fabric REST API

Job description

Responsibilities:

• Administer Lilly’s Power BI/Fabric analytics platform day-to-day; ensure reliability and secure, scalable analytics adoption.
• Lead installation/upgrades and large-scale deployments of Fabric/Power BI Report Server/Service across Dev, QA, Production.
• Maintain HA/cluster/failover; plan and execute patches/security updates/version upgrades with minimal disruption.
• Run CAPA activities (e.g., certificate renewals, password rotations, security patching; update quality documents/SharePoint articles).
• Optimize Gateway performance, Dataflow efficiency, and dataset refresh reliability.
• Define/enforce governance for workspaces, datasets, reports, permissions, and content lifecycle; perform audits and usage/performance/capacity insights.
• Build automation scripts/DevOps pipelines using Fabric/Power BI REST APIs and PowerShell; implement inventory/monitoring/usage tracking.
• Troubleshoot with infrastructure/network/database/cloud/security teams; support integrations (Azure, AWS, Snowflake, Databricks, hybrid).
• Lead capacity planning/scaling/performance tuning; mentor junior admins and establish SOPs; act as platform SME.

Qualifications/Skills:

• Deep Fabric/Power BI architecture knowledge (capacity mgmt, HA/DR, integrations) and proven performance optimization.
• Strong On-Premises Data Gateway expertise (install/config, clustering, service accounts, ports/proxy, tuning, troubleshooting, cert/credential management).
• Ability to generate/analyze diagnostic logs (Fabric and Gateway) for proactive health and incident investigation.
• Networking fundamentals for SaaS connectivity (firewalls, private endpoints, Azure Service Tags, proxy/DNS, Service Bus Relay) and ability to partner with Network teams.
• Expertise in PowerShell and REST API; advanced SQL.
• Enterprise identity/security/SSO experience (AD, Azure AD).
• Azure/AWS knowledge; ability to manage Fabric capacity in Azure with GitHub Actions CI/CD.
• Communication and business-to-configuration translation skills.
• Preferred: Spotfire or SAP Business Objects; ServiceNow (or equivalent).

Basic Requirements:

• High School Diploma/GED + 3+ years administering Fabric/Power BI platforms; 3+ years hands-on Fabric/Power BI Service + Report Server admin.
• SQL capability; PowerShell and Fabric/Power BI REST API; enterprise BI operations, migrations, DR planning.
• Must be authorized to work in the United States full-time; no visa sponsorship.

Benefits/Compensation (as stated):

• Anticipated wage: $64,500–$158,400; eligible for company bonus; comprehensive benefits (e.g., 401(k), medical/dental/vision, flexible benefits, life insurance, time off, well-being).

Additional Info:

• Onsite in Indianapolis, IN (relocation required).
• Schedule: 9:00 AM–6:00 PM, Mon–Fri; 3 days in-office; on-call evenings/weekends for escalations; <5% travel.