Senior BA - Power BI

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

Job summary

Insight Global is seeking an experienced Senior BI Analyst to bridge business needs with data teams. You will translate requirements into KPIs, dashboards, and scalable data solutions, focusing on governance, adoption, and value realization.

The role emphasizes understanding business processes, partnering with Data Engineering, and delivering actionable insights across supply chain and logistics domains. Travel may be required.

Qualifications

• 5+ years in Business Analysis, Business Intelligence, 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 acting as a bridge between business stakeholders and technical/data teams.
• Working knowledge of Power BI, 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.
• Experience within distribution, supply chain, logistics, retail, or similarly complex operational environment.
• Understanding of inventory management and planning, supply and demand planning, category management, procure-to-pay, forecast-to-deliver processes.

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 intake through design, UAT, deployment, and business adoption.
• Define and validate KPIs, metrics, dashboards, scorecards, and executive reporting requirements with business leaders.
• Review existing Power BI dashboards and reports and identify 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 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.

Skills

Stakeholder management

Requirements gathering

BRD development

Data analytics

Communication

Education

Bachelor’s degree

Tools

Power BI

SQL

Excel

Visio

Power Apps

Power Automate

Job description

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.

Skills and Requirements

• Bachelor’s degree.
• 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.
• 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].