Data Automation Analyst

hace 1 mes


Medellín, Colombia Lean Solutions Group A tiempo completo

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.

Position Title: Data Automation Analyst (Excel & Power BI)

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.

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

Requirements & Qualifications:

To excel in this role, you should possess:

Main Skills:

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

Secondary Skills:

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

Soft Skills:

  1. Attention to detail.
  2. Agile mindset.
  3. Strong analytical attitude.
  4. Empathy and excellent verbal and written communication skills.
  5. Problem analysis and problem-solving abilities.
  6. Effective planning and organizing skills.
  7. Sound decision-making capabilities.
  8. Ability to work effectively in a team and share ideas.

Why you will love Lean Tech:

  1. Join a powerful tech workforce and help us change the world through technology.
  2. Professional development opportunities with international customers.
  3. Collaborative work environment.
  4. 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.

#J-18808-Ljbffr

  • Medellín, Antioquia, Colombia Lean Solutions Group A tiempo completo

    Role OverviewLean Tech is seeking a skilled Data Automation Analyst to join our 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...

  • Data Analyst

    hace 3 meses


    Medellín, Antioquia, Colombia ttg Talent Solutions A tiempo completo

    **JOB TITLE**: Data Analyst/Developer **LOCATION**: Hybrid - Medellin **TYPE**: Full-time **SCHEDULE**: Monday to Friday **TYPE OF CONTRACT**: Permanent **PAY RATE + BENEFITS**: Competitive salary + comprehensive benefits package **DESCRIPTION**: We are currently seeking a Data Analyst/Developer who will contribute to enhancing various technologies and...

  • Data Architect

    hace 4 semanas


    Medellín, Antioquia, Colombia Rockwell Automation A tiempo completo

    At Rockwell Automation, we are looking for a skilled Data Engineer to join our team and help us drive innovation in the field of data management.The ideal candidate will have a strong background in systems development lifecycle and data management concepts, with experience in Agile development methodologies and system/process documentation.Responsibilities...

  • Senior Data Architect

    hace 3 semanas


    Medellín, Antioquia, Colombia Rockwell Automation A tiempo completo

    We are seeking an experienced Senior Data Architect to join our team at Rockwell Automation. Based in Colombia, this role will involve designing, developing, and implementing data management solutions that support business growth and innovation.As a Senior Data Architect, you will be responsible for overseeing the stability of our platform, sourcing new...

  • Operations Analyst

    hace 1 mes


    Medellín, Antioquia, Colombia SD Solutions A tiempo completo

    SD Solutions is seeking a talented Operations Analyst to join our team and contribute to the success of our global payables automation platform.Key Responsibilities:Data Analysis:Conduct thorough analysis of customer data to identify trends, opportunities, and at-risk accounts.Provide actionable insights through comprehensive reporting on team performance,...


  • Medellín, Antioquia, Colombia Rockwell Automation A tiempo completo

    At Rockwell Automation, we're looking for a talented Data Engineer Leader to join our team. As a key member of our organization, you will play a crucial role in supporting the stability of our platform by monitoring and responding to support tickets. You will also enable business capability teams to meet their objectives by sourcing new data.We're seeking a...

  • Data Analyst

    hace 1 mes


    Medellín, Antioquia, Colombia Curv Group LLC A tiempo completo

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Curv Group LLC. As a Data Analyst, you will play a critical role in managing and optimizing the flow of information in our sales CRM, Pipedrive.Key Responsibilities:Manage and optimize the flow of information in the sales CRM (Pipedrive), ensuring data accuracy and...

  • Data Engineer

    hace 1 mes


    Medellín, Colombia Rockwell Automation A tiempo completo

    Rockwell Automation is a global technology leader focused on helping the world’s manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale,...

  • Data Engineer

    hace 4 semanas


    Medellín, Colombia Rockwell Automation A tiempo completo

    Rockwell Automation is a global technology leader focused on helping the world’s manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale,...

  • Lead Data Engineer

    hace 3 meses


    Medellín, Antioquia, Colombia Rockwell Automation A tiempo completo

    Rockwell Automation is a global technology leader focused on helping the world’s manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale,...

  • Marketing Data Analyst

    hace 4 semanas


    Medellín, Antioquia, Colombia AgileEngine A tiempo completo

    Job Title: Marketing Data AnalystJob Summary:We are seeking a highly skilled Marketing Data Analyst to join our team at AgileEngine. As a Marketing Data Analyst, you will be responsible for conducting thorough research on our current Ideal Customer Profile (ICP) and new potential ICPs to identify trends, behaviors, and preferences. You will analyze market...


  • Medellín, Antioquia, Colombia Parexel A tiempo completo

    Parexel is seeking a skilled Senior Clinical Data Analyst to support our FSP team.This is a remote role, and we welcome candidates based in Argentina, Brazil, Mexico, and Colombia.The Senior Clinical Data Analyst will independently perform and/or coordinate all clinical data validation activities on assigned projects, commensurate with experience and/or...

  • Data Insights Analyst

    hace 4 semanas


    Medellín, Antioquia, Colombia BairesDev A tiempo completo

    We are leading the way in technology projects, delivering cutting-edge solutions to giants like Google and innovative startups in Silicon Valley. Our diverse team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.As a Growth Data Analyst at BairesDev, you will collect, organize, analyze, and...


  • Medellín, Antioquia, Colombia Rockwell Automation A tiempo completo

    **Company Overview** Rockwell Automation is a global leader in technology, dedicated to helping manufacturers become more productive, sustainable, and agile. With over 28,000 employees who strive to make the world a better place every day, we know we have something special. Behind our customers – amazing companies that contribute to global food security,...

  • People Data Analyst

    hace 1 mes


    Medellín, Antioquia, Colombia VTEX A tiempo completo

    About the RoleWe are seeking a highly skilled People Data Analyst to join our team at VTEX. As a key member of our growth team, you will be responsible for building and optimizing dashboards, databases, and analytics to provide actionable insights that will guide our decisions related to our people strategy.Key ResponsibilitiesDevelop and maintain dashboards...


  • Medellín, Antioquia, Colombia Third Way Health A tiempo completo

    About the RoleWe are seeking a highly skilled Salesforce Analyst to join our team at Third Way Health. As a key member of our team, you will be responsible for analyzing and interpreting data from Salesforce and related third-party systems to identify trends and opportunities for improvement.Key ResponsibilitiesAnalyze and interpret data from Salesforce and...


  • Medellín, Antioquia, Colombia Parexel A tiempo completo

    Parexel is seeking a Senior Clinical Data Analyst to support our FSP team.The Senior Clinical Data Analyst will independently perform/lead and/or coordinate all clinical data validation activities on assigned projects, commensurate with experience and/or project role, with high degree of proficiency and autonomy.Further responsibilities shall include...

  • Sports Data Analyst

    hace 4 semanas


    Medellín, Antioquia, Colombia Genius Sports A tiempo completo

    About Genius SportsWe're a leading sports technology company that's changing the game. Our mission is to create a more sustainable sports data ecosystem that benefits everyone involved.What We're Looking ForWe're seeking a highly motivated and detail-oriented Live Feed Analyst to join our team. As a Live Feed Analyst, you'll be responsible for collecting and...

  • Data Analyst

    hace 3 semanas


    Medellín, Antioquia, Colombia Neostella A tiempo completo

    **Key Responsibilities**: - Collaborate with cross-functional teams to understand business requirements and objectives. - Clean and manipulate data from multiple sources to ensure accuracy and reliability. - Develop and maintain dashboards, reports, and visualizations using Domo and PowerBI to communicate key insights effectively. - Conduct in-depth data...

  • Business Data Analyst

    hace 3 meses


    Medellín, Antioquia, Colombia Sofka A tiempo completo

    **Are you looking for challenges and a place where you can find a close working environment while constantly learning?***: We are a company with a clear purpose: "To **TRANSFORM **people’s lives being the most trusted **TECHNOLOGY **partner". Get ready and be part of this adventure! **What will you find?**: - Professional and personal...