Dean Dorton→
Marketing Analyst Intern at Dean Dorton in Cincinnati, OH
InternshipRemoteCincinnati, OH
Skills
ga4tableaupower bilooker studioexcelsqlpythonrgoogle analytics 4
Job Description
Internships
Cincinnati,
Ohio
Lexington,
Kentucky
Louisville,
Kentucky
Fort Wright,
Kentucky
Description
About Dean Dorton:
Dean Dorton’s team makes up one of the largest advisory firms in the United States. We thrive when you thrive! We are here to help you succeed in every step of your development and career as you work with nationally recognized experts in a recognized best place to work.
Position Overview
We are looking for a data-curious and detail-oriented Marketing Analyst Intern to join our team. You will help us decode customer behavior, track campaign ROI, and provide actionable insights that shape our 2026 marketing strategy. This is an ideal role for someone who loves "the why" behind the numbers and wants hands-on experience with industry-standard analytics tools.
Key Responsibilities
- Data Collection & Hygiene: Assist in pulling data from various channels (Social Media, Google Ads, Email) and ensuring it is clean and organized for analysis.
- Campaign Tracking: Monitor the performance of live marketing campaigns using GA4 and internal dashboards; flag underperforming segments in real-time. Familiarity in keyword optimization, SEO/SEM.
- Competitor Benchmarking: Conduct market research to identify industry trends, competitor pricing, and emerging digital strategies.
- Reporting: Help build and update automated dashboards in Tableau, Power BI, or Looker Studio to visualize key performance indicators (KPIs).
- AI Optimization: Use generative AI tools to assist in sentiment analysis of customer reviews or to draft data-backed recommendations for content optimization.
- Collaboration: Work alongside the creative team to explain what data says about their content, helping them pivot based on what actually converts.
Required Skills & Qualifications
- Education: Currently pursuing or a recent graduate of a Bachelor’s or Master’s degree in Marketing, Statistics, Business Analytics, Economics, or a related field.
- Excel Mastery: Proficiency in VLOOKUPs, Pivot Tables, and data visualization.
- Analytical Mindset: Ability to spot patterns in large datasets and translate "data-speak" into simple business insights.
- Technical Familiarity: Basic understanding of Google Analytics 4 and social media metrics (engagement rates, CTR, CPC).
- Communication: Strong written and verbal skills for presenting findings to stakeholders.
Preferred (Bonus) Qualifications
- Experience with SQL for basic database querying.
- Familiarity with Python or R for statistical modeling.
- Experience in Google Ads, HubSpot, or Salesforce.
- Experience using AI-driven marketing tools (e.g., ChatGPT for data cleaning or Jasper for SEO analysis).
What You Will Gain
- Mentorship from seasoned marketers.
- Practical experience with "Big Data" in a fast-paced corporate environment.
- A portfolio of completed projects and reports to showcase to future employers.