Business Analyst

Business Analyst

We are looking for someone with a passion for innovation who will seek, develop, and help implement strategic initiatives for improved efficiency and productivity. This person will help scale and enhance our systems and processes to effectively support our continued growth. From researching systems solutions to evaluating their impacts, the ideal candidate will be a detailed planner, expert communicator, and top-notch analyst. This person should be comfortable wearing many hats and wholly committed to rolling up their sleeves to do what it takes to ensure the success of multiple projects.

Objectives of this role

• Drive awareness of requirements across business units and identify substandard systems processes through evaluation of real-time data
• Leads discovery conversations with stakeholders to identify business needs and process gaps and designs systems prototypes that promote increased efficiency and productivity on multiple levels
• Create and implement precise management plans for every project, with attention to transparent communication at all levels
• Perform, evaluate, and communicate thorough quality assurance at every stage of systems development
• Determine and develop user requirements for systems in production, to ensure maximum usability
• Develop reporting and dashboards that help stakeholders make informed decisions and track KPI's
• Develop documentation of customized programming and support their maintenance

Responsibilities

• Partner with stakeholders across business units (ex: sales, finance, operations) to develop analyses and documentation in a collaborative way, communicating effectively and efficiently with production, managerial, and executive teams
• Evaluate, analyze, and communicate systems requirements on a continuing basis, and maintain systems processes, including the delivery of monthly status reports to all appropriate parties
• Author and update internal and external documentation, and formally initiate and deliver requirements and documentation
• Conduct daily systems analytics to maximize effectiveness and troubleshoot problems
• Establish meaningful and lasting relationships with developers, consultants and stakeholders for optimized systems integration
• Develops and maintains a knowledge base of best practices for end users
• Maintains security administration of ERP system and ensures users have proper access levels to the appropriate functionality
• Manage tasks of 3rd party developers and consultants to ensure completion within timeline of overall projects
• Work with stakeholders to develop reporting that helps them achieve departmental goals and drive strategic business decisions.
• Perform tasks as needed to deliver project or task completion, such as but not limited to; engaging in data cleanup, updating access controls, system configuration, system administration, and developing custom fields.
• Other duties as assigned

Required skills and qualifications

• Five or more years of experience in analytics and systems development
• High proficiency with SQL, ability to create views, custom fields, and build queries
• Experience in generating process documentation and reports
• Excellent communication skills, with an ability to translate data into actionable insights
• Proven ability to manage multiple projects and user testing
• High proficiency in Excel and PowerBI
• Working knowledge of ERP systems
• High attention to detail
• Results Driven

Preferred skills and qualifications

• Bachelor's degree (or equivalent) in information technology or computer science
• Experience in a manufacturing environment
• Experience with data visualization and creating dashboards
• High proficiency in technical writing
• Experience with Sage 300 or Accpac
• Experience developing, interpreting, and maintaining Programming/Scripting using SQL, Python, XML, JSON, API, VBA

Desired Skills and Experience

VBA

PowerQuery

PowerBI

SQL

DAX