Senior Data Analyst - Gain Theory

We're in search of a Principal Data Analyst to join our team on a permanent basis.

Please be aware that Wunderman Thompson Commerce and Technology are recruiting on behalf of Gain Theory, both of which are Wunderman Thompson/WPP companies.

Your role:

As part of a client team, you will support a Data Communications Lead in the collection, ingestion, and processing of marketing data, delivering cleaned data to the analytics arm of the team. The Principal Data Analyst should be proficient in data processing techniques including SQL and , as well as our internal data automation tools to ensure effective execution of data pipelines for data cleaning and transformation. The role also entails updating and creating new data processes and pipelines as needed. You will assist the Data Communications Lead in coordinating with client and agency contacts to ensure continuous flow of data from relevant sources. Your role will extend to interaction with Gain Theory's broader data community, particularly with members of the Data Centre of Excellence (DCOE), to share best practices and provide and receive support. You will also mentor junior analysts on their projects, teaching processes, best practices, and specific tools utilized by Gain Theory.

Primary Responsibilities:

Data Management & Analysis: Oversee data extraction, manipulation, and validation.

• Carry out data extraction and processing
• Generate data insights relevant to the project
• Ensure comprehensive checking of data and compliance with all QA steps

Data Architecture: Implement and update data pipelines.

• Construct data ingestion and transformation pipelines using a suite of tools provided by Gain Theory
• Collaborate with fellow data analysts in creating scalable solutions utilizing ETL/ELT pipelines

Research & Development: Aid in broader improvements in data

• Suggest better approaches to enhance internal procedures, including new methodologies, etc.
• Exchange techniques and ideas within the wider data community

Meetings: Organize and participate in internal meetings

• Initiate internal project meetings while maintaining an agenda
• Lead internal meetings as necessary
• Ensure that post-meeting action points are disseminated among the team

We're looking for someone who:

• Is at ease working with large amounts of data in a cloud environment
• Is familiar with regular data processing tools/concepts (e.g., SQL, ETL) and has experience in robust QA processes
• Has experience in Snowflake (a plus)
• Has experience with data manipulation/visualization tools (e.g., Excel, SQL, Tableau)
• Has Python/R experience (a plus)
• Has exceptional attention to detail
• Has knowledge or experience in business marketing and media (a plus)
• Possesses strong interpersonal and communication skills, both written and verbal
• Has a team-oriented attitude
• Has the capability to learn new skills and master new tools
• Has the ability and willingness to guide junior team members through mentorship and setting examples

What we can offer you:

Along with an opportunity to work with some of the most thrilling brands worldwide, we'll prioritize your career development and skills enhancement. We'll empower you to make a difference, let you be yourself, and respect who you are.

We offer an attractive benefits package that includes hybrid working adaptable for everyone, and opportunities to stretch your learning, development, and career growth.

Our personality and behaviors: We believe that what we do, not just what we say, defines us. Our shared values and behaviors illustrate how to actualize Gain Theory's culture through our daily actions:

• Be Curious
• Be Positive
• Act with Consideration
• Make it Better

Our exceptional, talented people are the linchpin of Gain Theory's success. That's why we are in search of individuals who always challenge our thinking to keep improving.

What we do:

Gain Theory is a global marketing effectiveness and foresights consultancy. Our mission is to fast-track growth for ambitious brands by informing our clients to make better data-driven investment decisions. Our distinctive partnerships and proprietary technology underpin our award-winning solutions. As a WPP consulting firm, Gain Theory also has access to a myriad of data, expertise, and tools, constituting a truly unparalleled offering.

Who we are:

We are a people-first organization, embodying four crucial values: Be Curious, Be Positive, Make it Better, and Act with Consideration. These values guide our work style and the way we interact with each other and our clients.

Should you require any adjustments during the application or interview process, please let us know.

As a WPP company, Gain Theory is committed to creating a diverse, inclusive, and equitable workplace where everyone feels welcomed, valued, heard, and is treated with respect and dignity. As leaders and creative partners across industries, it's our responsibility to foster an environment that reflects our greatest asset—our people. We believe this commitment stimulates growth and ensures fair outcomes for everyone, as well as the clients and communities we serve.