Senior Data Analyst

Company Description

Publicis Production harnesses the power of Publicis Groupe's entire global production capabilities. Through our family of production brands, we access best-in-class production talent, models and technology worldwide.Our purpose is to deliver seamless, relevant and impactful consumer experiences across every touchpoint in every market. We do this with pioneering production solutions that drive performance in a data-led marketing landscape and help brands to win in the platform world.

Job Description

We're looking for a Senior Data Analyst with strong technical and analytical skills to join our data team in production technology.

In this role, you'll use tools like BigQuery, PostgreSQL and Python to turn raw data into curated data structures and meaningful insights that support strategic business decisions across the organization. Whilst also interrogating further databases to support data engineering and data science in data discovery.

The main stakeholders will be the immediate data team, operations and product, as well as external clients -with you taking ownership of data analysis, reporting, and storytelling that drive measurable outcomes. You will also need the ability to work with dev teams to build dynamic dashboards. This role is perfect for someone who's hands-on, detail-oriented, and an independent data problem solver looking for a role with varied scope.

Responsibilities

• Design, develop, and maintain reports and data outputs that enable presentation of key business metrics
• Write advanced SQL queries to analyze large datasets and identify patterns, trends, and anomalies
• Use Python for more advanced analytics, automation, and data processing tasks
• Work with BigQuery to build scalable analytical workflows in a cloud-based environment
• Understand and design output for cross-functional teams to define KPIs, design experiments, and uncover actionable insights
• Deliver clear, concise insights and recommendations to stakeholders using data visualizations and presentations
• Support data quality, governance, and process improvement initiatives

Qualifications

Experience

• Relevant experience in a data analyst or business intelligence role
• Strong proficiency in SQL (joins, CTEs, window functions, optimization techniques)
• Advanced skills in Microsoft Excel (pivot tables, lookups, data analysis toolpak, macros a plus)
• Experience writing Python for data manipulation, automation, or visualization (pandas, matplotlib, seaborn)
• Hands-on experience working with BigQuery or other cloud-based data warehouses (Redshift, Snowflake, etc.) and JSON data structures
• Strong team player and desire to support work of team members to deliver outcome
• Highly motivated, with strong problem-solving skills and business acumen

Desirable Skills

• Experience with data visualization tools (e.g., Looker, Tableau, Power BI)
• Familiarity with dbt, Airflow, or other modern data tools
• Exposure to marketing or e-commerce industries

Additional Information

Diversity and inclusion is a core part of who we are at Prodigious London. We're committed to building an inclusive culture that encourages, celebrates and supports our wonderfully diverse employee group - whatever their age, gender identity, race, sexual orientation, physical or mental ability or ethnicity. Diversity and inclusion doesn't just fuel our creativity and innovation, it brings us closer to our people and audiences. We will continue to strive to create a culture and environment where everyone feels empowered and more importantly comfortable enough to bring their full, authentic selves to work. We are committed to providing reasonable adjustments for employees with disabilities and for candidates in our application process. If you need assistance or adjustment due to a disability, please contact us.