About the Position

Data Analyst – BI & Automation

About Us

VML Colombia connects creativity, strategy, technology, data, and business to build impactful solutions for our clients and their brands. We are looking for a Data Analyst – BI & Automation to work with our team on projects related to information analysis, business intelligence, and process automation.

We aim to transform data into reliable and actionable information, optimizing processes and facilitating decision-making through analytical solutions and technological tools. Our Human First culture drives us, where collaboration, curiosity, and continuous learning are part of our daily routine.

Responsibilities

As a Data Analyst – BI & Automation, you will be responsible for managing data processes from start to finish: from data extraction, cleaning, and transformation to process automation and the construction of dashboards and reports.

Your work will be key to ensuring data quality and availability, optimizing recurring tasks, and converting business needs into efficient analytical solutions.

We are looking for someone with analytical thinking, autonomy, and strong technical skills who can investigate, solve problems, and develop solutions that go beyond data visualization.

Daily Tasks

Extract, clean, transform, and analyze data from different sources.
Develop and maintain Python scripts to automate processes, reports, and file generation.
Build and optimize SQL queries for data extraction, cross-referencing, and validation.
Create, maintain, and update dashboards and reports in Power BI, using data modeling, DAX, and Power Query.
Manage databases, files, and update processes, ensuring data quality and consistency.
Automate recurring processes and optimize workflows using Python, Excel, and other tools.
Address analytical requirements and ad hoc requests, identifying errors and proposing solutions.
Analyze trends, identify inconsistencies, and generate useful information for decision-making.
Document processes and manage code versions using Git/GitHub.
Work with technical and business teams to understand needs and deliver timely solutions.

Requirements

Professional degree in Systems Engineering, Statistics, Mathematics, Industrial Engineering, Economics, or related fields.
3 to 5 years of experience in data analysis, Business Intelligence, automation, or related roles.
Intermediate/advanced knowledge of Python, especially Pandas, NumPy, data cleaning and transformation, exploratory analysis, and automation.
Experience with SQL/MySQL, including queries, JOINs, subqueries, CTEs, and aggregate functions.
Intermediate/advanced knowledge of Power BI, including Power Query, data modeling, DAX, measures, and dashboards.
Advanced knowledge of Excel, including formulas, pivot tables, Power Query, and Power Pivot.
Knowledge of Git/GitHub for version control and repository management.
Ability to manage complete data processes, from extraction to the delivery of reports and analytical solutions.
Analytical thinking, attention to detail, and problem-solving orientation.
Autonomy, organization, and ability to manage multiple requirements and deadlines.
Ability to communicate technical results clearly to different teams.

Nice to Have

Experience automating data reports and processes on a recurring basis.
Experience working with APIs, cloud services, or integrations between different data sources.
Experience in commercial, financial, sales, marketing, retention, or performance analysis processes.
Knowledge of applied statistics and exploratory data analysis.
Experience developing solutions to optimize operational processes and improve team efficiency.

We Offer

Indefinite term contract.
Hybrid modality.
Learning and growth opportunities within a global network like WPP.
A dynamic and collaborative environment focused on innovation and strategic data use.
The opportunity to develop automation and analytical solutions with direct business impact.
Experience working with multidisciplinary teams and projects that integrate technology, data, and strategy.

About the Company

VML is part of WPP, the trusted growth partner for the world's leading brands. We are committed to fostering a totally inclusive work environment that is rewarding and promotes professional development. We believe in creating a dynamic work environment that values diversity and inclusion and strive to recruit a diverse list of candidates to help us achieve this goal. We will be happy to provide reasonable accommodations to people with disabilities who need accommodation to use or access VML's career site or to fully participate in the application process. If you need an accommodation to complete your application or any other aspect of our recruitment process due to a disability, please contact our Human Resources department or send an email to (HR contact) to request it.

When you click "Submit Application", the information you enter below will be sent to VML. Before you do this, we suggest you review our Recruitment Privacy Policy. California residents should read our California Recruitment Privacy Notice. These documents explain how we use your personal data when you apply for a position with us, as well as how you can update or remove the information you have provided us.

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we've adopted a hybrid approach, with teams in the office an average of four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.

WPP (VML) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

When you click "Submit Application", this will send any information you add below to VML. Before you do this, we think it's a good idea to read through our Recruitment Privacy Policy. California residents should read our California Recruitment Privacy Notice. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.

Data Analyst – BI & Automation

Job description