Mindshare | SQL Data Analyst

Data, Analytics & Insight Singapore, Singapore


Description

Position at Mindshare

Mindshare is an agency of GroupM, the world’s largest media investment company and are a part of WPP. We are currently looking for an SQL and Data Analyst to join us.

In this role, you will work in SQL to extract, transform and load data to help the client-teams and clients reporting on media campaigns and/or delivering data solutions products. You will be a master at data manipulation and querying using variety of 3rd party and open-source tools. 

Overview of job

Mindshare is an agency of GroupM, the world’s largest media investment company and is a part of WPP. In fact, we are responsible for one in every three ads you see globally. We are currently looking for an SQL and Data Analyst to join us.

In this role, you will work in SQL to extract, transform and load data to help the client-teams and clients reporting on media campaigns and/or delivering data solutions products. You will be a master at data manipulation and querying using variety of 3rd party and open-source tools connected to our proprietary data platforms

At GroupM APAC, our people are our strength, which is why fostering a culture of diversity and inclusion is important to us.

Reporting of the role

This role reports to: Manager, Data Consulting & Solutions


Best thing about the role

Mindshare is the market leading media agency in the fastest growing region of the world, but we are far from complacent. As part of the Regional team, you will have access to the best and latest thinking on integrated brand to performance solutions that you can deploy for your clients. You will also have the opportunity to work closely with some of the best domain experts in the industry. The flat regional structure provides autonomy and control in ways of working and mobility across markets and domains.

If you have a start-up spirit and thrive in fast-paced working environment, then you should be part of this team. You are part of a pioneering group of people to create bespoke data solutions for the client-team and client use. Concurrently, it is a great opportunity for you to push the boundaries of complex data manipulation.

You will be part of ULTRA DNA (Data & Analytics) team as part of the FAST team offering in Mindshare. Also, will be working closely with the ULTRA Trading Team on the daily basis.


Measures of Success

3 months:

  • Familiarised yourself with our media performance data sets that sit beneath various products, and the role it serves for our client teams
  • Worked closely with the ULTRA teams (Data & Analytics and Trading) to define the data aggregation requirements for a client engagement.
  • Familiarised yourself with the tools and platform in order to build various data sets.
  • Creating at least two new data solution products for media and supply performance

6 months:

  • Successfully delivered a set of key data sets tailored to the client-team and client use case.
  • Suggested new data extraction and aggregation techniques to enhance the dashboard and/or other product offering.
  • Created at least two additional data products which business and operational needs

 12 months:

  • Become the regional expert on data ETL, data in general and dashboarding (technically as well as best practices)
  • Effectively collaborated with the local agencies to design data visualization for other client engagement opportunities.
  • Proactively explored new data visualization tools and techniques in collaboration with the wider global Data & Analytics team.


What You Will Need

The ideal candidate will be able to demonstrate knowledge and experience in data ETL and especially SQL. You will be familiar with and have experience of SQL tool (SQL Server, Azure or other SQL products) and may be required to showcase some of the past works in this field.

 The successful applicant should have:

  • A good degree in Computer Science (Multimedia), Engineering, Data & Analytics.
  • Minimum 2 years’ work experience in creating Data ETL techniques
  • Knowledge of database solutions such as Azure, SQL Server, etc
  • Some knowledge of data manipulation tools (e.g., R, Python, SAS, etc.)
  • Experience with open-source visualization technologies such as Java, D3 and R and how to operationalize client facing solutions based on these frameworks will also be nice to have.
  • Formal training in related topics such UX design and/or web design is welcome but not essential.
  • Knowledge in Programmatic, digital media and advertising design is welcome but not essential.
  • Ability to work collaboratively with multi-cultural business partners and stakeholders, and strong team player.
  • Proven track record of delivering independently – to quality and timelines

 

More about Mindshare

We were born in Asia in 1997, a start up with a desire to change the media world. Now we are a global agency with more than 7,000 employees in 116 offices across 86 countries, operating as one team - #teammindshare. We believe that in today’s world, everything begins and ends in media. We aim to be our clients’ lead business partner, to grow their business, and drive profitability through adaptive and inventive marketing. We do this through speed, teamwork and provocation and by operating as a network of networks rather than a rigid hierarchy. We create new things and have fun doing it. Whenever and wherever you join us, you open a door to opportunities in any and of all aspects of media, technology and innovation. We will support you, recognize you and reward you, making Mindshare the place where you do the best work of your career.

Mindshare APAC has won 500 awards in the last year alone, including “Agency Network of the Year 2017” by both the MMA SMARTIES™ and Campaign Asia for the fifth and third consecutive year, respectively. Mindshare is part of GroupM, the media investment management arm of WPP, the world’s leading communications services group. To learn more about Mindshare and our philosophy of Original Thinking, visit us at www.mindshareworld.com and follow us on Twitter @mindshare and facebook.com/mindshareapac and linkedin.com/company/mindshare.


More about GroupM Singapore

GroupM Singapore operates in one of the most dynamic and exciting environments in the world. Although it is a small domestic market, there is a vibrant media industry which is undergoing rapid evolution as digital technology reshapes the way marketing supports advertisers’ needs. Being at the crossroads of Asia means, that aside from the local clients and media owners, we also have a high proportion of multi-national clients, renowned brands and media owners. Making GroupM Singapore the Number One organisation to join and develop your career in media investment.

GroupM is an equal opportunity employer. We view everyone as an individual and we understand that inclusion is more than just diversity – it’s about belonging. We celebrate the fact that everyone is unique and that’s what makes us so good at what we do. We pride ourselves on being a company that embraces difference and truly represents the global clients we work with.