SQL Marketing Data Analyst

Company Description

At Jellyfish, we believe in the power of diverse perspectives and inclusive collaboration. We welcome individuals who excel in collaborative, varied teams and value the unique contributions that each person brings to the table.

Jellyfish is a global digital marketing agency; a unique fusion of tech enthusiasts, creative minds, and media and data experts all united to empower our clients along their digital journey. Our commitment to embracing diverse perspectives fuels our innovation and strategies that challenge the status quo, reinvent media activation, and craft influential stories for our global clients and their customers. Join us in shaping a future where business growth and personal fulfilment go hand in hand.

Job Description

Reporting to the VP of Investment Analytics, you will make an impact within our Paid Media department by combining technical expertise (35%) with client-facing analytics and solution design (65%). You will analyse campaign data to identify trends and provide insights for performance improvement.

At Jellyfish we take pride in our global client portfolio and our proprietary technology, setting us apart in the industry, and we are committed to promoting professional growth. Your career path could lead to Data Insights Director.

Your primary responsibilities will include:

• Meet with our clients to understand their marketing goals and timings to define a solution design, covering data sources, collection and analysis.
• Bring together data from different sources with potentially varying file formats, naming conventions and columns, and transform it into cohesive datasets, highlighting where underlying changes to the data sources may be required.
• Complete projects and mathematical analysis that assess the efficiency of paid media campaigns, including attribution models and geo-testing, to evaluate their impact on sales, conversions, awareness and other goals.
• Create visually appealing and informative dashboards.
• Conduct testing and validation, to ensure dashboards match the underlying data sources and their design meets client requirements.
• Present technical solutions, reports and studies to our clients with the support of our Paid Media, Media Planning, and Client Management teams.

Qualifications

• Over 3 years of experience with at least one of the following data visualisation tools: Tableau (preferred), Power BI, Looker Studio or advanced use of Excel (you can perform complex functions).
• Proficiency in SQL.
• Understanding of paid media campaign measurement with platforms like DV360, Google Ads, and Meta for Business.
• You love getting to know your clients, developing long-lasting relationships and adding value to their business.
• You seek and implement solutions to refine and automate processes.
• When faced with a problem, you collaborate with the appropriate people to evaluate different options find practical solutions.

Note: We emphasise skills, expertise and behavioural attributes over years of experience and traditional degrees. If you want to join our collaborative team, we invite you to apply today with your resume in English.

Additional Information

Join Jellyfish and experience a workplace where we prioritise your growth, celebrate your contributions, and empower you to tailor your work environment to suit your needs.

💰 Reward: You'll receive a loyalty salary increase on your Jellyfish anniversary in addition to joining our discretionary annual bonus scheme.

💫 Custom Work Environment: Work remotely for up to 60% of your days and shape your day between 8am. and 6:30pm with flexible working hours.

📈 Growth, Your Way: Grow your career with one paid day each month for self-development and access to LinkedIn Learning with unlimited online courses.

👪 Family Support: Enjoy 14 weeks of paid leave for primary caregivers and 4 weeks of paid leave for secondary caregivers. We also provide £1000 (or equivalent) towards courses for returning primary caregivers to support your transition back into work.

Unfortunately, there has been an increase in fake recruiters impersonating Jellyfish and unlawfully using our brand name. If you are unsure if an email with a job offer you have received is genuinely from Jellyfish, or if you suspect any fraudulent activity, please report it to [email protected].

#LI-Hybrid