Marketing Data Analyst

Synergis; Culver City (CA); On-site; USD 100,000 - 125,000; Full time

Job summary

A leading company is seeking a Marketing Data Analyst to join their Growth Marketing team. The role involves optimizing audience lists for email and push notification campaigns, utilizing SQL for data analysis, and collaborating with various teams to meet campaign goals. The ideal candidate will have extensive experience in data analysis, strong SQL skills, and the ability to work with large datasets.

Benefits

Medical insurance

Dental insurance

Vision insurance

Disability insurance

Life insurance

401k

Commuter benefits

Qualifications

• 5-7 years of experience in a data analyst role, preferably in marketing.
• High proficiency with databases and data retrieval.
• Experience with large data sets and performance tuning.

Responsibilities

• Optimize and create production audience lists for campaigns.
• Translate business requirements into complex SQL queries.
• Work with stakeholders to gather requirements.

Skills

Python

SQL

Data Analysis

Automation

Documentation

Tools

Trino

Snowflake

Tableau

Job description

TITLE: Marketing Data Analyst
LOCATION: Hybrid in Culver City, CA, Cupertino, CA or Austin, TX
ANTICIPATED DURATION: 12 months

You will be joining the Growth Marketing team that focuses on supporting list pull campaigns for services within the business. Your role will be to optimize, support, and create the production audience lists for email and push notifications campaigns. You will do this by working with the CLM Strategy, Operations, and Email Producers to understand the goal of the campaigns translating those business requirements into complex SQL queries to build target audience lists and dashboards and optimizing attributes for use in automation.

Marketing Data Analyst Top Skills:

• Experience with Python, automating repetitive tasks
• Experience working with/creating/updating procedures for use in automation · 5-7 years of experience in a data analyst role – marketing domain required (i.e., analyzing e-mail marketing, digital campaign analysis, logistics analysis, operations analysis etc.) – This person must come from an analytical background
• Experience working with large data sets (i.e., pulling lists over 1 billion records on a regular basis).
• High proficiency with databases and data retrieval, ANSI SQL (Trino/Snowflake)
• Strong SQL skills (must be able to demonstrate the following expertise in an interview)
• Ability to convert queries in automated scripts using SQL
• Ability to write queries off of business requirements (example query concepts: want to look at the most popular artist per user – how would you create this query)
• Performance tuning – when a data set is too big you must simplify it to optimize performance.
• Working knowledge of stored procedures, triggers, functions, and packages
• Creation of server-side Tableau dashboards and setting up requisite data sources
• Knowledge of statistical principles and the underlying data assumptions on which they rely
• Hands-on experience with at least 2 of the following statistical models/techniques: recommendation systems, neural networks, deep learning, optimization and simulation, churn models, logistic regression, linear regression, forecasting, A/B testing, clustering and segmentation, or others
• Extremely strong with documentation

Marketing Data Analyst Soft Skills:

• Excellent written, oral and general communication skills
• The ability to fully digest and run requirement gathering meetings with business stakeholders.
• Strong communication skills and able to articulate roadblocks
• Someone who is very process-oriented
• Must communicate both upstream and downstream
• Concise and thoughtful communicator
• Ability to adapt to changes, self-driven and multitasking in very fast paced environment are key success factors for the right candidate.

Marketing Data Analyst Preferred Experience:

• UNIX Shell Scripting
• Experience with Trino/Snowflake
• Experience with working with LLM tools and AI frameworks

The hourly pay rate range for this position is $60 to $66 (dependent on factors including but not limited to client requirements, experience, statutory considerations, and location). Benefits available to full-time employees: medical, dental, vision, disability, life insurance, 401k and commuter benefits.

Synergis is proud to be an Equal Opportunity Employer. We value diversity and do not discriminate on the basis of race, color, ethnicity, national origin, religion, age, gender, gender identity, political affiliation, sexual orientation, marital status, disability, military/veteran status, or any other status protected by applicable law.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with the requirements of applicable state and local laws, including but not limited to, the San Francisco Fair Chance Ordinance, the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

For immediate consideration, please forward your resume to [e-mail]

If you require assistance or an accommodation in the application or employment process, please contact us at [e-mail].

Synergis is a workforce solutions partner serving thousands of businesses and job seekers nationwide. Our digital world has accelerated the need for businesses to build IT ecosystems that enable growth and innovation along with enhancing the Total Experience (TX). Synergis partners with our clients at the intersection of talent and transformation to scale their balanced teams of tech, digital and creative professionals. Learn more about Synergis at www.synergishr.com.