Marketing Operations Specialist (SQL)

Philtech Inc.; Taguig; On-site; PHP 1,000,000 - 1,400,000; Full time

Job summary

Philtech Inc. is seeking a Senior Marketing Operations Analyst to support execution of marketing and loyalty programs, including digital offer allocations and multi-channel audience creation. The role requires strong SQL skills, meticulous attention to detail, and the ability to follow standardized SOPs.

Offshore analysts must be available during Pacific Time for collaboration with the onshore team. You will build audience files for Email, Push, and RCS, optimize SQL queries, maintain SOP

Qualifications

• 3+ years of advanced SQL experience.
• Strong written and verbal English.
• High attention to detail and commitment to zero‑defect execution.
• Ability to follow detailed SOPs and process documentation.

Responsibilities

• Execute digital offer allocations based on defined business rules.
• Build and maintain audience files for Email, Push, and RCS channels.
• Serve as a power user of GrowthLoop CDP.
• Write and optimize complex SQL queries for segmentation, targeting, and QA.
• Develop and maintain SOP documentation.
• Partner with CRM and Marketing Operations to ensure correct audience integration with deployment systems.
• Conduct rigorous QA of your own work and teammates' to ensure zero-defect campaigns.

Skills

Advanced SQL

English fluency

Detail-oriented

SOP adherence

Tools

Snowflake

BigQuery

Teradata

GrowthLoop CDP

Job description

The Senior Marketing Operations Analyst supports execution of marketing and loyalty programs, including digital offer allocations and multi-channel audience creation. This role requires strong SQL skills, excellent attention to detail, and the ability to follow standardized processes and documentation. Offshore analysts must be available during Pacific Time working hours Monday through Friday for collaboration with the onshore team.

Key Responsibilities:

• Execute digital offer allocations based on defined business rules.
• Build and maintain audience files for Email, Push, and RCS channels.
• Serve as a power user of our Customer Data Platform (GrowthLoop).
• Write and optimize complex SQL queries for segmentation, targeting, and QA.
• Develop and maintain SOP documentation.
• Partner with CRM and Marketing Operations team to ensure correct audience integration with deployment systems.
• Conduct rigorous QA of your own work and the work of your teammates to ensure zero-defect campaign launches.

Required Qualifications:

• 3+ years of advanced SQL experience.
• Strong written English communication skills; clear spoken English for collaboration.
• High attention to detail and commitment to zero‑defect execution.
• Ability to follow detailed SOPs and process documentation and exercise sound judgment by proactively seeking clarification from the onshore team when instructions are unclear or require additional context.

Preferred Skills:

• Experience with Snowflake, BigQuery, or Teradata data warehouses.
• Hands-on CDP experience (especially GrowthLoop).
• Experience with Email, Push, and RCS campaign execution.
• Background in Marketing Operations or Campaign Operations.