Business Intelligence Manager

About the Role:

We are seeking a hands-on Business Intelligence Manager to develop reporting solutions, manage business analytics initiatives, and transform operational data into actionable insights. This is a full-time, on-site opportunity in Northeast Ohio. The Business Intelligence Manager will lead dashboard development, data integration, automated reporting, and data quality improvement projects across manufacturing, ecommerce, warehousing, and logistics operations. This is an individual contributor position with project leadership responsibilities, ideal for a business intelligence professional who enjoys working directly with SQL, Python, Power BI, data visualization, and database systems rather than focusing exclusively on people management.

Responsibilities:

• Design, develop, implement, and maintain business intelligence dashboards, automated reports, KPI scorecards, and analytical tools that support data-driven decision-making.
• Develop and optimize complex SQL queries, database views, reporting scripts, and data extraction processes to consolidate information from multiple operational systems.
• Analyze business performance data related to inventory management, order fulfillment, shipping expenses, warehouse productivity, operational costs, and process efficiency.
• Integrate data from ERP systems, warehouse management software, ecommerce platforms, shipping applications, and third-party data sources using APIs and database connections.
• Build and maintain automated reporting workflows, data transformation processes, and analytical solutions using Python, SQL, and business intelligence platforms.
• Collaborate with technology leadership, finance, operations, and department stakeholders to gather reporting requirements, define key performance indicators, and prioritize analytics projects.
• Identify data inconsistencies, perform data validation, troubleshoot reporting discrepancies, and implement quality controls to improve data accuracy and reliability.
• Lead business intelligence and reporting projects, including solution planning, development, testing, stakeholder review, implementation, and ongoing support.
• Evaluate opportunities to improve business intelligence capabilities through cloud analytics platforms, workflow automation, and AI-assisted data analysis.
• Develop and maintain documentation covering reporting logic, data sources, database relationships, dashboard definitions, and analytical processes.

Qualifications:

• Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business Intelligence, Data Science, or a related field, or equivalent practical experience.
• 2 to 3 years of experience in business intelligence, data analytics, reporting development, data engineering, or a related analytical technology role.
• Strong SQL skills, including complex queries, joins, aggregations, data transformations, and database performance optimization.
• Hands-on experience developing dashboards, reports, and visualizations using Microsoft Power BI, Tableau, Looker, or comparable business intelligence platforms.
• Working knowledge of Python or a similar scripting language for data preparation, reporting automation, and analytical workflows.
• Experience integrating data from multiple software applications, relational databases, APIs, and enterprise systems.
• Understanding of data modeling, ETL processes, data validation, reporting logic, and data quality management.
• Ability to define business metrics, interpret operational data, identify trends, and translate analytical findings into actionable recommendations.
• Experience managing reporting initiatives, prioritizing analytics requests, and coordinating deliverables with business and technical stakeholders.
• Strong attention to detail, analytical problem-solving, communication, and technical documentation skills.

Desired Qualifications:

• Experience developing business intelligence solutions for manufacturing, supply chain, logistics, ecommerce, warehousing, or distribution operations.
• Familiarity with ERP platforms, warehouse management systems, inventory management tools, and order processing applications.
• Experience with Google BigQuery, cloud data warehouses, SQL-based analytics platforms, or related cloud technologies.
• Knowledge of Shopify, WooCommerce, ecommerce reporting, fulfillment analytics, or shipping cost analysis.
• Experience with advanced Power BI functionality, including DAX, Power Query, data modeling, and automated data refresh processes.
• Familiarity with data governance, workflow automation, AI-assisted analytics, internal application development, or low-code reporting tools.