Marketing Analytics Intern: Data-Driven Insights & Dashboards

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

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.