Power BI Consultant (Onsite / Contract)

• Design, develop, and maintain Power BI reports and dashboards for Finance and Operations.
• Develop, optimize, and troubleshoot SQL queries and report datasets.
• Build and optimize reporting solutions for Inventory, Sales, COGS, Accounts Payable (AP), Open Receipts, Floor Stock, WIP, Capital Reporting, and Weekly Operational Tracking.
• Validate business rules and ensure data accuracy across reporting solutions.
• Enhance existing reporting processes by reducing manual effort and improving automation.
• Implement business workflows, alerts, notifications, and exception monitoring mechanisms.
• Support automation initiatives including Vendor Statement & Invoice Management and other document-driven processes.
• Integrate data from multiple enterprise platforms such as PeopleSoft, Infor LN, Databricks/Hadoop, MES, SharePoint, and other approved sources.
• Work closely with business SMEs to understand reporting requirements and translate them into technical solutions.
• Conduct data analysis and support KPI definition, validation, and reporting optimization activities.
• Participate in User Acceptance Testing (UAT), defect resolution, deployment, and post-implementation support.
• Prepare technical documentation and deliver knowledge transfer sessions to end users and support teams., Key Deliverables
• Automated and optimized business reporting solutions.
• Interactive operational and financial dashboards.
• SQL-based reporting and data integration solutions.
• Workflow automation, alerts, and notification mechanisms.
• Inventory, Accounts Payable, Capital Reporting, and Operational Tracking analytics solutions.
• Documentation, knowledge transfer, and post-deployment support.

• Strong experience in Microsoft Power BI development.
• Proficiency in SQL development, query tuning, and data analysis.
• Experience in data modeling, Power Query, and DAX.
• Knowledge of reporting automation and business process improvement.
• Experience working with enterprise data platforms and multiple data sources.
• Strong analytical, problem-solving, and stakeholder management skills.
• Ability to gather and document business requirements effectively.

Preferred Skills

• Exposure to Accounts Payable, Inventory Management, Capital Reporting, and Operational Reporting processes.
• Experience with PeopleSoft, Infor LN, Databricks, Hadoop, MES, and SharePoint.
• Understanding of workflow automation and document management processes.
• Experience supporting UAT, deployment, and business process transformation initiatives.