Senior IT BA/ERP/Reporting Administrator

About the role

The Senior IT Business Analyst (BA) / ERP / Reporting Administrator is a senior-level technical and functional role responsible for the strategic management, optimization, and support of the organization’s Enterprise Resource Planning (ERP), reporting, and manufacturing-integrated systems. This position serves as a key subject-matter expert and trusted advisor to business and IT leadership, bridging complex business requirements with scalable technical solutions.

Key Responsibilities

• Microsoft Dynamics AX/ERP Administration & Architecture (Senior-Level)
• Serve as the senior administrator and functional owner of the organization’s Microsoft Dynamics ERP system.
• Configure and optimize Microsoft Dynamics modules supporting manufacturing, finance, inventory, supply chain, and operations.
• Maintain ERP security architecture including roles, permissions, segregation of duties, and audit compliance.
• Lead Microsoft Dynamics migrations, upgrades, patches, vulnerability testing, and deployments with minimal business disruption.
• Proactively monitor system health, performance, and data integrity; resolve complex issues and root causes.
• Establish and maintain Microsoft Dynamics standards, documentation, and best practices.
• Manufacturing Systems Integration (Required)
• Lead and support integrations between IT and Manufacturing-related systems such as MES, shop-floor systems, EDI, inventory automation, and third-party manufacturing applications.
• Partner with manufacturing and operations teams to ensure accurate production, inventory, costing, and scheduling data flows.
• Support manufacturing data structures including BOMs, routings, work orders, labor, and material consumption.
• Troubleshoot and resolve manufacturing-to-ERP data and transaction issues.
• Business Analysis & Process Leadership
• Act as the senior liaison between IT and business stakeholders across Manufacturing, Finance, Operations, Supply Chain, and Leadership.
• Lead requirements gathering, functional design, gap analysis, and solution architecture.
• Identify and drive process improvements, automation opportunities, and system enhancements.
• Mentor junior analysts or administrators as applicable.
• Support organizational change management and user adoption initiatives.
• Reporting, Analytics & Data Engineering (Required)
• Architect, develop, and maintain enterprise reporting and analytics solutions using Power BI, SQL, and SSRS.
• Design and optimize SQL queries, views, stored procedures, and data models to support reporting and analytics.
• Develop executive dashboards, operational reports, and manufacturing KPIs.
• Ensure reporting accuracy, consistency, performance, and scalability.
• Parenthetize stakeholders to define metrics, KPIs, and data governance standards.
• Integration, Data Governance & Compliance
• Oversee ERP and reporting data governance, master data management, and validation processes.
• Lead data migration, understanding, and integrity initiatives.
• Support internal controls, audits, and compliance requirements related to Microsoft Dynamics AX and reporting systems.

Basic and Social Skills, Leadership, and Business

• Strategic Thinking: Make IT decisions aligned with business and production goals.
• Initiative & Ownership: Take responsibility for the IT environment and lead improvement projects within role responsibility.
• Cross-Functional Collaboration: Work effectively with production, engineering, office, and vendor teams.
• Cost Awareness: Recommend solutions that balance performance, reliability, and cost.
• Communication: Clearly explain technical concepts to non-technical staff.
• Collaborate effectively with a wide range of coworkers and departments.
• Provide thoughtful, respectful support to users with varying technical skill levels.
• Represent the IT function with integrity, reliability, and confidentiality.
• Demonstrate a helpful, customer-focused mindset in all interactions.
• Manage misunderstandings or miscommunications constructively.
• Build trust with others through own authenticity and follow-through on commitments.
• Values and supports diversity in the workplace.
• Ensures thorough familiarity with company policies and procedures. Properly applies policies and procedures in compliance with government laws. Policies and procedures include, but not limited to: ISO 9000 & 14000, government regulations and functional policies.

Education Requirements

• Bachelor’s degree in information technology, Business Administration, Computer Science, or related field with equivalent experience.

Preferred Experience or Skills

• 7+ years of progressive experience supporting and administering Microsoft Dynamics AX in a manufacturing environment.
• Hands-on expertise with Power BI, SQL, and SSRS (required).
• Direct experience in integrating ERP systems with manufacturing/MES environments (required).
• Strong understanding of manufacturing, supply chain, finance, and operational business processes.
• Proven ability to lead complex system analysis, design, and optimization efforts.
• Advanced analytical, problem-solving, and documentation skills.
• Strong communication skills with the ability to influence both technical and non-technical stakeholders.
• Experience with ERP platforms such as Microsoft Dynamics AX / D365, SAP, Oracle, or equivalent.
• Advanced SQL development and performance tuning experience.
• Experience supporting multi-site or global manufacturing operations.
• Experience mentoring or leading other ERP or BI team members.
• Senior ERP Administration & Architecture
• Manufacturing Systems Integration
• Power BI, SQL & SSRS Expertise
• Business Process Optimization

Physical Requirements

• Ability to stand or sit for prolonged periods of time.
• Ability to occasionally climb, stoop, bend, kneel, crouch, reach, and twist.
• Ability to lift and carry office equipment or equipment required for responsibilities (typically up to 25lbs).
• Ability to work in climate controlled and non-controlled environments.