ERP Systems Specialist

ElectroCraft, Inc.; Northern (KY); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

401(k) with company match

Paid time off and holidays

Job summary

ElectroCraft, Inc. seeks an ERP Systems Specialist to own and optimize Microsoft Dynamics AX 2012, SQL Server databases, and related business systems. You will support manufacturing, finance, supply chain, operations, and reporting with stability and security of the ERP platform.

The role involves configuring ERP modules, maintaining environments, developing reports with SSRS/Power BI, and ensuring data quality and governance across enterprise systems.

Qualifications

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

Responsibilities

• Design, implement, and maintain ERP configurations and modules across Manufacturing, Inventory, Purchasing, Supply Chain, Finance, and Operations.
• Monitor ERP performance, security roles, user access, and segregation of duties; coordinate upgrades and patches.
• Develop reports and data models using SQL, SSRS, and Power BI for operational and executive dashboards.
• Support data governance, migrations, and integration between ERP, reporting, and third‑party systems.
• Provide technical and functional support to users across departments; drive process improvements in manufacturing and supply chain.

Skills

Microsoft Dynamics AX 2012

SQL Server

SSRS

Power BI

T-SQL

Education

Bachelor’s degree in IT, Business Admin, CS or related

Tools

Microsoft SQL Server

SSRS

Power BI

Job description

Description

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.

Requirements

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.

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.

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.

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.

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.

The above statements are intended to describe the general nature and level of work being performed by people assigned to the job. They are not intended to be an all‑encompassing list of all responsibilities, duties and skills required of personnel so classified.

What We Offer

Competitive salary based on experience

Health, dental, and vision insurance

401(k) with company match

Paid time off and holidays

Opportunity to grow in a dynamic, technology‑driven manufacturing environment

A respectful and inclusive workplace culture

Equal Employment Opportunity (EEO) Statement

ElectroCraft is an Equal Opportunity Employer. We are committed to creating a diverse environment and are proud to be an employer of choice. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, or any other legally protected status.

Harassment Policy

ElectroCraft maintains a strict policy prohibiting harassment of any kind in the workplace. We are committed to fostering a professional and respectful work environment where all individuals are treated with dignity and fairness. Violations of this policy are taken seriously and addressed in accordance with our internal complaint and disciplinary procedures.