Junior Operational Risk and Internal Controls Analyst, Data

Banco Mercantil

Analista de Risco Operacional e Controles Internos Jr integrating data management and risk assessment. Involves project contributions and interdepartmental collaboration at Banco Mercantil.

Posted 7/2/2026full-timeBelo Horizonte • 🇧🇷 BrazilJuniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, dashboard creation, and report preparation using Power BI and SQL. Proficient in translating complex data insights into actionable business strategies while collaborating effectively across departments.

Highest-signal resume keywords

Power BI Dashboard CreationSQL Query ProficiencyData AnalysisPython AutomationAdvanced Excel Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisDashboard CreationSQLPythonExcelStatistical AnalysisReport PreparationData ExtractionKey Risk IndicatorsBusiness Intelligence

Soft Skills

Clear CommunicationProblem SolvingCollaborationCreative ThinkingDidactic Explanation

Tools & Technologies

Power BIMicrosoft OfficeExcelSQL ServerData Analysis Tools

Industry Keywords

Operational Loss DatabaseRisk ManagementBusiness AdministrationData ScienceBanking Sector

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

Create, model, and maintain dynamic dashboards in Power BI, ensuring business units and executive management have access to reliable data for decision-making;
Support the calculation, extraction, and monitoring of Key Risk Indicators (KRIs), using SQL queries to consolidate complex data sets;
Investigate and analyze the bank's operational loss database, identifying patterns, bottlenecks, and anomalous behavior through basic statistical analyses;
Interact directly with other bank departments to investigate reported incidents, understand root causes of losses, gather explanations, and assist in developing effective action plans to mitigate future risks;
Use Python and advanced Excel to automate data extraction routines and manual reports, optimizing the team's delivery times;
Prepare management reports, presentations, and concise executive summaries, translating technical data into business language to report the bank's risk exposure levels.

Requirements

What you’ll need

Bachelor's degree in Data Science, Business Administration, Computer Science, or a related field;
Experience in data analysis and report preparation;
Proficiency with Microsoft Office (Word, Excel, PowerPoint); experience with data analysis tools and Power BI;
Ability to explain data insights clearly and didactically to different audiences;
Ability to examine data, question root causes, and propose creative solutions.

Benefits

Comp & perks

Meal and food allowance (if preferred, both amounts can be combined onto a single food card);
Health insurance;
Dental insurance;
Childcare assistance;
Life insurance;
Private pension plan (retirement savings);
Wellhub (employee wellness platform);
Mercantil Development Academy (training and development program);
Profit-sharing (PLR);