Bogota
Colombia
813

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 budget figures.

6. Prepares division expenses analysis to generate alerts by analyze complex information and reports to provide accurate and timely financial recommendation to management for decision-making purposes.

KNOWLEDGE, SKILLS AND ABILITIES

Education

Bachelor’s degree or equivalent in Business Administration or Engineer.

Experience

2+ years of experience in Finance departments on related areas with integrated financial systems.

1. Strong analytical, organizational and time management skills.

2. Advance proficient in spreadsheet (Excel) in a Windows environment to maintain financial information, perform financial analysis and utilize linking and downloading functions.

3. Excellent communications skills to effectively communicate with all levels of the organization, including personnel in international locations.

4. Teamwork, Problem-solving skills, Analytical.

5. Able to design the annual consolidated profit planning system, assist cost center throughout the profit planning process, develop the capital budgeting plan and perform analysis to support or negate decisions affecting the financial position of the Company.

6. Ability to communicate: Excellent oral and written communication skills to interface with individuals at all levels within the Company.

7. Bilingual: English minimum 60%.

8. Implement and work with a Business Intelligence Tool and Dashboard reports