Sr Business Intelligence & Analytics Manager

Optimas Solutions; Wood Dale (IL); On-site; USD 114,000 - 144,000; Full time

Job summary

Optimas OE Solutions in Wood Dale, IL, seeks a Senior Manager of BI & Analytics to shape data capabilities, lead a centralized BI team, and partner with business leaders to deliver trusted insights.

You will drive data models, ETL processes, and dashboards, advocate data literacy, and guide governance to ensure accuracy and self-service analytics.

This hands-on leader balances strategy with execution in a growing environment, utilizing SQL Server and Tableau to enable AI-ready analytics.

Qualifications

• 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)
• Strong hands-on experience with Tableau (or similar BI tools), including dashboard development

Responsibilities

• Lead, mentor, and develop a centralized BI team (analysts, developers, engineers)
• 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 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 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

Skills

Leadership

Data storytelling

Strategic thinking

Stakeholder management

Communication

Problem-solving

Education

Bachelor's degree (IS/Analytics/CS)

Tools

SQL Server on-prem

Tableau

Job description

Description

Sr Manager of Business Intelligence and Analytics

Wood Dale, IL

$114,000-144,000 From design to delivery, Optimas integrates fastener manufacturing and distribution for greater inventory certainty, consistent quality, and a lower cost of ownership.

Description

Sr Manager of Business Intelligence and Analytics

Wood Dale, IL

$114,000-144,000 From design to delivery, Optimas integrates fastener manufacturing and distribution for greater inventory certainty, consistent quality, and a lower cost of ownership.

Fuel your passion with a career at Optimas. Become part of a team of diverse thinkers and doers who make a daily impact on our customers. We're always looking for talented, self-motivated, smart and resourceful team members. And we're committed to developing, supporting and driving your success.

Our Values are the THREAD that connects us as one team to ensure that we are accountable for our contributions to the success of our company and customers:

• Teamwork
• Honesty
• Respect
• Excellence
• Accountability
• Drive

To learn more, please visit our website http://www.optimas.com

Position Summary:

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.

Areas of impact:

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

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

Qualifications:

• 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)
• Strong hands-on experience with Tableau (or similar BI tools), including dashboard development (server experience a plus)

Equal Opportunity Employer:

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.