Business Intelligence Developer(SQL/PowerBI/Tableau/AWS)

SM Retail Inc.; Pasay; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

SM Retail Inc. is seeking an experienced Reports and Visualization Analyst to work with business users across the organization, translating analytic needs into actionable dashboards for Marketing and Business teams.

You will lead a small BI team, drive data quality, and deliver insights through SQL-based reports and visualization tools, enabling customer profiling, campaign analysis, and improved store performance.

Qualifications

• 5+ years’ experience in data mining, database query, or reports generation.
• Experience with loyalty and CRM programs; led teams or major projects.
• Proficient in SQL and BI tools (Power BI / Tableau).
• Strong communication skills.

Responsibilities

• Generate reports and analyze data for profiling, segmentation and CRM campaigns.
• Guide users in data analysis, customer profiling, customer segmentation and measuring campaign effectiveness.
• Analyze transaction data to gain insight in improving store traffic and customer loyalty.
• Coordinate with teams on report production requirements and schedules to publish reports on time.
• Ensure data quality and integrity throughout the process of building and optimizing dashboard performance.
• Lead the team of BI Developers and Data Analysts to deliver report requirements via T-SQL Extraction and Data Visualization tool.

Skills

Data Mining

SQL scripting

Campaign analysis

Team leadership

Tools

Power BI

Tableau

Job description

An experienced reports and visualization analyst who will be working with the business users across the organization to determine their analytic needs, provide business analysis and design reports for Business and Marketing Teams to be used for insighting, customer profiling and campaign analysis.

Responsibilities

• Knowledgeable in Report Generation and Data Analysis, particularly in profiling, segmentation & CRM(Customer Relationship Management)
• Guide users in data analysis, customer profiling, customer segmentation and measuring campaign effectiveness.
• Analyze transaction data to gain insight in improving store traffic and customer loyalty.
• Coordinate with teams on report production requirements and schedules, to be able to publish reports on a timely basis.
• Ensure data quality and integrity throughout the process of building and optimizing dashboard performance
• Lead the team of BI Developers and Data Analysts to deliver report requirements via T-SQL Extraction and Data Visualization tool

Qualifications

• Preferably more than 5 years’ experience specializing in Data Mining, Database Query and Reports generation, Data Visualization or equivalent, with exposure in Loyalty and CRM programs, and has managed a team or major projects.
• Proficient in SQL scripting, Visualization Tool such as: Power BI and Tableau.
• Detail oriented with high emphasis on quality and accuracy
• Must possess excellent verbal and written communication skills