ERP Systems Specialist

ElectroCraft Ohio Inc•Green Township, OH

13h

About The Position

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. We are seeking a highly skilled and detail-oriented ERP Systems Specialist to join our dynamic team. In this role, you will serve as the technical owner and subject matter expert for our Microsoft Dynamics AX 2012 environment, Microsoft SQL Server databases, and related business systems. Your expertise will be vital in maintaining the stability, security, and performance of our ERP platform, supporting key business functions across manufacturing, finance, supply chain, operations, and reporting.

Requirements

Bachelor’s degree in information technology, Business Administration, Computer Science, or related field with equivalent experience.
Minimum 3 years of experience supporting Microsoft Dynamics AX 2012 or comparable ERP systems.
Minimum 3 years of experience administering Microsoft SQL Server environments.
Strong experience with T-SQL development, Query optimization, Stored procedures, Views and database design, Performance tuning, Database maintenance.
Experience developing reports using SSRS and SQL reporting tools.
Experience supporting manufacturing business processes and ERP workflows.
Strong analytical, troubleshooting, and problem-solving skills.
Ability to communicate effectively with both technical and non-technical users.
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.
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.
Teamwork: Collaborate effectively with a wide range of coworkers and departments.
Empathy & Patience: Provide thoughtful, respectful support to users with varying technical skill levels.
Professionalism: Represent the IT function with integrity, reliability, and confidentiality.
Service Orientation: Demonstrate a helpful, customer-focused mindset in all interactions.
Conflict Resolution: 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. Appropriately applies policies and procedures in compliance with government laws. Policies and procedures include, but not limited to: ISO 9000 & 14000, government regulations (e.g. health, safety, quality and environment), and functional policies.

Nice To Haves

Bachelor’s degree in information technology, Computer Science, Information Systems, Business, or equivalent work experience.

Responsibilities

Serve as the primary technical resource for Microsoft Dynamics AX 2012.
Administer and maintain Production, Test, Development, and Training environments.
Configure and support ERP modules including Manufacturing, Inventory, Purchasing, Supply Chain, Finance, and Operations.
Manage system configuration, security roles, user access, and segregation of duties.
Monitor application performance and proactively identify opportunities for improvement.
Troubleshoot system issues, transaction errors, workflow failures, and data inconsistencies.
Coordinate testing, upgrades, patches, system enhancements, and application changes.
Develop and maintain ERP support documentation, standards, and procedures.
Administer and support Microsoft SQL Server databases supporting Dynamics AX and related business applications.
Monitor database health, performance, storage, and availability.
Develop and optimize SQL queries, views, stored procedures, functions, and data models.
Manage database maintenance activities including backups, restores, indexing, statistics updates, and integrity checks.
Identify and resolve database performance bottlenecks and data-related issues.
Support disaster recovery planning, testing, and database recovery activities.
Implement and maintain database security and access controls.
Design, develop, and maintain enterprise reporting solutions using SQL, SSRS, and Power BI.
Create operational reports, executive dashboards, manufacturing KPIs, financial reports, and business analytics solutions.
Develop and maintain datasets, reporting structures, and data models.
Validate report accuracy and ensure consistency across reporting platforms.
Collaborate with stakeholders to define business metrics, KPIs, and reporting requirements.
Support enterprise reporting standardization and data governance initiatives.
Support business processes related to manufacturing, production planning, inventory management, purchasing, and supply chain operations.
Assist with data structures including Bills of Material (BOMs), routings, work orders, inventory transactions, costing, and production reporting.
Analyze business requirements and recommend system improvements.
Partner with business users to identify automation opportunities and process efficiencies.
Provide technical and functional support to users across multiple departments.
Maintain data quality, consistency, and integrity across ERP and reporting systems.
Support data imports, exports, migrations, validation, and cleansing efforts.
Assist with integration support between ERP, reporting, manufacturing, and third-party systems.
Support audit requests, compliance reviews, and internal control activities.
Maintain technical documentation for data flows, integrations, and business systems processes.
Participate in ERP modernization and future ERP migration initiatives.