Senior ERP & Power Platform Solutions Architect

The speed of technology is changing how we work and live. Access Michigan, LLC is a manufacturer’s representative that is in the business of building the electric and mechanical infrastructure that supports the digital world. Over the next five years over 100 billion IoT devices will be added to the global network. The IT spaces that support this growth run on uninterrupted power, HVAC, power generation and monitoring systems that we design, supply, and service.

Over 70% of US data centers utilize our represented manufacturers equipment, Vertiv, Packet Power, Raycap, and many others. We are also heavily involved in the design, sale, service, and implementation of HVAC equipment that serves hospitals, government, commercial and industrial applications.

We are driven by our Core Values of Be the Best You, Put Others Before Yourself, Act like an Owner, Doing it for the Right Reason and Enjoy the Ride
. We acknowledge that our success is a direct result of our empowered, hard-working, and dedicated employees.

The Senior ERP & Power Platform Solutions Architect is responsible for the architecture, design, delivery, integration, and ongoing improvement of core business systems centered on Microsoft Dynamics, Spectrum ERP, Microsoft Power Platform, Dataverse, Power BI, Azure Dev Ops, and Vertiv OSC-connected workflows.

This role bridges business process design, enterprise application architecture, data modeling, automation, analytics, systems integration, and delivery governance. The position is ideal for a senior technical professional who can translate operational and financial requirements into scalable, supportable, and secure business application solutions.

• Define the target architecture, solution patterns, technical standards, and design approach for ERP-connected business applications and integrations.
• Lead solution design across Microsoft Dynamics, Spectrum ERP, Dataverse, Power Platform, Power BI, Azure Dev Ops, and external operational systems.
• Evaluate business requirements and design scalable, maintainable, and supportable technical solutions aligned to operational goals.
• Establish architectural guardrails for data integrity, workflow reliability, security, supportability, and long-term platform sustainability.
• Produce and maintain solution diagrams, design documentation, integration specifications, data mappings, and support artifacts.

• Architect, configure, extend, and support Microsoft Dynamics-based business applications, workflows, data structures, and business processes.
• Support Spectrum ERP integration, enhancement, and optimization for finance, service, inventory, operations, and related workflows.
• Work with business stakeholders to improve process efficiency, system usability, reporting quality, and application adoption.
• Identify opportunities to simplify fragmented manual processes through workflow redesign, automation, and system integration.

• Design and govern solutions using Microsoft Power Platform, including Power Automate and Dataverse-based applications and data models.
• Define Dataverse table structures, relationships, security roles, business rules, and environment-management practices.
• Oversee automation design for approvals, notifications, exception handling, integrations, and process orchestration.
• Ensure Power Platform solutions follow sound lifecycle, deployment, governance, and support practices.

• Architect and support Power BI datasets, semantic models, dashboards, and reporting solutions for operational and management decision-making.
• Define reporting patterns, data logic, and KPI structures that improve trust in ERP and business-system reporting outputs.
• Partner with stakeholders to prioritize reporting needs and translate them into scalable analytics solutions.
• Improve data consistency and reporting reliability across business systems and connected applications.

• Architect and support integrations among Microsoft Dynamics, Spectrum ERP, Dataverse, Power Platform components, Vertiv OSC, and other internal or external systems.
• Define integration methods, transformation rules, synchronization logic, scheduling, reconciliation, monitoring, and exception-management practices.
• Lead troubleshooting and remediation for integration failures, data mismatches, and process breakdowns across connected systems.
• Coordinate with vendors, internal…