Sql analyst Jobs in Chicago, IL

SEO Analyst

Spark Foundry was built during the most transformative time in the history of advertising and marketing. We deliver everything a traditional media agency has to offer and have grown into one of the world's most successful agencies by helping brands evolve their marketing by leveraging identity, commerce, artificial intelligence, and more to connect with people. Transformation is part of our DNA. Spark Foundry's start-up spirit delivers high-touch approaches and a never-ending desire to challenge the status quo. Combined with Publicis Media's powerhouse soul leveraging connected data assets, advanced AI applications, and investment clout, we "Bring HEAT to Brands." No other agency possesses the expertise that we do to address today's most pressing challenges to drive business transformation through media.

Overview

The SEO Analyst is responsible for supporting client accounts towards stated client and company objectives. Reporting to the SEO Manager, the Analyst provides assistance to internal client service teams, and at the direction of SEO Manager/Associate Director, initiates and coordinates projects with other internal teams.

Responsibilities

Client Service and Program Support

• Contribute to the success of client engagements
• Follow all processes as defined by Manager
• Create and follow a self-directed learning plan to master SEO fundamentals
• Project manage components of assigned accounts
• Gain exposure to client service process including resourcing, project management, and client communications
• Participate in weekly/monthly client calls
• Submit and manage resource plan requests and QA
• Assist with data and performance monitoring
• Implement best practices in account and program management
• Possess a basic understanding of clients and partner agencies functions
• Accomplish multiple tasks in a timely manner and with accuracy
• Effectively contribute to multiple accounts simultaneously
• Maintain autonomy during execution of pre-defined tasks
• Seek out opportunities to learn new skills, advance in role, and demonstrate autonomy
• Understand essential components of managing a successful SEO project
• Prove understanding of larger media landscape and how individual tasks affect the big picture
• Identify opportunities to grow and develop client relationships

Analytics & Reporting

• Support assigned accounts in pulling data and creating reports and presentations
• Track work assignments daily
• Manage and update client task reports
• Track and manage operations resource plan for client accounts
• Perform ad hoc analysis and reporting

Qualifications

• Bachelor's Degree
• Relevant SEO work or internship experience preferred
• Experience with Google Analytics, Adobe Analytics, SEMrush, BrightEdge, Moz, Screaming Frog, DeepCrawl, or Conductor a plus
• Strong analytical and implementation skills
• High competency level in MS Office products including Excel and PowerPoint
• Able to work as directed and balance multiple tasks

Additional Information

Our Publicis Groupe motto "Viva La Diffrence" means we're better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

If you require accommodation or assistance with the application or onboarding process specifically, please contact USMTTACompliance@publicis.com.

All your information will be kept confidential according to EEO guidelines.

Compensation Range: USD $50,065.00 - USD $66,360.00/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. 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 8/9/2026.