Principal Data Analyst

2 weeks ago


London Area, United Kingdom Gain Theory Full time

Principal Data Analyst required to drive our analytics strategy and ensure our data insights align with business objectives. In this role, you will lead complex analytical projects, mentor a team of analysts, and collaborate across departments to deliver actionable recommendations.

You will work as part of a client team supporting a Data Communications Lead on the collection, ingestion, and processing of marketing data, delivering cleaned data to the modeling team for analysis. The Principal Data Analyst is expected to be proficient in data processing techniques including SQL, ETL, and Python.

You will leverage these skills for data interrogation, manipulation, and cleaning, as well as building and maintaining data pipelines. You will utilize our internal data automation tools to ensure efficient execution of these pipelines. The role also includes updating and creating new data processes and pipelines as required.

Additionally, you will work with the Data Communications Lead to coordinate with client and agency contacts regarding the continued flow of data from relevant sources. You will interact with the wider data community within Gain Theory, especially with members of the Data Centre of Excellence (DCOE), to share best practices and 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.

Responsibilities:

  • Data Management & Analysis: Manage data extraction, manipulation, validation, and interrogation using SQL, Python, and other relevant tools. Build data insights relevant to the project. Ensure all data is systematically checked and passes all QA steps.
  • Data Architecture: Execute and update data pipelines. Build data ingestion and transformation pipelines using available tools, including Python scripting for data processing and automation. Work with fellow data analysts to build scalable solutions using ETL/ELT pipelines.
  • Python Development: Develop and maintain Python scripts for data interrogation, cleaning, processing, and automation. Contribute to the development and improvement of our internal data processing tools and libraries.
  • Research & Development: Propose better approaches to improve internal procedures, including new methodologies. Share techniques and ideas with the wider data community.
  • Meetings: Organize and participate in internal project meetings, ensuring agendas are set and action points are shared. Lead internal meetings as required.
  • Mentorship: Guide and support junior analysts, providing training on tools and best practices.

Experience:

  • Comfortable working with large amounts of data in a cloud ecosystem.
  • Proficient with SQL and ETL processes, and experience driving robust QA processes.
  • Experience with data interrogation, cleaning, and processing using Python.
  • Snowflake experience a plus.
  • Experience with data manipulation/visualization tools (e.g., Excel, Tableau).
  • R experience a plus.
  • Extreme attention to detail a must.
  • Understanding or experience of business marketing and media a plus.
  • Strong interpersonal and communication (written and oral) skills.
  • Team-oriented attitude.
  • Capacity to learn new skills and master new tools.
  • Ability and desire to lead junior team members through mentorship and example setting.

Qualifications

  • Background (3-4 years+) in Computer Science, Data Science, Data Engineering Information Science, or related quantitative field
  • In depth experience with all things data including ability to work with a variety of datasets from multiple sources, familiar with standard data processing tools/concepts (e.g. SQL, NoSQL ETL), and experience driving robust QA processes
  • In depth experience of the advertising ecosystem (e.g. ad trafficking, Ad servers, DSPs, Media Strategy and Activation, etc.) and a working knowledge of appropriate metrics, measurement, and reporting
  • Required skillsets: Snowflake, Python, GIT, AWS/Azure
  • Can lead requirements gathering, project planning, and implementation of projects developed with DCOE leads
  • Has project management skills including planning tasks and deliverables, managing timelines and risks, managing team resource allocation, and overseeing multiple simultaneous projects
  • Ability to manage and motivate Gain Theory team members and to teach concepts or technologies that are developed
  • Organized, detail-oriented, QA-focused
  • Experience with DBT is highly valuable
  • Excellent written, verbal, and presentation skills

Values and Behaviors I Demonstrate

Joining Gain Theory means joining a group of people who live, breath and behave by our values:

  • Be Curious: continuously asking, understanding, learning, and developing.
  • Be Positive: approaching everything we do with a positive mindset and making positive impact on each other.
  • Act with Consideration: seeing things from someone else's perspective; respecting and embracing diverse thinking.
  • Make it Better: continuous improvement and stretching our abilities, being honest with ourselves and each other.

