Job Title:  Business Data Analyst II- Outside Plant Field Service

Job Purpose

The Business Analyst is responsible for the implementation of standard processes and reports for OSP Field Services Projects planning and control. Key processes include both sales order management and inventory management. This position will work within a team environment consisting of Project Managers, Customer Service, Finance & Accounting, Field Service Leadership, and other supporting staff as well as vendors and customers. The ideal candidate will have strong analytical and problem-solving mindset, and excellent research and presentation skills, combined with expert level MS Excel skills. They will be responsible to retrieve, review and analyze both customer sales order data and field inventory data in order to build key metric reports. They develop, capture and report KPI’s relevant to our customers.

Essential Duties and Responsibilities

• Prepare, process, and analyze customer order and inventory data to help inform business decisions.
• Create reports on an as needed basis by researching and collating data in SAP, Sharepoint, GoCanvas, Smartsheet and other customer business applications.
• Conduct trend analysis and report data, ex: pending and open customer orders, aged customer orders, inventory balances by location, inventory turn performance.
• Develop and maintain revenue forecasting tools in coordination with field managers and directors.
• Partner with Field Service Project Managers and functional business managers to identify internal and external dependencies, milestones, and deliverables.
• Track, forecast, and report on project progress including metrics and challenges.
• Actively participate in project teams and project status meetings as required.
• Lead reviews of business processes and develop optimization strategies as required
• Liaison between business, operations, and technology and innovation teams to accurately gather, analyze, document and deliver business requirements.
• Provide ongoing status reporting to the Director and senior managers.
• Other projects, reports, tasks, and duties as assigned.

Qualifications

• Bachelor’s degree
• Minimum three years of experience in related operations required with involvement in developing reports, analyzing data, and analyzing margins
• Strong attention to detail; ability to deliver high quality, timely, and accurate work
• Strong communication and collaboration skills to work effectively with cross-functional teams
• Be able to review current processes and provide recommendations and improvements
• Proficiency with Microsoft Office applications, including Word, Advanced Excel (macros), Outlook, plus experience with (SAP) and IT basic knowledge.
• Must be able to manage multiple projects and tasks with various deadlines.
• Must be able to identify new business processes that can realize value from analytics capabilities.

General Job Requirements