Marketing Analytics Intern

Jobtailor; Chicago (IL); On-site; USD 25,000 - 44,000; Part time

Job summary

Jobtailor in Chicago seeks a Marketing Analytics intern to support funnel analysis using SQL and Python, contribute to reporting, and help optimize marketing effectiveness.

You will update DBT data models in Snowflake, enhance Periscope dashboards, and collaborate with Marketing, Risk, and Engineering to drive data-driven decisions. Local candidates or relocation are acceptable; must be eligible to work in the U.S.

Qualifications

• Proficient in SQL and Python for data analysis.
• Strong written and verbal communication with attention to detail.
• Experience writing queries for data extraction, transformation, and analysis.
• Comfortable with joins, aggregations, subqueries, CTEs, and window functions.

Responsibilities

• Monitor funnel metrics via reports and dashboards to track channel performance and surface root-cause insights.
• Use SQL and Python to analyze funnel trends, quantify drop-off drivers, and provide optimization recommendations.
• Communicate findings clearly to stakeholders.
• Assist in updating DBT data models in Snowflake to streamline reporting.
• Enhance Periscope dashboards by adding charts and metrics for visibility across the marketing funnel.
• Partner with Marketing, Risk, and Engineering to implement strategy changes and analyze post-release impact.
• Support the Marketing Analytics team while collaborating with senior analytics experts.

Skills

SQL

Python

Data analysis

Cross-functional collaboration

Attention to detail

Education

Bachelor’s or Master’s degree in a quantitative field (in progress)

Tools

Snowflake

DBT

Periscope

Job description

• Monitor key funnel metrics through reports and dashboards to track channel performance, diagnose deviations, and surface root-cause insights
• Use SQL and Python to analyze funnel trends, quantify drop-off drivers, and provide recommendations to optimize
• Communicate findings clearly and concisely to stakeholders
• Assist in updating and maintaining DBT data models in Snowflake to streamline reporting
• Enhance Periscope dashboards by adding charts and metrics to improve visibility across the marketing funnel
• Partner with Marketing, Risk, and Engineering to implement strategy changes, monitor releases, and conduct post-release impact analysis
• Support the Marketing Analytics team while partnering with Marketing and senior analytics experts

Requirements

• Currently pursuing a Bachelor’s or Master’s Degree
• Strong written and verbal communication skills with excellent attention to detail
• Strong ability to write queries for data extraction, transformation, and analysis
• Comfortable with joins, aggregations, subqueries, CTEs, and window functions
• Strong quantitative and problem-solving skills with key attention to detail
• Advanced degree in a quantitative discipline is a plus, including math, statistics, operations research, quantitative finance, physics, engineering, computer sciences, or related fields
• Experience supporting and working with cross-functional teams in a dynamic environment is a plus
• Proficiency using Python is a plus
• Candidates must be local to Chicago or able to relocate independently; relocation assistance is not provided
• Must be legally authorized to work in the U.S. without the need for current or future visa sponsorship

Core Competencies

Proficient in SQL and Python for data analysis, with strong quantitative and problem-solving skills. Capable of communicating insights effectively to stakeholders and collaborating with cross-functional teams to enhance marketing strategies.

Highest-signal resume keywords

• SQL Query Writing
• Python Proficiency
• Data Analysis
• Cross-Functional Collaboration
• Attention to Detail

Hard Skills

• Data Extraction
• Data Transformation
• Data Analysis
• Joins
• Aggregations
• Subqueries
• CTEs
• Window Functions
• Funnel Metrics Monitoring
• DBT Data Models

Soft Skills

• Written Communication
• Verbal Communication
• Problem-Solving
• Attention to Detail

Industry Keywords

• Marketing Analytics
• Quantitative Discipline
• Dynamic Environment
• Stakeholder Communication

Tools & Technologies

• Snowflake
• Periscope