Data Automation Analyst

hace 6 días

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

  • Senior Data Architect

    hace 2 semanas

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

    Rockwell Automation is a global leader in industrial automation and digital transformation. We empower manufacturers to improve productivity, sustainability, and agility through innovative technologies and solutions.We are seeking a highly skilled and experienced Data Engineer to join our team. As a key member of our data management team, you will be...

  • Data Analyst

    hace 2 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 1 día

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

  • Operations Analyst

    hace 1 mes

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

    Operations Analyst Job DescriptionSD Solutions is seeking a skilled Operations Analyst to join our team. As an Operations Analyst, you will play a crucial role in analyzing data, streamlining processes, and optimizing the customer experience.Key Responsibilities:Data Analysis: Conduct thorough analysis of customer data to identify trends, opportunities, and...

  • Operations Analyst

    hace 5 días

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

  • Operations Analyst

    hace 4 semanas

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

    Operations Analyst Job DescriptionSD Solutions is seeking a skilled Operations Analyst to join our team. As an Operations Analyst, you will play a crucial role in analyzing data, streamlining processes, and optimizing the customer experience.Key Responsibilities:Data Analysis: Conduct thorough analysis of customer data to identify trends, opportunities, and...

  • Data Engineer Leader

    hace 3 días

    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 2 semanas

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

  • Operations Analyst

    hace 1 mes

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

    Operations Analyst Job DescriptionSD Solutions is seeking a skilled Operations Analyst to join our team. As an Operations Analyst, you will play a crucial role in analyzing data, streamlining processes, and optimizing the customer experience.Key Responsibilities:Data Analysis: Conduct thorough analysis of customer data to identify trends, opportunities, and...

  • Data Engineer

    hace 5 días

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

  • Operations Analyst

    hace 4 semanas

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

    Unlock Your Potential as an Operations Analyst at SD SolutionsJoin our team at SD Solutions, a global payables automation platform, as we seek a talented Operations Analyst to drive our fintech unicorn rocketship forward. As an Operations Analyst, you will play a pivotal role in analyzing data, streamlining processes, and optimizing the customer...

  • Operations Analyst

    hace 2 semanas

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

    Operations AnalystSD Solutions is seeking a highly skilled Operations Analyst to join our team. As an Operations Analyst, you will play a critical role in supporting our customer success initiatives and driving business growth.Key Responsibilities:Conduct data analysis to identify trends and opportunities for improvementDevelop and maintain key performance...

  • Lead Data Engineer

    hace 2 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 2 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,...

  • Growth Data Analyst

    hace 2 semanas

    Medellín, Antioquia, Colombia BairesDev A tiempo completo

    About the RoleWe are seeking a talented Growth Data Analyst to join our team at BairesDev. As a key member of our marketing team, you will be responsible for collecting, organizing, and analyzing data to drive business growth and inform strategic decisions.Key ResponsibilitiesCollect and organize data related to marketing activitiesAnalyze data to extract...

  • Senior Clinical Data Analyst

    hace 2 días

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

  • Senior Data Analyst

    hace 2 semanas

    Medellín, Antioquia, Colombia Endava A tiempo completo

    At Endava, we harness technology to drive meaningful change. Our data team is responsible for transforming raw data into actionable insights, building robust data infrastructures, and enabling data-driven decision-making and innovation through advanced analytics and predictive modeling. As a Senior Data Analyst, you will be responsible for extracting...

  • Data Insights Analyst

    hace 2 días

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

  • People Data Analyst

    hace 2 semanas

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

  • Data Analyst, Colombia

    hace 1 mes

    Medellín, Antioquia, Colombia Aimpoint Digital A tiempo completo

    About Aimpoint DigitalAimpoint Digital is a leading analytics consulting firm dedicated to driving business value for clients through expertise in analytics, decision science, data engineering, and infrastructure. Our analytics practice focuses on analytics process automation, data visualization, and statistical analyses.Job SummaryWe are seeking a talented...