Full Time
Category: Data Center
Company: Gain Theory
New York, New York, United States
Posted 1 month ago
Expires on: May 3, 2026

Gain Theory

Principal Data Analyst  
Who we are & what we do: 
Gain Theory is a leading global marketing effectiveness and foresight consultancy. We combine quality data, proprietary technology, and advanced analytics to give our clients the confidence to make better informed investment decisions that drive growth. 
Growth is the defining characteristic of successful organizations, and Gain Theory’s vision is to accelerate growth for ambitious brands. We define ambitious brands as those that generate earnings/profits above the industry average. We deliver: 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Data strategy, harmonization, and visualization. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1">Advanced analytics and modeling, including MMM, attribution and unified measurement, testing, segmentation, behavioral sciences, choice analytics, simulation, war gaming, and forecasting. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1">High-touch consultancy that includes bespoke roadmaps, training and education, industry benchmarking, and activation planning. </li>
</ul>
At Gain Theory, we love accelerating growth for ambitious brands and people. As a Gain Theorist, you will need to demonstrate behaviors that support our values. 
Our values are: Be Curious, Be Positive, Act with Consideration, and Make it Better. You can read more about our values here: www.gaintheory.com/our-culture-people-and-value 
What you’ll do: 
As a Principal Data Analyst, you will join the Gain Theory Data Practice and be embedded within one of our client-focused squads. Working closely with your manager, you’ll collaborate on some of the world’s top brands, gaining hands-on experience with diverse data sources—including media, client-specific, Gain Theory proprietary, sales, and more. 
In this role, you’ll be part of a team that processes and organizes data in preparation for modeling. You’ll face exciting challenges and have opportunities to drive innovation and automation across workflows. 
As a Principal Data Analyst, you will apply data processing techniques such as SQL, ETL and Python alongside our internal automation tools, to manage, clean, and transform data through efficient pipelines. You’ll also run rigorous data quality assurance processes—ensuring data integrity, which is the foundation of all our work. Additionally, you’ll collaborate with the Data Manager to coordinate with client and agency partners, maintaining the continuous flow of data from key sources. Beyond your squad, you’ll engage with the wider Gain Theory data community, including the Data Centre of Excellence (DCOE), to share best practices and both provide and receive support. The Principal Data Analyst will also mentor and support junior analysts on their projects, helping them learn processes, best practices, and specific tools used by Gain Theory. 
At Gain Theory, our teams combine cutting-edge data engineering, advanced analytics, unified measurement solutions, and enterprise-scale platforms to build products that will shape the next decade of faster, smarter, data-informed decision-making. We are committed to ensuring consumer privacy, safeguarding client confidentiality, driving brand growth, and delivering exceptional user experiences. 
Key Responsibilities: 
Data Management & Analysis: Manage data extraction, manipulation and validation. 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1">Manage data extraction, manipulation, validation, and interrogation using SQL, Python, and other relevant tools.  </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1">Build data QA insights relevant to the project </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1">Ensure that all data is systematically checked and passes all QA steps  </li>
</ul>
Data Architecture: Execute and update data pipelines 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1">Building and maintaining data ingestion and transformation pipelines using all the tools that Gain Theory has at your disposal </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1">Build data ingestion and transformation pipelines using available tools, including Python scripting for data processing and automation. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1">Working with fellow data analysts to building scalable solutions using ETL/ELT pipelines </li>
</ul>
Research & Development: Support wider improvements in data 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1">Propose better approaches to help improve internal procedures including new methodology, etc. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="8" data-aria-level="1">Share techniques and ideas with the wider data community </li>
</ul>
Meetings: Organisation and participation in internal meetings 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="9" data-aria-level="1">Initiate and engage with internal project meetings, ensure there is an agenda </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="10" data-aria-level="1">Ensure that project meeting action points are collated and shared with the team </li>
</ul>
Mentorship: Help guide and support junior members of the team 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="26" data-list-defn-props="{"335552541":1,"335559685":1080,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="11" data-aria-level="1">Guide and support junior analysts, providing training on tools and best practices  </li>
</ul>
 
What you’d need to succeed: 
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="1" data-aria-level="1">Comfortable working with large amounts of data in a cloud ecosystem. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="2" data-aria-level="1">Proficient with SQL and ETL processes, and experience driving robust QA processes. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="3" data-aria-level="1">Experience with data interrogation, cleaning, and processing using Python. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="4" data-aria-level="1">Snowflake experience a plus. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="5" data-aria-level="1">Experience with data manipulation/visualization tools (e.g., Excel, Tableau). </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="6" data-aria-level="1">R experience a plus. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="7" data-aria-level="1">Extreme attention to detail a must. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="8" data-aria-level="1">Understanding or experience of business marketing and media a plus. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="9" data-aria-level="1">Strong interpersonal and communication (written and oral) skills. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="10" data-aria-level="1">Team-oriented attitude. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="11" data-aria-level="1">Capacity to learn new skills and master new tools. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="12" data-aria-level="1">Ability and desire to lead junior team members through mentorship and example setting. </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="13" data-aria-level="1">Can lead requirements gathering, project planning, and implementation of projects developed with DCOE leads </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="14" data-aria-level="1">Has project management skills including planning tasks and deliverables, managing timelines and risks, managing team resource allocation, and overseeing multiple simultaneous projects </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="15" data-aria-level="1">Ability to manage and motivate Gain Theory team members and to teach concepts or technologies that are developed </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="16" data-aria-level="1">Organized, detail-oriented, QA-focused </li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="27" data-list-defn-props="{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"multilevel"}" data-aria-posinset="17" data-aria-level="1">Experience with DBT is highly valuable </li>
</ul>
 <div class="content-pay-transparency"><div class="pay-input"><div class="description">The base salary range for this position at the time of this posting is indicated below. Individual compensation varies based on job-related factors, including location, business needs, level of responsibility, experience, and qualifications. We offer a competitive benefits package, click <a href="https://www.wpp.com/en/careers/wellbeing/benefits-at-wpp-in-the-us" target="_blank">WPP Benefits </a>for more details.</div><div class="title">_</div><div class="pay-range">$100,000—$110,000 USD</div></div></div><div class="content-conclusion">WPP (Gain Theory) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers. 
Gain Theory is a WPP-owned consultancy. For more information, please visit please visit <a href="https://gaintheory.com/" target="_blank">our website</a> and follow Gain Theory on our social channels via <a href="https://www.linkedin.com/company/gaintheory/" target="_blank">LinkedIn</a> and <a href="https://twitter.com/gaintheory" target="_blank">Twitter</a>.
Note: We rely on legitimate interest as a legal basis for processing personal information under the GDPR for purposes of recruitment and applications for employment
When you click "Submit Application", this will send any information you add to Gain Theory. Before you do this, we think it's a good idea to read through our <a href="https://gaintheory.com/recruitment-policy/">Recruitment Privacy Policy</a>.  California residents should read our <a href="https://gaintheory.com/california-recrutiment-policy/">California Recruitment Privacy Notice</a> which explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it. </div>

Set up job alerts and get notified about the new jobs

Similar Jobs

[my_related_jobs]

Similar Jobs

Leave a Reply Cancel reply