Data Analyst: SQL & Python Insights for Retail Growth

Chempro QLD Pty Ltd; Metro Manila; On-site; PHP 500,000 - 800,000; Full time

Job summary

Chempro QLD Pty Ltd in Manila is seeking a hands-on Data Analyst to join the Data Team. You will work directly in SQL and Python against our PostgreSQL data warehouse to model data, build reporting and turn point-of-sale and operational data into insight the business can act on.

You will work across the full path from raw data to decision — querying and shaping the data yourself, validating it, and presenting the result clearly to stakeholders across retail operations, category and marketing.

Qualifications

• Strong, demonstrable SQL with joins, aggregations, window functions and query optimisation.

Responsibilities

• Write and optimise SQL for PostgreSQL data warehouse to extract, transform and model data for reporting and analysis.
• Build and maintain Python scripts and notebooks to automate data extraction, transformation, validation and recurring reporting.
• Develop and maintain reporting and dashboards covering SKU sell-through, category growth, catalogue performance and store-level trading.
• Investigate business questions end to end — scope the question, source and validate the data, analyse it, and present a clear recommendation.
• Build forecasts across various periods, identifying peaks, seasonality and the drivers of volume change.
• Provide store-level reporting and forecast summaries with a localised approach, plus quarterly and annual sales forecasts for the marketing team.
• Review data for errors, gaps and inconsistencies; investigate root causes and work with the data team to fix them at the source.
• Contribute to the design, testing and documentation of data models, transformations and reporting logic.
• Use AI and large language model tooling to accelerate analysis, automate repetitive work and draw insight from unstructured data.
• Communicate findings to internal and external stakeholders in plain language, with clear visuals and a clear "so what".

Skills

SQL

Python

PostgreSQL

Analytical reasoning

Data quality

Communication

Tools

Power BI

Job description

Chempro QLD Pty Ltd in Manila is seeking a hands-on Data Analyst to join the Data Team. You will work directly in SQL and Python against our PostgreSQL data warehouse to model data, build reporting and turn point-of-sale and operational data into insight the business can act on.

You will work across the full path from raw data to decision — querying and shaping the data yourself, validating it, and presenting the result clearly to stakeholders across retail operations, category and marketing.