Bogotá, Bogotá, Colombia
4 months ago

Job Overview

Job Type
Full-Time
Pay
Not disclosed

Job description

Location:
Bogotá, Bogotá, Colombia
Work arrangement:
On-site

Role Summary

  1. Purpose of the Role

He is responsible for leading and executing financial planning processes, performance analysis, projections, automation and generation of financial insights within the Global Business Services — GBS model, guaranteeing the quality, reliability and traceability of information for decision making.

The purpose of the role is to ensure structured financial management through the analysis of variations, budgeting, forecasting, consolidation of financial information and construction of analytical tools and automations that allow increasing operational efficiency and executive visibility.

Likewise, the position will contribute to strengthening the area's analytical and digital capabilities through the development of Power BI dashboards, light automations and simplified ETL structures for data integration and transformation.

  1. Scope and Responsibilities

The FP&A Senior acts as a focal point for financial analysis activities, information consolidation, report automation and dashboard construction within the GBS environment. Its scope includes the preparation of financial analysis, budget monitoring, process automation and support for regional and global stakeholders.

The position constantly interacts with financial and operational teams, functional areas and regional stakeholders, ensuring alignment between financial information, business needs and organizational objectives. It does not have direct personnel in charge.

Technical Knowledge

Solid knowledge of financial planning, forecasting, budgeting and performance analysis processes.

Advanced use of Microsoft Excel, including pivot tables, advanced formulas, macros and automation.

Advanced use of Power BI to build dashboards, data modeling and generation of executive insights.

Knowledge of automation tools such as Power Automate, Power Query, Python or similar.

Knowledge of ETL structures and data transformation with Python.

Management of financial indicators, KPIs, executive reports and variation analysis.

Knowledge of consolidation and validation of financial information.

Knowledge of Oracle, SQL or similar financial platforms is desirable.

Analytical ability to interpret financial trends, risks and opportunities.

Intermediate or advanced use of collaborative tools and the Microsoft Office ecosystem.

  1. Skills and Competencies

Analytical and financial thinking.

Planning and organization.

Attention to detail.

Results orientation.

Capacity for analysis and synthesis.

Effective communication with stakeholders.

Prioritization ability.

Problem solving.

Proactivity and sense of urgency.

Adaptability to dynamic environments.

Automation and continuous improvement capacity.

Ability to document and structure information clearly.

Influence without direct authority.

Collaborative work.

Orientation to operational efficiency.

Ability to work with large volumes of information.

Risk management and problem resolution.

Prioritization ability.

Attention to detail.

Adaptability to dynamic environments.

Collaborative work.

Proactivity and sense of urgency.

Ability to document, structure and present information clearly.

Orientation to continuous improvement.

Influence without direct authority.

Responsibilities

  • Lead financial planning, budget, forecast and analysis of monthly results processes, ensuring accuracy and compliance with established schedules.
  • Consolidate, analyze and present financial and operational information to support executive and strategic decision making.
  • Prepare analysis of variations versus budget, forecast and previous year, identifying relevant risks, opportunities and deviations.
  • Design, automate and optimize financial reports using tools such as advanced Excel, macros, Power Automate and Power BI.
  • Build and maintain executive and operational dashboards in Power BI, guaranteeing reliability, traceability and updating of information.
  • Develop lightweight ETL processes for extraction, transformation and consolidation of data from multiple sources.
  • Manage databases and financial information structures to ensure data integrity and availability.
  • Coordinate with regional and global stakeholders the validation and alignment of financial and operational information.
  • Identify opportunities for improvement in financial processes, reporting and automation, contributing to the efficiency and maturity of the GBS model.
  • Ensure compliance with financial guidelines, corporate standards and established internal controls.
  • Participate in regional initiatives for financial transformation, automation and digitalization of processes.
  • Maintain effective communication with internal stakeholders, ensuring clarity on results, risks, action plans and next steps.

Requirements

  • Education: Professional in Finance, Economics, Business Administration, Industrial Engineering, Accounting, Systems Engineering or related careers.
  • Desirable specialization or complementary training in Corporate Finance, Business Intelligence, Data Analytics, Process Automation or related disciplines.
  • Between 4 and 5 years of experience in areas of FP&A, financial analysis, controlling, financial reporting or corporate planning.
  • Experience in building and automating financial reports and executive dashboards.
  • Minimum 3 years of experience in Power BI, including data modeling, DAX, visualizations and reporting automation.
  • Experience in automations using macros, Power Query, Power Automate, Python or similar tools.
  • Experience in building lightweight ETL and data transformation for consolidation of financial information (Python preferred).
  • Experience in variance analysis, budgets, forecasting and monitoring of financial KPIs.
  • Desirable experience in multinational environments, Shared Services Centers — SSC, Global Business Services — GBS or regional structures.
  • Experience working with large volumes of information and multiple data sources is desirable.

Language

English C1, oriented towards regional and global interaction, executive presentations, financial documentation and communication with international stakeholders.

Benefits

  • Hours: Monday to Friday
  • Modality: In-person
  • Salary: To be agreed

Direct contract for an indefinite term.

About the Company

SGS is the world leader in inspection, verification, analysis, training and certification. It is considered the main world reference in quality and integrity, we have more than 95,000 collaborators and a network of more than 2,400 offices and laboratories around the world.

Role:
BUSINESS DATA ANALYTICS FP&A RBS
Industry Type:
Real Estate
Job Type:
Full-Time

More jobs at SGS

Similar Financial Analyst jobs at other companies