Data Automation Analyst (Excel & Power BI)

at  Lean Tech

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:

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.

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

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.

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 Skill