Gain Theory is committed to actively building a diverse, equitable and inclusive workplace where everyone feels welcomed, valued and heard, and is treated with dignity and respect. As leaders and creative partners across industries, it is our responsibility to cultivate an environment reflective of our greatest asset; our people. We believe that this commitment inspires growth and delivers equitable outcomes for everyone as well as the clients and communities we serve.

Gain Theory is a WPP-owned consultancy. For more information, please visit please visit our website and follow Gain Theory on our social channels via LinkedIn and Twitter.


  • Principal Analyst

    3 weeks ago


    London Area, United Kingdom DATAHEAD Full time

    Principal Analyst - Data Science & Marketing Mix ModellingGlobal BrandLocation: London (Hybrid)£55,000 plus bonus and benefitsDATAHEAD is partnering with a world-leading global communications agency to find a Principal Analyst specialised in Marketing Mix Modelling (MMM) and Data Science. As a Principal Analyst, you'll play a pivotal role within a dynamic...


  • London, Greater London, United Kingdom Gain Theory Full time

    Principal Data Analyst required to drive our analytics strategy and ensure our data insights align with business objectives. In this role, you will lead complex analytical projects, mentor a team of analysts, and collaborate across departments to deliver actionable recommendations.You will work as part of a client team supporting a Data Communications Lead...

  • Principal Analyst

    1 week ago


    London Area, United Kingdom Nicholson Glover Full time

    Principal Analyst (MMM) | Media & Entertainment | Up to £70,000 + 7.5% Bonus | London/Hybrid We are working on a great opportunity with a leading media and entertainment brand. They are hiring a Principal Econometrician to join their growing Econometrics team.The CompanyThey are one of the biggest companies in Europe. Working across multiple offerings, from...

  • Principal Analyst

    1 week ago


    London Area, United Kingdom Gain Theory Full time

    Principal Analyst with expertise in Marketing Mix Modelling (MMM) required to join our dynamic team. As a Principle analyst, you will leverage data analytics to optimise marketing strategies and drive business growth. Your analytical prowess and strategic thinking will be vital in interpreting complex datasets and providing actionable insights that enhance...

  • Principal Analyst

    2 weeks ago


    London, Greater London, United Kingdom Nicholson Glover Full time

    Principal Analyst (MMM) | Media & Entertainment | Up to £70,000 + 7.5% Bonus | London/Hybrid We are working on a great opportunity with a leading media and entertainment brand. They are hiring a Principal Econometrician to join their growing Econometrics team.The CompanyThey are one of the biggest companies in Europe. Working across multiple offerings, from...

  • Principal Analyst

    6 days ago


    London, Greater London, United Kingdom Nicholson Glover Full time

    Job Description Principal Analyst (MMM) | Media & Entertainment | Up to £70,000 + 7.5% Bonus | London/HybridWe are working on a great opportunity with a leading media and entertainment brand. They are hiring a Principal Econometrician to join their growing Econometrics team.The CompanyThey are one of the biggest companies in Europe, working across multiple...

  • Principal Analyst

    3 weeks ago


    London, Greater London, United Kingdom Gain Theory Full time

    Principal Analyst with expertise in Marketing Mix Modelling (MMM) required to join our dynamic team. As a Principle analyst, you will leverage data analytics to optimise marketing strategies and drive business growth. Your analytical prowess and strategic thinking will be vital in interpreting complex datasets and providing actionable insights that enhance...

  • Principal Analyst

    3 weeks ago


    London, United Kingdom Gain Theory Full time

    Principal Analyst with expertise in Marketing Mix Modelling (MMM) required to join our dynamic team. As a Principle analyst, you will leverage data analytics to optimise marketing strategies and drive business growth. Your analytical prowess and strategic thinking will be vital in interpreting complex datasets and providing actionable insights that enhance...

  • Principal Analyst

    1 day ago


    London, Greater London, United Kingdom TripAdvisor LLC Full time

    Principal Analyst - Search Marketing (Viator)London, UKPrincipal Analyst - Search Marketing I ViatorAbout ViatorViator, a Tripadvisor company, is the leading marketplace for travel experiences. We believe that making memories is what travel is all about. And with 300,000+ travel experiences to explore—everything from simple tours to extreme adventures (and...

  • Data Analyst

    4 weeks ago


    London Area, United Kingdom Cobalt Recruitment Full time

    Data AnalystLondon/ Hybrid £30,000 - £38,000Role OverviewCobalt is delighted to be working with a leading global real estate company that is looking to hire a Data Analyst to join their team, focusing on a retail portfolio. The successful candidate will be responsible for analysing and interpreting key data sets to drive business insights and optimise...

  • Data Analyst

    2 weeks ago


    London Area, United Kingdom TDA Full time

    Data Analyst | Hybrid (London) Are you an experienced Data Analyst with a background in insurance or financial services ? We're seeking a skilled professional to support a Sage and Sun Systems implementation for a leading insurance organization. This is a 3-month contract role (inside IR35) , with the potential for extension, offering an exciting...

  • Data Analyst

    1 week ago


    London Area, United Kingdom Gravitas Recruitment Full time

    Role: Data AnalystRate: £450/DayDuration: 6 MonthsIR35 Status: OutsideLocation: 3 Days per week in Central LondonThis role is for a UK Scale up who are looking for an experienced Data Analyst to join their team on a 6-month contract. This role is outside IR35 and offers a day rate of £450. The position is hybrid, requiring three days per week in the London...

  • Data Analyst

    3 weeks ago


    London Area, United Kingdom Harnham Full time

    DATA ANALYSTUP TO £37,000LONDONAre you an analytical thinker with a passion for customer insights and data-driven strategy? Do you want to work in a fast-paced, multichannel environment where your analysis directly influences business performance? If so, this could be the perfect opportunity for youTHE COMPANY:A leading B2C brand is looking for a Customer...

  • Data Analyst

    4 weeks ago


    London Area, United Kingdom TDA Full time

    Data Analyst | Hybrid (London) Are you an experienced Data Analyst with a background in insurance or financial services ? We’re seeking a skilled professional to support a Sage and Sun Systems implementation for a leading insurance organization. This is a 3-month contract role (inside IR35) , with the potential for extension, offering an exciting...

  • Data Analyst

    4 weeks ago


    London Area, United Kingdom Harnham Full time

    DATA ANALYSTUP TO £37,000LONDONAre you an analytical thinker with a passion for customer insights and data-driven strategy? Do you want to work in a fast-paced, multichannel environment where your analysis directly influences business performance? If so, this could be the perfect opportunity for you!THE COMPANY:A leading B2C brand is looking for a Customer...

  • Data Analyst

    4 weeks ago


    London Area, United Kingdom Harnham Full time

    DATA ANALYSTUP TO £37,000LONDONAre you an analytical thinker with a passion for customer insights and data-driven strategy? Do you want to work in a fast-paced, multichannel environment where your analysis directly influences business performance? If so, this could be the perfect opportunity for you!THE COMPANY:A leading B2C brand is looking for a Customer...

  • Data Analyst

    3 weeks ago


    London Area, United Kingdom Match Digital Full time

    Data Analyst (1 Year Maternity Cover)£35,000 - £40,000 + 10% bonus + benefitsLondon (2 days per week in the office)Our clientOur client is a global strategic technology and payments partner. They deliver seamless personalised shopping experiences to over 29m international shoppers, who in turn generate €22.9bn revenue.With 2,000 employees spread across...


  • London Area, United Kingdom Harnham Full time

    PRINCIPAL DATA ARCHITECT LONDON £110,000 THE COMPANY This global management consultancy operating in the capital markets is now looking for a Principal Data Architect to help serve their clients and manage the projects. THE ROLE As a Principal Data Architect you will be involved in several projects working with data structures, and ensuring that...

  • Data Analyst

    2 weeks ago


    London Area, United Kingdom Amiqus - Games Recruitment Specialists Full time

    Job Opportunity: Data AnalystMy client is renowned publisher looking for a skilled Data Analyst to join their dynamic team. This role is pivotal in supporting both internal and external studio partners, focusing on data-driven strategies to enhance marketing and growth efforts for PC and Console titles.Role Overview: You will be responsible for establishing...

  • Business Data Analyst

    2 weeks ago


    London Area, United Kingdom Arthur Recruitment Full time

    Business Analyst - Data (Insurance)A Global insurance company is looking for a Business Analyst to join their Data team. In this role, you'll gather and analyse business needs, design data solutions, and support project delivery.Essential skills of the: Business Analyst – Data Expertise in business process mapping, data analysis, and requirements...