BI analyst

Description

Job Summary: Drive strategic decisions through analytics to size staffing, forecast demand, and optimize costs—aligning operations and finance. Key Responsibilities: 1. Collect and consolidate data to feed analytical models. 2. Apply statistical techniques and predictive models to estimate volumes. 3. Develop dashboards to communicate operational and financial KPIs. **Job Description** ---------------------- Drive strategic decisions through analytics to size staffing, forecast demand, and optimize costs—aligning operations and finance. Collect and consolidate data: extract information from corporate sources (GCP databases, BigQuery, contact center platforms, and internal systems) to feed analytical models. Clean and transform data: apply ETL processes in Python and SQL to ensure data quality, integrity, and appropriate formatting for forecasting. Model data: design data structures, segment variables, and build relationships supporting sizing analyses, contact forecasting, and FTE forecasting. Forecast contacts: apply statistical techniques and predictive models (time series, regressions, machine learning) to estimate contact volumes by channel, campaign, and time slot. Size staffing and FTEs: calculate required headcount per skill, shift, and campaign, considering service levels, shrinkage, occupancy, and seasonality. Conduct financial analysis: evaluate the cost associated with sizing, calculate cost per contact, cost per FTE, and project the financial impact of operational plans. Generate FTE requisitions: create and track formal personnel requisition orders to BPOs and internal departments, aligned with validated forecasts. Visualize and communicate results: develop dashboards in Power BI, Tableau, or Looker displaying operational, financial, and capacity KPIs for business stakeholders. Interpret trends: identify patterns, deviations, and improvement opportunities in operations—and translate them into actionable recommendations. **Candidate Requirements** -------------------------- * Industrial engineering or related degree * Minimum 2 years of experience * Python (pandas, numpy, scikit\-learn, statsmodels) * Advanced SQL (BigQuery, GCP) * Power BI / Tableau / Looker * Advanced Excel (financial modeling, Power Query) * Forecasting models (ARIMA, Holt\-Winters, Prophet, ML) * WFM staffing (Erlang C, simulation, capacity planning) or automated implementations using programming languages * Financial analysis (cost per contact, cost per FTE, operational P\&L) **Selection Process** ------------------------ The selection process is conducted via Aira—a recruitment platform designed to enhance your application experience. To apply, you only need: 1\. Apply to the position 2\. Check your email 3\. Log in to Aira and respond to the requested questions and/or assessments Then, if your profile matches our requirements, we will contact you by email (via Aira) to proceed to the in-person stage. **About Us** ------------------ We are over 88,000 people who work every day toward our firm Purpose—Simplify and Enjoy Life More. We operate in 9 countries and consist of five major brands across diverse industries: Falabella Retail, Sodimac, Banco Falabella, Tottus, and Mallplaza. Each brand defines who we are, and together—as One Team—we strive daily to reinvent ourselves and exceed our customers’ expectations. A team full of dreams that makes things happen. We dare to launch and innovate, take risks, and create opportunities—keeping us at the forefront and driving us to continuously reinvent ourselves to deliver the best shopping experience at every touchpoint with us.