Mid-Level Reporting Analyst

Lean Tech, a Lean Solutions Group Division; Medellín; Presencial; COP 40.000.000 - 70.000.000; Jornada completa

Descripción de la vacante

Global Technology Services in Medellín, Colombia seeks a Mid-Level Reporting Analyst to own recurring and ad hoc reporting, creating dashboards and analyses that support leadership decisions.

You will use advanced SQL and Power BI to build data models, validate results, and troubleshoot issues while communicating insights to nontechnical stakeholders. Opportunities exist to expand Python workflows and AI-enabled automation.

Formación

• Bachelor’s degree in Computer Science, Information Systems, Statistics, Economics, or equivalent practical experience.
• 2+ years in reporting, BI, data analytics, or related field.
• Advanced SQL with complex joins, aggregations, CTEs across multiple sources.
• Independent SQL writing and troubleshooting; validate reporting results.
• Strong Power BI experience building interactive dashboards and data models.
• Proficient in DAX and Power Query for calculations and data transformation.
• Experience creating and interpreting KPIs and performance metrics.
• Professional proficiency in English, both written and spoken.

Responsabilidades

• Own recurring and ad hoc reporting for managers and executive leadership.
• Understand business questions, define reporting requirements and KPIs, and translate into dashboards.
• Use SQL to extract, join, and prepare data; build and maintain Power BI data models and dashboards.
• Validate results, investigate discrepancies, troubleshoot reporting issues and improve performance.
• Present findings clearly to managers, executives, and nontechnical stakeholders.
• Contribute to Python workflows and AI-driven automation when appropriate.
• Collaborate with stakeholders across Latin America and the United States.

Conocimientos

Advanced SQL

Power BI

DAX

Power Query

Python basics

English proficiency

Stakeholder communication

Educación

Bachelor’s degree in a related field

Herramientas

Snowflake

Descripción del empleo

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 many opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting‑edge developments in multiple industries.

We’re looking for a Mid-Level Reporting Analyst with advanced SQL skills, strong Power BI experience, and excellent communication skills to develop reporting solutions that support business decisions. This role combines technical reporting expertise with direct stakeholder interaction, requiring someone who can understand business needs, develop solutions, and clearly communicate findings to nontechnical audiences.

Position Title: Reporting Analyst

Category: Business Intelligence & Data Analytics

Seniority: Mid

What you will be doing:

You will own recurring and ad hoc reporting that helps managers and executive leadership monitor company performance and manage teams and programs. Working directly with stakeholders, you will understand their business questions, define reporting requirements and KPIs, and translate those needs into accurate, actionable dashboards and analyses.

You will use advanced SQL to extract, combine, and prepare data, and Power BI to build and maintain data models and interactive dashboards. You will validate results, investigate discrepancies, troubleshoot reporting issues, and improve report performance and usability.

This position requires ownership throughout the reporting process, from gathering requirements to presenting findings and addressing stakeholder feedback. As the team expands its automation capabilities, you may also contribute to Python workflows and use AI tools to improve efficiency, with opportunities to develop these skills on the job.

Required Skills & Experience

Bachelor’s degree in a related field, such as Computer Science, Information Systems, Statistics, Economics, or equivalent practical experience.

2+ years of experience in reporting, business intelligence, data analytics, or a related field.

Advanced SQL proficiency, including complex joins, aggregations, common table expressions, and data preparation across multiple tables and sources.

Ability to independently write and troubleshoot SQL queries, investigate data discrepancies, and validate reporting results.

Strong hands‑on Power BI experience building and maintaining interactive dashboards and data models.

Working proficiency in DAX and Power Query to implement calculations, transform data, and support reporting requirements.

Experience creating, maintaining, and interpreting KPIs and business performance metrics.

Ability to translate business questions into reporting requirements and deliver useful analytical solutions.

Experience validating data accuracy and consistency across reports and dashboards.

Ability to present findings clearly to managers, executives, and other nontechnical stakeholders.

Professional proficiency in English, both written and spoken.

Nice to Have Skills

Advanced Power BI expertise, particularly in complex data models, DAX calculations, and dashboard performance optimization.

Experience with Snowflake or other cloud data warehouses.

Basic Python knowledge and an understanding of how Python pipelines support data preparation and recurring automation.

Experience using AI/LLM tools such as ChatGPT, Claude, or Copilot to improve productivity, with the judgment to review and validate their output.

Familiarity with integrating AI/LLM tools into data workflows through APIs or automation.

Soft Skills

Strong stakeholder communication, including the ability to clarify business needs and explain analytical findings in accessible language.

Ownership and independence in managing reporting requests from initial discovery through delivery and presentation.

Strong analytical thinking and problem‑solving skills, with close attention to data accuracy.

Ability to prioritize recurring reporting and ad hoc requests from different business teams.

Collaborative approach to working with business stakeholders and technical colleagues.

Curiosity, adaptability, and willingness to learn new tools and improve reporting processes.