Junior Data Analyst

Lean Solutions Group; Medellín; Remote; COP 70,061,000 - 95,538,000; Full time

Job summary

Global Technology Services in Medellín is seeking a Junior Data Analyst to transform raw data into clear insights that support business decision-making and operational performance. You will learn to develop reports, dashboards, and basic data models while working with experienced teams across Latin America, the Philippines, and the United States.

The role emphasizes data accuracy, discovering trends, and opportunities for process improvement; you will collect, clean, and validate data, create

Qualifications

• 1-2 years of data analysis, BI, or related coursework/internship.
• Foundational to intermediate SQL skills (joins, aggregations, subqueries).
• Excel proficiency: pivot tables, lookups, basic data analysis.
• Understanding of relational databases and data modeling basics.
• Data cleansing, transformation and validation experience.

Responsibilities

• Transform raw data into clear insights to support decisions.
• Create/update basic reports, dashboards, and data visualizations.
• Write basic to intermediate SQL queries to analyze data.
• Collaborate with stakeholders to gather reporting requirements.

Skills

SQL basics

Excel basics

DB fundamentals

Data cleansing

Analytical mindset

Tools

SQL

Excel

Job description

Company Overview

Global Technology Services is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer a multitude of opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America, Philippines and the United States, contributing to cutting-edge developments in multiple industries.

Position Title

Junior Data Analyst

Location

LATAM

What you will be doing

We are seeking a Junior Data Analyst to help transform raw data into clear insights that support business decision-making and operational performance. The ideal candidate has strong foundational analytical skills, familiarity with structured data, and an eagerness to learn how to develop reports, dashboards, and basic data models.

You will work alongside experienced data analysts, data engineers, and business stakeholders to ensure data accuracy while learning to identify trends, patterns, and opportunities for process improvement.

• Assist in collecting, cleaning, and validating data from primary and secondary sources to ensure consistency and quality.Create and update basic reports, dashboards, and data visualizations to track key business metrics.

• Write basic to intermediate SQL queries to retrieve, aggregate, and analyze dataset information.

• Support cross-functional teams and stakeholders by gathering initial reporting requirements and helping translate data into actionable insights.

• Participate in data reconciliation tasks to help resolve data quality issues.

Required Skills & Experience

• 1-2 years of experience in data analysis, business intelligence, reporting, or a related coursework/internship background.Foundational to intermediate proficiency in SQL (joins, group by/aggregations, basic subqueries, and familiarity with CTEs).

• Proficiency with Microsoft Excel (pivot tables, lookup functions, basic data analysis).

• Basic understanding of relational databases and fundamental data modeling concepts.

• Experience or coursework in data cleansing, transformation, and validation techniques.

• Financial background or coursework is a plus.

• Strong curiosity, analytical mindset, and acute attention to detail.

• Ability to present technical findings clearly to both technical and non-technical teammates.

Soft Skills

• Solid analytical, logic, and troubleshooting skills.High adaptability and eagerness to learn new tools and technologies.

• Strong team player who collaborates well and asks for guidance when needed.

• Clear verbal and written communication skills to document processes and share findings effectively.

Why you will love GTS

• Join a powerful tech workforce and help us change the world through technology

• Professional development opportunities with international customers

• Collaborative work environment

• Career path and mentorship programs that will lead to new levels.

Join GTS and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. GTS is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.