Business Intelligence Lead Jobs in Illinois

Job Title: Team Lead, Business Intelligence (BI) – Microsoft Fabric & Power BI

Location: Vernon Hills, IL

Department: IT

Reports To: Director, Data Analytics

Direct Reports/Manages others: No

We are seeking a highly skilled Team Lead, BI Developer to lead a centralized Business Intelligence and Analytics team. This role is responsible not only for hands-on development, but also for leading a team to design, build, and deliver scalable enterprise analytics solutions within Microsoft Fabric and Power BI. The Team Lead will drive best practices, mentor developers, and ensure delivery of high-quality, performant, and governed BI solutions.

Key Responsibilities:

• Leadership & Team Management
• Lead and mentor a team of BI developers and analysts.
• Drive delivery of analytics solutions from requirements through deployment.

• Work with leadership to establish development standards, code reviews, and best practices.

• Solution Delivery (Hands-on + Oversight)

• Lead development of semantic models, reports, and dashboards.

• Ensure team delivers scalable, reusable, and governed BI solutions.

• Power BI & Semantic Modeling

• Design enterprise semantic models and reusable data assets.

• Implement RLS, calculation logic, and semantic model settings.

• Performance Optimization

• Guide optimization strategies for large datasets and composite models.

• Oversee incremental refresh and performance tuning efforts.

• Deployment & DevOps

• Own Dev/QA/Prod deployment pipelines and release processes.

• Data Connectivity & Gateways

• Oversee gateway management and connectivity strategies.

• Governance & Self-Service

• Enable governed self-service BI through certified datasets and standards.

Qualifications

• 5+ years BI experience with leadership responsibilities.
• Advanced Power BI (DAX, modeling, performance tuning).
• Experience leading teams and delivering enterprise BI solutions.
• Strong knowledge of Microsoft Fabric, data gateways, pipelines, RLS, and incremental refresh.
• Exposure to Databricks and modern cloud data platforms.

Salary Target Range: $110,000 - $130,000, bonus eligible

From big benefits to small, we take care of our associates! After 30 days of employment, you will be eligible for a benefits package that includes medical, dental, life, disability and business travel insurance, flexible spending accounts, EAP, stock purchases and more. We also offer a 401(k) plan after three months of employment. Associates are vested in the RPM Pension plan after completing five years of service. Rust-Oleum offers 9 paid holidays and one floating holiday per year. You are also eligible to earn three weeks of vacation on an annualized basis.

Rust-Oleum is an equal opportunity employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color, or any other protected class.