Senior Analyst Business Intelligence

Company Description

Dentsu Media is the largest area of specialism within the dentsu network. It is brought to markets globally, through three award-winning agency brands: Carat, iProspect and dentsu X. All three are underpinned by a scaled network offering of talent, capabilities, and services to support, grow and transform the world’s leading advertisers. Operating across more than 145 countries, dentsu Media is trusted by leading brands across a broad range of sectors, from pioneering technology to cutting-edge fashion. Dentsu leverages technology, creativity, and in-depth data analytics to drive superior results that amplify its clients' brands. Dentsu Media is transforming advertising as a force for growth, a force for good and has become the destination for employees to cultivate meaningful careers and for brands to accelerate previously unseen, sustainable growth.

Job Description

§Develop and manage dashboard in BI Platforms (Tableau, Power BI, Datorama, Data Studio) as per the requirement.

§Deliver the reports or Dashboards on a timely manner.

§Work on data preparation/data modelling necessary for the visualization purpose.

§Identifying patterns and meaningful insights from data by analyzing it.

§Create customize charts and custom calculations(LOD’s, Table calculations and DAX) as per requirements.

§Continuous improvement of existing dashboards in BI tools through own initiative and Client feedback

§Implement row level security on data and handle the user management for the projects.

•

Requirement:

§Advanced knowledge of Power BI/Tableau/Datorama(At least Strong in one tool)

§Should have experience writing complex queries in SQL

§Expertise in Data modelling, Data cleaning and Data preparation and data warehousing concepts.

§Experience in Python,R or any Big data or cloud technology/Platform will be plus.

§Should have knowledge and experience in prototyping, designing, and requirement analysis.

§Must have been on a client facing role with regular meetings & catchups.

§Good Communication.

§Critical Thinking and Problem Solving.

Self learning capability.

Qualifications

§Handle client communication and allocate works to the team

§Design and create data visualizations (reports and dashboards) as required to support business needs

§Analyze, define requirements, develop and create documentation for dashboards

§Champion dashboard quality, consistency, usability and reliability by documenting and applying best practices to design and development

§Communicate project status updates and recommendations

§Define, execute and interpret SQL queries  

Write complex calculations and try to automate the process wherever it’s required.

Roles & Responsibilities: