<p>MPS Group, Inc., is seeking a detail-oriented and technically skilled ERP Systems Administrator & Reporting Analyst to join our team at Headquarters located in Farmington Hills, MI. This individual is responsible for managing and enhancing our Microsoft Dynamics GP ecosystem, support SQL Server operations, and deliver impactful business insights through SSRS (SQL Server Reporting Services) and Power BI reporting. This role bridges the gap between Operations, Finance, and IT.</p> <p>Shift Details:</p> <p>Shift: 1st Shift</p> <p>Schedule: Monday- Friday, 8:00 a.m. - 4:00 p.m.</p> <p>Responsibilities and Job Duties:</p> <ul> <li>Administer and support Microsoft Dynamics GP, including user security management, module configuration, year-end processes, and coordination of version upgrades with vendors. </li><li>Support the Payroll team and maintain our Payroll process within MS Dynamics GP including payroll processing and troubleshooting payroll calculation issues. </li><li>Design, develop, and maintain SSRS reports tailored to business requirements across departments. </li><li>Build dynamic dashboards and visuals in Power BI to present actionable insights on business metrics. </li><li>Manage the SSRS report catalog and Power BI workspace environments, including access controls, publishing pipelines, and report version management. </li><li>Collaborate with Operations, Finance, and IT stakeholders to understand reporting needs and translate into technical solutions. </li><li>Maintain and optimize Microsoft SQL Server databases, including performance tuning, query optimization, index maintenance, and capacity planning. </li><li>Write and maintain T-SQL stored procedures, views, and functions supporting ERP and reporting workflows. </li><li>Design, maintain, and troubleshoot API, file-based, and scheduled data integrations between Dynamics GP, payroll, CRM, and other third-party systems, ensuring data consistency and timely processing. </li><li>Maintain system security, user access controls, and audit logs in accordance with internal IT policies and data governance standards. </li><li>Provide Tier 2/3 technical support for ERP-related issues, triaging problems, escalating when appropriate, and maintaining a knowledge base of resolutions. </li><li>Develop, support, and administer various applications utilized by our Operations teams. </li><li>Support or lead data migration efforts between ERP platforms, including data mapping, validation, and cutover planning. </li><li>Perform database lifecycle tasks including backups, restores, and archiving. </li><li>Lead or actively contribute to ERP enhancement projects, including requirements gathering, UAT coordination, and phased rollouts. </li></ul> <p>Requirements and Qualifications:</p> <ul> <li>Minimum of three years proven experience with Microsoft Dynamics GP administration, support, and configuration. </li><li>Experience supporting payroll processing and troubleshooting within Dynamics GP or a comparable ERP system. </li><li>Strong proficiency in Microsoft SQL Server, including T-SQL development (stored procedures, views, functions), performance tuning, and database administration tasks. </li><li>Solid experience with SSRS report development, including report catalog management and deployment. </li><li>Solid understanding of Power BI, including DAX, data modeling, and workspace management. </li><li>Experience designing and maintaining data integrations using APIs, file-based exchanges, or ETL processes between ERP and third-party systems. </li><li>Experience with ERP data migrations, including data mapping, validation, and cutover planning. </li><li>Experience with database security roles, permissions, and audit log management. </li><li>Strong analytical and problem-solving skills with experience providing Tier 2/3 application support. </li><li>Ability to work independently and cross-functionally with Operations, Finance, and IT teams. </li><li>Excellent communication, documentation, and stakeholder management skills. </li></ul> <p>Preferred Qualifications:</p> <ul> <li>Familiarity with financial processes, accounting principles, and payroll regulations. </li><li>Experience with integration platforms or middleware such as SSIS and/or SmartConnect for ERP data integration workflows. </li><li>Experience with the Microsoft Power Platform, including building Power Apps solutions and automating business workflows using Power Automate. </li><li>Familiarity with Microsoft Dataverse or experience connecting Power Platform solutions to external data sources such as SQL Server or ERP systems. </li><li>Awareness of, or experience with, Microsoft Dynamics 365 Business Central, particularly in the context of ERP migration planning. </li><li>Microsoft certifications in SQL Server, Azure Data, Power BI, or Dynamics 365 are a plus. </li><li>Experience working in an Agile or IT project management environment. </li></ul>