Principal Data Analyst
Hybrid
London, United Kingdom
Full Time
12-03-2025
Job Specifications
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.
About the Company
Gain Theory is a global marketing effectiveness and foresight consultancy with expertise in data, advanced analytics, and technology. We exist to accelerate growth for ambitious brands by empowering smarter, data-informed marketing investment. Our experts fuse hindsight, insight, and foresight to improve investment decisions and activate growth at speed. Gain Theory is a recognized Leader in The Forrester Wave™: Marketing Measurement and Optimization, Q3 2023. Available in 58 markets, our award-winning solutions and highl... Know more
Related Jobs
- Company Name
- South Wales Police
- Job Title
- ICT Database Analyst
- Job Description
- Job Title: ICT Database Analyst Location: South Wales Police Headquarters, Bridgend, Wales Salary: £35,526 - £40,893 p/a Job Type: Full time / Contract (2-year Fixed Term Contract) About Us South Wales Police is the largest police force in Wales, serving a population of approximately 1.3 million people across an area of 2,117 square miles. We are dedicated to keeping our communities safe and secure, and we rely on cutting-edge technology to support our operations. We have recently invested heavily in our ICT department with exciting new projects and opportunities funded by significant investment. We are going through a period of significant growth and technological change, there has never been a better time to join! About The Role Are you eager to embark on an exciting journey in the world of database administration? We are in search of a dedicated Database Administrator and Support Specialist Engineer to join our dynamic ICT Database team. You'll play a vital role in supporting our database infrastructure, honing your skills, and contributing to the efficiency and integrity of data that keeps South Wales Police and UK policing services running smoothly. The Database Analyst role works in the Technical Delivery section of the ICT Department and reports to the Database Team Manager. Our Information and Communications Technology Department (ICT) has a wide and varied range of responsibilities from 1st line service desk, 2nd line technical support to 3rd line specialist technical architect/design. ICT are also responsible for IT Security management, Service Management, Business Support and Project Management that maintain and continuously improve critical services, software, platforms, and hardware required throughout the full IT lifecycle. This underpins the delivery of secure and timely 24/7 operations for approximately 10,000 users across 100 geographical locations supporting over 20,000 computers including multiple datacentres together with the underlying network, physical and virtual (including cloud services) IT infrastructure. Duties And Responsibilities Database Support: Assist in the development and maintenance of the Force's core database infrastructure, ensuring that South Wales Police operates efficiently. Performance Analysis: Collaborate with the team to analyse the performance of our database infrastructure and help fine-tune it for optimal functionality. Database Development: Contribute to the design, development, testing, and deployment of databases, gaining hands-on experience in managing complex data structures. Documentation: Create and maintain essential documentation for database and application processes, promoting transparency and knowledge sharing. Data Integrity and Security: Work diligently to ensure the integrity and security of all databases, assisting in the implementation of best practices and security measures. Technical Support: Provide support and assist in troubleshooting issues related to databases and applications, learning from experienced DBAs along the way. About You Educational Background: Possess a relevant degree or demonstrate equivalent skills and abilities, as you take your first steps into the world of database administration. Technical Knowledge: Show enthusiasm and a willingness to learn, with an understanding of core database technologies and concepts, including but not limited to: Relational Database Management Systems (RDBMS), with an emphasis on Microsoft SQL Server. Basics of database backup, recovery, security, performance tuning, and client software configuration. Capacity planning for database scaling. SQL Enthusiast: Display an interest in SQL databases, eager to develop your proficiency in crafting and managing queries. Database Administration: Although you're at the start of your journey, prior experience in database administration is a plus. Operational Awareness: Begin to grasp the strategic implications of effective database technologies within the organisation. As a Database Administrator and Support Specialist Engineer, you'll be mentored by experienced professionals, gaining hands-on experience in the exciting field of database administration. Your contributions will be instrumental in maintaining the efficiency and integrity of our database infrastructure, and you'll have the opportunity to learn and grow within a supportive team environment. Benefits Training and professional development opportunities Local Government Pension Scheme 24 days Annual Leave increasing to 29 days after 5 years employment. Flexible working dependant of duties Free on-site parking On site fitness centre and canteen Collaborative and supportive work environment. Cycle to work scheme. Wellness programmes SWP Diolch Vectis & Blue light Discount Card Opportunity to make a meaningful contribution to public safety and community well-being. Please click the APPLY button to submit your CV for this role. Candidates with experience or relevant job titles of Database Analyst, Data Analysis Specialist, SQL Database Analyst, Data Quality Analyst, and Database Reporting Analyst may also be considered.
- Company Name
- European Bioinformatics Institute | EMBL-EBI
- Job Title
- BioImaging Data Platform Research Software Engineer
- Job Description
- Your role The role will work across the technical stack to support scaling and automation of deposition and presentation systems for high volumes of biological image data. You will extend and build on the EMBL-EBI imaging resources’ to enable better automation, integrate with high performance computing and storage resources and develop/implement new functionality. Specific Responsibilities Design and implement systems to support rapid deposition, curation and archival of biological image data, including back-end, front-end and supporting infrastructure. Develop systems for interactive online exploration of biological image data, working with existing tools, extending these, and developing new solutions as appropriate Act as liaison between the BioImage Archive/EMPIAR and EMBL-EBI's compute/storage infrastructure teams to deploy and manage these systems. Coordinate with other service teams on shared development and process implementation. Contribute to the broader team activities, including helpdesk support, planning, design review and improvement of the team's software development processes. You have You should have a university degree in computer science, life sciences or a related discipline and have several years' experience in a software development capacity. Substantial experience developing full stack applications Extensive hands-on experience with Javascript and Python Working with relational databases such as PostGres or MySQL Software development lifecycle, including design, implementation, testing, continuous integration, deployment and version control Working with Linux systems Personal Attributes A strong affinity with, and enthusiasm for, the goal of EMBL-EBI to provide world-class open data and services to the global community A strong desire to learn new skills and technologies Excellent communication and interpersonal skills The ability to work both independently and as part of a team You may also have Experience designing data systems that operate at scale Experience working with BioImaging data from one or more modalities Experience with NoSQL databases, such as MongoDB Experience with batch scheduling systems such as SLURM Experience with containerisation (e.g. Docker) and container orchestration (e.g. Kubernetes) Infrastructure-as-code deployment tools such as Ansible or Terraform Salary: Grade 5 or 6 depending on qualifications and experience, monthly salary at £3,229 or £3,612 after tax but excluding pension and insurance contributions. Plus generous benefits. Contract Length: 3 year contract - Project based Why join us Do something meaningful At EMBL-EBI you can apply your talent and passion to accelerate science and tackle some of humankind's greatest challenges. EMBL-EBI, part of the European Molecular Biology Laboratory, is a worldwide leader in the storage, analysis and dissemination of large biological datasets. We provide the global research community with access to publicly available databases and tools which are crucial for the advancement of healthcare, food security, and biodiversity. Join a culture of innovation We are located on the Wellcome Genome Campus, alongside other prominent research and biotech organisations, and surrounded by beautiful Cambridgeshire countryside. This is a highly collaborative and inclusive community where our employees enjoy a relaxed atmosphere. We are committed to ensuring our employees feel valued, supported and empowered to reach their professional potential. Watch this video to see how EMBL-EBI makes an impact. Enjoy Lots Of Benefits Financial incentives: Monthly family, child and non-resident allowances, annual salary review, pension scheme, death benefit, long-term care, accident-at-work and unemployment insurances Flexible working arrangements - including hybrid working patterns Private medical insurance for you and your immediate family (including all prescriptions and generous dental & optical cover) Generous time off: 30 days annual leave per year, in addition public holidays Relocation package including installation grant (if required) Campus life: Free shuttle bus to and from work, on-site library, subsidised on-site gym and cafeteria, casual dress code, extensive sports and social club activities (on campus and remotely) Family benefits: On-site nursery, 10 days of child sick leave, generous parental leave, holiday clubs on campus and monthly family and child allowances Benefits for non-UK residents: Visa exemption, education grant for private schooling, financial support to travel back to your home country every second year and a monthly non-resident allowance. For detailed information please visit our employee benefits page here. What else you need to know International applicants: We recruit internationally and successful candidates are offered visa exemptions. Please take a look at our International Applicants page for further information. EMBL is a signatory of DORA. Find out how we apply DORA principles to our recruitment and performance assessment processes here. Diversity and inclusion: At EMBL, we strongly believe that inclusive and diverse teams benefit from higher levels of innovation and creative thought. We encourage applications from women, LGBTQ+ & individuals from all nationalities. How to apply: To apply please submit a cover letter and a CV through our online system. We aim to provide a response within two weeks after the closing date. Closing Date 05/04/2025
- Company Name
- SoftNice
- Job Title
- Senior Data Analyst
- Job Description
- Job Description: Overall 10+ years of experience in working as data analyst within investment banking/ insurance. Familiar with Bloomberg / Statestreet data feeds Experience in understanding the functions and the data elements within Pension, Home insurance, Pet insurance Experience in drafting the reporting requirements with business stakeholders.
- Company Name
- Phoenix Software Limited
- Job Title
- Data Analytics Apprentice
- Job Description
- Overview Of The Role Phoenix enables digital transformation in the workplace, empowering UK organisations to innovate and transform with cloud and hybrid infrastructures, data, AI, security, and collaboration tools. We are seeking a Data Analytics Apprentice to join our marketing team. This position would be ideal for someone who is looking to start their career in data analytics and IT. You will work closely with experienced professionals to learn about data collection, organisation, and analysis, focusing on marketing-specific systems and platforms such as CRM (Customer Relationship Management) software (such as Dynamics 365), Google Analytics, and marketing automation tools (such as HubSpot). What will you be doing? Assist in collecting and organising marketing data from various sources, including CRM systems and digital marketing platforms such as Dynamics 365, Power BI, social media platforms (LinkedIn, X, Instagram), Google and Bing, Ahrefs, and HubSpot. Learn basic data analysis techniques to extract insights and trends from marketing data. Support the maintenance and management of marketing databases, systems and processes. Assist in generating reports and dashboards to track marketing performance metrics. Ensure systems, data, and processes are protected and aligned to UK data protection acts such as GDPR. Why you should apply? This role is ideal for somebody looking for their first step into the IT industry and allows you the opportunity to gain an apprentice-level qualification in IT through on-the-job training and learning. At Phoenix, our philosophy is simple - we aim to be the UK's leading IT solution and managed service provider and that means we recognise that it's our people who are the heart of everything we do. We do this by providing the encouragement, support and skill development that you need to be the very best you can be at work. We are proud of our culture, so much so that we have developed our Culture Blueprint which you can read here. What are we looking for? The right person for this role will have a strong interest in data analysis and the IT industry in general. You don't need any prior work experience and can be someone who recently left school/college or someone who is looking to change careers. You will have a desire to learn as well as exceptional problem-solving abilities. Key Skills: A strong interest in data analysis Strong attention to detail and organisational skills. A basic understanding of data management principles. A desire to learn and for continuous improvement. Has the ability to embrace feedback as well as being able to adapt to change. Understands how to act in a professional setting. Excellent time management and organisational skills. Practical stuff Where is the role based? Primary location is our HQ in Pocklington (YO42) and you will be expected to on-site full-time What is the apprenticeship? You will be completing the ‘Level 3 Data Essentials' apprenticeship through Phoenix and our apprenticeship provider. Offering a payment progression plan, candidates have the opportunity to increase their earnings alongside their professional development. After completing the apprenticeship and gaining experience in this role, there is potential for this position to lead to a role in our Service Desk - Technical Support Team. What are the benefits? You Can Read About The Benefits On Offer Here Important* BPSS Check As part of our recruitment process due to the nature of the work we do, all employees are required to undertake a Baseline Personal Security Standard (BPSS) check. While some employees require further security clearance, the BPSS check is a must-have requirement and all offers of employment are conditional pending the passing of this check Have you made it this far? If you're still reading, we think there's a strong chance you might be our kind of person. Here's the thing, though — research suggests that 60% of women and underrepresented people might have already talked themselves out of applying. Even if you don't check every box above, we want to encourage you to introduce yourself. We believe a diversity of perspectives and experiences makes a team stronger — and the stronger our team, the more successful we will be.