Agency:Havas Media GroupJob Description Summary:The Havas Media Global Investment Team is responsible for monitoring and measuring buying efficiencies across the network for key clients.It is a transversal role with liaison between the IT team and the Global Investment Team of Havas Media Group with the aim of automating data collection and media audit processes, through the development of business intelligence solutions.Job Description:As General Investment Executive you will:- Analyze and capture business requirements (audit methodologies, business KPIs).- Analyze data sets with a business-oriented approach.- Extract, load and reconcile large data sets from multiple digital marketing platforms and sources (DV360, META, Google Adwords ).- Work closely with IT team in the definition of requirements ensuring these meet business needs while remaining with the defined scope of work.- Ensure data quality, completeness, and accuracy. Utilize SQL to perform data extractions and query functions.- Compile reporting of buying results in excel.- Set up templates and working processes to improve the automation of the department.- Help in the maintenance of the automation platform.- Support other members of the department in the adoption of the new business intelligence solutions.Desired skills:- Strong numeric skills.- Strong analytical skills and attention to detail.- Good written and oral communication skills in English.- Other languages are desirable, especially Spanish and French.- Good at problem solving.- Intermediate user of Excel.- SQL knowledge is a plus.- Interested in technology ( Cloud, Data Analysis )Skills:Contract Type:PermanentHere at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.