Team Lead, Business Intelligence; BI – Microsoft Fabric & Power BI

Job Description

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.

• 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 & Dev Ops
  • 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.

• 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.