Senior Manager, BI, and Forecasting

Overview

Remote
$120,000 - $200,000
Full Time

Skills

Business Intelligence
BI
MySQL
MSSQL
Excel
Data Analytics
Retail
Forecasting

Job Details

Job Description:

Job Title: Senior Manager, BI, and Forecasting

Location: Remote

Job Type: Full Time/Permanent

Primary Duties and Responsibilities

  • Directing and overseeing high-level strategic and tactical decisions for business intelligence tools and applications.
  • Organizing the work of 8 team members in 3 locations (with the help of a manager and associate manager).
  • Coaching a team on the pros and cons of different types of analytics, data modeling, and providing mentorship on extrapolating and examining insights from large data sets.
  • Coordinating a big number of one-time custom activities concerned with data collection, analysis, reconciliation, trends investigation.
  • Organizing the metrics and dashboards setup for various areas of the business using MS BI Stack and other custom reporting tools.
  • Managing the creation and maintenance of SSRS reports and subscriptions.
  • Building long-term high-level forecasts for major financial metrics. Maintaining the model, monitoring trends compared to the model, and digging into issues.
  • Keeping track and managing high-level company KPIs.
  • Providing guidance to our Procurement teams during large purchasing campaigns and strategic buys.
  • Driving projects related to the design and development of automated decision-making systems for the business. Answering questions and suggesting improvements on the proprietary systems created earlier, such as Product-level Demand Forecasting, Net Margin calculations system, Lead Times calculation system, Automatic Pricing system, etc.
  • Acting as a liaison between our Finance and the Business reconciling financial and operational reports and KPIs.
  • Participating as an SME and helping in other company-wide projects. Providing expertise for other departments when it comes to profitability measurement, ROI measurement, understanding impact on cash conversion cycle, etc.
  • Providing leadership in the development, implementation, and ongoing management of all key performance indicators (KPIs) and reporting capabilities for a number of operational areas. Using insights to challenge the organization to be more efficient and cost-effective.
  • Researching, analyzing and explaining the current and past activity, expected trends, and the potential effect of the changes made. Presenting and supporting findings and recommendations to various management levels within the organization.

Qualifications, Skills and Requirements

  • 3+ years of managerial experience in the BI field
  • MA/MS or higher degree in Statistics, Computer Science, Applied Math, Physics, or other technical field
  • Understanding of Ecommerce, Retail, Supply Chain Management, Finance and Marketing
  • Strong MS SQL/MySQL skills
  • Experience or deep understanding of Microsoft BI tools: SSRS, SSAS, SSIS, PowerBI
  • Advanced MS Excel skills
  • Experience solving analytical problems using other technical field approaches
  • Excellent Communication skills
  • Proficiency in utilizing Google Analytics. Google BigQuery expertise is a plus
  • Experience in Ecommerce is a major plus
  • Expertise/background in artificial intelligence/machine learning is a plus
  • Some programming experience is a plus (PHP, C++, Javascript, VBA, or others).