ERP Systems Specialist

ElectroCraft; Gallipolis (OH); Vor Ort; USD 90.000 - 120.000; Vollzeit

Zusammenfassung

ElectroCraft, Inc. seeks an ERP Systems Specialist to own Dynamics AX 2012 environments, SQL Server databases, and related business systems across manufacturing, finance, and supply chain. You will ensure stability, security, and performance while supporting reporting and analytics for multiple departments.

Key responsibilities include module configuration, security, data integrity, and collaboration with stakeholders to implement process improvements and ERP upgrades.

Qualifikationen

• Experience supporting Microsoft Dynamics AX 2012 or similar ERP systems is required.
• Strong SQL Server administration and database maintenance skills are essential.
• Ability to design reports and dashboards using SSRS and Power BI.

Aufgaben

• Serve as technical owner for Dynamics AX 2012 environments including Prod, Test, Dev, and Training.
• Administer ERP modules: Manufacturing, Inventory, Purchasing, Supply Chain, Finance, and Operations.
• Maintain system configuration, security roles, user access, and segregation of duties.
• Develop and optimize SQL queries, views, procedures, and data models.
• Design and maintain enterprise reports and KPIs using SSRS and Power BI.
• Support data governance, data quality, and integrations with external systems.

Kenntnisse

SQL optimization

T-SQL development

Stored procedures

Views & data design

Performance tuning

Database maintenance

Data governance

Disaster recovery planning

Problem solving

Analytical thinking

Ausbildung

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

Tools

Microsoft Dynamics AX 2012

Microsoft SQL Server

SSRS

Power BI

Jobbeschreibung

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.

Job Summary

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.

ERP Administration & Support

• 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.
• Troubleshot 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.

SQL Database Administration & Development

• 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.

Reporting, Analytics & Data Solutions

• 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.

Manufacturing Systems & Business Process Support

• 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.

Data Governance & System Integration

• 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.

Education Requirements

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

Preferred Experience or Skills

• Bachelor's degree in information technology, Computer Science, Information Systems, Business, or equivalent work 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.