Media Data Analyst Intern Jobs in Addison, IL (NOW HIRING)

Company Description
With a history that dates back over 80 years, Starcom is a global communications planning and media leader. We are an agency still grounded in our founding principle that people are at center of all we do. Each day, we apply this belief to harness the transformative power of data and technology to inspire and move people and business forward. With more than 7,000 employees in over 100 offices around the world, Starcom partners with the world's leading marketers and brands, including Bank of America, Best Buy, Kellogg Company, McDonald's, Novartis, Samsung, Visa and more.
Overview
The Manager on this team will be pivotal in assisting client teams to convert raw data into valuable insights by developing and maintaining data infrastructure and analytics solutions. The role is also tasked with managing and supporting our clients on our data platforms. Additionally, the person in this role builds and runs reports, dashboards, visualizations on our data platforms. The person will work closely with all internal stakeholders like the Advanced Analytics, Investment and Planning teams in designing and implementing insightful data solutions.
Responsibilities
Data Modeling/Data Preparation

• Design, develop, and maintain data models as part of client data strategy using Visio or any other tool
• Write SQL to access data from data sources
• Write processes using scripting languages like Python to efficiently integrate data from diverse sources into reporting data marts
• Develop and maintain scalable and efficient data models to support analytical needs, ensuring data is organized, consistent, and accessible using tools like Prep Builder or working with Engineers on more complex implementation

Reporting and Visualization:

• Create and manage reports, dashboards, and visualizations using BI tools such as Tableau, Power BI, Looker, Dataroma to deliver actionable insights to business partners
• Work with database connections like Microsoft SQL Server, Azure

Collaboration:

• Work closely with data analysts, Engineers, reporting analysts and business partners to understand data needs and translate business requirements into technical specifications
• Work regularly with our partners to appraise them of our latest capabilities and implement those to elevate client success

Data Quality and Governance:

• Implement data quality checks and validation processes to ensure accuracy, consistency, and reliability of data sources. Support data governance practices and compliance initiatives on our BI platform
• Optimize database queries and ETL processes to improve overall system performance and data processing speed

Education and Support:

• Document data processes, technical specifications, architecture, and data models to ensure clarity and support future maintenance and development
• Monitor and solve issues within BI solutions, ensuring high availability and reliability of data and reporting systems

Required Skills:
Technical Proficiency:

• Solid skills in SQL for querying and manipulating relational databases
• Data Modeling using MS Visio (preferred)
• Experience with Tableau Prep Builder and/or Allteryx (preferred)
• Proficiency in BI and data visualization tools such as Tableau and Power BI or Looker or Dataroma
• Experience with scripting languages such as Python, R for data manipulation and automation (preferred)
• Knowledge with TabPy, Pandas and NumPy preferred

Analytical Thinking:

• Strong analytical and problem-solving skills with the ability to interpret complex data sets and deliver clear insights
• Experience in structured and unstructured problem-solving

Communication:

• Excellent communication skills to effectively collaborate with multi-functional teams and present findings to non-technical partners

Project Management:

• Experience with Microsoft Office Suite (Word, Excel and PowerPoint)
• Jira Issue Management System (preferred but not required)
• Demonstrated experience in independently leading small-mid size projects and manage time effectively

Qualifications

• Bachelor's degree in computer science, Information Systems, Data Science, or a related field. A Master's degree is a plus.
• Background in Media Performance measurement and Reporting Preferred
• 3+ years of experience in data analysis, BI development, or a related field
• Familiarity with data governance, and industry standard processes is beneficial

Additional Information
Starcom is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, medical condition as defined by applicable state law, genetic information, marital status, military service and veteran status, or any other characteristic protected by applicable federal, state or local laws and ordinances.
The Power of One starts with our people! To do powerful things, we offer powerful resources. Our best-in-class wellness and benefits offerings include:

• Paid Family Care for parents and caregivers for 12 weeks or more
• Monetary assistance and support for Adoption, Surrogacy and Fertility
• Monetary assistance and support for pet adoption
• Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance
• Tuition Assistance
• Paid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more
• Matching Gifts programs
• Flexible working arrangements
• 'Work Your World' Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)
• Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to U.S. based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents.
Compensation Range: $87,210 - $125,265 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 10/10/2025.
If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com. All your information will be kept confidential according to EEO guidelines.
#LI-RO1
#DNI
Compensation Range: USD $ - . This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 4/8/2025.