ERP Systems Architect – Dynamics AX & SQL Reporting

ElectroCraft; Gallipolis (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

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.

Qualifications

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

Responsibilities

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

Skills

SQL optimization

T-SQL development

Stored procedures

Views & data design

Performance tuning

Database maintenance

Data governance

Disaster recovery planning

Problem solving

Analytical thinking

Education

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

Job description

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.