Senior Manager, Business Intelligence
Location: Wood Dale, IL (Open to Remote)
Department: Business Intelligence
Reports To: Senior Director of Business Intelligence and Data Governance
About Optimas:
Optimas is a global distributor of integrated supply chain solutions, and engineering support focused on delivering fasteners, components, industrial and safety supplies to our diverse customers around the world. Our local, on-the-ground teams understand the nuances of every community we serve. This allows us to adapt with our customers and partners as needs evolve, leveraging our footprint to remain at your side while providing a highly personalized level of service and support no matter where you find yourself around the globe.
To learn more about our company, please visit our website http://www.optimas.com/
Position overview:
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.
Key Responsibilities
Leadership & Strategy
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
Data & Architecture
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
Reporting & Visualization
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
Stakeholder Engagement
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
Operations & Delivery
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
Qualifications
Required
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 and ability to align analytics to operational and financial KPIs
Exceptional communication, prioritization, and stakeholder management skills
Preferred
Experience with Tableau Server administration
Familiarity with data governance frameworks and data quality tools
Exposure to legacy and modern BI environments (hybrid ecosystems)
Experience scaling BI functions in mid-to-large organizations
Prior use of NetSuite
Key Competencies
Strategic thinking and business acumen
Strong leadership and team development skills
Excellent communication and stakeholder management
Data storytelling and visualization expertise
Problem-solving and analytical mindset
Ability to balance hands-on technical work with leadership responsibilities
Ability to bring clarity and simplification
Outside the box thinking to creatively solve business problems with system driven solutions
Success Metrics
Adoption and usage of BI tools and dashboards
Data accuracy and reporting reliability
Time-to-delivery for BI requests
Stakeholder satisfaction and engagement
Performance and scalability of BI solutions
BI team development and growth
Optimas OE Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Optimas OE Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
To Staffing and Recruiting Agencies: Optimas does not accept unsolicited CVs or applications from agencies. Optimas is not responsible for any fees related to unsolicited CVs or applications and explicitly reserve its right to contact candidates presented in such unsolicited CV or application