Senior Marketing Data Analyst

Responsibilities

• Build and maintain SQL-backed datasets for campaign, channel, lead, attribution, and conversion reporting
• Analyze marketing performance across paid search, paid social, display, email, web, offline, and other channels
• Partner with channel owners to answer key business questions: what happened, why it happened, and what to do next
• Standardize marketing KPIs including leads, conversion rates, CPL, CPA, ROI, attribution windows, and funnel metrics
• Develop Tableau dashboards and recurring reports based on trusted data models
• Monitor data quality, tracking gaps, duplicates, reconciliation issues, and reporting inconsistencies
• Support attribution, media mix, lead quality, funnel conversion, and budget allocation analysis
• Design, execute, and analyze A/B tests, multivariate tests, and marketing experiments
• QA and troubleshoot tracking across GA4, GTM, Salesforce, Invoca, paid media platforms, email, web, and offline channels
• Present clear, actionable insights to Marketing, Sales, agencies, and leadership

Requirements

• 3+ years of experience as a marketing analyst, marketing data analyst, data analyst, or similar role
• Experience supporting digital or performance marketing teams with actionable reporting and analysis
• Hands-on experience with Google Analytics 4 and Google Tag Manager
• Strong data-quality mindset and ability to validate reporting before sharing insights
• Clear communication skills with the ability to explain findings to technical and non-technical audiences

Preferred

• Advanced SQL, including CTEs, window functions, performance tuning, or warehouse/ETL experience

Python or R for deeper analysis

• Experience with customer lifetime value, predictive scoring, MMM, or multi-touch attribution
• Basic JavaScript, HTML, or CSS for GTM and tracking troubleshooting

Paid media platform APIs or warehouse integrations

• Experience in security, home services, smart home, subscription, or lead-generation businesses
• Experience working with agencies and Sales teams on lead quality and funnel conversion

What We’re Looking For

• Strong SQL skills, including pulling, joining, cleaning, and aggregating marketing and CRM data
• Experience with Tableau or similar BI tools connected to SQL/data models
• 2+ years of experience designing and analyzing marketing tests or experiments
• Understanding of paid search, paid social, display, email, and omnichannel campaign measurement
• Experience with CRM or marketing automation reporting; Salesforce preferred
• Bachelor’s degree in Marketing, Business, Statistics, Data Analytics, Economics, or related field preferred; equivalent experience considered

Nice to Have

Why Join CPI Security?

At CPI Security, you’ll join a collaborative, mission-driven team focused on innovation, service, and protecting what matters most. Your work will directly influence how marketing performance is measured and how teams make decisions that help customers feel safer, more connected, and more in control.

Competitive pay

• Medical, dental, vision, life insurance, and disability options
• Paid holidays, floating holidays, and PTO
• 401(k) with competitive company match
• Free monitored security system eligibility after 90 days

Education assistance

Volunteer and community engagement opportunities

On-site café, coffee/smoothie bar, walking trail, basketball court, and fitness facility with dedicated staff