The Sr. Analyst Financial, Planning & Analyst is responsible for developing forward-looking forecasts, budgets and statement models. Drives enterprise-wide decision-making through Power BI dashboards, Excel trackers, and strategic reporting tools. Leads automation projects to improve financial processes such as aging reports, cash forecasting, and vendor onboarding workflows. Manages data modeling and validation from multiple sources including Snowflake, SAP B1, and SAP HANA APIs. Collaborates cross-functionally to understand business needs and deliver customized financial insights. Experienced in board-level reporting, KPI tracking, and performance analysis across countries and entities. Responsibilities and duties: Prepare monthly reports on financials to be distributed to the business Drive decision making across the business to meet organizational objectives by providing insightful financial analysis, interpretations, predictions, support, tools and recommendations; and clearly communicate results and recommendations to ensure clarity and optimal decision making Undertake a monthly proactive review of costs; flag early any changes to be inputted into the forecast based on actual results Provide support/assistance in performing monthly analysis of revenue vs forecast, with details of under- or over-performance Improve efficiency and control environment, including management of cost center structure and assignment by evaluating processes and providing recommendations Develop and perform reporting of operating metrics that ensures financial performance, e.g. profitability of different products in the portfolio. Manage and optimize the processes for data intake, validation and mining, as well as modeling, visualization and communication deliverables Responsible for developing forward-looking forecasts and budgets. Specific activities include: *Asia Payment Forecast *3-statement Model. Drive decision-making across the company by providing tools such as dashboards, templates, and reports. Specific activities include: *Profitability Report (Power BI) *Inventory Report (Power BI) *Aging Report (Power BI) *Cash Flow Monitor (Power BI) *Occupancy + Compensation by Store (Excel) *Daily Sales Report (in progress – Power BI) *Board of Directors Presentation (PPT) *Monthly Cash Flow (Excel) *BOD Aging Report (Excel) *HoldCo Monthly Presentation (PPT) *Country Managers KPI Trackers (Excel) *Store Investment Template (in progress – Excel). Responsible for building and maintaining effective relationships across the business to understand the key drivers, goals, and needs of internal partners and stakeholders. Lead automation projects based on internal customer needs. Specific projects include: *Automated Aging Report (for weekly payment cycle) *Consolidation of Country Cash Forecasts (for global cash flow) *Monthly Financial Statements by Entity (in progress) *Vendor Form in MS Forms with Approval Workflow (in progress) *BI Sales Audit (Power BI – in progress). Data mining, modeling, and validation of data sources. Specific activities include: *Review of Snowflake sources *Review of on-premise sources (SAP B1 / Exactus / PS) *SAP HANA API integration. Required Experience, Skills and Qualifications Bachelor's degree in finance, accounting, or a related field. 2+ years of experience in financial planning, analysis, and modeling. Ability to present financial information to a non-financial audience. Working knowledge of financial strategies. Strong organizational and multitasking skills. Excellent communication, interpersonal, and presentation skills. Detail-oriented and able to perform in a high-pressure environment. Strong analytical and problem-solving abilities with attention to detail. Proficiency in Microsoft Excel (pivot tables, lookups, modeling) and PowerPoint. Familiarity with Power BI, Tableau, or other BI tools. Hands-on experience with ERP systems (e.g., SAP, Oracle, NetSuite) and financial reporting tools. Ability to translate financial data into actionable business insights. Strong communication skills to explain complex information to non-financial stakeholders. Ability to work independently, manage multiple priorities, and meet deadlines Experience in data mining and statistical analysis Experience conducting analyses and building predictive models using SAS (or similar) Experience (preferred but not requited) with programming languages such as Java / Python (or “R”) Experience conducting regression analyses #J-18808-Ljbffr
Bilingual English / Spanish Sr. Analyst Financial, Planning & Analytic
PAYLESS
Bogotá, Bogotá
Publicado hace 11 días
Denunciar empleo