Business intelligence and Data Analyst

JOB DESCRIPTION CIB COLOMBIA - BNP PARIBAS

Job Title: Business intelligence and Data Analyst
Reports to: GM Sales
Location: Bogotá D.C.

Please note that sections “About BNPP” and “Business Overview” are standard sections that should be modified only by HR in collaboration with Communications; these are used only when sharing Job Description externally with headhunters and potential candidates.

About BNP Paribas:
BNP Paribas is a leading bank in Europe with a significant international presence, operating in 64 countries and territories, with a diverse workforce of more than 180,000 employees. The BNP Paribas Group's activities are organized around three main operating divisions, which bring together a range of business lines and capabilities designed to meet the specific needs of its clients, including individuals, entrepreneurs, small and medium-sized enterprises (SMEs), and large corporate and institutional clients. The Group supports its clients in achieving their goals by offering a comprehensive range of solutions, including financing, investment, savings, and protection insurance. In Europe, BNP Paribas has a strong presence in four domestic markets: Belgium, France, Italy, and Luxembourg, where BNP Paribas Personal Finance is a leader in consumer lending. The Group is also rolling out its integrated retail banking model in Mediterranean countries, Turkey, Eastern Europe, and has a large network in the western United States. Additionally, in its Corporate and Institutional Banking and International Financial Services activities, BNP Paribas holds top positions in Europe, has a strong presence in the Americas, and a solid and rapidly growing business in the Asia-Pacific region.

Business Overview:
The Latin America region is a strategic market for BNP Paribas, with a diverse range of countries contributing to the bank's business and long-standing relationships with clients. While Brazil is the largest economy in the region, other major countries, such as Colombia, Chile, Mexico, Peru, and Argentina, are also significant contributors. Notably, BNP Paribas has maintained a continuous presence in Colombia for over 50 years, demonstrating its commitment to the region.

BNP Paribas has a rich history in Hispanic Latin America, with a presence dating back to 1914. Today, the bank employs nearly 3,900 people across its Corporate and Institutional Banking (CIB) and International Financial Services divisions in the region. The CIB team in Hispanic Latin America comprises approximately 400 professionals, ensuring comprehensive coverage of BNP Paribas' client franchise in the region. All of BNP Paribas' business lines operate in Hispanic Latin America, with a structured approach that provides clients with access to specialists according to sector, product, or geographic region. In response to growing globalization, the bank's regional platforms enable it to support clients across the globe, with key hubs including:

• New York and Sao Paulo, where a team of professionals covers Latin America.
• Major European cities, such as Paris, London, Frankfurt, and Madrid.
• Asia, where the bank has broad coverage of all major economies in the region.

In Colombia, BNP Paribas has a significant presence through four entities and two representative offices, which together represent the Group's diverse activities. The Corporate and Institutional Banking division is represented by the BNP Paribas S.A. Representative Office, Corporación Financiera, and BNP Paribas Securities Services Sociedad Fiduciaria S.A. Additionally, the Investment and Protection Services division is represented by an insurance company (Cardif) and a Representative Office for Asset Management Services, and the Retail Banking division is represented by a leasing company (Arval).

Job Purpose:

• Contribute to building a more scalable and efficient operating model by supporting the integration of data, automation and AI driven tools into day-to-day trading and operational workflows.
• Help transform the FX/Trades desk by automating manual processes, improving data capabilities and introducing AI based solutions that reduce operational risk and enhance decision making.

Duties and Responsibilities:

• Reporting and Process Automation:
  • Help with the development and automation of current and prospective reports.
  • Support the analysis and documentation of critical processes.
  • Assist in automating repeatable tasks such as booking, validation, reconciliation, report generation and control checks.
• Data Analysis and AI Implementation:
  • Lead the analysis of market and client data to surface trends, patterns, and opportunities that enhance pricing and client engagement.
  • Translate data insights into simple, actionable recommendations for the trading and sales teams.
  • Design, test, and deploy AI‑driven assistants, alert generators, and basic predictive models.
  • Implement LLM‑based tools that streamline operational workflows (e.g., chat assistants, auto‑generated confirmations).
• Knowledge Management and Continuous Improvement:
  • Document senior traders’ pricing logic, risk controls, and execution practices into structured formats (process documentation, playbooks, or decision frameworks).
  • Drive a “knowledge‑sharing” initiative that reduces reliance on individual expertise.
  • Identify quick‑win automation opportunities, measure their impact (time saved, error reduction), and champion a culture of curiosity around new tools.
• Operational Support:
  • Replace Sales analyst on daily tasks and duties whenever absent.

Qualifications:

• Education: Active student in a Bachelor’s or Master’s degree in Engineering, Economics, Computer Science, Data Engineering, Business Analytics, Project Management, or a related field.
• Experience: 0-2 years of professional experience in Software/automation development, Data Engineering, Data Analysis, Data Pipeline construction, or Business Analysis/Process Improvement projects.
• Technical Abilities:
  • Medium level of English.
  • Proficient in Microsoft Excel, PowerPoint, Python, and SQL.
  • Familiarity with RPA tools or ability to write robust scripts/macros.
  • Experience with data visualization tools.
  • Exposure to AI/ML concepts (LLMs, basic predictive modelling).
  • Basic version control knowledge (Git).
• Core Skills:
  • Automation mindset (constantly asking, “can this be automated?”).
  • Strong analytical and problem-solving abilities.
  • Ability to translate traders’ needs into technical solutions and vice versa.
  • Curiosity about emerging AI/automation tools and self-learning orientation.
  • Excellent attention to detail, proactive attitude, and teamwork orientation.

Behavioral Competencies:

• Ability to Collaborate / Team Work.
• Communication Skills (oral & written).
• Active listening.
• Creativity, Innovation, and Problem Solving.
• Ability to Synthesize and simplify information.
• Organizational Skills and Adaptability.
• Client Focus.
• Decision Making and Resilience.
• Critical thinking and Ability to share knowledge.
• Personal impact and ability to influence.
• Attention to detail and rigor.
• Results Driven.

Transversal Competencies:

• Ability to Understand, explain, and support change.
• Analytical Ability.
• Ability to set up relevant performance indicators.
• Ability to anticipate business/strategic evolution.
• Ability to manage a project.

Certifications:
Not necessary but helpful:

• AMV Operador básico (including advisory component).
• AMV operador Divisas.
• AMV operador Renta Fija.
• AMV Operador Derivados.
  (Note: Whenever the position includes trading, closing, or trade booking activities, the respective certifications will be required).

Interactions:

• Internal: BNPP Back Office, Middle Office, Front Office (local and other GM teams), Coverage Team, Risk and Credit department, and BNPP IT Business team.
• External: Clients' Front Office.

Decisions:

• Decisions related to the development of reports and ideas to improve the daily tasks of the business.

Training:

• Mandatory trainings as indicated by Compliance, Legal, Region, and Group.
• Mandatory Corporate trainings in soft skills or BNPP competencies for all new hires (as indicated by HR)