Business Intelligence Analyst

Granite City Electric Supply is the area's premier electrical distributor serving electrical contractors as well as residential, commercial and industrial customers for over 100 years.  With over 30 branches covering Massachusetts, New York, Rhode Island, New Hampshire, Vermont and Connecticut, we are the largest regional independent electrical supply company and the official distributor of electrical supplies to the Boston Red Sox. 

In addition to standard benefits, Granite City Electric offers a company 401K match and profit sharing, competitive health benefits with telehealth, up to $450 in health & wellness reimbursement, employee assistance program and referral incentives.

Overview

We are seeking a detail‑oriented and data‑driven Business Intelligence Analyst to support our product distribution operations through advanced reporting, analytics, and data modeling. The ideal candidate will have strong SQL capabilities, experience with BI tools, and a strong understanding of distribution and supply chain workflows. This role will play a critical part in turning operational data into actionable insights that improve efficiency, forecast performance, and support strategic business decisions.

Key Responsibilities

Data Analytics & Reporting

• Develop, automate, and maintain dashboards and performance reports that support distribution, logistics, and product lifecycle teams.
• Analyze large datasets to identify trends, anomalies, and opportunities for operational improvements.
• Create forecasts, KPIs, and performance models to support demand planning, inventory management, and process optimization.
• Translate data into compelling visualizations using tools such as Power BI, Tableau, or Looker.

SQL & Data Management

• Write complex SQL queries to extract, cleanse, and transform data from multiple systems (ERP, WMS, CRM, etc.).
• Partner with data engineering teams to enhance data quality, structure, and accessibility.
• Ensure data integrity and consistency across analytical models and operational systems.

Business & Distribution Insights

• Work closely with distribution, operations, and sales stakeholders to understand business processes and information needs.
• Support initiatives related to warehousing efficiency, product flow, order accuracy, and transportation performance.

Cross‑Functional Collaboration

• Communicate data findings and recommendations to leadership through clear storytelling.
• Assist in the development of new business processes, analytics standards, and data governance frameworks.
• Collaborate with IT and operational teams to improve system integrations and workflows.

Qualifications

Required

• Bachelor’s degree in Data Analytics, Business, Information Systems, Supply Chain, or related field.
• 3+ years of experience as a BI Analyst, Data Analyst, or similar role.
• Strong SQL skills.
• Experience using BI/reporting tools (Power BI, Tableau, Looker, Qlik, etc.).
• Demonstrated experience working with product distribution, logistics, supply chain, or fulfillment operations.
• Solid understanding of data modeling, data warehousing concepts, and ETL workflows.
• Ability to turn complex datasets into clear insights for non‑technical stakeholders.

Preferred

• Familiarity with ERP (Epicor Eclipse) and WMS systems (e.g., SAP, NetSuite, Oracle, Manhattan, etc.).
• Advanced Excel skills (PowerQuery, PowerPivot, macros).
• Familiarity with AI tools for data analytics.

Key Competencies

• Strong analytical and problem‑solving skills
• Excellent communication and data storytelling
• High attention to detail
• Ability to work cross‑functionally in fast‑paced environments
• Process‑oriented mindset with a focus on continuous improvement

Granite City offers competitive wages, great benefits including medical, dental, vision, life, STD/LTD, 401k, vacation, holiday, sick and more!  Join our team and work among the best in the industry!

We are an equal opportunity employer. Disabled/Veterans.

Except where prohibited by state law, all offers of employment are conditioned upon successfully passing a drug test.

This employer uses E-Verify.