Junior Data Analyst

Banco Mercantil

. Extract, transform, and consolidate large volumes of data from structured databases (SQL and Snowflake) .

Posted 10/8/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 extraction, transformation, and analysis using SQL and Power BI, with a focus on developing automated dashboards and analytical reports. Proficient in monitoring KPIs and creating executive presentations to support data-driven decision-making.

Highest-signal resume keywords

SQL Query DevelopmentPower BI Dashboard CreationData Warehouse ExperiencePython for Data AnalysisData Storytelling Techniques

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 ExtractionData TransformationAnalytical ReportingSQLDAX FormulasData ModelingData AnalysisData ConsolidationKPI MonitoringExecutive Presentation Creation

Tools & Technologies

Power BISnowflakePythonPandasNumPy

Industry Keywords

Investment ProductsCommercial ProductionMarket InformationRelational DatabasesAnalytical Studies

Tech Stack

Tools & technologies

NumpyPandasPythonSQL

About the role

Key responsibilities & impact

Extract, transform, and consolidate large volumes of data from structured databases (SQL and Snowflake)
Develop, publish, and maintain automated dashboards in Power BI
Monitor and analyze commercial production KPIs, identifying deviations and opportunities for improvement
Create executive presentations focused on management indicators for leadership meetings
Support partner teams by answering questions and providing analytical studies based on internal data and external market information

Requirements

What you’ll need

Previous experience extracting data, working with relational databases, and developing analytical reports
SQL (queries, JOINs, filters, and aggregation)
Strong Power BI skills (data modeling, DAX formulas, and report publishing)
Experience with data warehouses (Snowflake)
Knowledge of Python for data analysis (Pandas, NumPy) — a plus
Familiarity with data storytelling techniques — a plus
Knowledge of investment products — a plus

Benefits

Comp & perks

Meal and food allowance (if preferred, both amounts may be provided on a single meal card)
Health insurance
Dental insurance
Childcare assistance
Life insurance
Private pension plan
Wellhub
Mercantil Development Academy
Profit Sharing (PLR)
Positions also available for people with disabilities