Match score not available

Data Automation Analyst (Excel & Power BI)

Remote:

Full Remote

Contract:

Full time

Experience:

Mid-level (2-5 years)

Work from:

Colombia

Offer summary

Qualifications:

Expert proficiency with Microsoft Excel including VBA, Solid experience using Power BI, 2+ years of experience with Microsoft Excel/macros, Experience with data visualization in Excel, Familiarity with cloud data platforms like AWS Redshift or Azure Synapse.

Key responsabilities:

Accurate data collection, processing, modeling, and analysis
Develop data analytics solutions based on user requirements
Create dashboards and reports using Microsoft Excel
Design and maintain macros for task automation within Excel
Train users on developed Excel solutions

Lean Tech Information Technology & Services SME https://www.leangroup.com/

501 - 1000 Employees

See more Lean Tech offers

Job description

Description

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 BigQuery.

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.