Remote ML Data Analyst for Market Insights

Prometeo Talent; Bogotá; Hybrid; COP 101,003,000 - 181,806,000; Full time

Benefits offered by this job

10 days PTO

USA Holidays

100% remote work

Job summary

Prometeo Talent is recruiting a Data Analyst (Machine Learning) to join a U.S.-based client focused on marketing effectiveness measurement. You will work with large-scale consumer and retail datasets, translating data into clear metrics for business decisions.

The role emphasizes SQL, Python, and pandas with strong communication in English. Open to a range of experience levels from graduates to mid-level analysts seeking to deepen data manipulation skills.

Qualifications

• 0 to 4 years of experience in Data Analysis, Business Analytics, or similar roles.
• Advanced English level (written and spoken).
• Foundational to intermediate SQL skills, including complex JOIN logic, standard aggregations, and CASE WHEN.
• Python scripting for data cleaning, manipulation, and processing, with proficiency in pandas.
• Familiarity with modeling libraries such as scikit-learn or statsmodels to build and evaluate predictive or statistical matching models.
• Experience working with messy text fields: cleaning, parsing, filtering, and pattern matching within string variables.
• Solid understanding of relational database design, including how tables connect, primary/foreign keys, and data normalization.
• Bachelor's degree in Business Analytics, Statistics, Mathematics, Computer Science, Economics, Marketing, or a related field with coursework covering database management or quantitative data analysis.

Responsibilities

• Write, optimize, and execute SQL queries to extract data from relational databases and cloud data warehouses.
• Develop, run, and validate machine learning, predictive, or statistical matching models to uncover deeper consumer behaviors and forecast trends.
• Slice, unpivot, and aggregate raw transactional or panel data to calculate core business metrics such as household penetration, market share, and purchasing trends.
• Build and maintain clean, structured data tables and views that feed into recurring tracking reports and stakeholder dashboards.
• Review query outputs, perform data audits, and double-check logic to ensure accuracy and data integrity before insights are finalized.
• Use conditional logic and filtering techniques to segment data and isolate specific tracking cohorts.
• Clean, parse, and categorize unstructured or semi-structured text data.
• Translate technical data structures and query results into clear written summaries, bullet points, or data tables for stakeholders in English-speaking environments.

Skills

SQL

Python

Pandas

Data analysis

English communication

Education

Bachelor's degree in Business Analytics/Statistics/Mathematics/CS/Economics/Marketing

Tools

Snowflake

BigQuery

Redshift

Job description

Prometeo Talent is recruiting a Data Analyst (Machine Learning) to join a U.S.-based client focused on marketing effectiveness measurement. You will work with large-scale consumer and retail datasets, translating data into clear metrics for business decisions.

The role emphasizes SQL, Python, and pandas with strong communication in English. Open to a range of experience levels from graduates to mid-level analysts seeking to deepen data manipulation skills.