FINANCE PLANNING COORDINATOR (CPL683)

Job title**finance planning coordinator** - entity- mary kay’s colombia office- global grading business unit- function division- sub-function group- area department- mary kay colombia- finance- finance planning- finance- band- grade- structure- country- approved by- date approved- colombia- ._ essential duties and responsibilities - 1. financial planning (rolling forecast estimate by division, strategic business plan, upload to hyperion) support and maintain the short-term and intermediate range financial planning and forecasting capabilities to support proposed financial decisions. analyze current and historical cost relationships and monitors financial and economic trends. oversee and manage the continued development of budgeting, financial forecasting, operating plan and modeling tools; business performance (analysis and explanation of variations by total p&l; and business unit)- 2. responsible for download a computerized data analysis and reporting system to better analyze the kpi and business trends and advise management of their impact on operations. analyze current and past trends in key performance indicators including all areas of revenue, cost of sales, expenses and capital expenditures; monitor performance indicators, highlighting trends and analyzing causes of unexpected variance- 3. monthly and quarterly financial presentations;- 4. implement and work with a business intelligence tool and dashboard reports- 5. support the monthly reports and quarters presentations by creating standard templates in excel to facilitate analysis and gaps between actual and bud...