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

Data ETL processes

Review Data daily to understand the disturbance or inconsistencies.

Pro actively fixing the issue in the database.

Manage all incoming data files.

Maintain and monitor client base.

Streamline data collection and analyze procedures to ensure fast access to metrics.

Update/review/generate documentation for all the database changes or refinements.

Improve efficiency in the database if needed.

Create automation scripts using Python/R to extract data from various platforms.

Data Management and Modelling

§Strong underrating on Data warehousing, Analysis, Data interpretation and Excel.

§Good understanding on creating tables, views and creating schema diagrams.

§Good understanding on Data modeling concepts.

§Produce visualizations in Dashboarding tools (tableau, Powerbi)

Qualifications

•Work closely with stakeholders to collect all technical requirements and scope them into a project plan.

•Support ETL, Data Migration, Data modelling and responsible for data sanity.

•Strong in Python, R and other data modelling tools.

•Produce visualizations in dashboarding tools (Powerbi, Tableau..etc)

•Performance tuning and optimizing procedures.

•Support Server integrations and Adhoc Reporting. (SSIS and SSRS)

•Regular Audits and Hygiene checks.

•Support the visualization team on the Data requirements. And suggest strategy for new assignments and Migrations.

Additional Information

Education & Training:

• Any Degree

• Excellent communication skills