Data Analyst (SQL/PowerBI/Tableau)

SM Retail; Pasay; On-site; PHP 400,000 - 700,000; Full time

Job summary

SM Retail Inc. seeks a data analyst to transform data into actionable insights for loyalty marketing campaigns. You’ll analyze large data sets, collaborating with marketing and loyalty teams to design campaigns and improve data-driven decisions.

You will interpret campaign results, develop data-driven solutions, and communicate findings to executives, while providing feedback to data infrastructure teams to improve data quality.

Qualifications

• Bachelor’s degree in quantitative disciplines (statistics, ops research, math, econ, engineering) preferred.
• Experience with database platforms (SQL Server, MySQL, Oracle, AWS, Azure) preferred.
• Experience with BI tools like SQL, R and/or Python, and presentation tools such as Tableau, QlikView, or MS Power BI.
• Ability to translate data analysis into actionable insights and to communicate with non-technical audiences.

Responsibilities

• Analyze large data sets using data analytic tools to understand customer behavior and identify opportunities for loyalty marketing campaigns.
• Collaborate with Business, Marketing, and Customer Loyalty units to develop innovative marketing campaigns.
• Evaluate results of campaigns and develop data-driven solutions and algorithms as identified by Business Units.
• Provide feedback to Data Warehouse team on data quality and data requirements to improve Data Warehouse.

Skills

Data analysis

Data storytelling

Collaboration

Communication

Education

Bachelor’s degree in quantitative discipline

Tools

SQL

Python

R

Tableau

QlikView

Power BI

MS SQL Server

MySQL

Oracle

AWS

Azure

Job description

The Data Analyst is responsible for enabling Business Users to make better business decisions, by transforming data into streams of actionable insights, and use these insights to design, create, execute, and monitor Loyalty marketing digital marketing campaigns and strategies.

Responsibilities:

• Analyze large data sets, using data analytic tools, to understand customer behavior, and identify opportunities for loyalty marketing campaigns.
• Work in teams composed of Business, Marketing, and Customer Loyalty units/representatives, to collaboratively develop innovative and effective marketing campaigns.
• Evaluate and interpret results of marketing Campaigns Research and develop data driven solutions, and appropriate algorithms as may be identified by the Business Units.
• Provide feedback to Data Warehouse team, on the use of the data (Data quality, completeness, additional data requirements) to enable Data Warehouse team to improve Data Warehouse.

Qualifications:

• A bachelor's degree in quantitative discipline: statistics, operations research, mathematics, economics, engineering is preferred.
• Knowledge of database platforms (MS SQL Server, MySQL, Oracle, Amazon Web Services, MS Azure, etc.) preferred
• Experience with the use of business intelligence toolslike SQL, R and/or Python, and presentation tools such as Tableau, Qlikview, or MS PowerBI.
• Passionate about using data and analysis to make things happen. Ability to translate data analysis to actionable insights
• Ability to work in teams, and able to explain complex technical material to non-technical or executive audiences.