Senior Manager of Business Intelligence and Analytics

Senior Manager, Business Intelligence

Location: Wood Dale, IL (Open to Remote)

Department: Business Intelligence

Reports To: Senior Director of Business Intelligence and Data Governance

The Senior Manager, Business Intelligence & Analytics is a critical leadership role responsible for shaping and delivering the organization’s data and analytics capabilities. This role serves as both a strategic leader and hands‑on practitioner, driving the development of scalable BI solutions while actively contributing to data modeling, reporting, and analytics execution. This individual will partner closely with business leaders, IT, and cross‑functional teams to deliver trusted, actionable insights, enable self‑service analytics, and elevate data literacy across the organization.

As a leader in a growing environment, this role requires a “player‑coach” mindset. Comfortable setting vision while also rolling up sleeves to solve complex technical and analytical challenges.

• Lead, mentor, and develop a centralized BI team (analysts, developers, engineers), fostering a high-performance and accountable culture
• Define and execute a scalable BI and analytics roadmap aligned to business priorities
• Establish and enforce BI governance, standards, and best practices across data, reporting, and analytics
• Act as a trusted advisor to executive leadership, identifying opportunities to drive value through data
• Champion a data-driven culture, improving data literacy and adoption across the organization
• Build and govern a Tableau super user community, driving consistency and best practices

• Actively contribute to the design, development, and optimization of data models, data marts, and reporting structures within SQL Server (on-prem)
• Write and optimize complex T‑SQL queries and support performance tuning efforts
• Partner closely with data engineering and IT to design and improve ETL pipelines and data integration processes
• Ensure data integrity, consistency, and reliability across core reporting assets
• Influence the design and evolution of an AI‑ready data warehouse architecture
• Troubleshoot and resolve complex data and performance issues as needed

• Establish visualization standards, KPI definitions, and usability best practices
• Deliver intuitive, high-impact dashboards that translate data into clear, actionable insights
• Balance self‑service enablement with strong governance and data accuracy controls
• Optimize dashboard performance and user experience

• Serve as the primary liaison between BI and business functions (Finance, Operations, Sales, etc.)
• Translate business needs into scalable technical solutions and analytics products
• Present insights, storytelling, and recommendations to senior leadership
• Manage and prioritize competing BI initiatives across functions with clarity and transparency
• Build strong cross‑functional relationships to ensure alignment and adoption

• Establish SLAs and performance metrics for BI delivery and support
• Lead project planning, prioritization, and execution (Agile or hybrid methods)
• Ensure on‑time, high‑quality delivery of BI initiatives
• Continuously measure and improve BI adoption, user satisfaction, and business impact

• Bachelor’s degree in Information Systems, Data Analytics, Computer Science, business, or related field
• 8–12+ years of experience in business intelligence, analytics, data engineering, or related disciplines
• 4–6+ years of leadership experience, preferably within a centralized BI or shared services model
• Proven ability to balance hands‑on technical work with strategic leadership in a resource‑constrained environment
• Deep expertise in Microsoft SQL Server (on-prem), including: advanced T‑SQL development, data modeling and schema design, query optimization and performance tuning
• Strong hands‑on experience with Tableau (or similar BI tools), including dashboard development (server experience a plus)
• Strong understanding of: data warehousing concepts (star schema, ETL, data marts), data structuring and transformation techniques
• Demonstrated business acumen…