Description
Position at Choreograph
Role:BI DeveloperDepartment/Team: Data Automation
Role Objective
We plan advertising communications for clients across various channels including TV, radio, and digital platforms like paid search and social media. Together with our clients we want to understand how we are getting on – we want to know what is working and what is not – meaning we need high-quality reporting at our fingertips.
We are looking for someone who can not only build great looking visuals, but who can also work with internal teams and clients to help them make sense of data and tell the story behind it.
About the role
- Design, develop, and maintain BI solutions, including data models, reports, and dashboards.
- Collaborate with other internal agency teams and clients to understand business requirements and translate them into technical specifications.
- Work alongside our data engineers to extract, transform, and load data from various sources into the BI system.
- Develop and optimize SQL queries and scripts for data extraction and analysis.
- Create and maintain documentation for BI solutions, including data dictionaries and technical specifications.
- Monitor and troubleshoot BI solutions to ensure data accuracy and system performance.
- Provide training and support to end-users on BI tools and solutions.
- Develop and maintain relevant media and advertising knowledge.
- Stay current with best practices and technical developments in BI and data analytics.
About you
You will have demonstrable experience working in a data-oriented environment, with a solid understanding of database and data visualisation concepts. Experience working with media data is an advantage but not essential. Your skills and experience will also include:
- Ability to design and build great-looking data visuals with experience in at least one of the major data visualisation tools.
- Experience in analysing and solving problems using a data driven approach.
- Experience in designing, building, and maintaining end-to-end BI solutions.
- Strong communication skills, with the ability to work with non-technical teams to gather requirements and scope BI solutions.
- Ability to create and maintain high-quality technical documentation.
- Intermediate SQL or Python skills, with the ability to write queries to mine and transform data.
- Awareness of the business needs for accurate and timely BI reporting.
- Self-starter with the ability to work autonomously to deliver to deadlines.
What we can offer you
- A strong salary commensurate and in-line with relevant experience
- 25 days annual leave and your birthday day off
- Ongoing internal and external training opportunities
- Flexible working
- The opportunity to attend industry conferences and awards nights
- Career and personal progression
- Private Healthcare
- Excellent pension matching structure
About Mindshare
Mindshare is a leading global marketing and media services network with billings in excess of £23billion worldwide. We work with some of the most famous businesses and brands in the UK – such as Unilever, Ford, KFC, Marks & Spencer and TK Maxx. The Mindshare network consists of 116 offices across 86 countries throughout the USA, Latin America, Europe, Middle East, and Asia Pacific; each dedicated to forging competitive marketing advantage for businesses and their brands.
Our Approach
Our ambition is to drive Good Growth for our clients.
Good Growth is about delivering growth that is enduring and is considerate of people and planet. Media is a powerful force, and we need to be mindful of the responsibility that it brings. We help our clients make better decisions by ensuring we use media in a trusted, inclusive and sustainable way. We recognise that in order to drive Good Growth, we need to place people at the heart of everything we do. Understanding people, not demographics allows us to place media meaningfully into their lives.
Good Growth is a big ambition – one which inspires change for the industry but also for our agency and we achieve this through our values of Energy, Empathy and Impact.
Working for Mindshare
Our brilliant people allow us to deliver our ambition. We invest heavily in their development to ensure they are progressing and thriving wherever they work in our business. We also think inspiration for our staff is key and our pinnacle and flagship event of the year, Huddle, connects people, opinions and perspectives across borders and is all about learning something new and participating.
Committed to Diversity & Inclusion
We have a big dream at Mindshare, to become the most inclusive place to work in the country! This will take time but the whole agency is passionate about making it a reality. To support this, we currently have 8 Employee Resource Groups available for our people to join and be a part of including, Roots, PrideM, Women in Business, Enable, Declassify, 0Borders, ADAM and Working Parents. These groups hold the agency to account for making progress and, along with our Mental Health Allies, design and lead events and initiatives that help us create a welcoming environment to all and a place where everyone can be their most confident self.
#LI-GB1
