Data Analyst - Marketing

HRTX; Philippines; On-site; PHP 380,000 - 580,000; Full time

Job summary

HRTX is seeking a data analyst in the Philippines to analyze sales and marketing data across categories and communicate actionable insights to buying, sales, and marketing teams.

You will interpret large transaction and customer data to inform category futures, work with cross-functional stakeholders, and own seasonal reporting such as sell-through performance for assigned categories.

Qualifications

• 2+ years of solid SQL querying experience, including BigQuery.
• Experience with Python or R for data analysis.
• Proficient in Excel for data manipulation and analysis.
• Familiar with ETL processes and data integration.
• Ability to synthesize large datasets into clear insights.

Responsibilities

• Analyze sales and marketing information for assigned categories and propose next steps.
• Provide insights on large transaction and customer data to business leaders.
• Articulate insights clearly to help category futures and strategies.
• Own seasonal reporting including sell-through and seasonal performance reports.
• Coordinate with cross-functional stakeholders to meet reporting needs.

Skills

SQL

Python

R

BigQuery

ETL

Excel

Data analysis

Tools

Google Cloud BigQuery

Job description

• Analyze company wide sales and marketing information for assigned categories, envision the next steps for that category based on the data, and inform our buying, sales and marketing teams to assist them in driving sales goals.
• Analyze, interpret and provide insights/conclusions on large amounts of transaction and customer/shopper data globally and by marketing area, to communicate impactful recommendations to business leaders.
• Creatively articulate the insights behind the data and help our team iterate category futures.
• Manage cross-functional stakeholder needs both effectively and sensitively.
• Own seasonal reporting related tasks including building and launching sell through and seasonal performance reports for all assigned categories.

Qualification

Requirements:

• Solid SQL writing / coding (Structured Query Language) / Google Cloud Big Data Query experience (at least 2 years of solid experience): Essential for querying databases and managing large datasets.
• Knowledge of languages such as Python and R for data analysis.
• Proficiency in tools like Microsoft Excel for data manipulation and analysis.
• Understanding of ETL processes and tools for data integration.
• General knowledge of segmentation models and an ability to synthesize and summarize large amounts of information clearly and concisely.