Job Description

Company Description

We are Dentsu. We innovate the way brands are built. That means we do things differently so they\xe2\x80\x99re better than before. In this way, we make our clients\xe2\x80\x99 most important marketing assets\xe2\x80\x94their brands\xe2\x80\x94win in a changing world. Dentsu is Innovating the Way Brands Are Built for its clients through its best-in-class expertise and capabilities in Media, CRM, and creative communications services. Dentsu is headquartered in London and operates in 145 countries worldwide with more than 50,000 dedicated specialists.



We are seeking a highly skilled and detail-oriented Data Analyst to join our team. As a Data Analyst, you will be expected to work diligently to meet our client\xe2\x80\x99s data & reporting needs and assist across on-boarding, data Integration, reporting, measurement, advanced analytics, insight development, forecasting and partner identification. The Data Analyst will also be responsible for designing and developing interactive dashboards using tools such as Data Studio or Tableau. Your primary focus will be on extracting, transforming, and loading data, as well as leveraging your expertise in SQL and Google BigQuery to analyze large datasets and generate actionable insights.

Additionally, we prefer candidates with experience working with Demand-Side Platforms (DSPs) such as Facebook Ads, Google Ads, LinkedIn Ads, Snapchat Ads, and other advertising platforms. Familiarity with these platforms will be valuable in understanding and analyzing marketing performance data.

• Work with executives an and other business leaders to identify opportunities for improvement
• Ownership of the end-to-end data warehousing and extraction process for clients through Google Big Query
• Leveraging insights, collaborate with various account teams on strategy and growth opportunities; consult on experimentation approaches and translate results into actionable
• Build backend data connection and manage data warehouse in the ETL process
• Lead the creation of post campaign reports/presentations through data visualization and story-telling, on an ad hoc/monthly/quarterly/yearly basis
• Establish KPIs to measure the effectiveness of business decisions
• Create presentations and reports based on recommendations and findings

Qualifications

• Excellent communication and presentation skills, with the ability to effectively convey complex concepts to both technical and non-technical stakeholders.
• Bachelor\'s degree in Business, Computer Science, Statistics, Mathematics, or a related field.
• Proven experience in designing and building interactive dashboards using Data Studio or Tableau.
• Strong knowledge of ETL processes and experience in data extraction, transformation, and loading.
• Proficiency in SQL and experience with relational databases, preferably Google BigQuery.
• Solid understanding of data modeling, data warehousing, and database design principles.
• Ability to analyze complex data sets and derive actionable insights using SQL queries and statistical techniques.
• Familiarity with Demand-Side Platforms (DSPs) such as Facebook Ads, Google Ads, LinkedIn Ads, Snapchat Ads, etc., and experience analyzing marketing performance data from these platforms.
• Experience in server-side tagging and GA4 implementation preferred
• Basic knowledge of cloud computing concepts and experience in Google Cloud

Additional Information

We know through experience that different ideas, perspectives and backgrounds foster a stronger and more creative work environment that delivers better business results. We strive to create workplaces that reflect the clients we serve and where everyone feels empowered to bring their full, authentic selves to work. We are committed to working with our candidates from all ability levels throughout the recruitment process to ensure that they have what they need to be at their best. If you need accommodation during the application or interview process, please contact Canada.Recruitment@dentsuaegis.com or to begin a conversation about your individual accessibility needs throughout the hiring process.

#LI-DM1

Dentsu International