BI Platforms Administrator (Microsoft Fabric/Power BI)

At Lilly, the work is demanding because patients are waiting. We unite caring with discovery to help make life better for people around the world, knowing that every decision, every detail, and every day matters. Headquartered in Indianapolis, Indiana, our over 50,000 employees around the globe take on complex challenges to discover and deliver life-changing medicines, strengthen how health is understood and managed, and support the communities we serve. This is hard, urgent, selfless work—but it’s work worth doing. If you’re driven by purpose and ready to bring your best to work that truly matters for patients, we invite you to join us. 

Come help us deliver cutting-edge Analytics Platforms with the power of AI and automation!

The Tech@Lilly Team is Actively Looking for an experienced BI Platform Administrator.

Are you passionate about operating highly available analytics platforms, driving automation, and establishing strong governance frameworks? Are you energized by leading enterprise-scale deployments and optimizing end-to-end BI performance? If so, bring YOUR technical expertise to Lilly—where your work helps accelerate scientific discovery, strengthen decision-making, and ultimately improve patient outcomes.

What You’ll Be Doing:

You will serve as an Analytics Platform Administrator for Lilly’s Power BI/Fabric platform—operating and administering the environment day to day, ensuring platform reliability, and enabling secure and scalable analytics adoption across the organization. You will collaborate closely with infrastructure, database, cloud (Azure & AWS), networking, firewall and security teams to integrate platforms into a modern analytics ecosystem. You will also help drive platform optimization, automation, and operational excellence across global environments.

How You’ll Succeed:

• Lead installation, upgrades, and large-scale deployments of Fabric/Power BI Report Server and Fabric/Power BI Service across Dev, QA, and Production environments.
• Design and maintain high-availability, clustered, and failover configurations to support enterprise BI workloads.
• Plan and execute patches, security updates, and version upgrades with minimal business disruption.
• Perform regular Corrective and Preventive Actions (CAPA), including but not limited to certificate renewals, password rotations, security patching, and quality document and SharePoint article updates.
• Optimize Fabric/Power BI Gateway performance, Dataflow efficiency, and dataset refresh reliability.
• Define, implement, and enforce governance for workspaces, datasets, reports, permissions, and content lifecycle management.
• Perform regular audits and generate insights on usage, refresh schedules, performance, and capacity utilization.
• Develop automation scripts and DevOps pipelines using Fabric/Power BI REST APIs, PowerShell, and related tools to reduce manual administrative effort.
• Implement automated inventory management, monitoring, and usage tracking.
• Partner with infrastructure, network, database, cloud, and security teams to troubleshoot complex issues and improve platform stability.
• Support integrations across Azure, AWS, Snowflake, Databricks, and hybrid environments.
• Lead capacity planning, platform scaling, performance tuning, and resource optimization initiatives.
• Mentor junior administrators, establish SOPs, and drive standard methodologies for platform operations.
• Act as the platform SME for day-to-day Fabric/Power BI operations, governance, and upgrades—supporting stakeholders, assessing operational risks, and communicating platform status.

What You Should Bring:

• Deep understanding of Fabric/Power BI architecture, including capacity management, HA/DR strategies, and system integration patterns.
• Proven ability to optimize dataset refresh, gateway performance, and BI workload distribution.
• In-depth expertise with On-Premises Data Gateways—including architecture internals, installation, detailed configuration (clustering, service accounts, network ports, proxy settings), performance tuning, troubleshooting, and certificate/credential management across enterprise environments.
• Expert-level ability to generate, collect, and analyze diagnostic logs for both Microsoft Fabric (capacity metrics, workspace activity, Spark logs, pipeline run logs) and On-Premises Data Gateways (gateway logs, mashup engine logs, performance counters) to support incident investigation and proactive health monitoring.
• Strong networking fundamentals as applied to Fabric and Power BI SaaS deployments—including firewall rules, private endpoints, Azure Service Tags, proxy configurations, DNS resolution, and Azure Service Bus Relay behavior—with the ability to partner effectively with Network teams to diagnose and resolve connectivity issues.
• Expertise using PowerShell, Fabric/Power BI REST API, and automation methods for large-scale administrative tasks.
• Advanced SQL skills for troubleshooting, data validation, and performance analysis.
• Experience managing enterprise identity, security models, and SSO integrations (AD, Azure AD).
• Strong working knowledge of Azure and AWS cloud platforms, including the ability to deploy, modify, and manage Fabric capacity resources in Azure using GitHub Actions CI/CD workflows; proficiency with GitHub operations including script modifications, pull/push, branching, merging, and creating pull requests.
• Strong communication, problem-solving, and stakeholder engagement skills.
• Ability to translate business requirements into administrative and configuration changes.
• Preferred experience administering BI tools such as Spotfire or SAP Business Objects.
• Experience with ServiceNow or equivalent ticketing systems.

Basic Requirements:

• High School Diploma/GED with 3+years of experience administering Fabric/Power BI platforms.
• 3+ years of hands-on experience with Fabric/Power BI Service and Power BI Report Server administration.
• Experienced with SQL capability
• Experience with PowerShell and Fabric/Power BI REST API.
• Experience supporting enterprise BI operations, migrations, and DR planning.
• Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support for or sponsor work authorization or visas for this role, including but not limited to F-1 CPT, F-1 OPT, F-1 STEM OPT, J-1, H-1B, TN, O-1, E-3, H-1B1, or L-1

Additional Information:

• Onsite role located in Indianapolis, Indiana (relocation required).
• Work Schedule:
  • 9:00 AM–6:00 PM, Monday–Friday (3 days in-office)
  • On-call evening/weekends for escalations
• Less than 5% travel.

Organization Overview:

Lilly IT builds and maintains capabilities using cutting-edge technologies to advance our purpose—creating medicines that make life better for people around the world. We hire the best technology professionals from a variety of backgrounds who bring diverse skills, perspectives, and innovative thinking to every part of our business.

Business Function Statement (Global Information & Services Technology):

The Global Information and Services Tech team is at the forefront of digitalization to enable and advance the entire company, delivering increased productivity and best-in-class customer experiences. This team provides a robust and sustainable infrastructure and services landscape that powers Lilly’s global workforce and business operations.

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form (https://careers.lilly.com/us/en/workplace-accommodation) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.

Lilly is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status.

Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia (AMECA), Black Employees at Lilly (BE@Lilly), Chinese Culture Network (CCN), EnAble, Evolve, Lilly Indian Network (LIN), Organization of Latinx at Lilly (OLA), Pride (LGBTQ+ Allies), Veterans Leadership Network (VLN) and Women’s Initiative for Leading at Lilly (WILL).

Actual compensation will depend on a candidate’s education, experience, skills, and geographic location.  The anticipated wage for this position is

Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lilly’s compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.

#WeAreLilly