MOC - Business Analyst

Job Title: Business Analyst
Department: Analytics
Supervisor: Chief Accounting Officer and Lead Business Analyst
Status: At will, Full Time, Non-exempt
WC Code: 8810 - Clerical/Office
EEO Class: 2 – Professionals
Pay Code: 4 Pay Range : 35.00/hr. – 37.00/hr.
Hours: Monday – Friday, 8:00 a.m. – 5:00 p.m., with after-hours as needed
Websites: http://www.assemi-group-careers/
Compensation: Commensurate with experience. Exceptional benefits package, including health, dental, vision, retirement, and daycare benefits

Position Description:
Under the general supervision of the Manager of the Analytics team. The Business Analyst will provide relevant and insightful analysis of organizational data, operate as an individual or member of a project group, and will contribute in the daily collection, research, and publication of data

Essential Functions/Accountabilities:
o Collect and maintain datasets in a timely and accurate basis, from source to product. This includes the creation, maintenance and application of data acquisition, transformation and delivery process.
o Quality Assurance – Build and employ automated and manual processes to monitor and address data quality issues, including outliers, missing values, duplicates, and errors as a part of the daily or weekly data updates.
o Identify and research data irregularities to promote accuracy and insight.
o Use the organizations' database software to upload, download, manage, and summarize data with the purpose of assisting end users in making accurate and informed decisions.
o Support the organization’s decision-making process through analysis, reporting, research and effective use of data generation from internal and external information systems.
o Properly identify the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
o Generate standard and ad-hoc reports that are to be used both in cross-functional areas and business lines.
o Financial Modeling Assistance- aid in the creation and improving financial models, scenarios, proformas, and spreadsheets used for tracking data.
o Help with dashboard creation for management of the company.
o Training – assist in creating and delivering internal training classes on basic, intermediate, and advanced Excel analysis and best practices for data modeling.
o Help with the organization and structure of data in ECM (M-Files) and databases. May assist with designing business processes and workflow in M-Files.
o Data normalization – Scrub data and normalizing data. Help with ETL and processing of data between different applications for purposes of integration of data sources.
o Become a subject matter expert in data/financial analysis tools, (IE: Adaptive Insights, Excel, Power BI tools for Excel, Etc.), to help other members of analytics team.

Supervisory Responsibility:
o None

Work Environment:
o This job operates within the professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.

Physical Demands:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job with or without reasonable accommodations.

o While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands and fingers to handle or feel; and reach with hands and arms. The employee is frequently required to sit; climb or balance; and stoop, kneel, crouch or crawl. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

Position Type/Expected Hours of Work:
o This is a full time at will position, and work hours are typically Monday through Friday 8:00 a.m. to 5:00 p.m. Occasional evening and weekend work may be required as department needs demand.

Travel:
o Travel is occasional and local during the business day.

Work Authorization:
o Must be eligible to work in the United States

Minimum Requirements
o Prior experience working in agriculture/farming operations helpful
o Experience working with ERP preferred (IE: Famous, Newstar, MS Dynamics)
o Business Intelligence software knowledge, Adaptive Insights, Power BI a, is preferred
o Advanced knowledge of Microsoft Excel is a must.
o Proficiency with VBA for Excel is a plus.
o Experience with SQL and/or Microsoft Access is a plus.
o Knowledge of programming language to manipulate data/conduct statistical analysis is a plus. (IE: Python or R)
o Demonstrated proficiency in Microsoft Office and related software programs.
o Technologically savvy and able to demonstrate competence in a variety of technological platforms and processes.
o Ability to communicate in a clear, friendly, professional and proactive manner.
o Ability to work under pressure while maintaining perspective and respect for others.
o High degree of confidentiality and attention to detail.
o Ability to multi-task and meet deadlines.
o Ability to work in a fast-paced, multi-entity and multi-cultural environment.
o Strong people skills.

This job description documents the general nature and level of work but is not intended to be a comprehensive list of all activities, duties and responsibilities. Job incumbents may be asked to perform other duties as required.