About Dewynters
DEWYNTERS is the leading integrated advertising agency for live entertainment, known for its unique blend of creativity, insights, and commercial expertise. We craft compelling campaigns for clients across the theatre, immersive, festivals, and exhibitions sectors. Our esteemed clients include Disney Theatrical Productions, The Royal Shakespeare Company, The Book of Mormon, and more.
About the Role:
We are looking for a Junior Data Developer to join our talented team for a fixed-term 18 -month contract.
This role will involve supporting the development and maintenance of the data infrastructure that drives our business intelligence initiatives. This role will report into the Business Intelligence (BI) Manager. You will also work closely with the wider Insights team to ensure the accuracy, accessibility, and usability of our data.
Your contributions will be vital in enhancing our data solutions and reporting capabilities to support the agency's diverse clients.
Key Responsibilities
* Maintain and enhance our data architecture and ETL processes, ensuring the accuracy of media, campaign, and performance data.
* Design, develop, and maintain compelling Power BI dashboards and reports that visualise campaign performance, media spend, audience behaviour, and KPIs.
* Work closely with internal stakeholders and clients to gather requirements and deliver tailored reporting solutions.
* Troubleshoot and resolve data issues related to media tracking, attribution, and platform integrations.
* Translate business and campaign reporting needs into scalable technical specifications.
* Use warehouse data to build automated reporting that supports planning, optimisation, and post-campaign analysis.
* Develop and maintain SQL queries, stored procedures, and data pipelines to support reporting and analysis.
* Collaborate with BI Managers and Insights team to ensure data consistency and integrity across systems.
* Document data models, processes, and dashboard specifications to support team knowledge-sharing and future development.
* Contribute to data quality initiatives by performing data validation, anomaly detection, and troubleshooting.
* Stay up to date with emerging data tools and technologies to identify opportunities for process improvement and innovation.
* Assist with ad hoc data requests and exploratory analyses to support rapid decision-making.
* Providing technical support to end-users
* Run internal training sessions for teams to increase their dashboard proficiency
* Keep the agency informed of new dashboard feature releases
* Obtain and monitor usage stats and feedback from Insights, Digital Media and Organic Social teams
* Maintaining documentation of data systems and processes
* Implementing and enforcing data security policies
Requirements
Your skills/Qualifications
* Proven experience developing dashboards with Power BI or similar visualisation tools (e.g., Tableau, Looker Studio), preferably within a marketing or media environment.
* Understanding of digital media metrics (e.g., impressions, clicks, conversions, reach, frequency, CTR, CPM, ROAS).
* Proficient in SQL, with working knowledge of BigQuery or other cloud-based databases.
* Familiarity with Python or R for data manipulation or statistical analysis.
* Knowledge of advertising technology, campaign tracking, and data integration tools is a plus.
* Basic understanding of data governance and security, especially in relation to client data.
* Collaborative and solutions-focused attitude, comfortable working across departments and clients.
Desirable skills/Qualifications
* Exposure to media reporting platforms such as Google Campaign Manager, DV360, Meta Ads, or Google Ads.
* Experience working with marketing data pipelines and APIs.
* Awareness of privacy regulations like GDPR and cookie/data tracking implications.
* Familiarity with attribution modelling and media mix analysis.
Benefits
* 25 days holiday rising to 30 days holiday
* Flexible / Hybrid working
* Company pension scheme
* Private health insurance after 3 years service
* Summer Friday's
* Cognitive Behavioural Therapy
* Ability to purchase additional annual leave
* Life Assurance
* Season ticket Loan
* Cycle2Work Scheme
* Complimentary theatre/entertainment tickets