Summer 2027 Intern, Optimization & Reporting

Thinklance LLP; Philadelphia (Philadelphia County); On-site; USD 23,000 - 32,000; Part time

Benefits offered by this job

Capstone Project

Philadelphia headquarters

Client-facing exposure

Company outings

Job summary

Thinklance LLP is offering a paid internship in Philadelphia focused on data analytics and business insights. You will collect and analyze data to support KPI reporting and performance tracking, and assist in building dashboards using Excel or other tools.

You will learn business analytics techniques, support client reports with insights, and help identify process improvements and automation opportunities. The internship includes a Capstone Project and in-person collaboration across departments,

Qualifications

• Curious data enthusiast who uncovers insights and proposes data-driven solutions.
• Collaborator with clear, open communication for sharing findings and ideas.
• Tech savvy with data analysis tools and ability to learn new software quickly.
• Highly organized and detail-oriented, manages time efficiently and ensures accuracy.
• Experience with data collection/analysis, marketing analytics exposure, KPI reporting; strong Excel, VBA, and dashboard skills; knowledge of social listening and Boolean search; leadership through activities.

Responsibilities

• Collect and analyze data to support KPI reporting and performance tracking.
• Assist in building dashboards and visualizations using Excel or other tools.
• Support development of client reports with insights and recommendations.
• Learn and apply business analytics techniques to real-world client data.
• Help identify process improvements and automation opportunities.

Skills

Data curiosity

Collaboration

Tech savvy

Organization & detail

Excel / VBA proficiency

Tools

Excel

Pivot tables

VBA

Job description

Your Role

Here’s what you will be doing:

• Collect and analyze data to support performance tracking and KPI reporting.
• Assist in building dashboards and visualizations using Excel or other tools.
• Support the development of client reports with insights and recommendations.
• Learn and apply business analytics techniques to real-world client data.
• Help identify process improvements and automation opportunities.

About You

The company is looking for:

• A data enthusiast driven by curiosity, who enjoys uncovering insights and proposing data-driven solutions.
• A collaborator with clear, open communication skills for effective idea and findings sharing.
• Tech savvy individuals familiar with data analysis tools and able to quickly learn new software.
• Highly organized and detail-oriented candidates who manage time efficiently and ensure accuracy.
• It’s a plus to have prior experience with data collection and analysis, exposure to marketing or social media analytics, familiarity with business analytics and KPI reporting, proficiency in Excel (pivot tables, advanced formulas, VBA), data visualization, dashboard design, experience with social listening platforms including advanced Boolean knowledge, and leadership experience through extracurricular or volunteer activities.

Compensation & Benefits

• Paid internship at $20/hour with biweekly pay during the nine-week program.
• Flexible scheduling of 20–30 hours per week coordinated with managers.
• In-person internship based at Athena’s Philadelphia headquarters.
• Professional exposure to client-facing work, enhancing skills in professionalism, communication, and public relations.
• Participation in a Capstone Project collaborating across departments to pitch new client opportunities to senior leadership and the CEO.
• Company outings showcasing Philadelphia’s culture and community, including visits to the Philadelphia Museum of Art and Citizens Bank Park.

Training & Development

Interns receive robust training and professional development, including weekly managerial check-ins and executive support. The program immerses interns in a collaborative, cross-functional environment working with teams across Creative, Marketing, Events, Operations, and Management Consulting.

Career Progression

The internship offers opportunities to take ownership of key reporting tasks and gain hands-on experience with performance tracking and workflow optimization, building foundational skills valuable for future career growth.