Senior Business Analyst

Insight Global; Pittsburgh (Allegheny County); On-site; USD 95,000 - 140,000; Full time

Job summary

Insight Global is seeking an experienced Senior Business Intelligence Analyst / Business Analyst to bridge business stakeholders and technical data teams. You will lead requirements and analysis for reporting and analytics, translating business needs into KPIs, dashboards, and scalable data solutions.

The ideal candidate understands Power BI, basic SQL, data lakes and warehouses, and will partner with technical teams to deliver the right solution.

Qualifications

• 5+ years of experience in Business Analysis, BI, Data Analytics, Reporting, or related area.
• 3+ years gathering requirements and creating BRDs, user stories, KPIs, reporting requirements, UAT scenarios, and process documentation.
• Strong experience bridging business stakeholders and technical/data teams.
• Working knowledge of Power BI, dashboards, metrics, reporting logic.
• Ability to write and understand basic SQL queries.
• Working understanding of relational databases, data models, data warehouses, and data lakes.
• Strong analytical, problem-solving, communication, presentation, and stakeholder-management skills.
• Ability to manage multiple priorities in a fast-moving enterprise environment.

Responsibilities

• Serve as the primary liaison between business stakeholders and technical teams (Data Engineering, Data Modeling, Data Architecture, Enterprise Applications, BI Development).
• Lead requirements gathering and translate business needs into BRDs, user stories, process flows, KPIs, and reporting requirements.
• Own reporting and analytics initiatives from intake through design, UAT, deployment, and adoption.
• Define and validate KPIs, metrics, dashboards, scorecards, and executive reporting needs.
• Review Power BI dashboards and reports; identify opportunities for enhancement and standardization.
• Analyze data to identify trends, risks, opportunities, and actionable insights.
• Partner with teams to understand data sources, models, warehouses, lakes, and data flows.
• Write and review basic SQL queries to validate data and calculations.
• Define data quality, integrity, and source-system requirements.
• Develop and coordinate UAT plans and testing, manage defects, obtain sign-off.
• Identify opportunities to standardize reporting processes and workflows.
• Promote data-driven decision-making across the organization.
• Manage multiple initiatives and stakeholder priorities in a digital transformation.

Skills

Business analysis

Data analytics

Stakeholder management

Presentation

Problem solving

Tools

Power BI

SQL

Job description

• 5+ years of experience in Business Analysis, Business Intelligence, Data Analytics, Reporting, or a related area.
• 3+ years of experience gathering requirements and creating BRDs, user stories, KPIs, reporting requirements, UAT scenarios, and process documentation.
• Strong experience acting as a bridge between business stakeholders and technical/data teams.
• Working knowledge of Power BI, with the ability to understand dashboards, visualizations, metrics, and reporting logic.
• Ability to write and understand basic SQL queries for data analysis and validation.
• Working understanding of relational databases, data models, data warehouses, and data lakes.
• Strong analytical, problem-solving, communication, presentation, and stakeholder-management skills.
• Ability to manage multiple priorities in a fast-moving enterprise environment.

Nice to Have Skills & Experience

• Experience within distribution, supply chain, logistics, retail, or a similarly complex operational environment.
• Understanding of inventory management and planning, supply and demand planning, category management, direct procurement/procure-to-pay, and forecast-to-deliver processes.
• Experience working with reporting and analytics across multiple ERP and source systems.
• Familiarity with Power Apps, Power Automate, Excel, PowerPoint, and Visio.
• Experience supporting a large-scale digital or data transformation.
• Ability to travel occasionally for key meetings or workshops.

Job Description

We are seeking an experienced Senior Business Intelligence Analyst / Business Analyst to serve as the bridge between business stakeholders and technical data teams. This person will lead the requirements and business analysis side of reporting and analytics initiatives, translating business needs into well-defined KPIs, dashboards, reporting requirements, and scalable data solutions.

This is not a hands-on BI Developer position. The ideal candidate should be technically proficient enough to understand Power BI, basic SQL, data lakes, data warehouses, data models, and enterprise data flows, but their primary responsibility will be understanding the business, defining requirements, and partnering with technical teams to deliver the right solution.

A strong understanding of supply chain, distribution, logistics, inventory, procurement, or category management is highly preferred.

Key Responsibilities

• Serve as the primary liaison between business stakeholders and technical teams, including Data Engineering, Data Modeling, Data Architecture, Enterprise Applications, and BI Development.
• Lead requirements gathering and translate business needs into BRDs, user stories, process flows, business rules, KPIs, and reporting requirements.
• Own reporting and analytics initiatives from initial intake and requirements through design, UAT, deployment, and business adoption.
• Work with business leaders to define and validate KPIs, metrics, dashboards, scorecards, and executive reporting requirements.
• Review existing Power BI dashboards and reports and help determine opportunities for enhancement, consolidation, standardization, or automation.
• Analyze business and operational data to identify trends, risks, opportunities, and actionable insights.
• Partner with technical teams to understand source systems, data models, data warehouses, data lakes, data dependencies, and end-to-end data flows.
• Write and review basic SQL queries to validate data, business logic, calculations, and reporting accuracy.
• Define and validate data quality, integrity, completeness, and source-system requirements.
• Develop UAT plans and test scenarios, coordinate business testing, manage defects, and obtain stakeholder sign-off.
• Identify opportunities to improve and standardize reporting processes and business workflows.
• Drive adoption of analytics capabilities and promote data-driven decision-making across the organization.
• Manage multiple initiatives and stakeholder priorities within a fast-paced digital transformation environment.