Data Engineer

The opportunity:

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 modelling team for analysis. The Data Engineer 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 the 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 Data Engineer will also mentor and support junior analysts on their projects, helping them learn processes, best practices, and specific tools used by Gain Theory.

What you’ll be doing:

· 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.

What we want from you:

· 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:

· Strong background 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 skill

Why work for us? 

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. 

What we pride ourselves on: 

• Growth and development
• Meaningful work
• Flexible by design
• Brilliant benefits 
• Culture with Heart 

Our exceptional and skilled team defines Gain Theory. That's why we seek individuals who strive for excellence and continually challenge us to improve.

What we do 

Gain Theory is a global marketing effectiveness and foresight consultancy. Our vision is to accelerate growth for ambitious brands by giving clients the confidence to make better data-informed investment decisions. High-touch consultancy powered by unique partnerships and proprietary technology are used to power our award-winning solutions.  

 As a WPP consultancy, Gain Theory also has access to a range of data, expertise, and tools that create a truly differentiated offering. 

 Gain Theory is a WPP agency (NYSE: WPP).      

 Who we are 

We are a people-centric organisation whose culture is underpinned by 4 important values: Be Curious, Be Positive, Make it Better and Act with Consideration. We channel these values through our behaviours, in the way we work, and in the interactions we have with each other and our clients.