Power BI Business Analyst

Position Summary

We are seeking a highly skilled Power BI Business Analyst Contractor to support supply chain analytics across S&OP, manufacturing, and operations. The contractor will translate complex business requirements and data into clear, scalable, and executive-ready dashboards that improve visibility and decision-making.

The ideal candidate combines advanced Power BI development, strong business analysis, supply chain knowledge, and disciplined data modeling. This individual will own the end-to-end BI lifecycle, from requirements and KPI definition through development, deployment, documentation, user enablement, and long-term support.

• Partner with supply chain, S&OP, manufacturing, operations, planning, and leadership teams to understand reporting and analytics needs.
• Translate business questions into clear requirements, KPI definitions, data specifications, and scalable BI solutions.
• Facilitate requirement-gathering sessions, document business logic, and align stakeholders on definitions and expected outcomes.
• Communicate insights clearly to both technical and non-technical audiences and serve as the bridge between business and data teams.

• Design, develop, test, publish, and maintain enterprise-grade Power BI dashboards and reports.
• Create intuitive dashboards that help leaders quickly understand performance, trends, exceptions, risks, and required actions.
• Develop reporting across S&OP, demand and supply planning, inventory, manufacturing, logistics, supplier performance, order fulfillment, and operational KPIs.
• Build effective drill-down, filtering, navigation, security, and self-service capabilities while maintaining a consistent user experience.
• Optimize report performance, refresh reliability, usability, and adoption.

• Design scalable, reusable, and well-structured semantic data models that can support future reporting requirements.
• Integrate and transform data from ERP, planning, manufacturing, operational, Excel, SharePoint, database, and other approved sources.
• Use Power Query, SQL, and established data modeling practices to prepare reliable datasets for reporting.
• Ensure data accuracy, consistent KPI logic, traceability, appropriate access controls, and adherence to data governance standards.
• Establish validation and reconciliation processes to build trust in dashboards and reported metrics.

• Own the ongoing maintenance and enhancement of Power BI solutions after initial deployment.
• Document data sources, transformations, data models, KPI definitions, refresh processes, dependencies, security, and support procedures.
• Diagnose and resolve data, refresh, performance, and report issues in partnership with business and technical teams.
• Create reusable standards, templates, and development practices that reduce dependency on individual developers.
• Train business users and designated support resources on dashboard usage, KPI interpretation, and basic troubleshooting.

• Bachelor's degree in Business, Supply Chain, Engineering, Information Systems, Analytics, Computer Science, or a related field, or equivalent professional experience.
• Five or more years of experience in business intelligence, analytics, business analysis, or a related field, with substantial hands-on Power BI experience.
• Advanced proficiency in Power BI Desktop and Power BI Service, including report development, publishing, refresh management, security, and performance optimization.
• Strong DAX capability for developing reliable business measures and analytical logic.
• Strong data modeling expertise, including dimensional modeling, relationships, data granularity, reusable semantic models, and performance-conscious design.
• Advanced Excel skills, including Power Query, Pivot Tables, lookup and analytical techniques, and structured data preparation.
• Working knowledge of SQL and data integration concepts.
• Demonstrated ability to gather requirements, define KPIs, analyze data, and present findings in a clear and decision-oriented manner.
• Strong written and verbal communication skills, attention to detail, and the ability to work independently in a contractor environment.

The candidate should understand core supply chain concepts and have practical exposure to several of the following:

• Sales & Operations Planning (S&OP) and integrated planning processes
• Demand planning, supply planning, backlog, capacity, and constraint visibility
• Inventory management, material availability, shortages, aging, and working capital
• Manufacturing performance, production plans, throughput, schedule adherence, yield, and quality
• Procurement, supplier performance, lead times, cost, and purchase order visibility
• Logistics, transportation, delivery performance, and order fulfillment
• Operational performance management, KPI governance, and root cause analysis

• Experience…