Business Analyst/ERP Administrator

Job Title (Internal): Business Analyst/ERP Administrator

Job Title (Market/External): Business Analyst/ERP Administrator

Division: Arrowhead- Regal Rexnord

Reprts to: Director of IT

Job purpose

The ERP Administrator within Information Technology will work closely with Manufacturing business owners to understand business processes, workflows, and their relationships to current and future solutions.  This role will create detailed business requirements, system documentation, and implement quality software solutions. This role will need to utilize multiple techniques to elicit, document and validate the requirements with all stakeholders.

In addition, this position is responsible for keeping databases up and running smoothly with the goal to provide a seamless flow of information throughout the organization, considering both backend data structures as well as frontend accessibility for end-users. 

Duties and responsibilities

These duties are not meant to be all-inclusive and other duties may be assigned.

Application Administration (50%)

• Providing software application support; troubleshooting and resolve production problems  analyzing reports and queries to uncover errors or problems.  Decide if errors are a result of data entry or programming and take necessary steps to correct errors or assist in resolving.  
• Test and review user screens and report bugs, errors, issues, etc. establishing the root causes of application errors and escalating serious concerns to leadership.
• Keeping record of configuration changes and scheduling application updates.

•  Analyze ERP system upgrades, with regards to impact, pros/cons and report possible impacts to financials and data integrity; assist with detailed testing plans and facilitate and monitor testing of major system upgrades as it pertains to security administration, system reporting software, and interface functions.

• Assist other disciplines in thorough documentation (workflow) on infrastructure, integrations, processes, and policies, etc. as well as any changes made to existing systems as it impacts financial data and integrity.
• Maintain knowledge on the current and future version of the company ERP System (Visual). Attend training, conferences, and learning events as necessary.  

Business Intelligence and Reporting (30%)

• Apply data warehouse (DW) and business intelligence expertise to support the technical needs of our internal customers.
• Using the Microsoft suite of products, write queries to deliver data, reports, and ad-hoc reporting capabilities to business users.
• Assist in designing and maintaining ETL solutions to support and maintain our data warehouse
• Creating technical documents that outline the purpose, capacity, and guidelines 

Database Administration (20%)

• Monitoring database system performance and identifying problems that arise.
• Protecting the database against threats or unauthorized access.
• Ensuring that the database is adequately backed up and able to be recovered in the event of memory loss.
• Reporting on metrics regarding usage and performance.
• Suggesting changes and improvements for maintenance or protection.

Qualifications

Education & Certifications:

• Bachelor’s or technical degree in the field of computer science or management information systems or a related discipline.

Knowledge & Experience:

• 5+ years of experience in Business Analysis, Information Technology, or in a related area, preferably in a manufacturing company.

• 3+ years of experience and strong SQL skills: ability to code complex SQL queries and tune for best performance; create and maintain stored procedures & functions; create and maintain database objects 

• Experience with ERP systems in a manufacturing environment is required, preference for experience with Infor VisualERP. 

• Advanced knowledge of programming languages, such as SQL Reporting Services, SQL Integration Services, VBA, C# and .NET; with a preference for more than one of these.

• Experience and proficiency with various web-based software applications including Microsoft Office Word, Excel, PowerPoint, SharePoint, etc.

Personal Attributes:

• Strong critical thinking, problem solving and decision-making skills with the ability to investigate and weigh alternatives and select the course of action that provides the greatest benefit to the organization.
• Creative thinking skills with the ability to ask the needed bigger-picture questions that lead to process improvements
• Excellent project management skills, effective multi-tasking, time-management skills, with the ability to prioritize tasks.
• Good written and oral communication skills; good interpersonal skills.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.

Working Conditions

• Participate in on-call rotation, ensuring proper resolution to escalated issues.

• Sitting for extended periods of time.
• Dexterity of hands and fingers to operate a computer keyboard, mouse, and other computer components.
• Lifting and transporting of moderately heavy objects, such as computers and peripherals.

 Regal Rexnord Automation Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.