Business Intelligence Lead

Date Posted: 02/02/2026
Hiring Organization:
Rose International
Position Number: 496469
Industry: Professional Services

Job Title:

Business Intelligence Lead

Job Location:

Indianapolis, IN, USA, 46204
Work Model:
Onsite

Shift: Local Business Hours

Employment Type:

Temporary
FT/PT:
Full-Time
Estimated Duration (In months): 12
Min Hourly Rate($): 58.00
Max Hourly Rate($): 64.00
Must Have Skills/Attributes: AWS, Data Modeling, Life Science Manufacturing, Power

BI, SQL
Experience Desired:
Life Sciences clinical manufacturing systems experience (3 yrs); GMP regulated environment experience (3 yrs);
Advanced Power BI Desktop expertise with DAX Power Query and semantic modeling (6 yrs);
Strong SQL and data modeling skills (6 yrs);
Experience implementing Row Level Security (RLS) (6 yrs)

C2C is not available

Required Qualifications

Skills and Experience:

• Advanced experience with Power BI Desktop
• Experience with Life Sciences clinical manufacturing systems
• Experience working in GMP environments
• Strong experience with DAX
• Proficiency in Power Query and M language
• Experience designing semantic models
• Strong SQL skills
• Experience with data modeling
• Experience implementing Row Level Security RLS

• Power BI administration experience

This role supports operational reporting and analytics initiatives for clinical manufacturing systems within a regulated life sciences environment. The Business Intelligence Lead will be responsible for building and maintaining Power BI based reporting solutions that meet performance, security, and compliance requirements. The role requires hands on experience with semantic model design, data integration, and secure data access. The position is primarily onsite at the client location in Indianapolis, with an expectation of 80 to 100 percent onsite presence.

• 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
• Only those lawfully authorized to work in the designated country associated with the position will be considered.
• Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).