Colombia Job Openings

Lean Tech

Data Automation Analyst (Excel & Power BI)

October 24, 2024

Company Overview:

Lean Tech 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 and the United States, contributing to cutting-edge developments in multiple industries.

Currently, we are seeking a Data Automation Analyst (Excel & Power BI) with a strong English level to join our team. Here are the challenges that our next warrior will face and the requirements we look for:

Position Title: Data Automation Analyst (Excel)

Location: Remote LATAM

What you will be doing:

We are seeking a highly motivated Data Automation Analyst to join our dynamic team in Medellín, Colombia. The ideal candidate will be responsible for accurate data collection, processing, modeling, and analysis using advanced data analytics techniques and tools within Microsoft Excel. This role focuses on discovering insights from large datasets and converting these insights into strategic opportunities, thereby driving data-driven decisions and business outcomes across various departments including sales, marketing, customer service, operations, and finance.

Meet regularly with users to gather and prioritize requirements for data analytics solutions.
Develop effective data analytics solutions based on gathered requirements.
Create and elaborate dashboards and reports for data visualization using Microsoft Excel.
Design, develop, and maintain macros and scripts to automate tasks and processes within Excel.
Build automation solutions to streamline data processing, analysis, and reporting tasks.
Implement Excel-based workflows to improve efficiency and reduce manual efforts.
Design user-friendly interfaces within Excel for data input, manipulation, and reporting.
Train users on the functionality of developed solutions in Excel.
Document and report on the organizational impact of developed and adopted solutions.
Assist in identifying process and data gaps across the enterprise.
Coordinate and communicate with other team members to ensure alignment and collaboration.

Requirements & Qualifications

To excel in this role, you should possess:

Main Skills:

These are the must-haves that are essential for this position.

Expert proficiency with Microsoft Excel including VBA.
Solid experience using Power BI
2+ years of experience with Microsoft Excel/macros.
Create custom functions and procedures to enhance Excel functionality.
Design, develop, and maintain macros to automate tasks within Excel.
Build automation solutions to streamline data processing and reporting tasks.
Implement Excel-based workflows for improved efficiency.
Experience with data visualization and UI-oriented solutions using Excel.

Secondary Skills:

These are additional skills that will help you succeed in this role.

Experience with additional BI tools such as Tableau or Qlik.
Familiarity with cloud data platforms like AWS Redshift, Azure Synapse, or Google Big Query.

Soft Skills
- Attention to detail.
- Agile mindset.
- Strong analytical attitude.
- Empathy and excellent verbal and written communication skills.
- Problem analysis and problem-solving abilities.
- Effective planning and organizing skills.
- Sound decision-making capabilities.
- Ability to work effectively in a team and share ideas.

Why you will love Lean Tech:

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 Lean Tech 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. Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

New Job Alerts

Performia Colombia

Diseñador Gráfico Senior

Bogota

FULL TIME

November 20, 2024

View Job Description

Profesor X

Agente Call Center Bilingüe - Cold Calls

Medellín

FULL TIME

November 20, 2024

View Job Description

Profesor X

Appointment Setter - Fines de Semana Libres!!!

Bogota

FULL TIME

November 20, 2024

View Job Description

BBVA

COMPLIANCE CROSS DISCIPLINE SENIOR MANAGER I- CONTROL INTERNO & CUMPLIMIENTO

Bogota

FULL TIME

November 20, 2024

View Job Description

PROMCIVILES SAS

PROFESIONAL EN LICITACIONES PÚBLICAS Y CALIDAD - BOGOTÁ

Bogota

FULL TIME

November 20, 2024

View Job Description

Profesor X

Agente Bilingüe

Medellín

FULL TIME

November 20, 2024

View Job Description

Gi Group Colombia

Asesor Comercial Externo TAT Preventista /Pereira y alrededores

Pereira

FULL TIME

November 20, 2024

View Job Description

GRUPO CARDINAL

TÉCNICO DE MANTENIMIENTO BÁSCULAS-SANTANDER

Bucaramanga

FULL TIME

November 20, 2024

View Job Description

Comdata Colombia

Técnico/a Auxiliar de Enfermería Ibagué

Ibagué

FULL TIME

November 20, 2024

View Job Description

FUNDACIÓN LA DIVINA PROVIDENCIA

Practicante de Nutrición

Data and Analytics Engineer

FULL TIME

October 4, 2024

View Job Description

Achievers

Database Reliability Engineer - Colombia

FULL TIME

October 1, 2024

View Job Description

Sezzle

Senior Data Scientist (Colombia)