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
Ecolab

Lead Field Service Rep I - NW

Medellín

FULL TIME

November 7, 2024

View Job Description
GRUPO CUMBRE COLOMBIA SAS

Medico ocupacional

Bogota

PART TIME

November 7, 2024

View Job Description
Brava Business Solution LLC

Gerente Comercial - Sales Manager

Usaquén

FULL TIME

November 7, 2024

View Job Description
Organizacion de viajes Siempre Colombia

Analista Contable

Bogota

FULL TIME

November 7, 2024

View Job Description
Activeone

React Native Mobile Developer

Bogota

FULL TIME

November 7, 2024

View Job Description
Looking for similar job?
Paystone

Data Engineer (Colombia)

Medellín

FULL TIME

August 30, 2024

View Job Description
ttg Talent Solutions

Data Scientist

Medellín

FULL TIME

August 30, 2024

View Job Description
Publicis Global Delivery

Data Analyst - PGD-18753

Bogota

FULL TIME

August 29, 2024

View Job Description
Worley

Data Analyst II (Bilingual)

Bogota

FULL TIME

August 28, 2024

View Job Description
Equisoft

Database Administrator (SQL)

Bogota

August 30, 2024

View Job Description
Lean Tech

Data Integration & OCR Specialist with AI & Low Code

August 29, 2024

View Job Description
See What’s New: Lean Tech Job Opportunities
Lean Tech

Mid-Level No-Code & Low-Code AI Developer

Medellín

November 7, 2024

View Job Description
Lean Tech

Mid-Level + Product Manager

October 25, 2024

View Job Description
Lean Tech

Data Automation Analyst (Excel & Power BI)

October 24, 2024

View Job Description
Lean Tech

Mid Java Developer

Bogota

October 24, 2024

View Job Description
Lean Tech

Mid to Mid+ Node/React Developer

Medellín

October 23, 2024

View Job Description
View More Jobs by Lean Tech
New Job Alerts
Ecolab

Lead Field Service Rep I - NW

Medellín

FULL TIME

November 7, 2024

View Job Description
GRUPO CUMBRE COLOMBIA SAS

Medico ocupacional

Bogota

PART TIME

November 7, 2024

View Job Description
Brava Business Solution LLC

Gerente Comercial - Sales Manager

Usaquén

FULL TIME

November 7, 2024

View Job Description
Organizacion de viajes Siempre Colombia

Analista Contable

Bogota

FULL TIME

November 7, 2024

View Job Description
Activeone

React Native Mobile Developer

Bogota

FULL TIME

November 7, 2024

View Job Description