THE POWER OF ONE PURPOSE FUELLED BY A DYNAMIC HEALTH ENGAGEMENT PLATFORM 
At Publicis Health, we are united around one purpose: to create a world where people are equipped and motivated to take control of their health. We transform healthcare marketing and communications into healthcare engagement. We believe healthcare marketing is healthcare, fostering healthy conversations, healthy behaviours and healthy people. Publicis Health is a Dynamic Health Engagement Platform, an organising principle that seamlessly connects data, content and technology; is driven by marketing and business transformation; and offers our clients fluid access to world-class talent and game-changing capabilities. With 40 offices and 11 brands across the globe, Publicis Health’s worldwide staff is comprised of more than 3,000 healthcare professionals who are experts in advertising and branding, data and analytics, strategic planning, service design, digital media and technology, science, and medicine. Publicis Health companies include Digitas Health, Heartbeat, insync, Langland, Payer Sciences, PlowShare Group, Publicis Health France, Publicis Health Media, Razorfish Health, Saatchi & Saatchi Wellness, and Verilogue. For more information, visit us at www.publicishealth.com.

Responsible for leading automation across BI and data initiatives and developing data products. This resource plays a critical role in the development of BI/data warehouse/data lake solutions utilized by internal and external stakeholders. These solutions include data ingestion, harmonization, visualization, quality assessment and delivery.

Responsibilities:

·       Lead portfolio of data projects across different clients in the agency

·       Work closely with different teams such as client, sales, IT, media planning and buying

·       Create high performance data products by monetizing warehouse and ETL solutions

·       Performance tuning and optimization of BI solutions such as Tableau, Datorama, Google Data studio, etc.

·       Leverage the data warehouse to design and develop tables, views, triggers, indexes, constraints and stored procedures

·       Build data flow automation to retrieve, transform and load data

·       Data management functions including:

o   ETL/data feed management

o   Metadata management

·       Maintain best practices for handling, storing and using data

·       Tools: 

o   SQL Server/SSIS

o   Python/Java

o   BI Platforms – Tableau, Datorama, etc

o   Cloud Technologies – AWS, Azure, Google

       BS Degree in one of the following subject areas; Computer Science, Information Technology or related field preferred

·       Ability to track and resolve BI and database related incidents as well as requests

·       Strong understanding of database structures, theories, principles, and practices

·       Strong understanding of ETL and data warehouse principles

·       Good interpersonal, written and oral communication skills

·       Technical documentation skills

·       Ability to present complex ideas in user-friendly language

·       Self-motivated and directed, with keen attention to detail

·       Able to prioritize and execute tasks in a team-oriented, high-pressure environment

Specific Skills Required:

·       Minimum 4 years SQL experience, 3 years of ETL experience, 3 years analyzing data sets

·       Minimum 4 years BI experience (Tableau, Datorama)

·       Strong data warehouse knowledge

·       Experience with large data sets

·       Python, Java, C# or R experience a plus

·       Experience with Web and Digital marketing data a plus

All your information will be kept confidential according to EEO guidelines.