The BA Business Analyst/Business Systems Analyst role is primarily responsible for the creation, modification, and maintenance of business reports and reporting systems and supports the selection, implementation, and maintenance of business software systems. The BA/BSA also assists with the development and maintenance of the ERP system, and all other data producing and storage systems, such as the Quality Management System and the Data Warehouse.
The incumbent must be capable of working in all phases of business systems product life-cycle, and must be able to apply business and process knowledge as well as technical skills, to systems development and support. Support of legacy systems is required.
An IT professional from a Public Accounting, Manufacturing Forensics, or IT Audit background is preferred, and financial consolidation and finance knowledge helpful.
Duties & Responsibilities:
Develop and maintain an in-depth understanding of the business software products and processes used by the organization
Develop a strong understanding of business strategies and objectives
Elicit or expand upon information requirements for reports and projects using interviews, document analysis, storyboards, requirements workshops, business process descriptions, scenarios, and task and workflow analysis
Understand systems and operational requirements, downstream system impacts, and legal compliance issues
Recommend implementation of features and functions where appropriate.
Handle several implementation tasks and/or projects at any given time
Provide business support for all company operations as required, including but not limited to physical inventory counts, scheduling, reporting, etc.
Practice standard project management and time management skills and provide progress updates
Bachelor’s degree in Business, Computer Information Systems or related field or equivalent experience
Minimum of five years of experience as a business analyst and/or systems analyst
Minimum of two years of SQL experience with the ability to write ad hoc reports and complex queries in order to perform data analysis
Experience with designing and implementing a Data Warehouse including management of the ETL process(es)
Experience with the Microsoft BI stack, including SQL Server (SSIS, SSAS, SSRS), SharePoint (Excel Services, PowerPivot, Performance Point), Bing Maps, Office (Excel-Power Pivot) and Power BI
Excellent written, verbal, and presentation skills, with an ability to express complex technical concepts in business terms
Strong problem-solving and analytical skills and a demonstrated attention to detail
Ability to multi-task and understand prioritization of deliverables
Ability to communicate technical concepts to non-technical personnel
Crystal Report writing experience required, experience with other report writing platforms a plus
Must be able to work in a dynamic environment, with multiple projects and deadlines
Understanding of Finance and Accounting as it relates to business systems (P&L, balance sheet structure, reporting and transactional data flow, i.e. order to shipment)
Process mapping and process analysis experience highly desirable