Business Analyst - Power Platform

Mill Steel Co.; Grand Rapids (MI); Hybrid; USD 75,000 - 110,000; Full time

Job summary

Mill Steel Co. in Grand Rapids, MI, seeks a Business Analyst – Power Platform to design, implement, and maintain enterprise solutions across the Power Platform, building scalable automation and AI-driven capabilities using Copilot Studio, Power Automate, Power Apps and Power BI.

You will collaborate with business users to define KPIs, ensure data quality and performance, and support integrations with D365 F&SCM, SharePoint, and Dataverse as part of ongoing modernization efforts.

Qualifications

• Bachelor’s degree in Business, Information Systems, or related field.
• Experience with Power Platform tools (Power Apps, Power Automate, or Power BI).
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Develop AI agents and copilots using Copilot Studio.
• Build and maintain Power Automate workflows for process automation.
• Create and enhance Power Apps applications (Canvas and Model-Driven).
• Support Power Pages solutions (e.g., portals, secure user experiences).
• Partner with business users to define KPIs and reporting requirements.
• Ensure data accuracy, usability, and performance optimization.
• Assist with Power Platform integrations across enterprise systems (e.g., D365 F&SCM, SharePoint, Dataverse).
• Troubleshoot issues across applications, workflows, and data pipelines.
• Gather and translate business requirements into technical solutions.
• Identify opportunities for automation and process improvement.
• Create and maintain documentation, job aids, and knowledge assets.

Skills

Power Platform

Analytical thinking

Communication

Education

Bachelor’s degree in Business/Information Systems or related field

Tools

Copilot Studio

Power Apps

Power Automate

Power BI

Dataverse

D365 F&SCM

Job description

Reports To: Business Analytics Manager
Location: Grand Rapids, MI

Position Summary

The Business Analyst – Power Platform supports the design, development, and maintenance of enterprise solutions across Microsoft's Power Platform ecosystem. This role focuses on building scalable solutions that enhance business processes, enable automation, and expand AI-driven capabilities using tools such as Copilot Studio, Power Automate, Power Apps, and Power BI.

Key Responsibilities

Power Platform Development

• Develop AI agents and copilots using Copilot Studio
• Build and maintain Power Automate workflows for process automation
• Create and enhance Power Apps applications (Canvas and Model-Driven)
• Support Power Pages solutions (e.g., portals, secure user experiences)

Analytics & Reporting

• Partner with business users to define KPIs and reporting requirements
• Ensure data accuracy, usability, and performance optimization

Systems & Integration Support

• Assist with Power Platform integrations across enterprise systems (e.g., D365 F&SCM, SharePoint, Dataverse)
• Troubleshoot issues across applications, workflows, and data pipelines

Business Analysis

• Gather and translate business requirements into technical solutions
• Identify opportunities for automation and process improvement
• Create and maintain documentation, job aids, and knowledge assets

Qualifications

Required:

• Bachelor’s degree in Business, Information Systems, or related field
• Experience with Power Platform tools (Power Apps, Power Automate, or Power BI)
• Strong analytical, problem-solving, and communication skills

Preferred:

• Experience with Copilot Studio / AI solutions
• Exposure to D365 F&SCM (ERP), Dataverse, or system integrations
• Familiarity with DAX, data modeling.
• Technical curiosity (AI, automation, low-code tools)
• Strong collaboration across business and IT teams