Marketing Analyst

We are seeking a data-driven Marketing Analyst to support credit card acquisition campaigns through advanced analytics, data processing, and reporting. This role requires strong expertise in Snowflake and SQL to build scalable data solutions and deliver actionable insights across multi-channel campaigns.

Key Responsibilities:

Campaign Analytics & Reporting

• Develop and maintain automated reporting and dashboards using Snowflake and SQL to track campaign performance.

• Produce summary-level metrics including applications, accounts, response rates, approval rates, and net booking rates.

• Build detailed reporting views across campaign dimensions such as segments, channels, creatives, and customer attributes.

• Integrate email performance data (deliveries, opens, clicks-to-application) into unified reporting for a holistic campaign view.

• Create funnel analysis from delivery through booking, identifying conversion rates and drop-offs at each stage.

• Ensure data accuracy and optimize query performance within Snowflake environments.

Campaign Data Management & Execution

• Translate marketing campaign requirements into technical data processing logic and workflows.

• Oversee campaign data preparation, including file standardization, validation, and quality checks. • Support processes such as NCOA updates, credit bureau pre-screening, and regulatory compliance.

• Generate campaign reporting outputs to support decision-making (e.g., waterfall reporting, segmentation analysis, model performance).

• Prepare and deliver campaign files for execution across channels (direct mail, email, digital, web). • Coordinate delivery of data files to internal teams (Analytics, Operations) and external vendors.

Required Skills & Qualifications:

• Strong hands-on experience with Snowflake for data warehousing and analytics.

• Advanced proficiency in SQL (joins, aggregations, window functions, performance tuning).

• Experience working with large datasets in a marketing, financial services, or credit card environment.

• Knowledge of campaign analytics, customer segmentation, and funnel analysis.

• Familiarity with credit bureau data, pre-screen processes, and marketing compliance requirements is a plus.

• Strong analytical thinking and ability to translate data into business insights.

• Excellent stakeholder communication and coordination skills.