Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Automate analytical processes and deliver insights to clients using SQL and Excel.
- Company: Join a remote-friendly company with a focus on continuous learning and collaboration.
- Benefits: Competitive salary, performance bonuses, stock options, and wellness stipends.
- Why this job: Make an impact in digital media analytics while working with industry leaders.
- Qualifications: Experience in programmatic advertising and strong SQL and Excel skills required.
- Other info: Flexible work options and access to a vibrant office environment.
The predicted salary is between 28800 - 48000 Ā£ per year.
This position reports to the Senior Director of Analytics & Technical Account Management; it works to standardize and automate analytical processes. In this role, you will join a team of Data Analysts who support our clients by delivering media quality analysis, campaign reporting, and optimization opportunities to advertisers, agencies, and publishers alike. You will be responsible for developing and automating reporting workflows and insights tools for both internal and external use. Day-to-day activities will include SQL querying, Excel modeling, client reporting, and insight delivery.
We are seeking a candidate with 2+ years of experience in programmatic advertising and digital media analytics, but all analytical experience will be considered. We have a NYC office and a London WeWork, but operate as a remote-friendly company with flexible work options.
What you will learn:
- Gain a deep understanding of attention metrics and media quality measurement
- Work alongside Senior Analysts and Data Scientists to build scalable solutions for our business
- Learn how business units collaborate by working within a transparent, cross-functional environment
- Network with industry leaders to drive adoption
Core responsibilities:
- Use SQL and Excel to explore, clean, and filter data in preparation for analysis
- Collaborate with other teams to ensure data quality, accuracy, and consistency
- Aid in the automation of analytics processes using Python and Excel modeling
- Create reports and dashboards that communicate key findings and trends to clients
- Provide client support by answering questions, resolving issues, and providing guidance on how to use our platform and metric
- Stay updated on the latest developments and best practices in the digital media industry
What you will bring:
- Client Engagement & Insight Delivery: Experience communicating directly with clients to present findings, answer questions, and translate analytical results into actionable recommendations; able to build trust, tailor insights to different audiences, and support strategic decision-making through data
- SQL Proficiency: Ability to write, optimize, and debug SQL queries; solid understanding of data modeling concepts and warehouse best practices a plus
- Excel Expertise: Command of Excel, including pivot tables, lookup functions, and formula-based analysis to support data exploration and reporting tasks; working knowledge of Macros a plus
- BI & Visualization Tools: Handsāon experience with BI/dashboarding platforms (e.g. Looker, Tableau); familiarity with semantic modeling layers a plus (e.g. LookML, dbt) a plus
- Programming Skills: Familiarity with Python for data transformation, scripting, and automation; experience with associated libraries (e.g. pandas, openpyxl) a plus
- Data Quality & Testing: Strong attention to detail in building data validation, profiling routines, and root cause analysis workflows
- Communication & Collaboration: Excellent interpersonal skills with experience working crossāfunctionally; ability to translate technical concepts for nonātechnical audiences and deliver training/support
- Educational Background & Experience: Bachelorās degree in a quantitative, technical, or analytical field (e.g. Computer Science, Math, Physics, Engineering) or a rigorous coding bootcamp with a portfolio demonstrating the above skills
Additional information: This position will be employed through Rippling's local Employer of Record (EOR) entity which will act as the legal employer.
Benefits:
- Health & Wellness
- Paid time off
- Parental leave
- Employee Development & Wellness Stipend
- Festive break
- Volunteer time off
- Competitive salary
- Performance-based quarterly bonus
- Stock options
- Group pension plan
- Remoteāfirst environment
- London office
- Access to available WeWork spaces
Equal Employment Opportunity (EEO) Statement: Adelaide is proud to be an Equal Opportunity Employer, committed to fostering a diverse, equitable, and inclusive workplace where all employees can thrive. We consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other legally protected status. Our commitment to equal opportunity employment extends beyond basic compliance to encompass the active cultivation of a workplace that values different perspectives, backgrounds, and experiences.
Data Analyst in London employer: Dataanalystjobs
Contact Detail:
Dataanalystjobs Recruiting Team
StudySmarter Expert Advice š¤«
We think this is how you could land Data Analyst in London
āØTip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
āØTip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, SQL queries, and any dashboards you've built. This will give potential employers a taste of what you can do and set you apart from the crowd.
āØTip Number 3
Prepare for interviews by brushing up on common data analyst questions and practising your responses. Be ready to discuss your experience with SQL, Excel, and any programming languages you know. Confidence is key!
āØTip Number 4
Don't forget to apply through our website! We love seeing applications directly from candidates who are excited about joining our team. Plus, it shows you're genuinely interested in the role and our company culture.
We think you need these skills to ace Data Analyst in London
Some tips for your application š«”
Tailor Your CV: Make sure your CV reflects the skills and experiences that match the Data Analyst role. Highlight your SQL proficiency, Excel expertise, and any relevant experience in programmatic advertising or digital media analytics.
Craft a Compelling Cover Letter: Use your cover letter to tell us why you're passionate about data analysis and how your background aligns with our mission. Share specific examples of how you've delivered insights or optimised processes in previous roles.
Showcase Your Technical Skills: Donāt forget to mention your programming skills, especially if you have experience with Python or BI tools like Tableau. We love seeing candidates who can automate processes and create insightful dashboards!
Apply Through Our Website: We encourage you to apply directly through our website for the best chance of getting noticed. Itās the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Dataanalystjobs
āØKnow Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss how you've used SQL in past projects, and maybe even practice writing some queries. This will show that you're not just familiar with SQL but can also apply it effectively.
āØExcel Like a Pro
Since Excel is a key part of the role, be ready to demonstrate your expertise. Familiarise yourself with pivot tables, lookup functions, and any advanced features youāve used. You might even want to prepare a mini-case study where you used Excel for data analysis.
āØCommunicate Clearly
This role involves client engagement, so practice explaining complex data insights in simple terms. Think about examples from your experience where you successfully communicated findings to non-technical audiences. This will highlight your ability to build trust and deliver actionable recommendations.
āØShow Your Passion for Continuous Learning
The company values ongoing professional growth, so come prepared to discuss how you stay updated on industry trends. Mention any courses, webinars, or books you've engaged with recently. This shows that you're proactive and eager to learn, which aligns perfectly with their culture.
