Solutions Architect - Business Intelligence

Data, Analytics & Insight
London, England


DiagramDescription automatically generated with medium confidenceLogoDescription automatically generated  




About EssenceMediacom  

We are a global communications agency leading with breakthrough thinking, building explosive growth for brands, and helping our clients see the bigger picture. Our daring global network of 10,000 influencers helps our clients breach traditional boundaries in media, uncover novel ideas, and unleash exponential growth. EssenceMediacom challenges conventional thinking to build, propel, and supercharge our clients’ businesses at scale and lead our industry in critical areas such as diversity, equity, inclusion, and sustainability.    

EssenceMediacom understands that our people are tasked with big goals: building breakthrough growth for brands and leading with breakthrough thinking in our industry. Our people are at the heart of this work because their ideas will enable us to decode the intersections of people, content, and technology to bring our aspirations to life. Our success is down to our eclectic, diverse, and talented people. EssenceMediacom is a place for us to grow our careers and expand our horizons. EssenceMediacom is committed to building an agency culture that supports our people, puts diversity at the forefront of our operations, and creates opportunity for all. This collective culture will be our “new power” where ideas are freely exchanged, and collaboration is actively encouraged in a place where you can innovate in our hyperconnected world.    


*Although we cannot make guarantees, we welcome conversations about flexible working for all roles at EssenceMediacom*  


Solutions Architect - Business Intelligence  

Performance Solutions / Feb 2024  


Position Overview  

As a Solutions Architect within the Performance Solutions team, you will play a pivotal role in the Business Intelligence function. Your primary responsibility will be to design and implement innovative solutions that streamline data capture, reporting automation, and measurement methodologies. This role sits at the intersection of technology, data analytics, and automation, contributing significantly to our mission of empowering data-driven decision-making and achieving best-in-class digital paid media performance  


Reporting of the role:  

This role reports to the Analytics Business Director.  


Key Responsibilities:  

  1. Solution Design and Transformation:
  • Collaborate with cross-functional teams to design and implement end-to-end solutions for capturing data throughout the entire lifecycle of digital media campaigns.
  • Transform data into actionable insights, ensuring alignment with business objectives and client requirements.


  1. Business Intelligence and Automation:
  • Work closely with the Automation teams to build and design tools that drive critical business results for our clients.
  • Play a key role in enhancing existing automation processes and developing new methodologies to optimize digital media performance.


  1. Client Collaboration:
  • Engage with key clients, including Coca-Cola, Adidas, PlayStation, iRobot, and others, to understand their unique business challenges and goals.
  • Provide expertise and guidance on leveraging Business Intelligence solutions to meet and exceed client expectations.


  1. Team Collaboration:
  • Collaborate with Insight and Ad Operations teams within the broader Performance Solutions group to ensure seamless integration of solutions.
  • Actively contribute to a culture of continuous improvement and innovation within the team.


The 3 best things about the job  

  1. Friendly, supportive team culture.
  2. Work with digital experts at the forefront of technology which is always innovating and changing.
  3. Build your expertise in coding advanced data solutions using PowerBI, Tableau, SQL, Python, R, and more.


Measures of success  

In three months, you will:   

  • Learn how each client has been set up on our database systems.
  • Learn how to execute core reporting tasks via SQL, Python, and Tableau 
  • Understand how key automation tools setup have been.

In six months, you will:   

  • Become an integral part of the team and take ownership of key client deliverables.
  • Learn how to build end-to-end data solutions for key clients from scratch.
  • Work directly with client teams across the business
  • Become an advanced user of our systems and tools.

In 12 months, you will:   

  • Design new reporting solutions and know how to onboard new clients.
  • Understand the direction of the industry when it comes to privacy, and what we need to do to help our clients adapt.
  • Test and integrate new tools and techniques, understanding their advantages and limitations, leading to the development of improved processes and increased efficiencies.


What you will need:  


Client Account Management  

  • Experience how to multi-task, delegate, prioritise, and manage expectations.
  • Able to break down a problem, get to the heart of the question, and come up with a way of fixing it
  • Demonstrate collaborative teamwork and citizenship.
  • Excellent written and verbal communication skills, including simplification of technical concepts for non-technical audiences.
  • Willingness to learn from others and share own knowledge.


Operating and Technical Skills  

Must haves  

  • Strong logical structured thinking
  • Agile Methodology
  • Continuous Learning
  • Documentation
  • Communication and stakeholder management
  • System Integration: Use of Excel, PowerBI, Tableau, or other data visualisation tools
  • Database Management
  • Automation and workflow optimisation
  • Ability to work in a fast-paced and dynamic environment.
  • Take ownership of account/project delivery
  • Troubleshooting and Problem Resolution
  • ETL Processes



  • Cloud Platforms
  • Data Architecture
  • Analytics and predictive modeling experience


What we can offer you.  


  • Company pension scheme
  • Private medical insurance
  • 25 days holiday (increases with length of service)
  • Life assurance
  • Permanent health insurance
  • WPP share options scheme.
  • Discretionary bonus scheme
  • Free eyecare vouchers and money off glasses
  • Extensive training and development
  • Corporate gym memberships
  • Cycle to work scheme.
  • Interest-free travel loan
  • Free breakfast (cereal and fruit)
  • Smart shopper (online discount on a variety of products)


Sounds good? We’d love to hear from you!  




Share This Job