Reporting Administrator

Hansen Corporation•Princeton, IN

About The Position

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. This role requires deep hands-on expertise in Microsoft Dynamics administration, manufacturing system integration, and enterprise reporting platforms including Power BI, SQL, and SSRS. The Senior Administrator drives data-driven decision-making, system reliability, and continuous process improvement across manufacturing, finance, supply chain, and operations. About Our Company ElectroCraft, Inc. provides application-engineered specialty fractional-horsepower motor and motion control products. Under the hood, Electrocraft motion systems power critical components of some of the world's most innovative products in medical equipment, robotics, industrial automation, agriculture, and lab equipment. Some of our innovative products include DC motors, gear motors, linear actuators, and motor drives. With facilities and customers around the globe, ElectroCraft provides advanced precision solutions with the highest reliability and lowest total cost of ownership, which is why it is trusted by both the largest brands and the newest cutting-edge companies.

Requirements

Bachelor’s degree in information technology, Business Administration, Computer Science, or related field with equivalent experience.
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.
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.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.
Partner with stakeholders to define metrics, KPIs, and data governance standards.
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
Make IT decisions aligned with business and production goals.
Take responsibility for the IT environment and lead improvement projects within role responsibility.
Work effectively with production, engineering, office, and vendor teams.
Recommend solutions that balance performance, reliability, and cost.
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.