Power BI Reporting Analyst: Dashboards & Data Visualization

Lean Solutions Group; Medellín; Remote; COP 60,000,000 - 95,000,000; Full time

Benefits offered by this job

Professional development

Mentorship programs

International customers

Job summary

Lean Tech is seeking a Mid to Mid+ Reporting Analyst to join our remote LATAM team. You will design, develop, and optimize Power BI dashboards and reports to support data-driven decisions across multiple industries.

Responsibilities include advanced DAX calculations, data modeling, ETL pipelines, and collaborating with cross-functional teams to define KPIs and metrics. Experience with Aveva PI System and PI Integrator is highly preferred.

Qualifications

• 2–4 years of experience in reporting and data visualization.
• Experience with large datasets and performance optimization.
• Familiarity with industrial or operational data analytics is a plus.
• Proven expertise in Power BI development, including advanced DAX, data modeling, and visualization.
• Strong understanding of relational databases and ETL processes.

Responsibilities

• Design, develop, and maintain advanced dashboards and visualizations using Power BI.
• Implement complex DAX calculations and data modeling to optimize performance and insights.
• Ensure high performance and fast rendering for reports by managing datasets and models efficiently.
• Work with business users to translate reporting needs into actionable dashboards and reports.
• Collaborate across teams to define KPIs, metrics, and goals for reporting initiatives.
• Extract, transform, and load data from relational and legacy systems into Power BI.
• Establish efficient ETL pipelines for consistent data availability.
• Continuously improve and optimize existing reports for scalability and usability.
• Ensure data accuracy and implement data validation processes.
• Address complex reporting challenges with custom solutions.
• Respond to ad-hoc requests for reports and data analysis.

Skills

Power BI

DAX

Data modeling

ETL

SQL

Tools

Aveva PI System

PI AF

PI Integrator

Job description

Lean Tech is seeking a Mid to Mid+ Reporting Analyst to join our remote LATAM team. You will design, develop, and optimize Power BI dashboards and reports to support data-driven decisions across multiple industries.

Responsibilities include advanced DAX calculations, data modeling, ETL pipelines, and collaborating with cross-functional teams to define KPIs and metrics. Experience with Aveva PI System and PI Integrator is highly preferred.